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 greater of two consecutive positive is 143, Find out the great...

Find out the greater of two consecutive positive odd integers whose product is 143. Let x = the lesser odd integer and let x + 2 = the greater odd integer. Because product is a

Pendulum, how many pendulum swings will it take to walk across the classroo...

how many pendulum swings will it take to walk across the classroom

Decision theory, DECISION THEORY People constantly make decision...

DECISION THEORY People constantly make decisions in their private lives as well as in their work. Some decisions are qualitative in terms of their implications and signi

Standard interpretations to derivatives, Standard interpretations to deriva...

Standard interpretations to derivatives Example Assume that the amount of money in a bank account is specified by P (t ) = 500 + 10

Example of repeated eigenvalues, Illustration : Solve the following IVP. ...

Illustration : Solve the following IVP. Solution: First get the eigenvalues for the system. = l 2 - 10 l+ 25 = (l- 5) 2 l 1,2 = 5 Therefore, we got a

John and charlie have a whole of 80 dollars he has x dollar, John and Charl...

John and Charlie have a whole of 80 dollars. John has x dollars. How much money does Charlie have? This problem translates to the expression 42 + (11 - 9) ÷ 2. Using order of o

Determine the size of the proposed repayments, Five years ago a business bo...

Five years ago a business borrowed $100,000 agreeing to repay the principal and all accumulated interest at 8% pa compounded quarterly, 8 years from the loan date. Two years after

Distinct eigenvalues-sketching the phase portrait, Sketch the phase portrai...

Sketch the phase portrait for the given system. Solution : From the last illustration we know that the eigenvectors and eigenvalues for this system are, This tu

3D Trigometry problems, I have difficuties in working out those 3D trigomen...

I have difficuties in working out those 3D trigomentry problems within teh shortest possible time. Are there any tricks to get through such problems as soon as possible?

Converting, I need help converting my project fractions to the number 1.

I need help converting my project fractions to the number 1.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages