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

Algebra, (a+b+c)2=

(a+b+c)2=

Calculate the edges in an undirected graph, Calculate the edges in an undir...

Calculate the edges in an undirected graph along with two vertices of degree 7, four vertices of degree 5, and the remaining four vertices of degree are 6? Ans: Total degree of

Algebra, (x+15)/y=10 where y=5

(x+15)/y=10 where y=5

How far off shore is the sinking ship, A sinking ship signals to the shore ...

A sinking ship signals to the shore for assistance. Three individuals spot the signal from shore. The ?rst individual is directly perpendicular to the sinking ship and 20 meters in

Class 10 cbse maths, Exercise 12c question number 24

Exercise 12c question number 24

Matrix, how to find eigen value for the given matrix 122 021 -122

how to find eigen value for the given matrix 122 021 -122

In how many years is the population expected to be 42, The population of a ...

The population of a particular city is increasing at a rate proportional to its size. It follows the function P(t) = 1 + ke 0.1t where k is a constant and t is the time in years.

Calculate the fourier cosine series, The Fourier series expansion for the p...

The Fourier series expansion for the periodic function, f ( t ) = |sin t | is defined in its fundamental interval. Taking π = 3.142, calculate the Fourier cosine series app

Determine randomly generated bit string, Assume E is the event that a rando...

Assume E is the event that a randomly generated bit string of length 4 starts with a 1 and F is the event that this bit string consists of an even number of 1's. Are E and F indepe

Linear Programming, #question.A manufacturer produces two items, bookcases ...

#question.A manufacturer produces two items, bookcases and library tables. Each item requires processing in each of two departments. Department 1 has 40 hours available and departm

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages