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

Power of x, (x+1/x)^2=3 then value of x^72+x^66+x^54+x^36+x^24+x^6+1 is

(x+1/x)^2=3 then value of x^72+x^66+x^54+x^36+x^24+x^6+1 is

Solve the form x2 - bx + c, The form x2 - bx + c ? This tutorial will ...

The form x2 - bx + c ? This tutorial will help you factor quadratics that look something like this: x 2 -7x + 12 (No leading coefficient; negative middle coefficient; p

Rarrrrrrrrrr, i need help in writing about a magic car?..

i need help in writing about a magic car?..

How will you use the Gantt chart for solving the sequencing, How will you u...

How will you use the Gantt chart for solving the sequencing problem?

How does the algorithm work?, How Does The Algorithm Work? Most of us, ...

How Does The Algorithm Work? Most of us, when asked to multiply, say, 35 by 23, write Why do we place the mark x (or 0, or leave a blank) in the second row of the calcul

Cylinder, #question Show that the enveloping cylinder of the conicoid ax 2 ...

#question Show that the enveloping cylinder of the conicoid ax 2 + by 2 + cz 2 = 1 with generators perpendicular to the z-axis meets the plane z = 0 in parabolas

Argument, what is the difference between argument and principle argument

what is the difference between argument and principle argument

MATH, I don''t understand so what is 3 (8-x);24-15

I don''t understand so what is 3 (8-x);24-15

Fractions, What is two-thirds plus two-thirds?

What is two-thirds plus two-thirds?

Fundamental theorem of integral facts formulasproperties, Fundamental Theor...

Fundamental Theorem of Calculus, Part I If f(x) is continuous on [a,b] so, g(x) = a ∫ x f(t) dt is continuous on [a,b] and this is differentiable on (a, b) and as,

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