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

Initial value problems, Write a Matlab function MyIVP that solves an initia...

Write a Matlab function MyIVP that solves an initial-value problem (IVP) for a system of ordinary differential equations (ODEs) of the form x ?(t) = f (t, x(t)), where f : R × Rn ?

Argument, what is the difference between argument and principle argument

what is the difference between argument and principle argument

Differential equations, Verify Liouville''''s formula for y "-y" - y'''' + ...

Verify Liouville''''s formula for y "-y" - y'''' + y = 0 in (0, 1) ?

Convert to scientific notation, 1 . If someone is 20 years old, deposits $3...

1 . If someone is 20 years old, deposits $3000 each year into a traditional IRA for 50 years at 6% interest compounded annually, and retires at age 70, how much money will be in th

Round 468.235 to the nearest hundredth, Round 468.235 to the nearest hundre...

Round 468.235 to the nearest hundredth ? The hundredths place is the second digit to the right of the decimal point (3). To decide how to round, you must like as at the digit t

Definition of a function, A function is a relation for which each of the va...

A function is a relation for which each of the value from the set the first components of the ordered pairs is related with exactly one value from the set of second components of t

Determine the volume of the hollow solid, A solid is formed by cutting the ...

A solid is formed by cutting the top off of a cone with a slice parallel to the base, and then cutting a cylindrical hole into the resulting solid. Determine the volume of the holl

Example of learning constructing tables versus rote , Maya says thafl for i...

Maya says thafl for instance, to help the children of Class 2 construct the '5 times table', she uses their hands. Each child counts how many fingers on one hand, and then how ma

Algebraic expressions, how to simplify an expression which has different si...

how to simplify an expression which has different signs

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