standard deviation graph
I have values that are produced every 3 minutes. I have calculated the
standard deviation of those values for each hour for a 7 month span. That is 5115 records. How do I make a bell shaped curve with these values? |
standard deviation graph
keano -
I suggest you start by creating a histogram (column chart of a frequency distribution). The Histogram tool of the Analysis ToolPak (an Excel-provided add-in) automates the procedure, or you could use my Better Histogram tool available from the Histogram page at www.treeplan.com. The chart of the frequency distribution may or may not have a bell shape. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "keano" wrote in message ... I have values that are produced every 3 minutes. I have calculated the standard deviation of those values for each hour for a 7 month span. That is 5115 records. How do I make a bell shaped curve with these values? |
All times are GMT +1. The time now is 01:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com