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

Travel time, you are driving on a freeway to a tour that is 500 kilometers ...

you are driving on a freeway to a tour that is 500 kilometers from your home. after 30 minutes , you pass a freeway exit that you know is 50 kilometer from your home. assuming that

Plus, 236+2344+346=

236+2344+346=

Absolute convergence - sequences and series, Absolute Convergence Whil...

Absolute Convergence While we first talked about series convergence we in brief mentioned a stronger type of convergence but did not do anything with it as we didn't have any

Unit rates with fractions, a math problem that involves the numbers $112 fo...

a math problem that involves the numbers $112 for 8 hours

Volume of solids, find the volume of a rectangular based right pyramid with...

find the volume of a rectangular based right pyramid with its base 18 cm by 24 cm and the slanted edge 39 cm

Matrices, What is Matrices?

What is Matrices?

Operations with rational numbers, larry spends 3/4 hours twice a day walkin...

larry spends 3/4 hours twice a day walking and playing with his dog. He spends 1/6 hours twice a day feeding his dog. how much time does larry spend on his dog each day?

Distinct roots, There actually isn't a whole lot to do throughout this case...

There actually isn't a whole lot to do throughout this case. We'll find two solutions which will form a basic set of solutions and therefore our general solution will be as,

Monica, Express area of a square with sides of length 5ab as a monomial.

Express area of a square with sides of length 5ab as a monomial.

Subtraction - vector arithmetic, Subtraction - Vector arithmetic Compu...

Subtraction - Vector arithmetic Computationally, subtraction is very similar. Given the vectors a → = (a 1 , a 2 , a 3 ) and b → = (b 1 , b 2 , b 3 ) the difference of the t

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages