100% T View Zoom Add Category Insert Table Chart Text Shape + Sheet1 #1 #2 #3 #4 #5 #6 From past shipments of mice, there is a known standard deviation of weight among the mice of 1.5 g and a nominal weight of 10 g. A sample of 100 mice is selected and weighed. The average weight of the sample is 9.6 g. The technician wishes to test the hypothesis that the average weight of the mice equals the nominal value versus the hypothesis that the mice sample is not equal to the nominal. Use confidence level of 99%% (note: this is not 95%). Repeat your analsis for a reduced sample of 10 mice and show work on the right side below. Update and input into the area below to show your work. Type in your final answers into the box below the input area. 100 input 10 update x bar input x bar no change mu input mu no change stdev input stdev no change SE 0.000 #s/SORT(s) copy and paste work from the left (n=100) z or t value =(x_bar-mu)/SE copy and paste work from the left (n=100) copy and paste work from the left (n=100) p_value use joo.dist[) formula for z or copy and paste work from the left (n=100) 1-p 1 0000 upper tall copy and paste work from the left (n=100) two tail 2.0000 two times the smallest copy and paste work from the left (n=100) copy and paste work from the left (n=100) alpha input copy and paste work from the left (n=100) alpha/2 0.000 need this for two-sided critical copy and paste work from the left (n=100) t crit update for alpha or alpha/2 copy and paste work from the left (n=100) copy and paste work from the left (n=100) m 0:000 #t crit"SE copy and paste work from the left (n=100) x bar-m 0.000 lower limit copy and paste work from the left (n=100) x bar+m 0:000 upper limit copy and paste work from the left (n=100) Type out your answers to the questions below in THIS box 1) State the null and al re hypotheses for this scenario 2) Compare the p_value to p_critical. Do you "reject" or "not reject" your null hypothesis? In words what does this mean: 3) compare the t_value to t_critical. Do you get the same result? Type in the values and answer below. 4) change the n value from 100 to 10 and explain below why your conclusion changes (even though everything else stays the same). 5) For n=100 and n=10, the spreadsheet should automatically calculate the confidence intervals. Does this confidence Interval confirm your conclusions? Type out the values and answer below