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

Angles, samuel left mauritius at 22:30 on saturday and travelled to london ...

samuel left mauritius at 22:30 on saturday and travelled to london (GMT) for 14h30min he had a stopover for 4 h in london and he continued to travel to toronto for another 6h20min

Arden''s Theorem, Find the Regular Grammar for the following Regular Expres...

Find the Regular Grammar for the following Regular Expression: a(a+b)*(ab*+ba*)b.

Trigonometry, important trigonometric formulas for class 10th CBSC board

important trigonometric formulas for class 10th CBSC board

Reduction formulae, assigenement

assigenement

ADDING AND SUBTRACTING EQUATION, GUESS THE NUMBER THAT WHEN YOU SUBTRACT 6 ...

GUESS THE NUMBER THAT WHEN YOU SUBTRACT 6 AND THEN SUBTRACT 0 IS-14

Factor , #Mai iss 3 years younger than twice the age of her brother . If b ...

#Mai iss 3 years younger than twice the age of her brother . If b represents the age of Mai''s brother .which expression below represents Mai''s age 2-3b 3-2b 2b-3 3b-2 2-3b 3-2b q

Characteristics of exponential smoothing, Characteristics of Exponential Sm...

Characteristics of Exponential Smoothing 1. More weight is described to the most recent data. 2. All past data are incorporated not like in moving averages. 3. Les

Emi, calculation of emi %

calculation of emi %

Define the correlations, A retention counselor at a state university believ...

A retention counselor at a state university believes that freshman year success is related to high school standard tests in math and reading, and in the number of credits the stude

Evaluate inverse tangents , Evaluate following limits. Solution ...

Evaluate following limits. Solution Here the first two parts are actually just the basic limits including inverse tangents and can easily be found by verifying the fol

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages