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 determinant, Find out the determinant: Find out the deter...

Find out the determinant: Find out the determinant of the following 3 x 3 matrix, expanding about row 1. Solution:

Securities markets, who investing in securities markets

who investing in securities markets

Construct a venn diagram, In a survey of 85 people this is found that 31 wa...

In a survey of 85 people this is found that 31 want to drink milk 43 like coffee and 39 wish tea. As well 13 want both milk and tea, 15 like milk & coffee, 20 like tea and coffee

Binomial expansion, 2+(+3)=

2+(+3)=

Indeterminate form, Indeterminate form : The 0/0 we initially got is calle...

Indeterminate form : The 0/0 we initially got is called an indeterminate form. It means that we don't actually know what it will be till we do some more work. In the denominator

Simple harmonic motion, prove that the composition of two simple harmonic o...

prove that the composition of two simple harmonic of the same period and in the same straight line is also a simple harmonic motion of the same period.

Direct and inverse variation, A man can do a piece of work in 25 days how m...

A man can do a piece of work in 25 days how many people are required to complete same work in 15 days?

Systems of differential equations, For this point we've only looked as solv...

For this point we've only looked as solving particular differential equations. Though, many "real life" situations are governed through a system of differential equations. See the

Last year a math textbook cost $54 what is this years cost, Last year, a ma...

Last year, a math textbook cost $54. This year the cost is 107 percent of what it was last year. What is this year's cost? a. $59.78 b. $57.78 c. $61.00 d. $50.22 To ?nd out

Elementary row operations to reduce the augmented matrix, Consider the syst...

Consider the system of linear equations X + ay = 1 2x + 8y = b Where a and b are real numbers. (a) Write out the augmented matrix for this system of linear equations.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages