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

Scanning the demographic environment, I am working for supermarket chain an...

I am working for supermarket chain and responsible for the customer relationship management.The chain is planning to open exclusive thirst quenching service centers.These outlets w

Obligatory application and interpretation problem, Obligatory application/i...

Obligatory application/interpretation problem : Next, we need to do our obligatory application/interpretation problem so we don't forget about them. Example : Assume that the

L''hospital''s rule, L'Hospital's Rule Assume that we have one of the g...

L'Hospital's Rule Assume that we have one of the given cases, where a is any real number, infinity or negative infinity.  In these cases we have, Therefore, L'H

Dora, dora and her family are driving to visit relatives for the holidays t...

dora and her family are driving to visit relatives for the holidays they travel 174 miles in 3 hours if they travel at a constant speed how many miles do they travel in one hourest

3-d geometry, Q) In 3D-geometry give + and - signs for x,y,z, in all eight ...

Q) In 3D-geometry give + and - signs for x,y,z, in all eight octants Ans) There is no specific hard rule for numbering the octants. So, it makes no real sense to ask which octan

Estimate how much work is completed in stretching, A spring has a natural l...

A spring has a natural length of 20 Centimeter. A 40 N force is needed to stretch and hold the spring to a length of 30 Centimeter. How much work is completed in stretching the spr

Derive a boolean first-order query, Consider a database whose universe is a...

Consider a database whose universe is a finite set of vertices V and whose unique relation .E is binary and encodes the edges of an undirected (resp., directed) graph G: (V, E). Ea

Problem, La proporción de empleados de una empresa que usan su auto para ir...

La proporción de empleados de una empresa que usan su auto para ir al trabajo es 5:16. Si hay un total de 800 empleados, diga la cantidad de autos que se espera que haya estacionad

Logic, INSTRUCTIONS: Construct a regular proof to derive the conclusion of ...

INSTRUCTIONS: Construct a regular proof to derive the conclusion of the following argument: 1. H v (~T > R) 2. Hv (E > F) 3. ~T v E 4. ~H & D / R v F INSTRUCTIONS: Con

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