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

Bernoulli differential equations, In this case we are going to consider dif...

In this case we are going to consider differential equations in the form, y ′ + p ( x ) y = q ( x ) y n Here p(x) and q(x) are continuous functions in the

Estimate the slope of a line?, Estimate the Slope of a Line? The slope o...

Estimate the Slope of a Line? The slope of a line is a measure of how steep it is. It is defined as y 2 - y 1 /x 2 -x 1 Where (x 1 , y 1 ) and (x 2 , y 2 ) are any two p

., WRITE the condition that should be fulfilled by two matrices A&B to get ...

WRITE the condition that should be fulfilled by two matrices A&B to get the product AB and BA

Elli[ital paths of celestial bodies, Create a detailed diagram to describe ...

Create a detailed diagram to describe the equation of an ellipse in terms of it’s eccentricity and indicate how the foci and major and minor semi-axes are involved. Y

Similar triangles, S IMILAR TRIANGLES : Geometry is the right ...

S IMILAR TRIANGLES : Geometry is the right foundation of all painting, I have decided to teach its rudiments and principles to all youngsters eager for ar

Linear equations with one unknown, x+8/2=5x/6

x+8/2=5x/6

Matrix, how to solve for x

how to solve for x

Determines the possibility, There is a committee to be selected comprising ...

There is a committee to be selected comprising of 5 people from a group of 5 men and 6 women. Whether the selection is randomly done then determines the possibility of having the g

Logarithmic equations, How do I solve logx/log2x=2

How do I solve logx/log2x=2

Pillais conjecture, Explain Pillais Conjecture?

Explain Pillais Conjecture?

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