Question: Please, show step by step, I just need part D, E, and F. thank you. 5. Trends and Regression a. Calculate the Linear Trend Line

Please, show step by step, I just need part D, E, and F. thank you.

5. Trends and Regression

a. Calculate the Linear Trend Line for the following data

b. Using the Liner Trend Line, what sales do you forecast for July 2016 (plot the values)

c. Using the Linear Trend Line, what sales do you forecast for July 2017 (plot the values)

d. Comment on the quality/reliability of your forecasts - what concerns should you have regarding the accuracy of a linear trend line forecast? (50 words or less)

e. Select an alternative Trend Line that you think best fits the historical data. Make the same forecasts for July 2016 and July 2017 and plot them. What are the two values?

f. Is your forecast for using the alternative trend line more or less reliable, feasible than the Linear Trend Line above? Why or why not? (50 words or less)

Month

Sales

Month

Sales

Month

Sales

Oct-12

-1.94

Oct-13

5.73

Oct-14

8.63

Nov-12

0.06

Nov-13

5.80

Nov-14

7.75

Dec-12

1.76

Dec-13

7.37

Dec-14

7.66

Jan-13

1.78

Jan-14

5.53

Jan-15

9.79

Feb-13

3.13

Feb-14

7.22

Feb-15

9.53

Mar-13

4.25

Mar-14

6.54

Mar-15

7.08

Apr-13

4.21

Apr-14

9.42

Apr-15

9.79

May-13

1.94

May-14

7.97

May-15

9.44

Jun-13

5.62

Jun-14

8.85

Jun-15

9.26

Jul-13

3.11

Jul-14

9.16

Jul-15

7.71

Aug-13

5.28

Aug-14

9.88

Aug-15

9.63

Sep-13

5.21

Sep-14

10.09

Sep-15

8.95

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

3. Systolic blood pressure experiment A pilot experiment was run by John Spitak in 1987 to investigate the effect of jogging on systolic blood pressure. Only one subject was used in the pilot...

Q:

1 would you please show step by step of how to do this question? question 2 I will give a thumbs up Consider the following tasks, times, and predecessors for an assembly of set-top cable converter...

Q:

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

Q:

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

Q:

046 A B D E F F G . Use this blue area to include regression re Put first cell of regression output here 2 Data Table 1 3 Month 4 January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12...

Q:

please help me with these questions thank you QUESTION 1 In conjunction with the housing foreclosure crisis of 2009, many economists expressed increasing concern about the level of credit card debt...

Q:

what would the excel formula be for each question a-i? A major source of revenue in Texas is a state sales tax. One category of tax is classified as Retail Trade. The following table gives four years...

Q:

One important measure of workers' performance is their attendance record. A personnel manager at a large company with a serious absenteeism problem undertook a two-year study. She took a random...

Q:

assignment #1 (a), #2(a), (b) , (d) Problemi d. Use the regression tool to verify your results from part c. Is the trend Statistically significant? Use at least three methods from the regression...

Q:

BA540 -- Problem Set 1 Problem 1.2 (Chapter 5): PART A: The following table gives restaurant sales data for the Timber Ridge ski lodge over a three year period. For the first part of this exercise,...

Q:

What role does bank activity diversification play in the ability of a bank to exploit economies of scale and scope? What remains as the limitation to creating potentially greater benefits?

Q:

One of the first scientists to study the density of nitrogen was Lord Raleigh. He noticed that the density of nitrogen produced from the air seemed to be greater than the density of nitrogen produced...

Q:

Can you help me with General accounting question? ABC Corp's sales are $500,000, its variable costs are 60% of sales, and its operating income is $75,000. What is ABC Corp's operating leverage

Q:

he unct ons you creat n ev IS ass 9 thi assignment some WI only be called b or these functions the grading script wi vector_set_rotate vector _set _cumulative sum planar _rotation set R _planar...