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

Wavy curve method, (x+3)>3

(x+3)>3

Square numbers., is 49 a square number?

is 49 a square number?

Cofactor of an element, Define Cofactor of an Element.

Define Cofactor of an Element.

Four distinct points on a circle, If (a,1/a), (b,1/b),(c,1/c),(d,1/d) are f...

If (a,1/a), (b,1/b),(c,1/c),(d,1/d) are four distinct points on a circle of radius 4 units then,abcd is equal to?? Ans) As they are of form (x,1/x) let eq of circle be x

Evaluate the subsequent inverse trigonometric functions, Evaluate the subse...

Evaluate the subsequent inverse trigonometric functions: Evaluate the subsequent inverse trigonometric functions. arcsin 0.3746 22° arccos 0.3746 69° arctan 0.383

I NEED HELP WITH A MATH PROJECT., HOW MUCH WILL A NEW CAR COST? THE AVERAGE...

HOW MUCH WILL A NEW CAR COST? THE AVERAGE COST OF A NEW CAR IN 1990 WAS $14371. IN 2003 THE AVERAGE COST HAD RISEN TO $22360. WHAT IS THE AMOUNT OF THE MONTHLY PAYMENT? THE AMOUNT

The stoichiometric reaction, Prove that a reaction following the rate law v...

Prove that a reaction following the rate law v = k[A] 2 is characterized by a linear plot of [P] t 1 versus t-l, where P is the product of the stoichiometric reaction A = P. Sho

????? ???????, ???? ????? ??????? ?? ????? ??? ?? ????? ??????? ??????

???? ????? ??????? ?? ????? ??? ?? ????? ??????? ??????

Fraction operation, 4 1/2 ----2----1/3=3

4 1/2 ----2----1/3=3

How much did kara pay in interest, Kara borrowed $3,650 for one year at an ...

Kara borrowed $3,650 for one year at an annual interest rate of 16%. How much did Kara pay in interest? To ?nd out 16% of $3,650, multiply $3,650 through the decimal equivalent

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