A B C D E
$136,297 98,715$139,114 75,886$165,575 83,3606Given the strong linear relationship between the advertising budget and uni sales in the previous example, can it be said that the budgeted dollars caused the salesA for Yes; B for No.7Use Excel's regression tool to perfrom a regression analysis for the budged and sales data in the above dataset. Treat the advertising budget as the independent varPlace the results In B97.8Using the TREND function as an ARRAY function, for the data in the above item predict the unit sales for the following advertising budget dollar amounts.$200,000$210,0009Use LINEST to perform a regression analysis on the budget and unit data above. Treat unit sales as the dependent variable.10The following adds additional data (Sales Price) to the dataset the previous problems used.Treating Advertising Budget and Sales Price, use the Regression tool in Data Analysisto conduct a regression analysis with Unit Sales as the dependent variable.Specify F137 as the Output Range.
You've reached the end of your free preview.
Want to read all 46 pages?
- Fall '15