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

Determine the exterior angle, Using the sketch below and the fact that ∠A +...

Using the sketch below and the fact that ∠A + ∠B + ∠C + ∠D = 325, Determine m∠E. a. 81° b. 35° c. 25° d. 75° b. The addition of the measures of the exterio

Graph of sine and cosine, what is the graph of 2 sin x

what is the graph of 2 sin x

How many hours does dee work, Susan begins work at 4:00 and Dee starts at 5...

Susan begins work at 4:00 and Dee starts at 5:00. They both finish at the similar time. If Susan works x hours, how many hours does Dee work? Since Susan started 1 hour before

Laplace transforms, As we saw in the previous section computing Laplace tra...

As we saw in the previous section computing Laplace transforms directly can be quite complex. Generally we just utilize a table of transforms when actually calculating Laplace tran

Chanllenge, a pizza driver delivered 27 pizzas in one night he delivered mo...

a pizza driver delivered 27 pizzas in one night he delivered more then one pizza to only one house . every other house he only delivered pizza to 18 houses . how many pizzas did he

Number, what is 5+10

what is 5+10

Core concepts of marketing, examination questions and answers to the above ...

examination questions and answers to the above title.

Express the product of -9p3r and the quantity 2p - 3r, Express the product ...

Express the product of -9p3r and the quantity 2p - 3r in simplified form. The translated expression would be -9p3r(2p - 3r). Noticed that the key word product means multiply.

Integration, Integration We have, so far, seen that differential ...

Integration We have, so far, seen that differential calculus measures the rate of change of functions. Differentiation is the process of finding the derivative

Money, how do you add 1,ooo and 100?

how do you add 1,ooo and 100?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages