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

Solving trig equations, Solving Trig Equations : Here we will discuss on s...

Solving Trig Equations : Here we will discuss on solving trig equations. It is something which you will be asked to do on a fairly regular basis in my class. Let's just see the

Find and classify all the equilibrium solutions, Find and classify all the ...

Find and classify all the equilibrium solutions to the subsequent differential equation. y' = y 2 - y - 6 Solution First, get the equilibrium solutions. It is generally

Compute the quartile coefficient of skewness, By using the above data compu...

By using the above data compute the quartile coefficient of skewness Quartile coefficient of skewness = (Q3 + Q1 - 2Q2)/(Q3 + Q1)                                The positio

quantitative, how to find group mean, mode and media

how to find group mean, mode and median

Two consecutive integers is 15 find out the larger integer, If the differen...

If the difference among the squares of two consecutive integers is 15 find out the larger integer. Let x = the lesser integer and let x + 1 = the greater integer. The sentence,

Course work2 , (b) The arity of an operator in propositional logic is the n...

(b) The arity of an operator in propositional logic is the number of propositional variables that it acts on – for example, binary operations (e.g, AND, OR, XOR…) act on two propo

Properties of reflection, explain under a reflection the image is laterally...

explain under a reflection the image is laterally inverted.

Steps for integration strategy - integration techniques, Steps for Integrat...

Steps for Integration Strategy 1. Simplify the integrand, if possible This step is vital in the integration process. Several integrals can be taken from impossible or ve

How many gumdrops, Will has a bag of gumdrops. If he eats 2 of his gumdrops...

Will has a bag of gumdrops. If he eats 2 of his gumdrops, he will have among 2 and 6 of them left. Which of the subsequent represents how many gumdrops, x, were originally in his b

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