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

Set theory, how to prove Decidability Theorem of Logic

how to prove Decidability Theorem of Logic

The shape of a graph, The Shape of a Graph, Part I : In the earlier secti...

The Shape of a Graph, Part I : In the earlier section we saw how to employ the derivative to finds out the absolute minimum & maximum values of a function. Though, there is many

The value of m+n, Every point (x,y) on the curve y=log2 3x is transferred t...

Every point (x,y) on the curve y=log2 3x is transferred to a new point by the following translation (x',y')=(x+m,y+n), where m and n are integers. The set of (x',y') form the curve

Coefficients of the equation, If coefficients of the equation ax 2 + bx + ...

If coefficients of the equation ax 2 + bx + c = 0, a ¹ 0 are real and roots of the equation are non-real complex and a + c (A) 4a + c > 2b (B) 4a + c Please give t

What percent of the figure below is shaded, What percent of the figure belo...

What percent of the figure below is shaded? Break the rectangle into eighths as shown below. The shaded part is 6/8 or 3/4 ; 3/4 is 75%.

Cyclic permutations, the operations of cyclic permutations

the operations of cyclic permutations

What is the limit of sin (1/x) when x tends to zero?, As x tends to zero th...

As x tends to zero the value of 1/x tends to either ∞ or -∞. In this situation we will not be sure about the exact value of 1/x. As a result we will not be sure about the exact/app

Electronic whiteboards, Topic : Use of Electronic whiteboards (ICT) in prim...

Topic : Use of Electronic whiteboards (ICT) in primary education in Australia and international. What are the key theories, concepts and ideas related to your topic? Wha

Circumference, circumference of a circle

circumference of a circle

What is addition rule of probability, Q. What is Addition Rule of probabili...

Q. What is Addition Rule of probability? Ans. Suppose there are 17 girls and 15 boys in your stats class. There are 17 + 15 = 32 ways for your teacher to pick one student

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages