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

Example of developing estimation skills, There are a variety of strategies ...

There are a variety of strategies that people use for developing this ability. For instance, while adding 1821,695 and 250, a person could estimate it mentally i) by rounding of

Topology, Is usual topology on R is comparable to lower limit topology on R...

Is usual topology on R is comparable to lower limit topology on R

N2, 5+5

5+5

One is then added to in which result what is final answer, Ten is decreased...

Ten is decreased through four times the quantity of eight minus three. One is then added to in which result. What is the final answer? The area of a square whose side measures

Decimals, which one of the following examples represents a repeating decima...

which one of the following examples represents a repeating decimal? 0.123123,1.111114,0.777777,4.252525?

Shares and dividends, how to find mv

how to find mv

Marketing, In a 2500 word report do the market analysis of China. Under thi...

In a 2500 word report do the market analysis of China. Under this you have to explain: - What are the advantages and disadvantages for foreign company to set up its business cent

Decision theory, DECISION THEORY People constantly make decision...

DECISION THEORY People constantly make decisions in their private lives as well as in their work. Some decisions are qualitative in terms of their implications and signi

Find probability simulation, A reliability system consists of 15 independen...

A reliability system consists of 15 independent components. The probability that a component works is 0.9 for each. The system works if at least 11 of the components work. Fi

Diferential equations, Find the normalized differential equation which has ...

Find the normalized differential equation which has {x, xex} as its fundamental set

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages