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

5th grader, my qustion is how do you muliply frations

my qustion is how do you muliply frations

If she remains going at similar rate how long will it take, Susan traveled ...

Susan traveled 114 miles in 2 hours. If she remains going at the similar rate, how long will it take her to go the remaining 285 miles of her trip? There is a 1 in 6 chance of

Simple harmonic motion, prove that the composition of two simple harmonic o...

prove that the composition of two simple harmonic of the same period and in the same straight line is also a simple harmonic motion of the same period.

Which of the subsequent numbers will yield a number larger, Which of the su...

Which of the subsequent numbers will yield a number larger than 23.4 while it is multiplied by 23.4? When multiplying through a number less than 1, you get a product in which i

Find the equation of circle concentric – coordinate geometry, 1. A point P(...

1. A point P(a,b) becomes (3,c) after reflection in x - axis, and (d,6) after reflection in the origin. Show that a = 3, b = - 6, c = 6, d = 2 2. If the pair of lines ax² + 2pxy

Determine a particular solution to differential equation, Determine a parti...

Determine a particular solution for the subsequent differential equation. y′′ - 4 y′ -12 y = 3e5t + sin(2t) + te4t Solution This example is the purpose that we've been u

Simultaneous linear equations (graphical method), Steps in solving graphica...

Steps in solving graphical method of simultaneous linear equations

volumes for solid of revolution, Volumes for Solid of Revolution Befo...

Volumes for Solid of Revolution Before deriving the formula for it we must probably first describe just what a solid of revolution is. To find a solid of revolution we start o

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