Question: Based on the excel report (I pasted the info at the bottom of the question). I do not have any other information. Thanks! Analyze the
Based on the excel report (I pasted the info at the bottom of the question). I do not have any other information.
Thanks!
- Analyze the regression results including all of the following in your analysis
- Adjusted R Squared
- Significance F
- P Value
- Coefficients
- Also state what overall conclusion you draw from this analysis
- Use your own words (you will not receive any credit for phrases copied from the textbook or video)
- Do not just state the numbers; indicate what the numbers are telling us
- Mention how you know that is what the numbers are telling us
- Explain in business terms how one variable would affect another (as applicable to that particular statistic) such as increase, decrease, positive relationship, negative relationship, strong or significant relationship, weak or not a significant relationship, etc.
- The explanations should be brief like bullet points (not lengthy sentences, not a paragraph)
| SUMMARY OUTPUT | |||||||||
| Regression Statistics | |||||||||
| Multiple R | 0.535927511 | ||||||||
| R Square | 0.287218297 | ||||||||
| Adjusted R Square | 0.26625413 | ||||||||
| Standard Error | 6938.734668 | ||||||||
| Observations | 36 | ||||||||
| ANOVA | |||||||||
| df | SS | MS | F | Significance F | |||||
| Regression | 1 | 659621859.2 | 659621859.2 | 13.70043883 | 0.000755105 | ||||
| Residual | 34 | 1636965319 | 48146038.79 | ||||||
| Total | 35 | 2296587178 | |||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| Intercept | 819247.4551 | 51893.25883 | 15.7871653 | 3.21959E-17 | 713787.6648 | 924707.2454 | 713787.6648 | 924707.2454 | |
| Advertising Expenses | 3.677554271 | 0.993554859 | 3.701410384 | 0.000755105 | 1.658407864 | 5.696700677 | 1.658407864 | 5.696700677 | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
