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

Calculate the area and perimeter of a right triangle, Calculate the area an...

Calculate the area and perimeter of a right triangle: Calculate the area and perimeter of a right triangle with a 9" base and sides measuring 12 and 15.  Be sure to involve th

ConnectEd, How do I increase and decrease tax and sales

How do I increase and decrease tax and sales

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 %

how much error, For a population with a mean of μ=70 and a standard deviat...

For a population with a mean of μ=70 and a standard deviation of o=20, how much error, on average, would you expect between the sample mean (M) and the population mean for each of

What is the average of his four quiz grades, Andy earned the subsequent gra...

Andy earned the subsequent grades on his four math quizzes: 97, 78, 84, and 86. What is the average of his four quiz grades? To ?nd out the average, you must add the items (97

Linear programming , Use the simplex method to solve the following LP Probl...

Use the simplex method to solve the following LP Problem. Max Z = 107x1+x2+2x3 Subject to 14x1+x2-6x3+3x4=7 16x1+x2-6x3 3x1-x2-x3 x1,x2,x3,x4 >=0

Absolute value, Consider x € R. Then the magnitude of x is known as it's...

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

Joey participated-a-thon how many hours did joey team dance, Joey participa...

Joey participated within a dance-a-thon. His team begin dancing at on Friday 10 A.M. and stopped at 6 P.M. on Saturday. How many hours did Joey's team dance? From 10 A.M. Frida

Wronskian, In the earlier section we introduced the Wronskian to assist us ...

In the earlier section we introduced the Wronskian to assist us find out whether two solutions were a fundamental set of solutions. Under this section we will look at the other app

Definition of laplace transforms, You know that it's all the time a little ...

You know that it's all the time a little scary while we devote an entire section just to the definition of something. Laplace transforms or just transforms can appear scary while w

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