Skip Navigation

# DISCUSS: Discovering Important Statistical Concepts Using SpreadSheets

This collection of modules uses spreadsheets to teach statistical topics like Charts and Graphs, The Binomial Distribution, The Poisson Distribution, Sampling, Regression and Correlation, Buffon's Needle, Coupon Collecting, Critical Path Analysis, Sampling Methods, and Dice.
Cumulative Rating: (not yet rated)
Date Of Record Creation 2006-07-11 09:58:00 2013-01-24 18:53:00 2006-07-11 09:58:00 Penny Project http://www.fon.hum.uva.nl/Service/Statistics/X2Test.html http://www.jcu.edu/math/faculty/TShort/Bradstreet/part5/bradp5t6.data n.hunt@coventry.ac.uk 2002 4 min. 33 sec. Neville Hunt and Sidney Tyrrell Coventry University, UK Subpages still exist, but this one does not. Microsoft Excel Note: There are Ads by Google on the site; however, they are not intrusive. The graphs are good, but more could be helpful. Because the intended audience is journalism students rather than statistics students, the author does not use statistical notation in every case one might, such as when introducing formulas or sample statistics. Most formulas are given only in words in a paragraph and not in equation format. These formulas, given in sentence format, were not explained from a conceptual viewpoint but only from a computational viewpoint. There is some concern that in an effort to simplify the material for the intended audience some incorrect statements were made in the standard deviation and margin of error tutorials. For example, the tutorial on standard deviation summarizes it as the "mean of the mean," which does not convey that it is a measure of how variable the data are. Also, the margin of error page states that "a margin of error is a confidence interval," but does not explain that it is used to calculate confidence intervals. This website provides a basic introduction of statistical concepts with clear explanations and good examples. Overall, the information is conceptually correct and includes useful points, for example, to use the median instead of the mean in certain settings. Please note the errors listed in the concerns. The tutorial is all reading. Students that have trouble reading paragraph after paragraph with few visuals may lose focus. It may be difficult not to skim. This tutorial is simple, clear, and easy to use. There are two easy ways to navigate this tutorial. 1) The introductory page lists all the lessons in a reasonable order; 2) Each page has a link to the "next page" at the end. While it isn't necessary to read the pages in order, it is easy to do so and allows the reader to easily go through all of them. The reading is easy. It is written as if the author is talking to you or lecturing, which makes it more interesting. These explanations may be at a level too simple to be integrated into some statistics curricula, depending on the assumptions made about prior knowledge. The tutorial only requires students to read and does not encourage students to be actively involved in learning. The author's comments about "Math Geek Stuff" and formulas not being important, although probably intended to be humorous, may undermine a teacher's ability to encourage students to learn formulas. There is a serious concern about the non-positive tone in the standard deviation and margin of error lessons toward learning statistics. The exposition is clear, engaging, and maintains an appropriate level of difficulty. The tutorial uses familiar examples to highlight each concept. Introductory level students should be able to use these tutorials by themselves to learn about several of the topics. It includes some good warnings like making sure writers understand what margin of error means before trying to interpret poll results and understanding the difference between correlation and causation. For courses with prerequisites that should have provided this level of understanding, this web site is useful for self-remediation on concepts with which students may still have trouble. 1

## Resource Comments

(no comments available yet for this resource)

Log In: