Forecasting by using least squares, Mathematics

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.

Posted Date: 2/16/2013 7:49:36 AM | Location : United States







Related Discussions:- Forecasting by using least squares, Assignment Help, Ask Question on Forecasting by using least squares, Get Answer, Expert's Help, Forecasting by using least squares Discussions

Write discussion on Forecasting by using least squares
Your posts are moderated
Related Questions
Urn A contains 1 white,2 black and 3 red balls;Urn B contains 2 white,1 black and 1 red balls;and Urn C contains 4 white,5 black and 3 red balls.One urn is chosen at random and two

writ the equation that describes the motion of a point on the wheel that has a center of 4m off the ground, has radius of 15 cm, makes a full rotation every 10 seconds and starts a


Joey participated within a dance-a-thon. His team begin dancing at on Friday 10 A.M. and stopped at 6 P.M. on Saturday. How many hours did Joey's team dance? From 10 A.M. Frida

Rounding whole numbers List the order in which nancy, amy, ethel and cindy line up in single file to board the school bus. Then match the girls with their heights, which are fo

what is the result if 816.537 is rounded to the nearest tenth

Pat is making a Christmas tree skirt. She needs to know how much fabric to buy. Using the example provided, calculate the area of the skirt to the nearest foot. a. 37.7 ft 2

how to round off 42,999,523

Solve discrete harmonic mapping of a given surface patch (suppose the surface is genus-0 and with one boundary) 1. Map the boundary loop onto a unit rectangle using chord-length

Evaluate following limits. Solution In this case we also contain a 0/0 indeterminate form and if we were actually good at factoring we could factor the numerator & den