Turning on the filter for a database allows sorting and filtering that is helpful in investigating the details of a data set.
Tag Archives: DataAnalysis
Scatterplots
The Chart Menu has commands for creating scatterplots. One type of scatterplot just displays the data in the order it appears in the range.
There is also a way to create a scatterplot that relates two columns of data – an XY scatterplot.
The Data menu
This tab has commands to connect an Excel spreadsheet to external data sources for reporting and graphing that data. There are also commands for sorting, filtering, outlining and data cleaning. Some of the more powerful and useful features for analysis are also located in this menu tab.
Descriptive statistics
The Analysis Toolpack has a command to create the descriptive statistics for a data set.
Histogram Tool
In the analysis toolpack, there is a command that will create a histogram.
Create a histogram with the frequency function
Instead of using the Analysis Toolpack histogram command, a histogram can also be created using the =FREQUENCY() function.
Add-ins for Excel
Even more complex features can be added to Excel with the use of add-ins. Some are provided with Excel but not installed, so if you have a new copy of Excel, you will have to learn a little about add-ins. There are also commercial extentions, and one that is used at the Goizueta Business School is the Decision Tools Suite from Palisades Software. This add-in provides a number of very useful tools (optimization, simulation), but is not offered in a version compatible with Mac OS/X.