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

Facts regarding linear equations, To solve out linear equations we will mak...

To solve out linear equations we will make heavy use of the following facts. 1. If a = b then a + c = b + c for any c.  All it is saying that we can add number, c, to both sides

Solid mensuration., assuming that the earth''s sphere with a radius of 6400...

assuming that the earth''s sphere with a radius of 6400 km.. find the distance along a 3 degree arc at the equator of the earth''s surface?

Solid, The lateral edge of a pyramidal church spire is 61feet.Each side of ...

The lateral edge of a pyramidal church spire is 61feet.Each side of its octagonal base is 22feet. What will be the cost of painting the spire at 2.5 cents a square foot

What it means to count-learning to count, What do we understand by "being a...

What do we understand by "being able to count"? Think about the following situation before you answer. Example 1: Three year-old Mini could recite numbers from I to 20 in the co

Division, 1000000 divided by 19

1000000 divided by 19

The laplace method, The Laplace method Laplace method employs all the i...

The Laplace method Laplace method employs all the information by assigning equal probabilities to the possible payoffs for every action and then selecting such alternative whic

Marketing., what is product life cycle

what is product life cycle

Calculus, how to find relative extrema at the indicated interval of the fol...

how to find relative extrema at the indicated interval of the following functions and how to sketch it?

Compute the total and annual return on the investment, 1. Calculate the ann...

1. Calculate the annual interest that you will receive on the described bond-A $500 Treasury bond with a current yield of 4 .2% that is quoted at 106 points? 2. Compute the tota

Estimate the greatest possible number of calculators, Martha has $20 to spe...

Martha has $20 to spend and would like to buy as several calculators as possible along with the money. The calculators that she needs to buy are $4.50 each. How much money will she

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