Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a bell graph for standard deviation? | Charts and Charting in Excel | |||
Standard deviation | Excel Discussion (Misc queries) | |||
STANDARD DEVIATION AND GRAPH | Excel Discussion (Misc queries) | |||
standard deviation | Charts and Charting in Excel | |||
Standard deviation | Excel Discussion (Misc queries) |