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 8^th year

Solution

Years (x)	Sales (y)	xy	x²
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	Σx²= 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 8^th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.

Related Discussions:- Forecasting by using least squares

4.4238/[1.047+{1.111[9.261/7.777]}1.01, Ask question #Min 4.4238/[1.047+{...

Ask question #Min 4.4238/[1.047+{1.111*[9.261/7.777]}*1.01

Triangles, In a triangle ABC, D &E is a are points on AB & AC ,if the one s...

In a triangle ABC, D &E is a are points on AB & AC ,if the one side of a triangle is 4cm & another side is 5 cm find that the ar(triangleABC):ar(BCDE)

Partial Differential Equations Walter A Strauss, Find the full fourier Seri...

Find the full fourier Series of e^x on (-l,l)in its real and complex forms. (hint:it is convenient to find the complex form first)

Rounding fractions and mixed numbers, round each number to the nearest half...

round each number to the nearest half 2 over 5

Calculate log equation, Calculate log equation: Calculate log 10 2 - ...

Calculate log equation: Calculate log 10 2 - log 10 3. Solution: Rule 2. log 10 (A/B): log 10 A - log 10 B log 10 2 - log 10 3 = log 10 (2/3) =

What is the volume of this prism in terms of x, The area of the base of a p...

The area of the base of a prism can be expressed as x2 + 4x + 1 and the height of the prism can be expressed as x - 3. What is the volume of this prism in terms of x? Because t

Addition of like terms with same signs, Case 1: Suppose we are given...

Case 1: Suppose we are given expressions like 3abc and 7abc and asked to compute their sum. If this is the case we should not worry much. Because adding like exp

Harold used a 3% iodine solution and a 20% iodine solution, Harold used a 3...

Harold used a 3% iodine solution and a 20% iodine solution to make a 95- ounce solution in which was 19% iodine. How many ounces of the 3% iodine solution did he use? Let x = t

Operations research, captial budgeting

captial budgeting

Trigonometry, If sec A = x+i/x, prove that sec A + tan A = 2x or 1/2x

If sec A = x+i/x, prove that sec A + tan A = 2x or 1/2x

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages