Because of the way aluminum cans are stacked when they are shipped, they need to be able to bear a minimum of 200 pounds before collapsing. Column B on the spreadsheet contains the weight at which a sample of 150 cans taken from the Birmingham plant collapsed.

a) Using = .05, conduct a one-tailed t test of the hypothesis that average weight bearing capacity is greater than 200 pounds. Use 200 as your null hypothesis

b) What is the p value associated with your sample mean weight?

c) What conclusions can you draw from these results?

Excel Tips: By default, =TINV assumes a 2-tailed t test. If you want to calculate a p-value using a 1-tailed t test, simply double the probability you enter into the formula. =TDIST is not capable of dealing with negative numbers. If your t test statistic is negative, use =ABS to make it positive so =TDIST can work correctly.