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

Fractions, I have a log that is 1/3 in mud and the rest of it is 6 meters l...

I have a log that is 1/3 in mud and the rest of it is 6 meters long. How long is the entire log?

Partial Differentiation, If the sides angles of a triangle ABC vary in such...

If the sides angles of a triangle ABC vary in such a way that it''s circum - radius remain constant. Prove that, da/cos A +db/cos B+dc/cos C=0

Craig D, i need help in discrete mathematics on sets, relations, and functi...

i need help in discrete mathematics on sets, relations, and functions.

Linear approximation method for interpolation, Linear Approxi...

Linear Approximation Method This is a rough and ready method of interpolation and is best used when the series moves in predicted interval

Change of base of logarithms, Change of base: The final topic that we have...

Change of base: The final topic that we have to look at in this section is the change of base formula for logarithms. The change of base formula is,

Compounding and Simple Interest, A painting was purchased 11 years ago for ...

A painting was purchased 11 years ago for $26900. It has just been sold for $78000. Calculate the flat rate of appreciation p.a.

Solids, a can of soup is shaped like wich solid

a can of soup is shaped like wich solid

Coefficient of correlation denoted, Coefficient of Correlation Denoted ...

Coefficient of Correlation Denoted There are two methods which measure the degree of correlation among two variables these are denoted by R and r. (a) Coefficient of correl

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