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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!