Question

Date	Sales
12-Jul	729.4
13-Jul	729.1
14-Jul	746.7
15-Jul	754.6
16-Jul	794.2

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?

Answer 1

1)

2)

3)

4)

Please revert back in case of any doubt.

Please upvote. Thanks in advance.