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

Naive regular perturbation of the form, Consider the equation e x 3 + ...

Consider the equation e x 3 + x 2 - x - 6 = 0, e > 0 (1) 1. Apply a naive regular perturbation of the form do derive a three-term approximation to the solutions

Help me, How should Shoppers’ Stop develop its demand forecasts?

How should Shoppers’ Stop develop its demand forecasts?

Differential Equations, Verify Liouville''s formula for y "-y" - y'' + y = ...

Verify Liouville''s formula for y "-y" - y'' + y = 0 in (0, 1) ?

Holistic marketing , Necessity of holistic marketing or importance of holis...

Necessity of holistic marketing or importance of holistic marketing

What is fibonacci sequence, what is Fibonacci Sequence? The most famous...

what is Fibonacci Sequence? The most famous sequence in mathematical history is called the Fibonacci sequence, discovered by the 12th-century mathematician Leonardo Fibonacci o

Describe common phrases to represent math operations, Describe Common Phras...

Describe Common Phrases to Represent Math Operations? The table below shows the common phrases used in word problems to represent addition, subtraction, multiplication, and div

Equivalent or equal sets, Equivalent or Equal sets Two sets C and D are ...

Equivalent or Equal sets Two sets C and D are said to be equal whether every member of set C belongs to D and every member of set D belongs also to C.

SHARES AND DIVIDEND, BROKARAGE.

BROKARAGE.

Triple integral transformed, An elliptical galaxy has gravitational boundar...

An elliptical galaxy has gravitational boundaries defiend by 9x 2 +16y 2 +144z 2 =144. A black hole at the center of the galaxy is interacting with dark matter producing a radiatio

Proof of various derivative facts formulas properties, PROOF OF VARIOUS DER...

PROOF OF VARIOUS DERIVATIVE FACTS/FORMULAS/PROPERTIES Under this section we are going to prove several of the different derivative facts, formulas or/and properties which we en

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages