Using the sales amount given in the table answer the next questions: (1) Calculate the forecast sales
Question:
Using the sales amount given in the table answer the next questions:
(1) Calculate the forecast sales for the year 2017, 2018, and 2019 using the TREND function.
(2) Add a line chart with markers using insert function
(3) Add a Trendline to show a linear line
(4) Display the Equation and R-squared on Chart.
Using the sales table given to answer the next questions. See the next worksheet for steps
(1) To get a visual picture of the historical relationship, create a scatter chart of the data (sales and Cash).
(2) What do you notice? What kind of relationship between sales and Cash does the plot suggest?
Run regression analysis and answer the following:
(3) What exactly is the relationship between Sales and Cash as per the regression results? Does it confirm to your guess from (2) above? Why (not)?
(4) How much of the variablitity in Cash can be explained by Sales?
(5) How good is the coefficient on Sales? I.e., how confident are you about the aforementioned relationship between cash and sales?
Date | Sales |
12-Jul | 729.4 |
13-Jul | 729.1 |
14-Jul | 746.7 |
15-Jul | 754.6 |
16-Jul | 794.2 |
Quantitative Analysis for Management
ISBN: 978-0133507331
12th edition
Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha