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

Determine the largest possible domain and inverse function, Consider the fu...

Consider the function f(x) =1/2 (2 x +2 -x ) which has the graph (a) Explain why f has no inverse function. You should include an example to support your explanation

Statistic, Suppose that the probability of your favorite baseball player ge...

Suppose that the probability of your favorite baseball player getting a hit at bat is 0.45. Assume that each at bat is independent. What is the probability that he bats eight times

Demand Forecast, How should shoppers Stop develop its demand forecasts?

How should shoppers Stop develop its demand forecasts?

Subtraction of like terms with same signs, Suppose we are required to...

Suppose we are required to find the difference between 3abc and 7abc. We look at two scenarios. The value we would obtain by subtracting a larger quantity from th

Derivatives, Derivatives The rate of change in the value of a...

Derivatives The rate of change in the value of a function is useful to study the behavior of a function. This change in y for a unit change in x is

Right triangle, info about right triangles

info about right triangles

What is the probability of getting a royal flush, Q. What is the probabilit...

Q. What is the probability of getting a Royal Flush? Ans. Five cards are picked from a standard deck of 52 cards. How many different hands of five cards are possible? What

Division, there are 2,500 chips in a bag you slit them up into 20 groups ho...

there are 2,500 chips in a bag you slit them up into 20 groups how many chips are in a group

Operations and properties, use an expression to write an expression with fi...

use an expression to write an expression with five 3s that has a value of 0

Projections - vector, Projections The good way to understand projection...

Projections The good way to understand projections is to see a couple of diagrams. Thus, given two vectors a → and b → we want to find out the projection of b → onto a → . T

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages