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

ADDING AND SUBTRACTING EQUATION, GUESS THE NUMBER THAT WHEN YOU SUBTRACT 6 ...

GUESS THE NUMBER THAT WHEN YOU SUBTRACT 6 AND THEN SUBTRACT 0 IS-14

Oscar sold 2 glasses of milk for each 5 sodas he sold, Oscar sold 2 glasses...

Oscar sold 2 glasses of milk for each 5 sodas he sold. If he sold 10 glasses of milk, how many sodas did he sell? Set up a proportion along with milk/soda = 2/5 = 10x. Cross mu

Differential equation, ssss

ssss

What was joe's approximate raw act score, Using the same mean and standard ...

Using the same mean and standard deviation from problem 10 (mean m = 20.1 and a standard deviation s = 5.8). Joe was informed that he scored at the 68 th percentile on the ACT, wh

Binomial, how do you find the co=efficent when there are two brackets invol...

how do you find the co=efficent when there are two brackets involved?

In an election contested between a and b determine vote, In an election con...

In an election contested between A and B, A obtained votes equal to twice the no. of persons on the electoral roll who did not cast their votes & this later number was equal to twi

Shares and dividends, How do I proceed with a project on Shares and Dividen...

How do I proceed with a project on Shares and Dividends?

Combined mean and standard deviation -illustration, Combined mean Assu...

Combined mean Assume m be the combined mean Assume x 1 be the mean of first sample Assume x 2 be the mean of the second sample Assume n 1 be the size of the 1 st

Unitary method, Who discovered unitary method? ?

Who discovered unitary method? ?

Parallel lines, Parallel to the line specified by 10 y + 3x= -2 In this...

Parallel to the line specified by 10 y + 3x= -2 In this case the new line is to be parallel to the line given by 10 y ? 3x ? -2 and so it have to have the similar slope as this

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages