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

Properties of integer exponents, Note that there are two possible forms for...

Note that there are two possible forms for the third property. Usually which form you use is based upon the form you want the answer to be in. Note as well that several of these

Adding , 100+5000

100+5000

Frobenius coin problem, How to solve Frobenius Coin Problem?

How to solve Frobenius Coin Problem?

Set builder notation, A={2,3,5,7,11} B={1,3,5,7,9} C={10,20,30,40,......100...

A={2,3,5,7,11} B={1,3,5,7,9} C={10,20,30,40,......100} D={8,16,24,32,40} E={W,O,R,K} F={Red,Blue,Green} G={March,May} H={Jose,John,Joshua,Javier} I={3,6,9,12,15}

Área de un rectangulo, calcula el área de la región sombreada de un rectáng...

calcula el área de la región sombreada de un rectángulo cuya base es 12.6 cm y su altura es 8.4

Find relative extrema f ( x ) = x2 on [-2, Recognizes the absolute extrema...

Recognizes the absolute extrema & relative extrema for the given function. f ( x ) = x 2 on [-2, 2] Solution Following is the graph for this fun

Triangles, The sides of a triangle are x^(2 )+x+1, 2x+1,x^2-1, prove that t...

The sides of a triangle are x^(2 )+x+1, 2x+1,x^2-1, prove that the largest angle is 120 degrees, and find range of x. Ans) The biggest side is x^(2) + x + 1 so findout the angl

Help me help me!, A 65 ohm resistor is connected to a power supply , a curr...

A 65 ohm resistor is connected to a power supply , a current of 2.4 amperes is drawn. what is the output voltage?

Negative Numbers, -3+4 #Minimum 100 words accepted#

-3+4 #Minimum 100 words accepted#

Kotler, Marketing management,Analysis,planning and implementation

Marketing management,Analysis,planning and implementation

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages