Forecasting by using least squares, Mathematics

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 8th year

Solution

Years (x)

Sales (y)

xy

x2

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

    Σx2= 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 8th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.

Posted Date: 2/16/2013 7:49:36 AM | Location : United States







Related Discussions:- Forecasting by using least squares, Assignment Help, Ask Question on Forecasting by using least squares, Get Answer, Expert's Help, Forecasting by using least squares Discussions

Write discussion on Forecasting by using least squares
Your posts are moderated
Related Questions
Explain Comparing Mixed Numbers in maths? A mixed number is made up of two parts: a whole number and a fraction. For example: 2(3/4) 2(3/4) is read "two and three-fourths

the limit of f(x) as x approaches 5 is equal to 7. write the definition of limit as it applies to f at this point

The length of Kara's rectangular patio can be expressed as 2x - 1 and the width can be expressed as x + 6. In the terms of x, what is the area of her patio? Since the area of a

On 30 June 2012 Bill purchase a home by taking out a 30 year mortgage of $600,000 at 6% interest per annum, compounded months. Repayments are made at the end of each month. (a) Cal

give me the derivation of external division of sectional formula using vectors

help me with how to write sample of proportion using visual basic

Solve 2 ln (√x) - ln (1 - x ) = 2 . Solution: Firstly get the two logarithms combined in a single logarithm. 2 ln (√x) - ln (x  - l) = 2 ln ((√x) 2 ) ln (1 - x ) = 2

Graph     ( x - 2) 2 /9+4(y + 2) 2  = 1 Solution It is an ellipse. The standard form of the ellipse is                                                         ( x - h

In a right triangle ABC, right angled at C, P and Q are points of the sides CA and CB respectively, which divide these sides in the ratio 2: 1. Prove that  9AQ 2 = 9AC 2 +4BC 2

Consider x € R. Then the magnitude of x is known as it's absolute value and in general, shown by |x| and is explained as Since the symbol   always shows the nonnegative