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

What is factoring of polynomials, What is Factoring of Polynomials? Fac...

What is Factoring of Polynomials? Factoring means much the same thing for polynomials as it does for integers. When you multiply several polynomials together, The polyn

Dividends, a

Multiples, The sum of the smallest and largest multiples of 8 up to 60 is?

The sum of the smallest and largest multiples of 8 up to 60 is?

What division means, WHAT DIVISION MEANS : Ask any primary school teacher...

WHAT DIVISION MEANS : Ask any primary school teacher which areas in arithmetic the children find very difficult. Division will probably top her list. This is not surprising. If y

Multiple, what number does not belong 43,47,53,59,65,67

what number does not belong 43,47,53,59,65,67

Find the are length and sketch the level curves, 1) Find the are length of ...

1) Find the are length of r(t) = ( 1/2t^2, 1/3t^3, 1/3t^3) where t is between 1 and 3 (greater than or equal less than or equal) 2) Sketch the level curves of f(x,y) = x^2-2y^2

Important points about the alternating series test, Important Points About ...

Important Points About the Alternating Series Test There are a several things to note about this test. Very first, unlike the Integral Test and the Comparison or Limit Compari

Evaluate the series, ?[1,99] x^5+2x^4+x^3+5x^2+6x+2÷x^2+2x

?[1,99] x^5+2x^4+x^3+5x^2+6x+2÷x^2+2x

Rolles therom, f(x)=sin x+cos x in the interval {0,90}

f(x)=sin x+cos x in the interval {0,90}

Ratio proportion unitary method, Find The Ratio Of : 2 dozens to a score

Find The Ratio Of : 2 dozens to a score

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages