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

Probability, If a school has lockers with 50 numbers on each co...

If a school has lockers with 50 numbers on each combination lock, how many possible combinations using three numbers are there.

Market testing, what are the dangers of not market testing a product

what are the dangers of not market testing a product

Determine that the series is convergent or divergent, Determine or find out...

Determine or find out if the subsequent series is convergent or divergent. If it converges find out its value. Solution To find out if the series is convergent we fir

Compare and contrast african immigrants, Compare and contrast African immig...

Compare and contrast African immigrants with our immigrant groups? How are they different? What are the implications of these differences for their adjustment to the larger society

Determine the length of the rectangle, The height of a rectangle is 20 cm. ...

The height of a rectangle is 20 cm. The diagonal is 8 cm more than the length. Determine the length of the rectangle. a. 20 b. 23 c. 22 d. 21 d. To determine the len

Area and surface Are, I cant figure out how to study for my math test

I cant figure out how to study for my math test

Calculus, I need help with my calculus

I need help with my calculus

Solve 3 + 2 ln ( x /7+3 ) = -4 logarithm, Solve 3 + 2 ln ( x /7+3 ) = -4 . ...

Solve 3 + 2 ln ( x /7+3 ) = -4 . Solution This initial step in this problem is to get the logarithm by itself on one side of the equation along with a coefficient of 1.

Rlc circuit, State clearly that the current in an RLC circuit with an AC so...

State clearly that the current in an RLC circuit with an AC source with and without the use of complex variables

Verification cayley Hamilton theorem, (1 0 3 21 -1 1 -1 1) find A-1

(1 0 3 21 -1 1 -1 1) find A-1

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages