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

BIOMATH, Ask quHarvesting prevents the population size of a species from at...

Ask quHarvesting prevents the population size of a species from attaining its natural carrying capacity. We can add harvesting to the logistic model by assuming that the per capita

Proof integral function, Proof of: if f(x) > g(x) for a x b th...

Proof of: if f(x) > g(x) for a x b then a ∫ b f(x) dx > g(x). Because we get f(x) ≥ g(x) then we knows that f(x) - g(x) ≥ 0 on a ≤ x ≤ b and therefore by Prop

The shortest distance among the line y-x=1 and curve x=y^2, Any point on pa...

Any point on parabola, (k 2 ,k) Perpendicular distance formula: D=(k-k 2 -1)/2 1/2 Differentiating and putting =0 1-2k=0 k=1/2 Therefore the point is (1/4, 1/2) D=3/(32 1/2

Estimate the area of this field in terms of x and y, Jonestown High School...

Jonestown High School has a soccer field whose dimensions can be expressed as 7y 2 and 3xy. What is the area of this field in terms of x and y? Since the area of the soccer ?e

Define ab for given matrix, Define AB where: A = | 3 -...

Define A*B where: A = | 3 -3 6 | B = | 6 1 | | 0 4 2 | | 0 -5 |

Least common denominator using primes, Least Common Denominator Using Prime...

Least Common Denominator Using Primes: A prime number is a whole number (integer) whose only factors are itself and one. So the first prime numbers are given as follows: 1,

Riddles, I am a number yell my identity subtract 20 from me and add 30 make...

I am a number yell my identity subtract 20 from me and add 30 make the total twice to reach century you still need eight

Simple equations, three times the first of the three consecutive odd intege...

three times the first of the three consecutive odd integers is 3 more than twice the third integer. find the third integer.

Optikmization tecniques, simplex methord

simplex methord

Curvature, steps to trace the cartesian curve

steps to trace the cartesian curve

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages