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

Find out the determinant, Find out the determinant: Find out the deter...

Find out the determinant: Find out the determinant of the following 3 x 3 matrix, expanding about row 1. Solution:

Construct a venn diagram, In a survey of 85 people this is found that 31 wa...

In a survey of 85 people this is found that 31 want to drink milk 43 like coffee and 39 wish tea.  As well 13 want both milk and tea, 15 like milk & coffee, 20 like tea and coffee

Indeterminate form, Indeterminate form : The 0/0 we initially got is calle...

Indeterminate form : The 0/0 we initially got is called an indeterminate form. It means that we don't actually know what it will be till we do some more work.  In the denominator

Simple harmonic motion, prove that the composition of two simple harmonic o...

prove that the composition of two simple harmonic of the same period and in the same straight line is also a simple harmonic motion of the same period.

Direct and inverse variation, A man can do a piece of work in 25 days how m...

A man can do a piece of work in 25 days how many people are required to complete same work in 15 days?

Systems of differential equations, For this point we've only looked as solv...

For this point we've only looked as solving particular differential equations. Though, many "real life" situations are governed through a system of differential equations. See the

Last year a math textbook cost $54 what is this years cost, Last year, a ma...

Last year, a math textbook cost $54. This year the cost is 107 percent of what it was last year. What is this year's cost? a. $59.78 b. $57.78 c. $61.00 d. $50.22 To ?nd out

Elementary row operations to reduce the augmented matrix, Consider the syst...

Consider the system of linear equations X + ay = 1 2x + 8y = b Where a and b are real numbers. (a)  Write out the augmented matrix for this system of linear equations.

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