Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started