Please help me. I have to use excel but I'm not sure how to do it. Could
Question:
Please help me. I have to use excel but I'm not sure how to do it. Could you provide screen visual captures and steps of you putting the data into excel and showing the equations with the right graphs in the screen captures you provide so that I can do the process my self correctly.
1.The space shuttle Challenger accident in January 1986 was the result of the failure of O-rings used to seal field joints in the solid rocket motor due to the extremely low ambient temperatures at the time of launch.
Prior to the launch there were data on the occurrence of O-ring failures and the corresponding temperature on 25 prior launches or static firings of the motor.
# O-RINGS Failures Y variable | Launch TEMP (F) X variable |
6 | 40 |
3 | 52 |
3 | 53 |
2 | 57 |
2 | 58 |
1 | 63 |
0 | 66 |
0 | 67 |
0 | 67 |
0 | 68 |
0 | 68 |
0 | 69 |
1 | 70 |
2 | 70 |
0 | 70 |
0 | 71 |
0 | 72 |
0 | 73 |
0 | 75 |
0 | 75 |
0 | 76 |
0 | 76 |
0 | 78 |
0 | 79 |
0 | 80 |
0 | 81 |
A. Find the Sample correlation coefficient for this data set and analyze your response? Use excel and paste the result here.
B. Build and show the linear regression, quadratic regression, and cubic regression statistical models relating the Number O-ring failures to the temperature using excel. Show each of those equations and report your analysis. Which one do you prefer?
C. Predict the number of O-rings to failat a temperature of 0 Celsius = 32 F degrees using cubic regression model (show equation and final solution)