Forecasting by using least squares, Mathematics

Assignment Help:

Forecasting By Using Least Squares

Data have been kept of sales over the last seven years

Year

1

2

3

4

5

6

7

Sales (in '000 units

14

17

15

23

18

22

27

It is required to forecast the sales for the 8th year

Solution

Years (x)

Sales (y)

xy

x2

1

14

14

1

2

17

34

4

3

15

45

9

4

23

92

16

5

18

90

25

6

22

132

36

7

27

189

49

       Σx=28

     Σy = 136

       Σxy=596

    Σx2= 140

136 = 7a + 28b

596 = 28a + 140b

∴b = 1.86

And substituting in one of the equations we acquire

a = 12

∴ Regression line = y = 12 + 1.86x

Or, Sales in ('000s of units) = 12.00 + 1.86 (no of years)

We utilize this expression for forecasting, for 8th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.


Related Discussions:- Forecasting by using least squares

Standard deviation, 2.When investigating times required for drive-through s...

2.When investigating times required for drive-through service, the following results (in seconds) were obtained. Find the range, variance, and standard deviation for each of the tw

Wit tester., two fathers and two sons went fishing . they caught only 3 fis...

two fathers and two sons went fishing . they caught only 3 fish and divided them equally among themselves without cutting. is it possible? how?

Geometry homework, i just have one question i need help on for my geometry ...

i just have one question i need help on for my geometry homework

Simple interest, Three payments of $2000 (originally due six months ago, to...

Three payments of $2000 (originally due six months ago, today, and six months from now) have been renegotiated to two payments: $3000 one month from now and a second payment due in

Conditional probability: independent events, Conditional Probability: Indep...

Conditional Probability: Independent Events If the probability of an event is subject to a restriction on the sample space, the probability is said to be conditional. Co

Market orientation, what is market orientation? what is the importance of ...

what is market orientation? what is the importance of market orientation?what are its implementation?

Evaluate of the largest angle, The measures of the angles of a triangle are...

The measures of the angles of a triangle are in the ratio of 3:4:5. Evaluate of the largest angle. a. 75° b. 37.5° c. 45° d. 60° a. The addition of the measures of t

Probability, An unbiased die is tossed twice .Find the probability of getti...

An unbiased die is tossed twice .Find the probability of getting a 4,5,6 on the first toss and a 1,2,3,4 on the second toss

Diferential equations, Find the normalized differential equation which has ...

Find the normalized differential equation which has {x, xex} as its fundamental set

Calculate the probability, Let D = 1 denotes the event that an adult male h...

Let D = 1 denotes the event that an adult male has a particular disease. In the population, it is known that the probability of having this disease is 20 percent, i.e., Pr (D = 1)

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd