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

Trigonometry, Prove: cotA/2.cotB/2.cotC/2 = cotA/2+cotB/2+cotC/2

Prove: cotA/2.cotB/2.cotC/2 = cotA/2+cotB/2+cotC/2

Solve the subsequent lp problem, Solve the subsequent LP problem graphicall...

Solve the subsequent LP problem graphically through enumerating the corner points. MAX: 3X1 + 4X2 Subject to: X1 12 X2 10

Quistins, define even and odd function state whether given function are eve...

define even and odd function state whether given function are even odd or neither 1 f x =sin x cos x 2 f x {x}=x +x3n #Minimum 100 words accepted#

Find out general formula for tangent vector and unit vector, Find out the g...

Find out the general formula for the tangent vector and unit tangent vector to the curve specified by r → (t) = t 2 i → + 2 sin t j → + 2 cos t k → . Solution First,

Multiplacation, how much is 6x12

how much is 6x12

Triangles, if triangle abc is similar to def and ab/de=3/4 find the ratio a...

if triangle abc is similar to def and ab/de=3/4 find the ratio af their perimeter and area

Permutations, prove that 0!=1

prove that 0!=1

How to subtract fractions with different denominators, Q. How to Subtract f...

Q. How to Subtract fractions with different denominators? Ans. As with adding fractions, you can't subtract unless the denominators are the same. Here is an example: 9/

Geometry Question, Does the Angle-Side Relationship Theorm work for all tri...

Does the Angle-Side Relationship Theorm work for all triangles or just a certain type of triangle? Does is correspond with the orthocenter of a triangle?

If she remains going at similar rate how long will it take, Susan traveled ...

Susan traveled 114 miles in 2 hours. If she remains going at the similar rate, how long will it take her to go the remaining 285 miles of her trip? There is a 1 in 6 chance of

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages