The historical data on sales, prices, and selling expenses of a company is given in table:

Using the regression tool in EXCEL, answer the following questions:

a.What is the estimated intercept (a) of the regression?

b.What is the estimated regression coefficient of the product's price (B1)?

c.What is the estimated regression coefficient of Selling Expense (B2)?

d.What is the coefficient of determination?

i tried to solve it be excel, i hope its correct.

regression homework - Excel X File Home Insert Page Layout Formulas Data Review View ? Tell me what you want to do. Sign in Share & Cut Calibri Copy - 11 AA 27 - T - Wrap Text General Normal Bad AutoSum ~ AYO Paste + Fill - Format Painter Merge & Center $ ~ % " 00 $.0 Conditional Format as| Good Neutral Insert Delete Format Formatting * Table Clear Sort & Find & Filter . Select Clipboard Font Alignment Number Styles Cells Editing 132 X V fx U S R Q P O N M K H G F E D X1 X Y Sales Price Selling Expense 8 16 16 2 9 9 4 14 14 4 9 10 7 5 13 13 5 7 11 SUMMARY OUTPUT 4 7 10 10 4 12 5 8 9 9 8 5 13 Regression Statistics 4 9 8 8 9 4 0.996501978 Multiple R UT V 14 11 7 11 4 15 0.993016192 R Square 3 13 5 13 w 16 0.990688256 Adjusted R Square 3 14 4 4 14 3 17 0.395259882 Standard Error 18 9 Observations ANOVA Significance F F MS SS 3.40625E-07 426.5650666 66.64241999 133.28484 Regression 0.156230374 0.937382245 Residual 134.2222222 Total Upper 95.0% Lower 95.0% Upper 95% Lower 95% P-value t Stat Standard Error Coefficients 27 17.52069166 10.86676262 17.52069166 10.86676262 4.53068E-05 10.4391853 1.359658511 14.19372714 Intercept 28 -0.621255573 -1.005476112 -0.621255573 -1.005476112 4.73288E-05 -10.35985492 0.078511316 -0.813365843 X Variable 1 29 0.727272777 0.023032 0.727272777 0.023032 0.040284165 2.606963004 0.143903994 0.375152388 X Variable 2 30 31 32 33 + |3aojg | 2do19 1do19 Ready + 100% LO emo 9 O A O (()) ENG 10:05 PM 3/15/2020