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

What was the original price of the coat before tax, Nick paid $68.25 for a ...

Nick paid $68.25 for a coat, including sales tax of 5%. What was the original price of the coat before tax? Since 5% sales tax was added to the cost of the coat, $68.25 is 105%

Shares and dividend, a man in rested rupee 800 is buying rupee 5 shares and...

a man in rested rupee 800 is buying rupee 5 shares and then are selling at premium of rupee 1.15. He sells all the shares.find profit

Properties of vector arithmetic, Properties of Vector Arithmetic If v, ...

Properties of Vector Arithmetic If v, w and u are vectors (each with the same number of components) and a and b are two numbers then we have then following properties. v →

Triangle, in triangle abc ab=ac and d is a point on side ac such that bc*bc...

in triangle abc ab=ac and d is a point on side ac such that bc*bc=ac*cd. prove that bc=bd

One-sided limits, One-sided limits: We do this along with one-sided limits...

One-sided limits: We do this along with one-sided limits. As the name implies, with one-sided limits we will just looking at one side of the point in question. Following are the

I want to learn mathematics, I was never really good at mathematics what is...

I was never really good at mathematics what is the best way? I am reading Math better explained but is there anything else I can do? I want to study advanced topics and get a good

Polar coordinates - parametric equations & polar coordinates, Polar Coordin...

Polar Coordinates Till this point we've dealt completely with the Cartesian (or Rectangular, or x-y) coordinate system. Though, as we will see, this is not all time the easie

Discrete Math - Set Theory, Show that A-B ? C ? A?B ? B?C?

Show that A-B ? C ? A?B ? B?C?

Derivatives, application of derivatives in engg.

application of derivatives in engg.

Principle of marketing by philip kotler, what is principle of marketing?

what is principle of marketing?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages