Teachers Pay Teachers

# Excel Projects for Statistics Frequency Distributions and Charts

Subjects
Resource Types
Product Rating
3.9
File Type
Compressed Zip File
How to unzip files.
0.7 MB   |   11 pages

### PRODUCT DESCRIPTION

This file contains three different projects with solutions and a quick reference card for students. It correlates to Bluman's Elementary Statistics textbook.
First is an Introduction to Excel. There is an example, guided practice and then 4 Projects. The instructions are on each sheet. The topics covered are: basic editing and formatting, beginning charts, beginning formulas, such as SUM and AVERAGE, and calculations. There is an editable grading rubric for this project. The Preview file was a pdf taken from the Excel Solution file.

Second Activity - correlates to section 2-2 - creating a frequency distribution. This includes the COUNTIFS formula for finding the frequency, as well as, reinforcing how to find boundaries and class widths. There is a detailed instruction sheet, as well as a solution file for this activity. (Thumbnails)

Third Activity - correlates to section 2-3 - creating different types of charts to display data. On this activity, students are asked to complete a histogram, frequency polygon, and cumulative frequency polygon (ogive). There is an editable detailed instruction sheet with some questions for this activity. There is a solution file as well, for this activity. (Thumbnails)
Total Pages
11
Included
Teaching Duration
1 Week

### Average Ratings

4.0
Overall Quality:
3.8
Accuracy:
3.9
Practicality:
3.9
Thoroughness:
3.9
Creativity:
3.8
Clarity:
3.9
Total:
4 ratings
\$5.00
User Rating: 3.9/4.0
(19 Followers)
\$5.00