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

Circles and cones, length of subnormal to the curve y2=2x+1 at (4,3)

length of subnormal to the curve y2=2x+1 at (4,3)

Micrometer, how to use a micrometer

how to use a micrometer

How much interest will she have made after 4 years, Celine deposited $505 i...

Celine deposited $505 into her savings account. If the interest rate of the account is 5% per year, how much interest will she have made after 4 years? Use the formula F = 9/5

Calculus, sq root of tan x dx

sq root of tan x dx

Integers, how to solve?

how to solve?

Alegrabra, how do you do algebra with division

how do you do algebra with division

Nature of mathematics 12th edition, $36.00*6/36+(-$3.60)x30/36

$36.00*6/36+(-$3.60)x30/36

Example of optimization , A piece of pipe is carried down a hallway i.e 10 ...

A piece of pipe is carried down a hallway i.e 10 feet wide. At the ending of the hallway the there is a right-angled turn & the hallway narrows down to 8 feet wide. What is the lo

Integration, Integration We have, so far, seen that differential ...

Integration We have, so far, seen that differential calculus measures the rate of change of functions. Differentiation is the process of finding the derivative

Unitary method, who ,why and when discovered unitary method

who ,why and when discovered unitary method

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