# Excel question on Computer Science

Excel question on Computer Science

CA 6

Confidence intervals

– Solve problem [#8.18, p. 251 in eText]

Watch the above video, and solve the problem on a Microsoft Excel and submit the file on the Blackboard, prior to Midnight of the due date.

CA 7

Hypothesis testing – Z test

– Solve problem [#9.16, p. 283 in eText]

Watch the above video, and solve the problem on a Microsoft Excel and submit the file on the Blackboard, prior to Midnight of the due date.

CA 8

Hypothesis testing – t test

– Solve problem [#9.28, p. 288 in eText]

Watch the above video, and solve the problem on a Microsoft Excel and submit the file on the Blackboard, prior to Midnight of the due date.

CA 9

Chi-square test – Goodness-of-fit test

Solve the following problem:

In the 2010 U.S. Census, the ages of individuals in a small town were found to be the following:

<18 18-35 >35

20% 30% 50%

in 2010, ages of n=500 individuals from the same small town were sample. Below are the results:

<18 18-35 >35

121 288 91

Using alpha=.05, would you conclude that the population distribution of ages has changed in those 10 years?

Watch the above video, and solve the problem on a Microsoft Excel and submit the file on the Blackboard, prior to Midnight of the due date.

CA 10

Regression analysis

· Solve problem [#13.73 (all except part f), P. 467 in eText]

Watch the above video, and solve the problem on a Microsoft Excel and submit the file on the Blackboard, prior to Midnight of the due date.