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

Find out a vector that is orthogonal to the plane, A plane is illustrated b...

A plane is illustrated by any three points that are in the plane. If a plane consists of the points P = (1, 0,0) , Q = (1,1,1) and R = (2, -1, 3) find out a vector that is orthogo

The perimeter of a rectangle is 104 inches find out width, The perimeter of...

The perimeter of a rectangle is 104 inches. The width is 6 inches less than 3 times the length. Find out the width of the rectangle. Let l = the length of the rectangle and let

Example of spiral development of the mathematics curriculum?, E1) Can you g...

E1) Can you give some more examples of the spiral development of the mathematics curriculum? E2) A Class 3 child was asked to add 1/4 + 1/5. She wrote 2/9. Why do you feel this

Compute the essential matrix and epipolar lines , 1. In Figure there are th...

1. In Figure there are three cameras where the distance between the cameras is B, and all three cameras have the same focal length f. The disparity dL = x0 - xL, while the disparit

Compound Interest, How do you calculate compound interest

How do you calculate compound interest

Trigonmetry, [3+tan20+tan80]/tan20+tan80

[3+tan20+tan80]/tan20+tan80

Example of exponential smoothing, Example of Exponential Smoothing ...

Example of Exponential Smoothing By using the previous example and smoothing constant 0.3 generate monthly forecasts Months Sales Forecast

Produce list containing m-vectors delta and lambda, The logarithm of the Po...

The logarithm of the Poisson mixture likelihood (3.10) can be calculated with the following R code: sum(log(outer(x,lambda,dpois) %*% delta)), where delta and lambda are m-ve

Examples on log rules, Examples on Log rules: Example: Calculate...

Examples on Log rules: Example: Calculate (1/3)log 10 2. Solution: log b n√A = log b A 1/n = (1/n)log b A (1/3)log 10 2 = log 10 3 √2 = log 10 1.

Probability transition matrices or brand switching, Define the Probability ...

Define the Probability Transition Matrices or Brand switching.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages