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

Geometry, what is sin, cos, and tan?

what is sin, cos, and tan?

Fractions, How do you add 7/9 + 6/8 + 3/4

How do you add 7/9 + 6/8 + 3/4

Rounding fractions and mixed numbers, round each number to the nearest half...

round each number to the nearest half 2 over 5

Four-step plan, Adison earned $25 mowing her neighbor''s lawn. Then she loa...

Adison earned $25 mowing her neighbor''s lawn. Then she loaned her friend $18, and got $50 from her grandmother for her birthday. She now has $86. How much money did Adison have to

Evaluate the inverse function , Question: a. What is the inverse of f (...

Question: a. What is the inverse of f (x)? b. Graph the inverse function from part (a). c. Rewrite the inverse function from part (a) in exponential form. d. Evaluate

Interpretation, Interpretation A high value of r as +0.9 or - 0...

Interpretation A high value of r as +0.9 or - 0.9 only shows a strong association among the two variables but doesn't imply that there is a causal relationship that is

How many teachers are there at russell high, There are 81 women teachers at...

There are 81 women teachers at Russell High. If 45% of the teachers in the school are women, how many teachers are there at Russell High? Use the proportion part/whole = %/100.

Graphing, please teach me

please teach me

Determine the property of join in a boolean algebra, Determine that in a Bo...

Determine that in a Boolean algebra, for any a and b, (a Λ b) V (a Λ b' ) = a. Ans: This can be proved either by using the distributive property of join over meet (or of mee

Laplace transforms, Here is not too much to this section. We're here going ...

Here is not too much to this section. We're here going to work an illustration to exemplify how Laplace transforms can be used to solve systems of differential equations. Illus

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages