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

H, 6987+746-212*7665

6987+746-212*7665

Example of developing an understanding, In class 1, the teacher had written...

In class 1, the teacher had written down the digits 0,1, ...., 9 on the board. Then she made all the children recite the corresponding number names. Finally, she made them write th

Fraction, Ask question #Minimum 100 words accepted

Ask question #Minimum 100 words accepted

In terms of x what is the area of her garden, Laura has a rectangular garde...

Laura has a rectangular garden whose width is x 3 and whose length is x4. In terms of x, what is the area of her garden? Since the area of a rectangle is A = length times widt

Calculate moving average, Calculate Moving Average The table given bel...

Calculate Moving Average The table given below represents company sales; calculate 3 and 6 monthly moving averages, for data Months Sales

Geometry help, One of two complementary angles is 80& of the other. What is...

One of two complementary angles is 80& of the other. What is the degree measure of the smaller angle?

Determine the area of the regular octagon, Determine the area of the regula...

Determine the area of the regular octagon with the following measurements. a. 224 square units b. 112 square units c. 84 square units d. 169 square units b. See

What difference among the areas of the two sections of a, If the areas of t...

If the areas of two sections of a garden are 6a + 2 and 5a, what is the difference among the areas of the two sections within terms of a? Because the question asks for the diff

Optimization, Optimization : In this section we will learn optimization p...

Optimization : In this section we will learn optimization problems.  In optimization problems we will see for the largest value or the smallest value which a function can take.

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