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

Shortricks, shortricks of compound interest

shortricks of compound interest

Introduction , what states and marketing tasks?

what states and marketing tasks?

Example of communicating the meaning of addition, Ms. Mehta teaches in a go...

Ms. Mehta teaches in a government primary school in Delhi. The children who come to her in Class 1 are familiar with a few numbers. At the beginning of the session, she asks the ch

Solve the form x2 - bx - c in factoring polynomials, Solve The form x 2 -...

Solve The form x 2 - bx - c in  Factoring Polynomials ? This tutorial will help you factor quadratics that look something like this: x 2 - 11x - 12 (No lead coefficient

Lcm, what is the LCM of 4, 6, 18

what is the LCM of 4, 6, 18

Initial conditions and boundary conditions, Initial Condition...

Initial Conditions and Boundary Conditions In many problems on integration, an initial condition (y = y 0 when x = 0) or a boundary condition (y = y

Porportions, how do you solve for porportions?

how do you solve for porportions?

Advantages and limitations of game theory, Advantages And Limitations Of Ga...

Advantages And Limitations Of Game Theory Advantage Game theory assists us to learn how to approach and understand a conflict condition and to develop the decision making

Normal Distribution, You don''t have to give me the answer. I just want to ...

You don''t have to give me the answer. I just want to know HOW to do it. In a set of 400 ACT scores where the mean is 22 and the standard deviation is 4.5, how many scores are ex

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