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 8^th year

Solution

Years (x)	Sales (y)	xy	x²
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	Σx²= 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 8^th 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

Math III Stem, 7=1/w-4(1/11

7=1/w-4(1/11

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.

Nombor berarah, pendaraban dan

pendaraban dan

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages