Following is a problem description. For all hypothesis tests, you MUST show all 7 steps we have been using and use the P-VALUE METHOD to make your decision. For confidence intervals, there are not specific steps, but there is a specific Excel tool for each interval. They should not be done by-hand for this set, nor should you simply use Excel formulas to use it as a calculator. Treat each question as a separate problem -- we use the same data set, but are answering different "research questions". You must attach and clearly label the Excel output that you use in answering the questions as appropriate. The part of the printout you are using must be clearly identified.

Many parts of cars are mechanically tested to be certain that they do not fail prematurely. In an experiment to determine which one of two types of metal alloy produces superior door hinges, 40 of each type were tested until they failed. Car manufacturers consider any hinge that does not survive 1 million openings and closings to be a failure. The number of openings and closings as observed and recorded in the accompanying table (to the closest 0.1 million). A statistician has determined that the number of openings and closings is normally distributed.

NOTE: use ONLY the P-value method for hypothesis tests. If you include both rules in step 4 or include both in your decision step, I will have to conclude that you do not yet understand the p-value rule.