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

Triangles, what are rules of triangles?

what are rules of triangles?

Compound interest, principal=2000 rate=5% time=2 years find compound intere...

principal=2000 rate=5% time=2 years find compound interest

What is order of operations simplifying expressions, What is Order of Opera...

What is Order of Operations Simplifying Expressions? Kevin gives Don directions to his house: "Go left 3 blocks and then go right 2 blocks." Don wasn't paying close attention.

Standard trig equation, "Standard" trig equation: Now we need to move into...

"Standard" trig equation: Now we need to move into a distinct type of trig equation. All of the trig equations solved to this point were, in some way, more or less the "standard"

Ratios....., if the ratio of boys to girls ism 3 to 5, then what percent of...

if the ratio of boys to girls ism 3 to 5, then what percent of the students are boys

Integrals involving roots - integration techniques, Integrals Involving Roo...

Integrals Involving Roots - Integration Techniques In this part we're going to look at an integration method that can be helpful for some integrals with roots in them. We hav

Find vertex, y=3x^2+12+11

y=3x^2+12+11

Using karnaugh map, a) Using Karnaugh map, show X': A'BC'D'+ ABC'D'+ A'B...

a) Using Karnaugh map, show X': A'BC'D'+ ABC'D'+ A'BCD'+ ABCD' (b) If R is an equival

Average, A boy covered half of distance at 20km/hr and rest at 40kmlhr. cal...

A boy covered half of distance at 20km/hr and rest at 40kmlhr. calculate his average speed.

Calculus, need someone to log into my hawkes and complete homework due

need someone to log into my hawkes and complete homework due

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