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

Word problem solving, the traffic light at three different road crossing ch...

the traffic light at three different road crossing change after every 48 seconds, 72 seconds and 108 seconds respectively. if they change simultaneously at 7 a.m., at what time wil

Integration, sketch the curve y=9-x2 stating the coordinates of the turning...

sketch the curve y=9-x2 stating the coordinates of the turning point and of the intersections with the axes.

How to multiply two fractions, Q. How to Multiply two Fractions? Multip...

Q. How to Multiply two Fractions? Multiplying fractions is really easy! The rule is: "multiply across"- You multiply the numerators, and you multiply the denominators.

What is the formula to know total area square shaped quilt, Cathy is formin...

Cathy is forming a quilt out of fabric panels that are 6 in through 6 in. She needs to know the total area of her square-shaped quilt. Which formula will she use? The area of a

Math 100, introduction to decimals

introduction to decimals

Free - damped vibrations, We are until now going to suppose that there will...

We are until now going to suppose that there will be no external forces acting on the system, along with the exception of damping obviously. Under this case the differential equati

Control a liner interpolation between original mesh, Use your keyboard to c...

Use your keyboard to control a linear interpolation between the original mesh and its planar target shape a. Each vertex vi has its original 3D coordinates pi and 2D coordinates

How much greater is 0.0543 than 0.002, How much greater is 0.0543 than 0.00...

How much greater is 0.0543 than 0.002? To ?nd out how much greater a number is, you required to subtract; 0.0543 - 0.002 = 0.0523. For subtract decimals and line the numbers up

Shares and dividend, i need some information on this topic for my holidays ...

i need some information on this topic for my holidays project..plz guide me what to do

On income and return from shares, a company declares a semu annual dividend...

a company declares a semu annual dividend on 5%.a man has 400 shares of the company.if his annual income from the share is rs 1000 find the face value of each share?

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