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

Circles, If the distances from origin of the centres of 3 circles x 2 +y 2 ...

If the distances from origin of the centres of 3 circles x 2 +y 2 +2alphaix= a 2 (i=1,2,3) are in G.P. , then length of the tangents drawn to them frm any point on the circles x2+

Michael has 16 cds how many cds does kathleen have, Michael has 16 CDs. Th...

Michael has 16 CDs. This is four more than twice the amount that Kathleen has. How many CDs does Kathleen have? Let x = the number of CDs Kathleen has. Four more than twice th

Empty set or null set, Empty Set or Null Set It is a set which having ...

Empty Set or Null Set It is a set which having no elements. It is usually designated by a Greek letter Ø, or else { }. The sets Ø and { Ø } are not the same thing since the

Show line graphs and histograms, Q. Show Line graphs and Histograms? A...

Q. Show Line graphs and Histograms? Ans. Line graphs are closely related to histograms. Look at the graph below. It shows the line graph of the example above but also in

Determine the conditional probability, Consider a class of 55 students. The...

Consider a class of 55 students. The student names are placed in a hat and 3 names are randomly drawn without replacement. a) If the first person drawn was named the class presi

Indices, what are the advantages and disadvantages of both Laspeyres and Pa...

what are the advantages and disadvantages of both Laspeyres and Paasche index

Comparing and scaling, a dairy mngr says it takes 70lbs of make 10 lbs of c...

a dairy mngr says it takes 70lbs of make 10 lbs of cottage cheese... How do I make a rate table and a make a graph showing the relationship between lbs of milk and lbs of cottage c

Domain and range of a relation, Consider R be a relation from A to B, that ...

Consider R be a relation from A to B, that is, take R A Χ B. Then Domain R = {a: a € A, (a, b) € R for any b € B} i.e. domain of R is the set of all the first components of

How high is a structure, One method of calculating the height of an object ...

One method of calculating the height of an object is to place a mirror on the ground and then position yourself so that the top of the object will be seen in the mirror. How high i

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