Question: Dependent Variable Independent Variable Axis Y X Title Flight Hours (1,000 hrs) Starter Replacements 30 8 40 11 70 12 60 10 80 15 50
| Dependent Variable | Independent Variable | |||||||||
| Axis | Y | X | ||||||||
| Title | Flight Hours (1,000 hrs) | Starter Replacements | ||||||||
| 30 | 8 | |||||||||
| 40 | 11 | |||||||||
| 70 | 12 | |||||||||
| 60 | 10 | |||||||||
| 80 | 15 | |||||||||
| 50 | 13 | |||||||||
| Results | ||||||||||
| Questions to interpret the results of the regression analysis | Type answer in the box | |||||||||
| 1. Is the regression model statistically significant (Yes or No)? | ||||||||||
| 2. Highlight the cell in green that corresponds to the statistic value you used to answer question #1. | ||||||||||
| 3. For each unit increase in Starter Replacements, how much do Flight Hours change? | ||||||||||
| 4. How much variability (in %) in Flight Hours, can be explained by the regression model with Starter Replacements as the independent variable? | ||||||||||
| 5. Highlight the cell in blue that corresponds to the statistic value you used to answer question #4. | ||||||||||
| 6. What is the projected Flight Hours (1000 hrs) when the Starter Replacements is 0? | ||||||||||
| 7. Highlight the cell in yellow that correponds to the Correlation Coefficient. | ||||||||||
| 8. If the Starter Replacements is 13, what are the estimated Flight Hours (1000 Hrs)? | ||||||||||
| SUMMARY OUTPUT | ||||||||||
| Regression Statistics | ||||||||||
| Multiple R | 0.770207984 | |||||||||
| R Square | 0.593220339 | |||||||||
| Adjusted R Square | 0.491525424 | |||||||||
| Standard Error | 13.34039361 | |||||||||
| Observations | 6 | |||||||||
| ANOVA | ||||||||||
| df | SS | MS | F | Significance F | ||||||
| Regression | 1 | 1038.135593 | 1038.135593 | 5.833333333 | 0.073139544 | |||||
| Residual | 4 | 711.8644068 | 177.9661017 | |||||||
| Total | 5 | 1750 | ||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| Intercept | -13.22033898 | 28.76616241 | -0.459579515 | 0.66968656 | -93.08800981 | 66.64733184 | -93.08800981 | 66.64733184 | ||
| Starter Replacements | 5.93220339 | 2.45616555 | 2.415229458 | 0.073139544 | -0.88720543 | 12.75161221 | -0.88720543 | 12.75161221 | ||
| RESIDUAL OUTPUT | PROBABILITY OUTPUT | |||||||||
| Observation | Predicted Flight Hours (1,000 hrs) | Residuals | Percentile | Flight Hours (1,000 hrs) | ||||||
| 1 | 34.23728814 | -4.237288136 | 8.333333333 | 30 | ||||||
| 2 | 52.03389831 | -12.03389831 | 25 | 40 | ||||||
| 3 | 57.96610169 | 12.03389831 | 41.66666667 | 50 | ||||||
| 4 | 46.10169492 | 13.89830508 | 58.33333333 | 60 | ||||||
| 5 | 75.76271186 | 4.237288136 | 75 | 70 | ||||||
| 6 | 63.89830508 | -13.89830508 | 91.66666667 | 80 | ||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
