software

I was asked to use Excel to extrapolate the growth of used capacity for
drive size on a server. Not really knowing too much about statistical
functions, I thought I'd try to educate myself.

I found the Trend function in Excel and it seemed to do what I want.
But then I was reading about the Growth Trend - where you select a
number of cells and then drag the fill handle it it just fills in
numbers for you without a specific function.

I tried both just to see what they did and I saw that the Growth Trend
produced higher estimates than the Trend function the farther out the
estimates went.

My question is which one do I trust? What is the difference between
the two?

Thanks,
Jennifer

Results from Trend function:
DateUsage
2/2/0636537.02
2/3/0636542.44
2/6/0634956.7
2/15/0638107.00
=============
Function starts here
2/16/0637821.75941
2/17/0638080.03568
2/18/0638599.78576
2/19/0638586.30352
2/20/0638975.31669
2/21/0639228.4507
2/22/0639416.2162
2/23/0639737.28979
2/24/0639957.73951
2/25/0640212.15911
2/26/0640482.92078
2/27/0640720.35541
2/28/0640982.94612Results from Growth Trend Dragging:
2/2/0636537.02
2/3/0636542.44
2/6/0634956.70
2/15/0638107.00
=============
Dragging starts here
2/16/0637316.84
2/17/0637629.26
2/18/0637941.68
2/19/0638254.10
2/20/0638566.52
2/21/0638878.94
2/22/0639191.36
2/23/0639503.78
2/24/0639816.20
2/25/0640128.62
2/26/0640441.04
2/27/0640753.46
2/28/0641065.88According to the Excel help file:

TREND Returns values along a linear trend. Fits a straight line...
GROWTH Calculates predicted exponential growth....

Which one you use depends on some knowledge of the nature of the increase you're
trying to model. Is your process intrinsically linear or exponential?

Bill
-----------------------------wrote:
gt; I was asked to use Excel to extrapolate the growth of used capacity for
gt; drive size on a server. Not really knowing too much about statistical
gt; functions, I thought I'd try to educate myself.
gt;
gt; I found the Trend function in Excel and it seemed to do what I want.
gt; But then I was reading about the Growth Trend - where you select a
gt; number of cells and then drag the fill handle it it just fills in
gt; numbers for you without a specific function.
gt;
gt; I tried both just to see what they did and I saw that the Growth Trend
gt; produced higher estimates than the Trend function the farther out the
gt; estimates went.
gt;
gt; My question is which one do I trust? What is the difference between
gt; the two?
gt;
gt; Thanks,
gt; Jennifer
gt;
gt; Results from Trend function:
gt; DateUsage
gt; 2/2/0636537.02
gt; 2/3/0636542.44
gt; 2/6/0634956.7
gt; 2/15/0638107.00
gt; =============
gt; Function starts here
gt; 2/16/0637821.75941
gt; 2/17/0638080.03568
gt; 2/18/0638599.78576
gt; 2/19/0638586.30352
gt; 2/20/0638975.31669
gt; 2/21/0639228.4507
gt; 2/22/0639416.2162
gt; 2/23/0639737.28979
gt; 2/24/0639957.73951
gt; 2/25/0640212.15911
gt; 2/26/0640482.92078
gt; 2/27/0640720.35541
gt; 2/28/0640982.94612
gt;
gt;
gt; Results from Growth Trend Dragging:
gt; 2/2/0636537.02
gt; 2/3/0636542.44
gt; 2/6/0634956.70
gt; 2/15/0638107.00
gt; =============
gt; Dragging starts here
gt; 2/16/0637316.84
gt; 2/17/0637629.26
gt; 2/18/0637941.68
gt; 2/19/0638254.10
gt; 2/20/0638566.52
gt; 2/21/0638878.94
gt; 2/22/0639191.36
gt; 2/23/0639503.78
gt; 2/24/0639816.20
gt; 2/25/0640128.62
gt; 2/26/0640441.04
gt; 2/27/0640753.46
gt; 2/28/0641065.88
gt;

Excel's help does not do TREND justice. TREND returns values along a model
that is linear in the unknowns (multiple linear regression, polynomials,
etc.). FORECAST is the function that is limited to a straight line.

Jerry

quot;Bill Martinquot; wrote:

gt; According to the Excel help file:
gt;
gt; TREND Returns values along a linear trend. Fits a straight line...
gt; GROWTH Calculates predicted exponential growth....
gt;
gt; Which one you use depends on some knowledge of the nature of the increase you're
gt; trying to model. Is your process intrinsically linear or exponential?
gt;
gt; Bill
gt; -----------------------------
gt; wrote:
gt; gt; I was asked to use Excel to extrapolate the growth of used capacity for
gt; gt; drive size on a server. Not really knowing too much about statistical
gt; gt; functions, I thought I'd try to educate myself.
gt; gt;
gt; gt; I found the Trend function in Excel and it seemed to do what I want.
gt; gt; But then I was reading about the Growth Trend - where you select a
gt; gt; number of cells and then drag the fill handle it it just fills in
gt; gt; numbers for you without a specific function.
gt; gt;
gt; gt; I tried both just to see what they did and I saw that the Growth Trend
gt; gt; produced higher estimates than the Trend function the farther out the
gt; gt; estimates went.
gt; gt;
gt; gt; My question is which one do I trust? What is the difference between
gt; gt; the two?
gt; gt;
gt; gt; Thanks,
gt; gt; Jennifer
gt; gt;
gt; gt; Results from Trend function:
gt; gt; DateUsage
gt; gt; 2/2/0636537.02
gt; gt; 2/3/0636542.44
gt; gt; 2/6/0634956.7
gt; gt; 2/15/0638107.00
gt; gt; =============
gt; gt; Function starts here
gt; gt; 2/16/0637821.75941
gt; gt; 2/17/0638080.03568
gt; gt; 2/18/0638599.78576
gt; gt; 2/19/0638586.30352
gt; gt; 2/20/0638975.31669
gt; gt; 2/21/0639228.4507
gt; gt; 2/22/0639416.2162
gt; gt; 2/23/0639737.28979
gt; gt; 2/24/0639957.73951
gt; gt; 2/25/0640212.15911
gt; gt; 2/26/0640482.92078
gt; gt; 2/27/0640720.35541
gt; gt; 2/28/0640982.94612
gt; gt;
gt; gt;
gt; gt; Results from Growth Trend Dragging:
gt; gt; 2/2/0636537.02
gt; gt; 2/3/0636542.44
gt; gt; 2/6/0634956.70
gt; gt; 2/15/0638107.00
gt; gt; =============
gt; gt; Dragging starts here
gt; gt; 2/16/0637316.84
gt; gt; 2/17/0637629.26
gt; gt; 2/18/0637941.68
gt; gt; 2/19/0638254.10
gt; gt; 2/20/0638566.52
gt; gt; 2/21/0638878.94
gt; gt; 2/22/0639191.36
gt; gt; 2/23/0639503.78
gt; gt; 2/24/0639816.20
gt; gt; 2/25/0640128.62
gt; gt; 2/26/0640441.04
gt; gt; 2/27/0640753.46
gt; gt; 2/28/0641065.88
gt; gt;
gt;