Where they put statistical analysis tools in MS Excel 2007?

Some people almost stuck with MS Excel just installed. After years using MS Excel 2003, they got new appearance of MS Excel 2007.  It looks some tools are either hided or removed.  Others admit the new look of MS Excel is more smoothly. Below are some statistical analysis tools that we can find in MS Excel 2007. Yes, it still there:


Pivot Table
In MS Excel 2003, pivot table is found in Table of pulldown menu. Now they place it in the left side in Insert of the Ribbon.
Goal Seek
In MS Excel 2007, goal seek can used via Data in the Ribbon, then choose What if Analysis in data tools group.

Descriptive Statistics
The function are implated in Data Analysis adds in. You can find how to install Data Analysis adds -In in previous posting. Descriptive Statistics has a function to summarize data, thus allowing reader easy to understand.  Some indicators which reflect data centering are used in this function such mean, median, mode. Others are reflecting data distribution from the data center. The data distribution can be measure with varians, standard deviation, range, mean absolute (MAD) and mean absolute percentage error (MAPE).

Descriptive Statistic of MS Excel 2007 includes mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum and count. How to use it? Assuming you has installed Data Analysis Adds-In;

  1. Be ready with a range of data in columned –form
  2. Choose Data in the Ribbon (previously pull-down menu)
  3. Click Data Analysis button in analysis group in the right side
  4. Choose Descriptive Statistics and press OK
  5. Input your data range
  6. Tick  summary statistic in output option
  7. Choose where you will put the result
  8. Press OK

Reblog this post [with Zemanta]