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

Find out the next number 320, Find out the next number in the subsequent pa...

Find out the next number in the subsequent pattern. 320, 160, 80, 40, . . . Each number is divided by 2 to find out the next number; 40 ÷ 2 = 20. Twenty is the next number.

Integration, integrate x over x+1

integrate x over x+1

Differential equations, particular solution of equation y''''-3y''-4y=2sinx...

particular solution of equation y''''-3y''-4y=2sinx

Calculate the average return, A department store faces a decision for a sea...

A department store faces a decision for a seasonal product for which demand can be high, medium or low. The purchaser can order 1, 2 or 3 lots of this product before the season beg

expected value, Describe the distribution of sample means shapefor samples...

Describe the distribution of sample means shapefor samples of n=36 selected from a population with a mean of μ=100 and a standard deviation of o=12. , expected value, and standard

Trigonometry, TRIGONOMETRY : "The mathematician is fascinated with the...

TRIGONOMETRY : "The mathematician is fascinated with the marvelous beauty of the forms he constructs, and in their beauty he finds everlasting truth." Example:

Unitary methods, john walked to school at an average speed of 3 miles/hr a...

john walked to school at an average speed of 3 miles/hr and jogged back along the same route at 5miles/hr. if his total time was 1 hour, what was the total number of miles in the

Wronskian, In the earlier section we introduced the Wronskian to assist us ...

In the earlier section we introduced the Wronskian to assist us find out whether two solutions were a fundamental set of solutions. Under this section we will look at the other app

#proving identity, sinX/cscX+secX/cosX=1

sinX/cscX+secX/cosX=1

#rounding off, I am the least two digit number which round off to 100?

I am the least two digit number which round off to 100?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages