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

Circle, 5-4

5-4

Differentiate inverse tangent functions, Differentiate the following functi...

Differentiate the following functions. (a) f (t ) = 4 cos -1 (t ) -10 tan -1 (t ) (b) y = √z sin -1 ( z ) Solution (a) Not much to carry out with this one other

Finding length and height with volume and width?, I figured out the volume ...

I figured out the volume and the width, but I have no idea how to use that information to get the height and the length!

Geometry, what are the parts of angles

what are the parts of angles

Applications of rational numbers, Kaylee makes 56 packages in seven hours T...

Kaylee makes 56 packages in seven hours Taylor makes 20% more packages in nine hours who makes more packages per hour

Theory of meta-games, Theory of Meta-games This theory shows to describ...

Theory of Meta-games This theory shows to describe how most people play non zero sum games concerning a number of persons Prisoner's dilemma is an illustration of this. The

What is the value of m+n, Every point (x,y) on the curve y=log2 3x is trans...

Every point (x,y) on the curve y=log2 3x is transferred to a new point by the following translation (x',y')=(x+m,y+n), where m and n are integers. The set of (x',y') form the curve

Group of symmetries, what is rotation

what is rotation

Find the value of given equations in polynomial , If α & ß are the zeroes ...

If α & ß are the zeroes of the polynomial 2x 2 - 4x + 5, then find the value of a.α 2 + ß 2 b. 1/ α + 1/ ß c. (α - ß) 2 d. 1/α 2 + 1/ß 2 e. α 3 + ß 3 (Ans:-1, 4/5 ,-6,

Evaluate the log function, Evaluate the log function: Calculate 3log 1...

Evaluate the log function: Calculate 3log 10 2. Solution: Rule 3. log (A n ) = nlog b A 3log 10 2 = log 10 (2 3 ) = log 10 8 = 0.903

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages