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

Solid Mensuration, The two sides of a triangle are 17cm and 28cm long, and ...

The two sides of a triangle are 17cm and 28cm long, and the length of the median drawn to the third side is equal to 19.5 cm. What is the distance from an endpoint of the median to

How to grow your brand with existing customers., "To grow your brand, you n...

"To grow your brand, you need to encourage your existing customers to buy your product a liitle more often. It is far more important to maximise the number of times your buyers buy

Find the shortest paths in the digraph, 1. a) Find the shortest paths from ...

1. a) Find the shortest paths from r to all other nodes in the digraph G=(V,E) shown below using the Bellman-Ford algorithm (as taught in class).  Please show your work, and draw t

Parabola, please i need the answers to x^_7x+10 i want the vertex,axis of s...

please i need the answers to x^_7x+10 i want the vertex,axis of semetery,y intersect and the x intercept

Differential equations, Verify Liouville''s formula for y "-y" - y'' + y = ...

Verify Liouville''s formula for y "-y" - y'' + y = 0 in (0, 1) ?

Interpretations of definite integral, Interpretations of Definite Integral ...

Interpretations of Definite Integral There are some quick interpretations of the definite integral which we can give here. Firstly, one possible interpretation of the defini

Simpson rule - approximating definite integrals, Simpson's Rule - Approxima...

Simpson's Rule - Approximating Definite Integrals This is the last method we're going to take a look at and in this case we will once again divide up the interval [a, b] int

General solution to a differential equation, The general solution to a diff...

The general solution to a differential equation is the most common form which the solution can take and does not take any initial conditions in account. Illustration 5: y(t) =

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