ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   applying st. dev. of a data set to a trendline forcast (https://www.excelbanter.com/charts-charting-excel/129722-applying-st-dev-data-set-trendline-forcast.html)

Kris@Cooper

applying st. dev. of a data set to a trendline forcast
 
I have a "bowl" with a capacity and flow through (water treatment plant). I
have a flow data set with a standard deviation (I cannot have for the entire
data set on the chart since it would turn black from too much data). I have
a line for 90% capacity of the plant. I have a trendline for my data set
(some data is already outside my 90%). I would like to apply that standard
deviation to the trendline to forcast when my plant can no longer handle the
flow (when my st. dev. is above my 90% capacity.


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com