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.
C:\Users\ADMINI~1\AppData\Local\Temp\WeChat Files\11b5f6a81c21d1da4ea0f193def6982.png
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.
C:\Users\ADMINI~1\AppData\Local\Temp\WeChat Files\485e87fe5e2d29adcf6c3b15ef2876f.png
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.
C:\Users\ADMINI~1\AppData\Local\Temp\WeChat Files\a1473a595ab370a124e3eb3abcd03cd.png
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.
C:\Users\ADMINI~1\AppData\Local\Temp\WeChat Files\46b0fc1641eaafa15b83311c033777f.png