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

What is the cost of one adult ticket, The cost of a student ticket is $1 mo...

The cost of a student ticket is $1 more than half of an adult ticket. Six adults and four student tickets cost $28. What is the cost of one adult ticket? Let x = the cost of a

Determine probability , You are going on a road trip and you buy snack pack...

You are going on a road trip and you buy snack packs and three different kind of beverages.  You buy 7 Cokes, 5 Pepsis and 4 Dr. Peppers.  You pull out two beverages at random.  An

Determine centigrade equivalent for a temperature, 1. 10 -2 is equal to ...

1. 10 -2 is equal to 2. If 3n = 27, what is the value of (4n) + 1 3. What is 1/100 of 10000? 4. The formula C=5/9 x (F-32) converts Centigrade temperature from Fa

Thinking mathematically-why learn mathematics, THINKING MATHEMATICALLY :  ...

THINKING MATHEMATICALLY :  Have you ever thought of what mental processes you are going through when you are solving a mathematical problem? Why don't you try the following proble

Example to understand division means, My nephew had been introduced to divi...

My nephew had been introduced to division by his teacher Ms. Santosh, in Class 3. He, and several of his friends who had been taught by her, appeared to be quite comfortable with t

Prove that the length of the altitude on the hypotenuse, If A be the area o...

If A be the area of a right triangle and b one of the sides containing the right angle, prove that the length of the altitude on the hypotenuse is 2  Ab /√ b 4 +4A 2 . An

Find the discount factors -linear interpolation, Find the discount factors ...

Find the discount factors -Linear interpolation: All rates should be calculated to 3 decimal places in % (e.g. 1.234%), the discount factors to 5 decimal places (e.g. 0.98765

What is the cost to generate, The production costs per week for generating ...

The production costs per week for generating x widgets is given by, C ( x ) = 500 + 350 x - 0.09 x 2 ,         0 ≤ x ≤ 1000 Answer following questions.  (a) What is the c

Estimate weight if telephone pole weighs 11.5 pounds foot, If a telephone p...

If a telephone pole weighs 11.5 pounds per foot, how much does a 32-foot pole weigh? Multiply 11.5 by 32; 11.5 × 32 = 368 pounds.

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