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

Rules for inequalities, Here we look at only the rules without going ...

Here we look at only the rules without going into their proofs. They are: a 0. If a If a If a

Determine the length of the diagonal, A box is 30 cm long, 8 cm wide and 12...

A box is 30 cm long, 8 cm wide and 12 cm high. Determine the length of the diagonal AB ? Round to the nearest tenth. a. 34.5 cm b. 32.1 cm c. 35.2 cm d. 33.3 cm

Area of a circle, How do you find the area of a circle given the diameter?

How do you find the area of a circle given the diameter?

Decision tree analysis, DECISION TREE ANALYSIS The Finance Manager of ‘...

DECISION TREE ANALYSIS The Finance Manager of ‘Softy’ baby soap manufacturing company being successful in the first two years of the company’s operations is considering to set

4 accounting majors, 4 accounting majors, 2 economics majors and 3 marketin...

4 accounting majors, 2 economics majors and 3 marketing majors have an interview for5 different positions with a large company. Find the number of dfferent ways that 5 of these c

Dividing, I don''t know how to do the next step like if I had 73 divided by...

I don''t know how to do the next step like if I had 73 divided by 9 wouldn''t 7 go into nine 1 time then you have to do something else but that is the part I don''t understand

Mechnics, i have many trouble in this subject

i have many trouble in this subject

Marketing research, Discuss the role research would play during your decisi...

Discuss the role research would play during your decision making

Linear programming, function [x, z] = readSolution(tableau, basis)

function [x, z] = readSolution(tableau, basis)

First order linear differential equation, Newton's Second Law of motion, wh...

Newton's Second Law of motion, which recall from the earlier section that can be written as: m(dv/dt) = F (t,v) Here F(t,v) is the sum of forces which act on the object and m

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages