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 shortest paths in the digraph, 1. a) Find the shortest paths from ...

1. a) Find the shortest paths from r to all other nodes in the digraph G=(V,E) shown below using the Bellman-Ford algorithm (as taught in class).  Please show your work, and draw t

Scatter graphs, Scatter Graphs - A scatter graph is a graph that compr...

Scatter Graphs - A scatter graph is a graph that comprises of points which have been plotted but are not joined through line segments - The pattern of the points will defin

#change of ratio, #in a picnic the ratio of boys to girls is 3:4. when 6 bo...

#in a picnic the ratio of boys to girls is 3:4. when 6 boys joined the group the ratio became even. how many boys were there before? how many children were there before? how many b

Determine the eigenvalues and eigenvectors of the matrix, Determine the eig...

Determine the eigenvalues and eigenvectors of the subsequent matrix. Solution : The first thing that we require to do is determine the eigen-values. It means we require

Find out the length of the parametric curve, Find out the length of the par...

Find out the length of the parametric curve illustrated by the following parametric equations. x = 3sin (t) y = 3 cos (t) 0 ≤ t ≤ 2? Solution We make out that thi

Obtain the number of significant modes, On the Assessment page for the modu...

On the Assessment page for the module Moodle site you will find five frequency response functions for the frequency range 20 to 100 Hz in the EXCEL spreadsheet "FRF_Data". These a

Ratio, how to make a tape diagram and a equivalent ratio

how to make a tape diagram and a equivalent ratio

Shares and dividends, I have a maths assignment as- Use a newspaper to stud...

I have a maths assignment as- Use a newspaper to study and give a report on shares and dividends.

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