Problem $3-29($Algo$)($PLEASE VERIFY YOUR ANSWER IS CORRECT!!!$)$

a$.$ Perform a regression analysis based on these data using Excel.

Note: Negative values should be Indleated by a minus slgn$.$ Round your answers to $4$ decimal places.

y bar $=$

Price

advertising

c$.$ Predict average yearly speaker sales for Speakers and Company based on the regression results if the price was $$295$ per unit and

the amount spent on advertising $($in thousands$)$ was $$895.$

Note: Enter your answer In thousands. Round your Intermedlate calculations and final answer to $2$ decimal places.