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

Estimation of difference among population proportions , Estimation of diffe...

Estimation of difference among population proportions Assume the two proportions be described by P1 and P2, respectively,Then the difference absolute between the two proportion

Utilize the chain rule to differentiate, Chain Rule : Assume that we have ...

Chain Rule : Assume that we have two functions f(x) & g(x) and they both are differentiable. 1. If we define F ( x ) = ( f o g ) ( x ) then the derivative of F(x) is,

Area, #What is an easy way to find the area of any figure

#What is an easy way to find the area of any figure

Three whole divisions, In the National Hockey championship, there are 30 in...

In the National Hockey championship, there are 30 independent ice hockey teams. Every of the teams will play 82 official NHL games every year. Many teams will have to travel from t

Example of rounding off, Example of Rounding Off: Example: Round ...

Example of Rounding Off: Example: Round off the subsequent number to two decimal places. 6.238 Solution: Step 1: 8 is the number to the right of t

Pressure and vorticity distributions, Normal 0 false false ...

Normal 0 false false false EN-IN X-NONE X-NONE

Slope-intercept form, Slope-intercept form The ultimate special form of...

Slope-intercept form The ultimate special form of the equation of the line is possibly the one that most people are familiar with. It is the slope-intercept form. In this if

Probability of chosen number from 1st 500 divisble by 3or5 , IN THIS WE HAV...

IN THIS WE HAVE TO ADD THE PROBABILITY of 3 and 5 occuring separtely and subtract prob. of 3 and 5 occuring together therefore p=(166+100-33)/500=233/500=0.466

Trignometry, verify 4(sin^4 30^0+cos60^0 )-3(cos^2 ?45?^0-sin^2 90^0 )=2

verify 4(sin^4 30^0+cos60^0 )-3(cos^2 ?45?^0-sin^2 90^0 )=2

Laura paid $17 for jeans what was original price of jeans, Laura paid $17 f...

Laura paid $17 for a pair of jeans. The ticketed price was 20% off the original price plus the sign on the rack said, "Take an additional 15% off the ticketed price." What was the

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages