ex_CSU_logo.jpg

About this Journal

Call for Papers

Submission
Guidelines

Review Criteria for Research Articles

Calendar of Events &
Opportunities

Exchanges
Editorial Board

Contributors

Post Your Comments

View Readers' Comments

Post Your Comments

ITL Homepage

Ex_header.jpg
Saltzman, Robert - Excel or Minitab: Which Software Package to Use in an Introductory Statistics Class? - Page 4
Exchanges: The On-line Journal of Teaching and Learning in the CSU


4. Conclusion

Some of the strengths and weaknesses of these two packages are summarized in Table 2 below. After weighing these, I'm still not sure what I'll do the next time I teach the course. On the one hand, I liked being able to offer students their choice of software packages. Several students said that they appreciated the opportunity to learn a new package. On the other hand, a fair amount of class time was lost in explaining two packages, when most students really only wanted to know about one of them. Given the limited amount of class time that I have to teach the underlying statistical concepts, I'm leaning toward using just Excel in the course next time around. Though it will require a little more effort from the students, I think it will give the class more focus and the students a solid introduction to an extremely powerful and prevalent analytical tool.

Table 2: Pros and cons of using Minitab and Excel for an introductory statistics class.
Minitab Pro Excel Con
  1. Easier for the novice to use - can do most tasks with just a few clicks.

  2. Uses common statistical terminology.



  3. Generates a default histogram without user-specified intervals.

  4. Performs almost all inferences discussed in a first statistics course.

  1. Harder for the novice to use - often must enter cell formulas and cell ranges.

  2. Occasionally misuses terminology, e.g., checking the box for "confidence level for the mean" yields the CI's margin of error.

  3. Harder to get a histogram, e.g., user must set up a column of "bins."

  4. Doesn't have built-in procedures for confidence intervals and 1-sample t-tests (although these can be performed).

Excel Pro Minitab Con
  1. Interface dialogs are consistent and have a modern look and feel.


  2. Flexible. Easy to control and modify the location of input data and output.

  3. Graphs are dynamically updated, and can be embedded in Word files.

  4. Wide use in business and other courses.

  1. Function interfaces are not consistent; many features are buried underneath several layers of dialog boxes.

  2. Somewhat inflexible. Can't control location of output; hard to modify graphs.

  3. Graphs are static: if the data change, the graphing process must be restarted.

  4. Limited use in business, other courses.

References:

Moore, David S., The Basic Practice of Statistics, Second Edition, W. H. Freeman, New York, 2000.

Carver, Robert, Doing Data Analysis with Minitab 12, Duxbury Press, Pacific Grove, CA., 1999.

Berk, Kenneth N. and Patrick Carey, Data Analysis with Microsoft© Excel, Duxbury Press, Pacific Grove, CA., 2000.




This article is dedicated to the memory of SFSU Professor Al Schainblatt,
who graciously shared with me many of his insights about how to teach statistics.


1 2 3 4

Back to From the Classroom

Back to Exchanges