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 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.


Related Discussions:- Forecasting by using least squares

What is the probability that the integer chosen is divisible, An integer i...

An integer is chosen at random from the first two hundreds digit. What is the probability that the integer chosen is divisible by 6 or 8.                    (Ans : 1/4 ) Ans:

Prisoners dilemma, Prisoners Dilemma This is a type of non-zero sum gam...

Prisoners Dilemma This is a type of non-zero sum game and derives its name from the given story: The district attorney has two bank robbers in separate cells and offers them

Dividing mixed numbers, Dividing Mixed Numbers Dividing mixed numbers i...

Dividing Mixed Numbers Dividing mixed numbers is a 3-step process: 1. Convert the mixed numbers to improper fractions. 2. Divide the fractions 3. Convert the result ba

Pattern, 1,5,14,30,55 find the next three numbers and the rule

1,5,14,30,55 find the next three numbers and the rule

Equivalent Fractions and Decimals, write each fraction as a decimal .round ...

write each fraction as a decimal .round to the nearest hundredth if necessary (1-4) (14-21)

Sequences - calculus, Sequences Let us start off this section along wi...

Sequences Let us start off this section along with a discussion of just what a sequence is. A sequence is nothing much more than a list of numbers written in a particular orde

Introduction to computers, What is a Computer? A computer is ...

What is a Computer? A computer is an electronic device which senses or accepts input data, performs operations or computations on the data in a pre-arranged sequence

Evaluating functions, Next we have to talk about evaluating functions.  Eva...

Next we have to talk about evaluating functions.  Evaluating a function is in fact nothing more than asking what its value is for particular values of x. Another way of looking at

Determine rational exponents, Evaluate following. (a) 625 3/4 Solut...

Evaluate following. (a) 625 3/4 Solution  (a) 625 3/4 Again, let's employ both forms to calculate this one.             625 3/4   =( 625 1/4 ) 3 =(5) 3   = 12

Write Your Message!

Captcha
Free Assignment Quote

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd