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

Reflection matrix, how do i solve reflection matrix just looking at the num...

how do i solve reflection matrix just looking at the numbers in a matrix

Analyze the dynamic path of pork prices, A well-known simple model, applica...

A well-known simple model, applicable for analysing boom-bust cycles in agriculture, but extendable to analysing boom-bust cycles in many different areas of economics is the hog cy

Fractions, you need to cut the proper to cut 2''48 long studs to the prop...

you need to cut the proper to cut 2''*4*8 long studs to the proper length to make a finished wall 8" in height underneath the studs there will be a double plate made up of two piec

Determine the function notation, Given f (x) = - x 2 + 6 x -11 determine e...

Given f (x) = - x 2 + 6 x -11 determine each of the following. (a) f ( 2) (b) f ( -10) (c) f (t ) Solution (a) f ( 2) = - ( 2) 2 + 6(2) -11 = -3 (

lmc, what is the concept of lm

what is the concept of lmc

Definite integral, Definite Integral : Given a function f ( x ) which is c...

Definite Integral : Given a function f ( x ) which is continuous on the interval [a,b] we divide the interval in n subintervals of equivalent width, Δx , and from each interval se

Product of cube of binomial, #question.what is the meaning of this

#question.what is the meaning of this

Utilizes second derivative test to classify critical point, Utilizes the se...

Utilizes the second derivative test to classify the critical points of the function, h ( x ) = 3x 5 - 5x 3 + 3 Solution T

Sums., 111111-11111=

111111-11111=

Poisson probability distribution, Poisson Probability Distribution - ...

Poisson Probability Distribution - It is a set of probabilities which is acquired for discrete events which are described as being rare. Occasions similar to binominal distri

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages