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

Undetermined coefficients, In this section we will see the first method whi...

In this section we will see the first method which can be used to find an exact solution to a nonhomogeneous differential equation. y′′ + p (t ) y′ + q (t ) y = g (t) One of

Product and brand management, core competency vs diversification

core competency vs diversification

Function to convert a complex number in algebraic form, Go back to the com...

Go back to the complex numbers code in Figures 50 and 51 of your notes. Add code fragments to handle the following: 1. A function for adding two complex numbers given in algeb

#change of ratio, #in a picnic the ratio of boys to girls is 3:4. when 6 bo...

#in a picnic the ratio of boys to girls is 3:4. when 6 boys joined the group the ratio became even. how many boys were there before? how many children were there before? how many b

Find the area of the remaining part of cardboard, From a sheet of cardboard...

From a sheet of cardboard in the shape of a square of side 14 cm, a piece in the shape of letter B is cut off. The curved side of the letter consists of two equal semicircles & the

Negative three and positive eight inclusive represent y, The value of y is ...

The value of y is among negative three and positive eight inclusive. Which of the subsequent represents y? This inequality displays a solution set where y is greater than or eq

Binimial, theory behind the greatest term in the binomial expansion

theory behind the greatest term in the binomial expansion

Write triangles named by the lengths of their sides, Write Triangles Named ...

Write Triangles Named by the Lengths of Their Sides? An equilateral triangle is a triangle with three congruent sides. All three sides of this triangle are the same lengt

Permission for xii class, Is there any class in expertsmind for second year...

Is there any class in expertsmind for second year english.?

HELP, WHAT TWO SIX DIDGIT NUMBERS CAN YOU ADD 984,357

WHAT TWO SIX DIDGIT NUMBERS CAN YOU ADD 984,357

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages