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

Perimeter and area of geometrical figures, 8.5cm square = m squar...

8.5cm square = m square

I need help, in 2000,nearly 18% of cars in north America were sliver. what ...

in 2000,nearly 18% of cars in north America were sliver. what percent of the cars sold were not sliver?

Operation, What is a characteristic of operation

What is a characteristic of operation

The invisible effort on learning maths, The Invisible Effort : Although t...

The Invisible Effort : Although the development of children is a process, what is noticed and given recognition to is the end-product. We usually speak of children having achieve

3-d coordinate system - three dimensional spaces, The 3-D Coordinate System...

The 3-D Coordinate System We will start the chapter off with a quite brief discussion introducing the 3-D coordinate system and the conventions that we will be utilizing. We

Estimate the greatest possible number of calculators, Martha has $20 to spe...

Martha has $20 to spend and would like to buy as several calculators as possible along with the money. The calculators that she needs to buy are $4.50 each. How much money will she

Solve 8 cos2 (1 - x ) + 13 cos(1 - x )- 5 = 0 trig function, Solve 8 cos 2 ...

Solve 8 cos 2 (1 - x ) + 13 cos(1 - x )- 5 = 0 . Solution Now, as specified prior to starting the instance this quadratic does not factor. Though, that doesn't mean all i

Empty set or null set, Empty Set or Null Set It is a set which having ...

Empty Set or Null Set It is a set which having no elements. It is usually designated by a Greek letter Ø, or else { }. The sets Ø and { Ø } are not the same thing since the

Monica, Express area of a square with sides of length 5ab as a monomial.

Express area of a square with sides of length 5ab as a monomial.

Theorem of continuous functions, Consider the subsequent IVP. y' = f(t,y...

Consider the subsequent IVP. y' = f(t,y) , y(t 0 ) = y 0 If f(t,y) and ∂f/∂y are continuous functions in several rectangle a o - h o + h which is included in a

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages