Simple Statistics Chart

Description:

Simple Statistic Chart Excel Add-In calculates the simple statistic data for the observed data series and visualizes the statistics data into a range chart. The bar presents the range of the data. The mean, median and quantile are marked on the bar and the standard deviation values are shown on the right axis of the graph.

One chart visualizes the following statistics values for the observed data series:

• Range

• Min

• Max

• Mean

• Median

• Quantile (1/4 and 3/4)

• Standard Deviation

Two sets of sample data show the data structure used by the add-in.

Features:

• Mouse over the chart to view the data detail in the tool-tips.

• Customizable bar color in the setting window.

• Easy to use and user-friendly. Sample data can be the template to build own data.

• Interactive Chart: the chart is binding to the data table in the sheet. The chart is updating when the data is entered.

Instruction:

• Download this add in and start Excel 2013 SP1 or later.

• Select a sample data in the sample data drop-down.

• Select a parameter for quantile marker or use default.

• Click insert sample data button.

• Update the value columns with own data.

• Rename the chart title by clicking in the title area and reenter the name as preferred.