Word File Edit View Insert Format Tools Table Window Help G G LO J Q 8 Mon Jul 1 3:39 PM AutoSave OFF ... Week 9 Excel for Assignment AutoSave . OFF 90 6 . Section 7 S... - Saved to my Mac ~ Q Home Insert Draw Page Layout Formulas Data Review View Home Insert Draw Design Layout >> Comments Editing Share Calibri (Body) 11 AA ab Con Calibri (Bo... v 20 A A Aav portfolio For Paste BIUV A Number Paste B I Uva X2 Av LAv Paragraph Styles Add-ins 207 Cell H28 X V fx 2) Excel Assignment - download the Excel coin flips data off Blackboard and answer the following A B D F G H (6 points): Subject# Quarters Dimes Nickels Pennys Subject#1 a. Just off to the side, tell me what your null and alternative hypotheses are (you can do a pol 7 M A W N Subject#2 different one for each coin or just one null and one alternative to cover all of your coins) Subject# Subject#4 . Tell me if you see any problems with the data in terms of missing data or scores outside Subject#5 of expected ranges. Subject #6 Subject#7 C. For Dimes, calculate the mean, Standard Deviation, Standard Error of the Mean, the er Subject#8 difference between the mean for dimes and 5.00, and your t-statistic. 10 Subject#9 A V U P O A V U V A WA WUVU 11 Subject #10 d. Copy those formulas over to calculate the same things for Nickels and Pennies 12 Subject#11 P W O UT O M O UT V A UT UI A AN 13 Subject#12 e. Tell me what your critical value is to determine significance using a p-value of .05 for a 14 Subject#13 two-tailed test. 15 Subject#14 16 Subject#15 f. Tell me if any of your results are statistically significant. SS 17 Subject#16 18 Subject#17 Subject#18 Mean Standard Dev Standard Error Mean Difference letter t-statistic Shot 07.06 PM Sheet Sheet2 Sheet3 + Shot Ready iJ Accessibility: Investigate Page 1 of 1 296 words OX Focus E + 07.13 PM 150% itv S A ssional Ith care