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

Linear differential equations, The first particular case of first order dif...

The first particular case of first order differential equations which we will seem is the linear first order differential equation. In this section, unlike many of the first order

Volume, #given that the perimeter of the buildig is 108m and the area of th...

#given that the perimeter of the buildig is 108m and the area of the floor is 138m, find the volume of the screed in m3 if it is 30mm thick

Rules for inequalities, Here we look at only the rules without going ...

Here we look at only the rules without going into their proofs. They are: a 0. If a If a If a

Stakeholders, what is the benefit for stakeholders or disadvantage in a mon...

what is the benefit for stakeholders or disadvantage in a monoply

Complex, find all the 8th roots of (19+7i)

find all the 8th roots of (19+7i)

Find out the length of hamiltonian path, Find out the length of Hamiltonian...

Find out the length of Hamiltonian Path in a connected graph of n vertices. Ans: The length of Hamiltonian Path in a connected graph of n vertices is n-1.

Difference between experiment and outcome, Difference Between Experiment an...

Difference Between Experiment and Outcome Experiment is an operation that produces outcomes which can be observed. Outcome/Event is the result of an experiment.

Divisiblety test, find the greater value of a and b so that the following e...

find the greater value of a and b so that the following even numbers are divisible by both 3 and 5 : 2ab2a

Fractions, how do i multiply and divide fractions?

how do i multiply and divide fractions?

Find the value of ((a+b)/(a-b)) , If arg (a/b) = pi/2, then find the value ...

If arg (a/b) = pi/2, then find the value of ((a+b)/(a-b)) where a,b are complex numbers. Ans) Arg (a/b) =Pi/2 Tan-1 (a/b)= Pi/2 A/B = tanP/2 ,therefore a/b=infinity.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages