LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Predicting an Intersection of a Linear Trend

Here is the problem as it stands:

First some sample data:

02/05/07 88.9%
02/12/07 80.6%
02/19/07 85.8%
02/26/07 84.4%
03/05/07 93.0%
03/12/07 90.6%
03/19/07 96.3%
03/26/07 87.0%
04/02/07 90.4%
04/09/07 91.0%
04/16/07 84.7%
04/23/07 91.7%

What Needs to be found:
Based on the trend when will the utilization go above 95% based on a
linear growth trend.

Why:
I need to graph a bar indicating when that 95% mark is met (for
capacity planning.)

How did this come about:
Normally I throw on a trendline and manually move a marker. I would
rather, for the sake of accuracy have the indicator plotted.

Any suggestions? All I need back is the date this happens (I'll be
setting the bar to 100% manually as to make a wall)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A formula that autofills by trend rather than linear Arlen Excel Discussion (Misc queries) 1 February 10th 09 08:08 PM
A formula that autofills by trend, not linear Arlen Excel Discussion (Misc queries) 3 February 10th 09 08:02 PM
Linear Regression using the TREND function scarlett1 Excel Worksheet Functions 2 May 26th 06 03:04 PM
How do I anchor one end of a linear trend line? William Spurlock Charts and Charting in Excel 3 January 15th 06 08:06 PM
intersection with linear range as true argument TACTG Excel Programming 1 August 9th 05 07:44 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"