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

Advanced functions, writ the equation that describes the motion of a point ...

writ the equation that describes the motion of a point on the wheel that has a center of 4m off the ground, has radius of 15 cm, makes a full rotation every 10 seconds and starts a

Weight, if an object weighed 11 pounds how many ounces would it weigh

if an object weighed 11 pounds how many ounces would it weigh

Construct a venn diagram, In a survey of 85 people this is found that 31 wa...

In a survey of 85 people this is found that 31 want to drink milk 43 like coffee and 39 wish tea. As well 13 want both milk and tea, 15 like milk & coffee, 20 like tea and coffee

Word problem, A computer is programmed to scan the digits of the counting n...

A computer is programmed to scan the digits of the counting numbers.For example,if it scans 1 2 3 4 5 6 7 8 9 10 11 12 13 then it has scanned 17 digits all together. If the comput

Use the power function to find derivative, Given, y = f(x) = 2 x 3 - 3x 2 ...

Given, y = f(x) = 2 x 3 - 3x 2 + 4x +5 a) Use the Power function to find derivative of the function. b) Find the value of the derivative at x = 4.

Geometry, finding missing values from given triangle diagra m..

finding missing values from given triangle diagra m..

Determine the length of the longer base, The longer base of a trapezoid is ...

The longer base of a trapezoid is 3 times the shorter base. The nonparallel sides are congruent. The nonparallel side is 5 cm more that the shorter base. The perimeter of the trape

Proportions, bananas are on sale for 3 pounds for $2. At that price how man...

bananas are on sale for 3 pounds for $2. At that price how many pounds can you buy for $22

Objectives of learning to count, Objectives : After studying this unit, y...

Objectives : After studying this unit, you should be able to : 1. explain the processes involved in counting; 2. explain why the ability to recite number names is no in

Montel''s Theorem, In 5 pages, please try to prove Theorem 3 based on Monte...

In 5 pages, please try to prove Theorem 3 based on Montel''s Theorem. please use "Latex" Knuth Donald to write this paper. It is known that Theorem 3 on page 137 of the attached

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages