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

Vector function - three dimensional spaces, Vector Function The good wa...

Vector Function The good way to get an idea of what a vector function is and what its graph act like is to look at an instance.  Thus, consider the following vector function.

Can tan theeta be integrated?, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Financial Math, can you help me with financial math??

can you help me with financial math??

Slopes downward from left to right has a positive slope, Can you explain th...

Can you explain that it is true that a line that slopes downward from left to right has a positive slope?

Describe three ways to write negative fractions, Describe Three Ways to Wri...

Describe Three Ways to Write Negative Fractions? There are three different ways that a negative fraction can be written. They are all represent the same value. 1. The negative

Sequences - calculus, Sequences Let us start off this section along wi...

Sequences Let us start off this section along with a discussion of just what a sequence is. A sequence is nothing much more than a list of numbers written in a particular orde

Describe about absolute values, Describe about Absolute Values ? When a...

Describe about Absolute Values ? When an integer is written with a vertical line on each side of the integer, it is called the absolute value of that integer. For example,

Rules of logarithms, Rule 1 The logarithm of 1 to any base is 0. Pro...

Rule 1 The logarithm of 1 to any base is 0. Proof We know that any number raised to zero equals 1. That is, a 0 = 1, where "a" takes any value. Therefore, the loga

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