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

Write following in terms of simpler logarithms, Write following in terms of...

Write following in terms of simpler logarithms.  (a) log 3 (9 x 4    / √y) Solution log 3 (9 x 4 / √y) =log ­ 3 9x 4 -  log  y (1/2) =log ­ 3 9 + log ­ 3 x 4

Angles, samuel left mauritius at 22:30 on saturday and travelled to london ...

samuel left mauritius at 22:30 on saturday and travelled to london (GMT) for 14h30min he had a stopover for 4 h in london and he continued to travel to toronto for another 6h20min

Math, The Timbuktu post office has only 3 cents and 7 cents stamps having r...

The Timbuktu post office has only 3 cents and 7 cents stamps having run out of all other denominations. What are the six amounts of postage that cannot be created? How do you know

Z-value, A study was conducted to determine the proportion of people who dr...

A study was conducted to determine the proportion of people who dream in black and white instead of color. Among 317317 people over the age of? 55, 7777 dream in black and? whi

Calculate the quarterly premium of a pension policy, You plan to retire whe...

You plan to retire when you are 65th years old.  You are now 25 years old.  You plan to buy a pension annuity that will pay you $100,000 per year starting one year after you turn 6

What is pythagorean triples, What is Pythagorean Triples? A set of thre...

What is Pythagorean Triples? A set of three numbers a, b, and c that can satisfy the equation A 2 +b 2 = c 2 , is called a Pythagorean triple. The following is a list of

Find the average, The center of a national park is located at (0,0). A spec...

The center of a national park is located at (0,0). A special nature preserve is bounded by by straight lines connecting the points A at (3,2), B at (5,1), C at (8,4) and D at (6,5)

Express the gcd as a linear combination, Express the GCD of 48 and 18 as a ...

Express the GCD of 48 and 18 as a linear combination.              (Ans: Not unique) A=bq+r, where  o ≤  r 48=18x2+12 18=12x1+6 12=6x2+0 ∴ HCF (18,48) = 6 now  6

What are various strategies adopted for learning maths, Give some children ...

Give some children around you a task in mathematics. The task should be in an area in which they' have not been given a large dose of algorithms and strategies. Do all of them foll

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