The owner of a retail store randomly selected weekly data on profits and advertising cost and asked a statistics student to analysis and interpret the results. Excel output is shown below: s) what is the correlation between advertising cost and profits?b) what percentage of profit is accounted for by using advertising cost?c) how many pairs of data were used in the sample?d) if advertising costs of equal $100, what is the predicted profit?e) is there a significant relationship between advertising cost and profit? Make this decision with a level of significance of 5%.Explain your decision.f) should the regression equation be used to predict profits?

The owner of a retail store randomly selected weekly data on profits and advertising cost and asked a statistics stud Excel output is shown below: SUMMARY OUTPUT Regression Statistics Multiple R 0.9562 R Square 0.9336 Adjusted R Square 0.9115 Standard Error 23.9274 Observations 5 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 210.068 17.865 11.759 0.0013 153.2146 266.9206 Advertising Cost 0.808 0.124 6.496 0.0074 0.4122 1.2040 a) What is the correlation between advertising costs and profits