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

Alegbra, what iz the value of x if y=56

what iz the value of x if y=56

The mean value theorem with proof, The Mean Value Theorem Assume f(x)...

The Mean Value Theorem Assume f(x) is a function that satisfies both of the subsequent. 1. f(x) is continuous on the closed interval [a,b]. 2. f(x) is differentiabl

DIFFERENTIAL EQUATION, Find an integrating factor for the linear differenti...

Find an integrating factor for the linear differential equation and hence Önd its general solution: SOLVE T^ 2 DY DX+T2

Draw the graph for finite state machine, Consider the finite state machine ...

Consider the finite state machine whose state transition table is : Draw the graph for it. Ans: The graph for the automata according to the transition table is drawn b

Quadratic equation, can anyone explain me the concept of quadratic equation...

can anyone explain me the concept of quadratic equation?

Relation is not a function, The following relation is not a function. ...

The following relation is not a function. {(6,10) ( -7, 3) (0, 4) (6, -4)} Solution Don't worry regarding where this relation came from. It is only on

Integers, hi i would like to ask you what is the answer for [-9]=[=5] grade...

hi i would like to ask you what is the answer for [-9]=[=5] grade 7

Sas, can you tell me how to find the "x" and the "y" when trying to find if...

can you tell me how to find the "x" and the "y" when trying to find if two triangles are smiliar

Divide 6.8 × 105 by 2.0 × 102 write your answer scientific, Divide 6.8 × 10...

Divide 6.8 × 10 5 by 2.0 × 10 2 . Write your answer in scientific notation? To divide numbers written in scienti?c notation and divide the ?rst numbers (6.8 ÷ 2.0 = 3.4); the

Polar coordinates, THE CURVE C HAS POLAR EQUATION R=[X^1/2][E^X^2/PI]. WHER...

THE CURVE C HAS POLAR EQUATION R=[X^1/2][E^X^2/PI]. WHERE X IS GREATER THAN OR EQUAL TO 0 BUT LESS THAN OR EQUAL TO PI. THE AREA OF THE FINITE REGION BOUNDED BY C AND THE LINE X EQ

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages