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

Give the definition of logarithms, Give the Definition of Logarithms ? ...

Give the Definition of Logarithms ? A logarithm to the base a of a number x is the power to which a is raised to get x. In equation format: If x = ay, then log a x = y.

Estimate how much work is completed in stretching, A spring has a natural l...

A spring has a natural length of 20 Centimeter. A 40 N force is needed to stretch and hold the spring to a length of 30 Centimeter. How much work is completed in stretching the spr

Calculate the instantaneous rate of change of the volume, Assume that the a...

Assume that the amount of air in a balloon after t hours is specified by                                             V (t ) = t 3 - 6t 2 + 35 Calculate the instantaneous

Conditional probability: independent events, Conditional Probability: Indep...

Conditional Probability: Independent Events If the probability of an event is subject to a restriction on the sample space, the probability is said to be conditional. Co

Determine the volume of the box, Safe deposit boxes are rented at the bank....

Safe deposit boxes are rented at the bank. The dimensions of a box are (22x5x5) in. Determine the volume of the box? a. 220 in 3 b. 550 in 3 c. 490 in 3 d. 360 in 3

Logic family, what are the characteristic of digital ic

what are the characteristic of digital ic

In terms of x what is the volume of the rectangular prism, The dimensions o...

The dimensions of a rectangular prism can be expressed as x + 1, x - 2, and x + 4. In terms of x, what is the volume of the prism? Since the formula for the volume of a rectang

Explain angle pairs, Explain angle pairs ? Adjacent angle pairs Two an...

Explain angle pairs ? Adjacent angle pairs Two angles are adjacent if they: 1. Have the same vertex. 2. Share a common side. 3. Have no interior points in common. Definit

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