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

Numerical analysis, just give me some tips to submit a good asignments

just give me some tips to submit a good asignments

Cycloid - parametric equations and polar coordinates, Cycloid The param...

Cycloid The parametric curve that is without the limits is known as a cycloid.  In its general form the cycloid is, X = r (θ - sin θ) Y = r (1- cos θ)  The cycloid pre

Integer., How do we add integers

How do we add integers

PROBABILITY.., Urn A contains 1 white,2 black and 3 red balls;Urn B contain...

Urn A contains 1 white,2 black and 3 red balls;Urn B contains 2 white,1 black and 1 red balls;and Urn C contains 4 white,5 black and 3 red balls.One urn is chosen at random and two

Compute standard and variance deviation, A firm is manufacturing 45,000 uni...

A firm is manufacturing 45,000 units of nuts. The probability of having a defective nut is 0.15 Compute the given i. The expected no. of defective nuts ii. The standard an

Rate and ratio, express 4:24 as fraction in lowest term

express 4:24 as fraction in lowest term

Tangent, construction of tangent when center not known

construction of tangent when center not known

Calculate zeros in the denominator of rational expressions, About Zeros in ...

About Zeros in the Denominator of Rational Expressions One thing that you must be careful about when working with rational expressions is that the denominator can never be zero

Detemine multiplying a polynomial by a monomial, Detemine Multiplying a Pol...

Detemine Multiplying a Polynomial by a Monomial? To multiply a polynomial by a monomial, use the distributive property. Let's start by talking about ordinary numbers. Say th

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