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

Divides a given line segment internally in the ratio of 1:3, Divides a give...

Divides a given line segment internally in the ratio of 1:3 Construction : i )Draw a ray AX making an acute angle with AB. ii) Mark 4 points at equal distance. on AX Let

Geometry, finding missing values from given triangle diagra m..

finding missing values from given triangle diagra m..

Fundamentals of math, When there are 4 dots how many chords are they

When there are 4 dots how many chords are they

20 MARK QUESTION, Let E; F be 2 points in the plane, EF has length 1, and l...

Let E; F be 2 points in the plane, EF has length 1, and let N be a continuous curve from E to F. A chord of N is a straight line joining 2 points on N. Prove if 0 Prove that N ha

Solve for x and y liner equation, Solve for x , y (x + y - 8)/2 ...

Solve for x , y (x + y - 8)/2 =( x + 2 y - 14)/3 = (3 x + y - 12 )/ 11 (Ans: x=2, y=6) Ans : x+ y - 8/2 = x + 2y - 14 /3 = 3x+ y- 12/11

Example of set theory, Suggest me the solution: Consider the given unive...

Suggest me the solution: Consider the given universal set T and its subjects C, D and E T = {0, 2, 4, 6, 8, 10, 12} C = {4, 8,} D = {10, 2, 0} E = {0} Find out

What is the approximate cost of 1 binder and 1 pen, At the school bookstore...

At the school bookstore and two binders and three pens cost $12.50. Three binders and five pens cost $19.50. What is the approximate cost of 1 binder and 1 pen? Let x = the cos

The central limit theorem, The Central Limit Theorem The theories was ...

The Central Limit Theorem The theories was introduced by De Moivre and according to it; if we choose a large number of simple random samples, says from any population and find

Speed, how much distance is covered by a man if he is travelling at a speed...

how much distance is covered by a man if he is travelling at a speed of 45km/h in 5 sec

Test of hypothesis on proportions, Test Of Hypothesis On Proportions It...

Test Of Hypothesis On Proportions It follows a similar method to the one for means except that the standard error utilized in this case: Sp = √(pq/n) Z score is computed

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages