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

How to solving one-step equations, How to Solving One-Step Equations? E...

How to Solving One-Step Equations? Equations, where one math operation is acting on the variable, can be solved in one step. The trick is to get the variable x by itself - isol

Parametric equations and polar coordinates, Parametric Equations and Polar ...

Parametric Equations and Polar Coordinates In this part we come across at parametric equations and polar coordinates. When the two subjects don't come out to have that much in

Counters and registers, design a synchronous, recycling, MOD-12 counter wit...

design a synchronous, recycling, MOD-12 counter with D FF''s. Use the states 0000 through 1011 in the counter.

Calculate the difference in payments of home mortgage loan, You have just r...

You have just renegotiated the interest rate of your home mortgage loan. (This is called rate modification.)  The original loan of $400,000 carries an interest rate is 6% has an or

Age problem, three years ago,Rica was thrice as old as dandy.Three years he...

three years ago,Rica was thrice as old as dandy.Three years hence,she will be twice as old.Find their present.

Reflection , How do you reflect about the origin

How do you reflect about the origin

Estimate the last month sales increased through only 1/2%, Sales increased ...

Sales increased through only 1/2% last month. If the sales from the previous month were $152,850, what were last month's sales? Multiply through the decimal equivalent of 1/2 %

He would such as to leave 20% tip how much should he leave, Mr. Pelicas too...

Mr. Pelicas took his family out to dinner. The bill was $65.00. He would such as to leave a 20% tip. How much should he leave? Find 20% by multiplying $65 through the decimal e

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