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

Progressions, * 2^(1/2)*4^(1/8)*8^(1/16)*16^(1/32) =

* 2^(1/2)*4^(1/8)*8^(1/16)*16^(1/32) =

Calculus, I need help with my calculus work

I need help with my calculus work

Diameter of the circle , The length of the diameter of the circle which tou...

The length of the diameter of the circle which touches the X axis at the point (1,0) and passes through the point (2,3) is ? Solution)  If a circle touches the x-axis, its equatio

Prove, Let Xn be a sequence of distinct real numbers. Defi ne E = {L : L is...

Let Xn be a sequence of distinct real numbers. Defi ne E = {L : L is a subsequential limit of Xn}. Prove E is closed.

How much more does she required to sell to meet her goal, Hanna's sales tar...

Hanna's sales target for the week is $5,000. So far she has sold $3,574.38 worth of merchandise. How much more does she required to sell to meet her goal? You must ?nd out the

Determine the displacement, Example: A 16 lb object stretches a spring 8/9...

Example: A 16 lb object stretches a spring 8/9 ft by itself. Here is no damping as well as no external forces acting on the system. The spring is firstly displaced 6 inches upward

Recognize the importance of famous numbers, Activity This activity will ...

Activity This activity will help you recognize the importance of some very famous numbers, as well as learn more about approximations. Directions Using the Internet, provi

Independent & Dependent functions, I am learning this at school today and I...

I am learning this at school today and I started getting confused which one is which, can you help me?

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