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

Linear algebra, i have question like proof, can you please help me on it?

i have question like proof, can you please help me on it?

Compare and contrast african immigrants, Compare and contrast African immig...

Compare and contrast African immigrants with our immigrant groups? How are they different? What are the implications of these differences for their adjustment to the larger society

Percent problems.., I have a graph, i need to determine the many hours per ...

I have a graph, i need to determine the many hours per day becky spends on math activity if she does it 25% of her day.

Ratios, 10:30:45

10:30:45

Commercial maths, if 500kg of food lasts 40 days for 30 men.how many men wi...

if 500kg of food lasts 40 days for 30 men.how many men will consume 675kg of food in 45 days.

Quadratic equation, can anyone explain me the concept of quadratic equation...

can anyone explain me the concept of quadratic equation?

Algebra, 4.2^2x+1-9.2^x+1=0

4.2^2x+1-9.2^x+1=0

Differential equation, xy

Hypothesis testing of the difference between proportions, Hypothesis Testin...

Hypothesis Testing Of The Difference Between Proportions Illustration Ken industrial producer have manufacture a perfume termed as "fianchetto." In order to test its popul

Euler equations, Euler Equations - Series Solutions to Differential Equ...

Euler Equations - Series Solutions to Differential Equations In this section we require to look for solutions to, ax 2 y′′ + bxy′ + cy = 0 around x0 = 0. These ki

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