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

Add fractions, 13 1/4 34 56/89

13 1/4 34 56/89

Calculate the volume and surface area of a sphere, Calculate the volume and...

Calculate the volume and surface area of a sphere: Calculate the volume and surface area of a sphere with r = 4". Be sure to include units in your answer. Solution: V

Perimeter of trinagle, what is the perimeter of a triangele with the sides ...

what is the perimeter of a triangele with the sides of 32 in /22 in/20 in/

Example to understand means to count, Place ten pebbles (or any other such ...

Place ten pebbles (or any other such objects) in front of a child who can recite number names upto ten in the correct sequence. Ask him/her to count them aloud while touching the p

GRAPH, HOW CAN WE TAKE SUPPOSE THE VALUES OF X AND Y

HOW CAN WE TAKE SUPPOSE THE VALUES OF X AND Y

Focal chord of the parabola, show that the circle described on any focal c...

show that the circle described on any focal chord of the parabola touches the directrix

Permutations and combinations, Consider this. You have four units A, ...

Consider this. You have four units A, B, C and D. You are asked to select two out of these four units. How do you go about this particular task? Will your methodo

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

Find out the absolute extrema for function and interval, Find out the absol...

Find out the absolute extrema for the given function and interval. g (t ) = 2t 3 + 3t 2 -12t + 4 on [-4, 2] Solution : All we actually need to do here is follow the pr

Finish the work., six men and Eight boys can finish a piece of work in 14 d...

six men and Eight boys can finish a piece of work in 14 days while eight men and twelve boys can do it in 10 days. Find the time taken by 1man alone and that by 1boy alone to fin

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages