Directions: Solve the following problems using Excel Data Analysis Toolpack.

Two different chemical formulations of rocket fuel are considered for the peak thrust they deliver in a particular design for a rocket engine. The thrust/weight ratios (in kilograms force per gram) for each of the two fuels are measured several times. The results are as follows: a. Assume the fuel processing plant is presently configured to produce fuel B and changeover costs are high. Since an increased thrust/weight ratio for rocket fuel is beneficial, how should the null and alternate hypotheses be stated for a test on which to base a decision whether to switch to fuel A ? b. Can you conclude at the 5% level that the switch to fuel A should be made? A group of eight individuals with high cholesterol levels were given a new drug that was designed to lower cholesterol levels. Cholesterol levels, in mg/dL, were measured before and after treatment for each individual, with the following results: a. Can you conclude that the mean cholesterol level after treatment is less than the mean before treatment? b. Can you conclude that the reduction in mean cholesterol level after treatment is greater than 75mg/dL