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

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

Determine the head loss, A 3 km pipe starts from point A end at point B ...

A 3 km pipe starts from point A end at point B Population = 3000 people Q = 300 L/day/person Roughness = cast ion pipe Length of the pipe = 3km Case 1 From A to B

Venm diagrams, In a class, all pupils take Mathematics (M), 18 take Chemist...

In a class, all pupils take Mathematics (M), 18 take Chemistry (C), 17 take Biology (B) and 24 take Physics (P) of those taking 3 subjects only, 5 take Physics and Chemistry, 7 ta

Expressing the interest rate as a decimal fraction, Total Contribution per ...

Total Contribution per Year for next 10yeras =$1000+$800 =$1800 So Total Future fund Vaule  =$1800*(1+1.073+power(1.073,2)+ power(1.073,2)+ power(1.073,3)+ power(1.073,4)+ power

Computerised payroll package, How to calculate costs if you have a computer...

How to calculate costs if you have a computerised payroll package for your large business?

2(sin 6+cos6) - 3(sin4+cos4)+1 = 0, 2(sin 6 ?+cos 6 ?) - 3(sin 4 ?+cos 4 ?...

2(sin 6 ?+cos 6 ?) - 3(sin 4 ?+cos 4 ?)+1 = 0 Ans:    (Sin 2 ?)3  + (Cos 2 ?)3-3 (Sin 4 ?+(Cos 4 ?)+1=0 Consider (Sin 2 ?)3  +(Cos 2 ?)3 ⇒(Sin 2 ?+Cos 2 ?)3-3 Sin 2 ?Co

Acid solution, A 90% acid solution is mixed with a 97% acid solution to obt...

A 90% acid solution is mixed with a 97% acid solution to obtain 21 litres of a 95% solution. Findout the quantity of every solutions to get the resultant mixture.

6thgrade, do you have 3 digit and 4 digit number problem

do you have 3 digit and 4 digit number problem

AREA, How do you find the distributive property any faster?

How do you find the distributive property any faster?

Geometry, RS=8y+4 ST=4y+8 RT=15y-9 a.) WHAT IS THE VALUE OF y b.) FIND RS...

RS=8y+4 ST=4y+8 RT=15y-9 a.) WHAT IS THE VALUE OF y b.) FIND RS, ST, AND RT

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