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

Draw a lattice hierarchy for dimension, New England University maintains a ...

New England University maintains a data warehouse that stores information about students, courses, and instructors. Members of the university's Board of Trustees are very much inte

Differential equatoin, how to solve questions based on higher differential ...

how to solve questions based on higher differential equations

Multiplication and division, you want to share 34 pencils among 6 friends ....

you want to share 34 pencils among 6 friends .How many would each friend get?

., Two boys A and B are at two diametrically opposite points on a circle. A...

Two boys A and B are at two diametrically opposite points on a circle. At one instant the two start running on the circle; A anticlockwise with constant speed v and B clockwise wit

The new area is 168 square inches how many inches increase, A 4-inch by 6-i...

A 4-inch by 6-inch photograph is going to be enlarged through increasing each side by the similar amount. The new area is 168 square inches. How many inches is each dimension incre

Explain multiplying-dividing negative fractions, Explain Multiplying/Dividi...

Explain Multiplying/Dividing Negative Fractions? There are 3 steps to multiplying or dividing fractions. 1. If any negative signs are present, place them next to the numerator

Example of word problem, Example of Word problem: There is a man who i...

Example of Word problem: There is a man who is 21 years older than his son.  5 years ago he was four times as old as his son. How older are both now? Solution: Step 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