Creating Frequency Tables and Histograms in MS Excel 2007

Creating Frequency Tables and Histograms in MS Excel 2007
Creating Frequency Tables and Histograms in MS Excel 2007
Grade Levels
Product Rating
4.0
File Type
PDF (Acrobat) Document File
Be sure that you have an application to open this file type before downloading and/or purchasing.
0.58 MB   |   10 pages

PRODUCT DESCRIPTION

This activity looks at a realistic data set and walks the student through constructing a frequency table and histogram using Microsoft Excel. It should be noted that Excel is not the best software package for creating histograms, but because it one of, it not the most widely used software package for data storage and presentation in business, it is important to know how to create professional-looking and statistically accurate graphics using this tool.

There are two different ways to construct histograms in Excel: using the basic charting functions and using the data analysis add-in. This worksheet assumes that the data analysis add-in is not available and walks the student through finding frequencies from a data set using the frequency array function. The histogram is created using a column graph and adjusted so that the bars touch creating a true histogram with bins that start and end at the desired endpoints.

The activity concludes with several follow-up questions (along with an instructor’s key and guide) that can be assigned or reviewed to summarize the activity. The questions pertain to constructing frequency tables and histograms as well as interpreting results.

Created by Veronica P. Hupper, Ph.D.
Total Pages
10
Answer Key
Included
Teaching Duration
90 Minutes

Average Ratings

4.0
Overall Quality:
4.0
Accuracy:
4.0
Practicality:
4.0
Thoroughness:
4.0
Creativity:
4.0
Clarity:
4.0
Total:
1 rating
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$3.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (2 Followers)
$3.00
Digital Download
ADD ONE TO CART
Creating Frequency Tables and Histograms in MS Excel 2007
Creating Frequency Tables and Histograms in MS Excel 2007