Use Excel to answer all of the following questions:ABC company records during the past six weeks indicate the number of jobs requests: WEEK 1 2 3 4 5…

a.Should this company use both price and promotion dollars, or just one of them only, to determine the sales? Perform data analysis and Explain.b.Use the model you determined (multipleregression) to predict sales if price is set at $125 and advertising is $55.c.Then compare the forecast in (b) above with the forecast you would have made using each independent variable alone.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *