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

Determine the quotient and remainder , Let a = 5200 and b = 1320. (a) If...

Let a = 5200 and b = 1320. (a) If a is the dividend and b is the divisor, determine the quotient q and remainder r. (b) Use the Euclidean Algorithm to find gcd(a; b). (c)

Calculate average speed of a train, Calculate average speed of a train: ...

Calculate average speed of a train: What is the average speed of a train which completes a 450-mile trip in 5 hours? Solution: Using Equation 15: V av = s/t V a

How many pages can it print in 4 minutes, Tammi's latest printer can print ...

Tammi's latest printer can print 13.5 pages a minute. How many pages can it print in 4 minutes? Multiply 13.5 by 4 to ?nd out the number of copies made; 13.5 × 4 = 54 copies.

How is probability distribution of random variable construct, How is the pr...

How is the probability distribution of a random variable constructed? Usually, the past behavior of the variable is studied and the frequency distribution of the past data is form

Engg maths, How to get assignment to solve and earn money

How to get assignment to solve and earn money

Sample space, Sample Space is the totality of all possible out...

Sample Space is the totality of all possible outcomes of an experiment. Hence if the experiment was inspecting a light bulb, the only possible outcomes

Decimals, 2.46825141458*1456814314.446825558556

2.46825141458*1456814314.446825558556

Calculus, how much it cost an hour

how much it cost an hour

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