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

What is the area of the court in square feet, A racquetball court is 40 ft ...

A racquetball court is 40 ft through 20 ft. What is the area of the court in square feet? The area of a rectangle is length times width. Thus, the area of the racquetball court

Interpretation, Interpretation A high value of r as +0.9 or - 0...

Interpretation A high value of r as +0.9 or - 0.9 only shows a strong association among the two variables but doesn't imply that there is a causal relationship that is

Add or subtract operations for complex numbers, performs the mentioned oper...

performs the mentioned operation and write the answers in standard form. ( -4 + 7 i ) + (5 -10 i ) Solution Actually there isn't much to do here other than add or subt

H, 6987+746-212*7665

6987+746-212*7665

Continuous random variable, Continuous Random Variable In the probabili...

Continuous Random Variable In the probability distribution the sum of all the probabilities was 1. Consider the variable X denoting "Volume poured into a 100cc cup from coff

Arclength surprise - mathematics, Suppose a unit circle, and any arc S on t...

Suppose a unit circle, and any arc S on the unit circle in the first quadrant. No matter where S is provided, the area between S and the x-axis plus the covered area between S and

Who had the highest batting average, Mike, Dan, Ed, and Sy played together ...

Mike, Dan, Ed, and Sy played together on a baseball team. Mike's batting average was 0.349, Dan's was 0.2, Ed's was 0.35, and Sy's was 0.299. Who had the highest batting average?

Simultaneous equations, two rolls of carpet cost £574, the first cost £8 pe...

two rolls of carpet cost £574, the first cost £8 per meter, the second which is 7m longer costs £7 p/m. how many meters are there in each roll

Brownian motion, How do I find the density of a square of a brownian motion...

How do I find the density of a square of a brownian motion .

Logarithmic function:solve for x: 4 log x2, Solve for x: 4 log x = log (15 ...

Solve for x: 4 log x = log (15 x 2 + 16) Solution:              x 4 - 15 x 2 - 16 = 0                (x 2 + 1)(x 2 - 16) = 0                x = ± 4   But log x is

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