Teachers Pay Teachers

Excel Projects for Statistics Frequency Distributions and Charts

Product Rating
3.9
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
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
Answer Key
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
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$5.00
Digital Download
ADD ONE TO CART
User Rating: 3.9/4.0
 (19 Followers)
$5.00
Digital Download
ADD ONE TO CART
Excel Projects for Statistics Frequency Distributions and Charts
Excel Projects for Statistics Frequency Distributions and Charts
Excel Projects for Statistics Frequency Distributions and Charts
Excel Projects for Statistics Frequency Distributions and Charts