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

Non linear relationships, Non Linear Relationships If the correlation ...

Non Linear Relationships If the correlation coefficient and the scatter diagram do not indicate linear relationship, then the relationship may be nonlinear. Two such relations

Average function value of even and odd function, Average Function Value ...

Average Function Value The first application of integrals which we'll see is the average value of a function. The given fact tells us how to calculate this. Average Functi

Show that 571 is a prime number, Show that 571 is a prime number. Ans: ...

Show that 571 is a prime number. Ans: Let x=571⇒√x=√571 Now 571 lies between the perfect squares of (23)2 and (24)2 Prime numbers less than 24 are 2,3,5,7,11,13,17,1

.fractions, what is the difference between North America''s part of the tot...

what is the difference between North America''s part of the total population and Africa''s part

Writing decimal place value in words, How will you write this in words 216....

How will you write this in words 216.9805

Determine the relative global error, Consider the differential equation giv...

Consider the differential equation give by y′ = -10(y - sin t) (a) Derive by hand exact solution that satis?es the initial condition y(0) = 1. (b) Numerically obtain the s

Undamped - forced vibrations, We will firstly notice the undamped case. The...

We will firstly notice the undamped case. The differential equation under this case is, mu'' + ku = F(t) It is just a non-homogeneous differential equation and we identify h

Horizontal asymptote, The horizontal asymptote of (16x+7)(x^2-5)/(x^2+36).

The horizontal asymptote of (16x+7)(x^2-5)/(x^2+36).

Intergrated algebra, -1

-1

Rationalize the denominator, (4 sqrt3+5 sqrt2)/(sqrt48+ srt18)

(4 sqrt3+5 sqrt2)/(sqrt48+ srt18)

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages