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

Venn Diagram, In a group of 85 people, 33 own a microwave, 28 own a DVD pla...

In a group of 85 people, 33 own a microwave, 28 own a DVD player and 38 own a computer. In addition, 6 people own both a microwave and a DVD player, 9 own both a DVD player and a c

Mensuration, if area of a rectangle is 27 sqmtr and it perimeter is 24 m fi...

if area of a rectangle is 27 sqmtr and it perimeter is 24 m find the length and breath#

Classify quadrilaterals, which quadrilaterals have only 1 pair of parallel ...

which quadrilaterals have only 1 pair of parallel sides

Symmetric and anti-symmetric relation on a set, 1. Let A = {1,2, 3,..., n} ...

1. Let A = {1,2, 3,..., n} (a) How many relations on A are both symmetric and anti-symmetric? (b) If R is a relation on A that is anti-symmetric, what is the maximum number o

Tangents, case 2:when center is not known proof

case 2:when center is not known proof

Numerical analysis and computer techniques, write a fortan programme to gen...

write a fortan programme to generate prime number between 1 to 100

Find the sum of first 40 positive integers, Find the sum of first 40 positi...

Find the sum of first 40 positive integers divisible by 6 also find the sum of first 20 positive integers divisible by 5 or 6. Ans: No's which are divisible by 6 are

Calculas, Q1: Find three positive numbers whose sum is 54 and whose product...

Q1: Find three positive numbers whose sum is 54 and whose product is as large as possible.

Calculus , Mean, variance, skewness and kurtosis of a probability density f...

Mean, variance, skewness and kurtosis of a probability density function f(r)that has a distribution of a passive scalar filed in a stationary isotropic turbulence for initial condi

Linearly independent, condition for linearly independent

condition for linearly independent

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages