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

Volume of grains in the silo , The volume of grains in a silo at a particul...

The volume of grains in a silo at a particular time (measured in hours) is given by V (t) = 4t(3-t) m 3 . Find the rate of change of the volume of grains in the silo from first pri

Patrice has worked a certain how many hours has she worked, Patrice has wor...

Patrice has worked a certain amount of hours so far this week. Tomorrow she will work four more hours to finish out the week along with a total of 10 hours. How many hours has she

Standard deviation, 2.When investigating times required for drive-through s...

2.When investigating times required for drive-through service, the following results (in seconds) were obtained. Find the range, variance, and standard deviation for each of the tw

Logorithms, log base 5 (3-2x) + log base 5 (2+x) = 1

log base 5 (3-2x) + log base 5 (2+x) = 1

Neuro marketing, Does neuro marketing give impetus to new consumer behavio...

Does neuro marketing give impetus to new consumer behaviour

Explain the vertex formula, Explain the Vertex Formula ? The vertex for...

Explain the Vertex Formula ? The vertex formula is a convenient way of finding the vertex of the graph for any quadratic function. The graph of the quadratic equation f(x) = ax

Matrices, Give me the assignment on the matrices...

Give me the assignment on the matrices...

Melisa and jennifer threw a fiftieth how much is a 20% tip, Melisa and Jenn...

Melisa and Jennifer threw a fiftieth birthday party for their father at a local restaurant. While the bill came, Melisa added a 15% tip of $42. Jennifer said in which the service w

Operation, What is a characteristic of operation

What is a characteristic of operation

Derivatives for logarithm, Logarithm Functions : Now let's briefly get the...

Logarithm Functions : Now let's briefly get the derivatives for logarithms.  In this case we will have to start with the following fact regarding functions that are inverses of ea

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