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

Determine does this point lie on the line, Does this Point Lie on The Line?...

Does this Point Lie on The Line? How do you know if a point lies on a given line? For example, does the point (1, 2) lie on the line 3x + y = 7? If you graph the line and the

Z-value, A study was conducted to determine the proportion of people who dr...

A study was conducted to determine the proportion of people who dream in black and white instead of color. Among 317317 people over the age of? 55, 7777 dream in black and? whi

., round 64 to the nearest 10

round 64 to the nearest 10

What are logarithmic function, The logarithm of a provided number b to the ...

The logarithm of a provided number b to the base 'a' is the exponent showing the power to which the base 'a' have to be raised to get the number b. This number is defined as log a

Plus, 1+1

1+1

Elli[ital paths of celestial bodies, Create a detailed diagram to describe ...

Create a detailed diagram to describe the equation of an ellipse in terms of it’s eccentricity and indicate how the foci and major and minor semi-axes are involved. Y

Prove that xa+ar=xb+br of circle, In figure, XP and XQ are tangents from X ...

In figure, XP and XQ are tangents from X to the circle with centre O. R is a point on the circle. Prove that XA+AR=XB+BR Ans: Since the length of tangents from externa

Finds out the center and radius of circle, Finds out the center & radius of...

Finds out the center & radius of each of the following circles & sketch the graph of the circle. a) x 2 + y 2 = 1 b) x 2 + ( y - 3) 2 = 4 Solution In all of these

Determine the probability that is of low quality, 1) A local factory makes ...

1) A local factory makes sheets of plywood. Records are kept on the number of mild defects that occur on each sheet. Letting the random variable x represent the number of mild de

Fractions, 2/6

2/6

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages