Please use the data I provided to answer the questions by using excel. Student Replicate Length A

Please use the data I provided to answer the questions by using excel. 

Transcribed Image Text:

Student Replicate Length A Width Height Drilled? Q1-4 11 1.9 1 1 N STUDENT A A 17 2.1 1.6 1 N A A 18 88 9 2.3 2 1.1 N LENGTH WIDTH HEIGHT 2.3 1.2 1.2 N MAX A 12 2.8 2.7 1.4 N MIN A 14 3.8 1.4 1.9 N A 1 3.9 1.4 1.9 Y MEAN MEDIAN A 4 4.2 2.2 2.1 N STDEV A 2 4.2 1.8 2.1 Y A 5 4.6 2.9 2.3 N STUDENT B A 7 5.2 4.1 2.6 N A 15 5.2 5.1 2.6 Y LENGTH WIDTH HEIGHT A 6 5.2 4 2.6 Y MAX A 8 7 4.9 3.5 Y MIN A 20 7.3 5.1 3.6 N MEAN A 3 7.3 4.8 3.6 Y MEDIAN A 16 7.3 4.9 3.6 Y STDEV A 13 7.8 5.5 3.9 Y A 10 8 5.9 4 Y Q5 Be sure to answer the questions on the worksheet! A 19 8.5 5.7 4.2 Y B 7 1 0.5 0.2 N Q6 Be sure to answer the questions on the worksheet! B 18 1.3 0.3 0.6 N B 9 2.5 2.5 1.3 N Q7 B 5 3.1 3 1.5 N Justify whether the data supports or refutes your hypothesis! p-value Are group A and B significantly different? B 20 3.2 1.5 1.6 N Length B 1 3.3 1.2 1.7 N Width B 19 3.5 B 10 54 2.9 1.7 N Height 1.5 2N B 2 4.1 3.3 2 Y Q8 B 15 4.3 2.4 2.2 N B 17 4.6 4 2.3 Y B 11 4.7 3.6 2.3 Y B 12 5 4.3 2.5 Y B 14 5.2 4.3 2.6 Y B 16 5.8 5.5 2.9 N B 3 5.8 5.8 2.9 Y B 4 6.4 3.9 3.2 N B 13 6.8 6 3.4 Y B 6 8.3 5.9 4.1 Y B 8 8.6 5.8 4.3 Y Q9 Be sure to answer the questions on the worksheet! 50% PREDICTION CHI SQUARE OBSERVED EXPECTED P-VALUE DRILLED NOT DRILLED 10% PREDICTION CHI SQUARE OBSERVED EXPECTED P-VALUE DRILLED NOT DRILLED Q10 OBSERVED SIZE 0-3 SIZE 3-6 SIZE 6-9 TOTAL Be sure to answer the questions on the worksheet! DRILL (Y) DRILL (N) TOTAL EXPECTED DRILL (Y) DRILL (N) TOTAL SIZE 0-3 SIZE 3-6 SIZE 6-9 TOTAL P-VALUE Answer questions 11 and 12 on your worksheet. Student Replicate Length A Width Height Drilled? Q1-4 11 1.9 1 1 N STUDENT A A 17 2.1 1.6 1 N A A 18 88 9 2.3 2 1.1 N LENGTH WIDTH HEIGHT 2.3 1.2 1.2 N MAX A 12 2.8 2.7 1.4 N MIN A 14 3.8 1.4 1.9 N A 1 3.9 1.4 1.9 Y MEAN MEDIAN A 4 4.2 2.2 2.1 N STDEV A 2 4.2 1.8 2.1 Y A 5 4.6 2.9 2.3 N STUDENT B A 7 5.2 4.1 2.6 N A 15 5.2 5.1 2.6 Y LENGTH WIDTH HEIGHT A 6 5.2 4 2.6 Y MAX A 8 7 4.9 3.5 Y MIN A 20 7.3 5.1 3.6 N MEAN A 3 7.3 4.8 3.6 Y MEDIAN A 16 7.3 4.9 3.6 Y STDEV A 13 7.8 5.5 3.9 Y A 10 8 5.9 4 Y Q5 Be sure to answer the questions on the worksheet! A 19 8.5 5.7 4.2 Y B 7 1 0.5 0.2 N Q6 Be sure to answer the questions on the worksheet! B 18 1.3 0.3 0.6 N B 9 2.5 2.5 1.3 N Q7 B 5 3.1 3 1.5 N Justify whether the data supports or refutes your hypothesis! p-value Are group A and B significantly different? B 20 3.2 1.5 1.6 N Length B 1 3.3 1.2 1.7 N Width B 19 3.5 B 10 54 2.9 1.7 N Height 1.5 2N B 2 4.1 3.3 2 Y Q8 B 15 4.3 2.4 2.2 N B 17 4.6 4 2.3 Y B 11 4.7 3.6 2.3 Y B 12 5 4.3 2.5 Y B 14 5.2 4.3 2.6 Y B 16 5.8 5.5 2.9 N B 3 5.8 5.8 2.9 Y B 4 6.4 3.9 3.2 N B 13 6.8 6 3.4 Y B 6 8.3 5.9 4.1 Y B 8 8.6 5.8 4.3 Y Q9 Be sure to answer the questions on the worksheet! 50% PREDICTION CHI SQUARE OBSERVED EXPECTED P-VALUE DRILLED NOT DRILLED 10% PREDICTION CHI SQUARE OBSERVED EXPECTED P-VALUE DRILLED NOT DRILLED Q10 OBSERVED SIZE 0-3 SIZE 3-6 SIZE 6-9 TOTAL Be sure to answer the questions on the worksheet! DRILL (Y) DRILL (N) TOTAL EXPECTED DRILL (Y) DRILL (N) TOTAL SIZE 0-3 SIZE 3-6 SIZE 6-9 TOTAL P-VALUE Answer questions 11 and 12 on your worksheet.