Keene - Pick an Excel Function

Each student will pick one of the following (to get to functions, hit insert, functions, and choose statistical) functions (in the case that there are several functions listed together, if you pick that line, you must do all the functions on that line):

Mean, Median, Mode
Stdev, Avedev
Var, Varsq
Percentile, quartile
Poisson
Normsdist, Normdist
ZTest
Binomdist
Skew
Forecast
Expondist

By _______ each student will blog their choice. Note that only one student will be allowed to choose a topic. In the case that two students pick the same topic, the earliest post will dictate who will do the topic.
Your assignment:
1. As the Leader, for the topic you choose, explain the topic, and how to use, such that each student can use it. Show an example (you can use actual data or create your own fictitious data set), using the link icon. Be sure to explain why someone would want the statistic you've developed. *** This must be posted by _______ *** If you use excel 2007, you must save the file as excel 2003.
2. each student must respond to 3 (no more and no less) other posts by showing an example (use the link icon) of their choice (use actual data set or create your own). Again, save the file as excel 2003 or earlier version. This is due no later than _______
3. the leader will check the postings of all who post to their topic, responding with agreement or disagreement.
4. If you have questions on how to use a tool, post a comment to the leader.

NOTE: all posting must be completed by _______