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

Coordinate geometry, find the value of x for which the distance between the...

find the value of x for which the distance between the points p(4,-5) and q(12,x) is 10 units

Graph f(x) = ex and g(x) = e- x - common graph, Graph f ( x ) = e x and g ...

Graph f ( x ) = e x and g ( x ) = e - x . Solution There actually isn't a lot to this problem other than ensuring that both of these exponentials are graphed somewhere.

Constrcut the adjacency matrix, Constrcut the adjacency matrix and the adja...

Constrcut the adjacency matrix and the adjacency lists for the graph G belowr.

Calculus, what is a domain of a function?

what is a domain of a function?

Allied mathematics, The tenth term in the binomial expansion of (1-1/4)(1-1...

The tenth term in the binomial expansion of (1-1/4)(1-1/5)(1-1/6)...(1-1/n+3) is equal to

Use newtons method to find out an approximation, Use Newton's Method to fin...

Use Newton's Method to find out an approximation to the solution to cos x = x which lies in the interval [0,2]. Determine the approximation to six decimal places. Solution

Trig, what is the domain of the function f(x)= 2x^2/x^2-9

what is the domain of the function f(x)= 2x^2/x^2-9

Quadaric equation, two numbers differ by 7 and have a product of 120.what a...

two numbers differ by 7 and have a product of 120.what are they ?

Shares and dividend, by purchasing rs.10 shares for rs.40 each mala gets 5%...

by purchasing rs.10 shares for rs.40 each mala gets 5% income on her investment. what rate of dividend is the company paying? what will be the amount of dividend if she buys 120 sh

Large samples, LARGE SAMPLES These are samples that have a sample size ...

LARGE SAMPLES These are samples that have a sample size greater than 30(that is n>30) (a) Estimation of population mean Here we suppose that if we take a large sample

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages