ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Graph Standard Deviations (https://www.excelbanter.com/excel-discussion-misc-queries/38572-graph-standard-deviations.html)

ed

Graph Standard Deviations
 
I have about 40 points that I wish to graph. I used these points to get a
logarithmic trendline. Now I want to graph one standard deviation above and
one below. How do I do that.

Bill Martin -- (Remove NOSPAM from address)

ed wrote:
I have about 40 points that I wish to graph. I used these points to get a
logarithmic trendline. Now I want to graph one standard deviation above and
one below. How do I do that.



I'd use helper columns. Compute the values for the +/- sigma at each X value
and then just add them to your graph in the normal way. There may be something
more clever, but this should work.

Good luck...

Bill


All times are GMT +1. The time now is 09:53 AM.

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