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

Word Problem, One box can hold 5 1/2 lbs of nuts and 3 lb 6oz of bolts. Wha...

One box can hold 5 1/2 lbs of nuts and 3 lb 6oz of bolts. What is the total weight for one box?

Sequence and series, Find the sum og series 1+(1+3)+(1+3+5)+.......+(1+3+.....

Find the sum og series 1+(1+3)+(1+3+5)+.......+(1+3+...+15+17)=

B cross c whole square equals., lbl 2 lcl 2 sin 2 θ

lbl 2 lcl 2 sin 2 θ

What is the value of the lesser integer, The sum of three times a greater i...

The sum of three times a greater integer and 5 times a lesser integer is 9. Three less than the greater equivalent the lesser. What is the value of the lesser integer? Let x =

To find out the volume of a cube give formula, To find out the volume of a ...

To find out the volume of a cube which measures 3 cm by 3 cm by 3 cm, what formula would you use? The volume of a cube is the length of the side cubed and the length of the sid

Rounding and number Lines(round to the nearest whole number), 2.3 8.8 3.5 4...

2.3 8.8 3.5 4 5 _______,___/____________ ?

Prove that a tree with n vertices has n - 1 edges, Prove that A tree with n...

Prove that A tree with n vertices has (n - 1) edges. Ans: From the definition of a tree a root comprise indegree zero and all other nodes comprise indegree one. There should

Vector, what is dot

what is dot

How do you find the second minimum spanning tree of a graph, How do you fin...

How do you find the second minimum spanning tree of a graph? Find the second minimum spanning tree of the following graph. Ans: The second minimum spanning tree is acq

Pre-algebra 8th grade math, 3x3

3x3

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