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

Find the curve on the surface - shortest arc lenght, (a) Find the curve on ...

(a) Find the curve on the surface z=x 3/2 joining the points(x,y,z)=(0,0,0) and (1,1,1) has the shortest arc lenght? (b) Use a computer to produce a plot showing the surface an

Constructing tables versus rote learning maths, CONSTRUCTING TABLES VERSUS ...

CONSTRUCTING TABLES VERSUS ROTE LEARNING :  Ask any adult how she would help a child to acquire simple multiplication facts. There is a very strong possibility that she would say,

Linear programming problem, I have a linear programming problem that we are...

I have a linear programming problem that we are to work out in QM for Windows and I can''t figure out how to lay it out. Are you able to help me if I send you the problem?

Matlab, Help my matlab questions

Help my matlab questions

Rocks and minerals, question..how do u understand thr rock cycle

question..how do u understand thr rock cycle

Limits at infinity part ii, Limits At Infinity, Part II :  In this sectio...

Limits At Infinity, Part II :  In this section we desire to take a look at some other kinds of functions that frequently show up in limits at infinity.  The functions we'll be di

Range, identify the range of h(x)=2x+1

identify the range of h(x)=2x+1

Real and distinct roots, Now we start solving constant linear, coefficient ...

Now we start solving constant linear, coefficient and second order differential and homogeneous equations. Thus, let's recap how we do this from the previous section. We start alon

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