Excel: Statistics

Using statistic formulas to deliver key metrics.

Beginning with a simple set of test sales data, I employed some simple statistic Excel formulas to display metrics regarding the data.
In addition to using Conditional Formatting to show revenue values in both the high (green) and low (red) ranges, I also show for all the values the Average and Median sales figures, as well as the highest and lowest values.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s