SALES/UNIT YEAR (THOUSANDS) PRICE $/UNIT 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 399 699 899 y bar- 1,302 1,137 1,193 899 1,105 970 1,233 898 809 281 224 211 217 224 198 228 207 220 211 233 252 Forecasted sales ADVERTISING ($000) a. Perform a regression analysis based on these data using Excel. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) 620 823 units 1,105 1,403 1,208 1,302 898 1,105 693 898 693 693 0.0314 Price + c. Predict average yearly speaker sales for Speakers and Company based on the regression results if the price was $299 per unit and the amount spent on advertising (in thousands) was $890. (Enter your answer in thousands. Do not round intermediate calculations. Round your answer to the nearest whole number.) 0.2136 Advertising

a. Perform a regression analysis based on these data using Excel. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.) c. Predict average yearly speaker sales for Speakers and Company based on the regression results if the price was $299 per unit and the amount spent on advertising (in thousands) was $890. (Enter your answer in thousands. Do not round intermediate calculations. Pound your answer to the nearest whole number)