Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Automate G Calibri (Body) 12 A A Paste B I U A C19 A fx =ROUND(NORM. INV(C15, C13,C14),4) B C Tell me ab General Insert Delete $ % 9 .00 Conditional Format 0 Formatting as Table Cell Styles Format 1 QUESTION F 2 4 5 Suppose Mark is taken to the emergency room after a car wreck and the doctors think he might have a brain injury. They give him a finger-tapping-speed test that has a mean of 3 100 and a standard deviation of 10 in the normal population and they decide to use a one- tailed test with all 5% of alpha in the lower end of the distribution. That means that they will conclude that he has brain damage if his score is at or below the point in the distribution that marks the lower 5% of the distribution. Also, suppose that the doctors believe that they know that the mean of the alternative distribution is 80 with a standard deviation of 10. Use Excel or R to find the probability of making a Type II error in this scenario. 60 7 8 9 10 11 12 Null Hypothesis Alternative Hypothesis 13 Mean 100 80 14 SD 10 10 15 PNORM (5%) 0.05 0.05 16 Z SCORE 17 18 100.5 80.5 83.55146373 63.55146373 19 TYPE II ERROR 20 21 22 23 24 A-D E 83.5515 0.0093 F Select destination and press ENTER or choose Paste + 63.5515 0.3612 D E LL F G H M > > > Tue Mar 28 10:52 PM Comments BD ssign Share X Sort & Filter Find & Select Analyze Data Sensitivity ot 4 PM J K 146% ot 41 PM ot 00 8 PM ot 6 PM test odf ssign X