Using excel Given the following data concerning weekly sale

* Using excel

Given the following data concerning weekly sales of large pizzas (Y) and weekly advertising expenditures(X)

X 150 100 250 180 210 100 120 180 170 160

Y 300 250 400 350 370 190 220 280 270 230

a) determine the regression equation.

b) Estimate Y when X-100

c) determine the coefficient of correlation r

d) determine the coefficient of determination r2

e) determine the standard error of estimate

Regression Equation

Y = 80.1 + 1.271 X

b) When X=100,Y=80.1+(1.271*100)=207.2

c) the coefficient of correlation r=0.878

d) coefficient of determination=r²=0.7715

e) the standard error of estimate=68.8