00 Incremental value New E Reader 400 700 900 1400 1900 2200 Relevant costs

00 incremental value new e reader 400 700 900 1400

This preview shows page 37 - 42 out of 46 pages.

A B C D E
Image of page 37
Image of page 38
Image of page 39
Image of page 40
$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.
Image of page 41
Image of page 42

You've reached the end of your free preview.

Want to read all 46 pages?

  • Fall '15
  • Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture