Drawing Tools File Home Insert Page Layout Formulas Data Review View Format Module4_Project_Excel - Excel Tell me what you want to do... Cut Aut Copy- Paste Calibri (Body) BIU 11 4 A A 1=1 Wrap Text General Fill 4 4 4 Format Painter A Merge & Center $ -% .00 -.0 +0.00 Conditional Format as Formatting Table Cell Insert Delete Format Clea 4 Styles Clipboard Font Alignment Number Styles Cells TextBox 1 X fx A B C D E F G H J K L M N O P 1 O Instructions 23 4 5 6 7 8 9 Open the next tab titled "MAT152HT-TestData" and use it to complete the questions below. This tab contains sample data for a random group of 41 MAT 152 students from previous semesters. For Tests 1 and 2, both the scores and the completion times were recorded for each student. For Test 3, only the scores were recorded. (Student names are fake to protect privacy, but the times and scores are real.) For full credit, you must show all work including the hypotheses (label the claim), a sketch or description of the sampling distribution indicating the direction of the test, test statistic, and P-value. You must also state your decision, and separately, give an interpretation in the context of the original claim. Use a different font color (other than black) for your answers. Problems 1. An instructor was evaluating Test 1 and was very pleased with the results. She said to her coworker, "I think the grades for Test 1 were very good. I'm willing to bet the average overall score for this test is higher than a 75." Test the instructor's claim that the population mean score for Test 1 is higher than 75. Use a level of significance of 0.01. (30 pts) 10 11 12 13 14 15 16 17 18 19 20 21 22 Instructions and Problems MAT152HT-TestData + Ready I 3 2) Drawing Tools Module4_Project_Excel - Excel Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Format Cut Calibri (Body) 11 F A A Wrap Text Copy 4 Paste Format Painter Clipboard TextBox 1 4 4 BI U Merge & Center Font X fx A B C D E 0 Alignment General $ -% Page Layout Formulas Data Review View Drawing Tools Format Module4_Project_Excel - Excel Tell me what you want to do... File Home Insert Cut Calibri (Body) 11 T A A 1=1 Copy ste 4 Format Painter BIU AME Clipboard Wrap Text General Merge & Center 4 $ -% < Test 3 Score Test 1 Time Test 2 Time 2 Oliver, Jennifer 97 3 Linzy, Bobby 67 94 97 45 66 93 51 78 4 Clark, Mitchell 100 91 85 42 69 5 McDonald, Irene 57 55 39 49 84 6 Wolf, John 73 75 72 69 86 7 Kelley, Dawn 68 35 40 76 70 8 Schroeder, Thomas 55 64 26 42 69 9 Cunningham, Kylee 98 74 99 42 86 10 Ochs, John 70 76 91 53 67 11 Garner, Lloyd 81 61 92 76 90 12 Clark, Kate 64 63 68 90 90 13 Dunaway, Margareta 88 79 87 49 70 14 Copper, Bert 100 91 81 55 75 15 Cox, Danny 63 10 8 53 60 16 Vandenberg, Roger 95.5 97 94 59 68 17 Craig, Eva 85.5 90 76.5 83 89 18 Griffith, Quinton 76.5 83 48 61 61 19 Riley, Andrea 82 77 68 77 80 20 Kemp, Joan 89 91 83.5 47 45 21 Baeza, Robert 81 89 96 83 60 22 Cole, Grace 82 87 92 75 95 23 King, Timothy 86 83 90 50 55 24 Hill, Katherine 97 83 95.5 52 44 25 Raglin, Bart 67.5 38 35 71 80 26 Rodden, Kevin 70.5 49 705 50 42 27 Campbell, Linda 88 84 55.5 49 41 28 Knapp, Theresa 98 86 94 42 52 29 Campbell, Sandra 84.5 64 78 65 75 30 Norris, Willie 72 88 85 68 82 31 Holmes, Francisco 90 96 97.5 73 74 32 Wilson, Beverly 62.5 31 30 65 46 33 Cintron, Shila 100 79 88.5 42 46 34 Brown, Connie 61.5 36 425 89 80 35 Garcia, Dominique 79.5 69 87 65 68 36 Gildersleeve, Kenneth 82.5 87 81 63 90 37 Griff, Lisa 94 79 80 49 45 38 Newton, Michael 86 76 82 65 63 39 Morrison, Melissa 86.5 78 90 60 52 40 Knox, Henry 94 94 915 43 68 41 Preston, Raymond 715 73 93 71 80 42 Davis, Ella 64 48 19 67 76 43 44 Calibri (Body) 11 A A Wrap Text General Copy 4 ste Format Painter BIUA Merge & Center - Clipboard Font 2 Alignment $ % 9 .0.00 .00 -.0 # Conditional Format as Cell Inse Formatting Table Styles Number Styles extBox 1 X fx A B C D E LL F G H J K L M 7 2 B 5 5 7 B 9 1 2. If your decision for the hypothesis test you performed for Problem 1 was incorrect, what type of error would it be (Type I or Type II)? Identify the type of error. Then, explain what this error would mean in the context of this situation. (10 pts)