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

Determine the area of the book jacket, A publishing company is creating a b...

A publishing company is creating a book jacket for a newly published textbook. Determine the area of the book jacket, given that the front cover is 8 in wide by 11 in high, the bin

Non-homogeneous differential equations, The Definition- The definition of ...

The Definition- The definition of the Laplace transforms. We will also calculate a couple Laplace transforms by using the definition. Laplace Transforms- As the earlier secti

Calculus, I need help with my calculus

I need help with my calculus

Chi-square hypothesis tests as non-parametric test(x2), Chi-square hypothes...

Chi-square hypothesis tests as Non-parametric test(X2) They contain amongst others i.    Test for goodness of fit ii.   Test for independence of attributes iii.  Test

ConnectEd, How do I increase and decrease tax and sales

How do I increase and decrease tax and sales

#title.square footage, The area of a rectangular yard is 480 square feet. T...

The area of a rectangular yard is 480 square feet. The yard is 24 feet wide. How many feet do I need to fence all four sides?

Trivial solution of equation, Specified a system of equations, (1), we will...

Specified a system of equations, (1), we will have one of the three probabilities for the number of solutions. 1.   No solution. 2.   Accurately one solution. 3.   Infinit

What is the smallest possible number 3, What is the smallest possible numbe...

What is the smallest possible number in which can be created along with four decimal places using the numbers 3, 5, 6, and 8? Place the smallest number in the largest place val

Which number falls among 5.56 and 5.81, Which number falls among 5.56 and 5...

Which number falls among 5.56 and 5.81? If you add a zero to the end of 5.6 to get 5.60, it is simpler to see that 5.56

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