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

Factorization, 143

143

Inverse laplace transforms, Determining the Laplace transform of a function...

Determining the Laplace transform of a function is not terribly hard if we've found a table of transforms opposite us to use as we saw in the previous section. What we would want t

Metric and costamary, can you please help me with this topic that im on in ...

can you please help me with this topic that im on in classand I just don''t get it and can u help me with dividing fractions adding mutply subtract add

Heat loss in cylinderical pipe, project on heat loss in a cylindrical pipe

project on heat loss in a cylindrical pipe

Expected value, Expected Value For taking decisions under conditions of...

Expected Value For taking decisions under conditions of uncertainty, the concept of expected value of a random variable is used. The expected value is the mean of a probability

Projects, maths projects for class 11

maths projects for class 11

Solid geomerty, find the equation to the sphere through the circle xsqaure+...

find the equation to the sphere through the circle xsqaure+ysquare+zsquare+=9 , 2x+3y+4z=5

Reduction formulae, Reduction formulae Script for Introduction: ...

Reduction formulae Script for Introduction: First let us know what is meant by reduction formula. In simple words, A formula which expressess(or re

Example of business applications, An apartment complex contains 250 apartme...

An apartment complex contains 250 apartments to rent. If they rent x apartments then their monthly profit is specified by, in dollars,, P ( x

Simplify, (3+2)^2+1-3^2.5

(3+2)^2+1-3^2.5

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