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

Estimate the grade resistance, The grade resistance is F=W sin θ, where θ i...

The grade resistance is F=W sin θ, where θ is the grade and W is the weight of the automobile.  What is the grade resistance of a 2500 pound car traveling on a 2.6 degree uphill gr

.fractions, what is the difference between North America''s part of the tot...

what is the difference between North America''s part of the total population and Africa''s part

Number line, I need to graph rational numbers on the number line Point A-.6...

I need to graph rational numbers on the number line Point A-.60, point B-1/4, point C-.4,point D-7/8

Geography, How do you find the maxima or minima on a parabolic graph?

How do you find the maxima or minima on a parabolic graph?

Find out the area of the region, Find out the area of the region enclosed b...

Find out the area of the region enclosed by y = x 2 & y =√x . Solution Firstly, just what do we mean by "area enclosed by". This means that the region we're interested in

Precalc, I dont understand arcsin and arccos and how to find the domain...h...

I dont understand arcsin and arccos and how to find the domain...help?

Find out a vector that is orthogonal to the plane, A plane is illustrated b...

A plane is illustrated by any three points that are in the plane.  If a plane consists of the points P = (1, 0,0) , Q = (1,1,1) and R = (2, -1, 3) find out a vector that is orthogo

Finance, Determine the value of a $1800 investment after six years at 9.3% ...

Determine the value of a $1800 investment after six years at 9.3% per year, simple interest

Precal, The law of cosines can only be applied to acute triangles. Is this ...

The law of cosines can only be applied to acute triangles. Is this true or false?

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