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

Show that a slope will vary along a curve, Can you show that a slope will v...

Can you show that a slope will vary along a curve (as opposed to a straight line)?

Non linear regression, solve the parameter estimate in v=a+bx+cx^2

solve the parameter estimate in v=a+bx+cx^2

Solutions to systems, Now that we've found some of the fundamentals out of ...

Now that we've found some of the fundamentals out of the way for systems of differential equations it's time to start thinking about how to solve a system of differential equations

Explain the algebraic expressions and equations, Explain the Algebraic Expr...

Explain the Algebraic Expressions and Equations? Writing a math problem algebraically means that you are using numbers and variables to represent relationships. "Three inche

Find the largest possible positive integer, Find the largest possible posit...

Find the largest possible positive integer that will divide 398, 436, and 542 leaving remainder 7, 11, 15 respectively. (Ans: 17) Ans: The required number is the HCF of the n

Sum of a number of terms in g.p., We know that the terms in G.P. are:...

We know that the terms in G.P. are: a, ar, ar 2 , ar 3 , ar 4 , ................, ar n-1 Let s be the sum of these terms, then s = a + ar + ar 2

Hypothesis testing procedure, Hypothesis Testing Procedure Whenever a b...

Hypothesis Testing Procedure Whenever a business complaint comes up here is a recommended procedure for conducting a statistical test. The reason of such a test is to establish

Matrix addition and subtraction, What is Matrix addition and subtraction? I...

What is Matrix addition and subtraction? Illustrate the procedure of Matrix addition and subtraction.

Help with individual questions, Hi, I''m looking for assistance/solutions t...

Hi, I''m looking for assistance/solutions to individual questions. I''ve already answered them but seek confirmation my answers are correct. I don''t want answers to a complete e

Determine principal strains and direction , A 100 by 150 mm rectangular pla...

A 100 by 150 mm rectangular plate is deformed as shown in the following figure. All dimensions shown in the figure are in millimeters. Determine at point Q: (a) the strain compone

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages