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

Euler method for ode, y'' + 2y = 2 - e-4t, y(0) = 1 use euler''s method wit...

y'' + 2y = 2 - e-4t, y(0) = 1 use euler''s method with a step size of 0.2 to find and approximate values of y

Vectors, apllication in business and economics

apllication in business and economics

Intregation, x

Angles, how to measure missing angle of an adjacent angle

how to measure missing angle of an adjacent angle

What is the cost per ounce of detergent, A 64-ounce bottle of detergent cos...

A 64-ounce bottle of detergent costs $3.20. What is the cost per ounce of detergent? To ?nd out the cost per ounce, divide the cost through the number of ounces; $3.20 ÷ 64 =

Give the introduction to scientific notation, Give the Introduction to Scie...

Give the Introduction to Scientific Notation? In mathematics, it can be very difficult and time-consuming to do calculations involving very large and very small numbers. This i

Express the product of -9p3r and the quantity 2p - 3r, Express the product ...

Express the product of -9p3r and the quantity 2p - 3r in simplified form. The translated expression would be -9p3r(2p - 3r). Noticed that the key word product means multiply.

Which state sold corsica to france in 1768, By which of those ancient civil...

By which of those ancient civilizations was Machu Pichu built? The Aztecs The Egyptians The Mayas The Incas Which state sold Corsica to France in 1768? - Not answered Genoa Veni

Prove that ar= 3/7 ac of parallelogram , ABCD is a parallelogram in the giv...

ABCD is a parallelogram in the given figure, AB is divided at P and CD and Q so that AP:PB=3:2 and CQ:QD=4:1. If PQ meets AC at R, prove that AR= 3/7 AC. Ans: ΔAPR ∼ Δ

Show that 8 - 10 + 21= 0, If A, B and P are the points (-4, 3), (0, -2) and...

If A, B and P are the points (-4, 3), (0, -2) and (α,β) respectively and P is equidistant from A and B, show that 8α - 10β + 21= 0. Ans : AP = PB ⇒ AP 2 = PB 2 (∝ + 4) 2

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages