Whoops! Something went wrong.

Click here to refresh the page

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
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
Product Rating
3.9
4 ratings
File Type

Compressed Zip File

Be sure that you have an application to open this file type before downloading and/or purchasing.

712 KB|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 pages
Answer Key
Included
Teaching Duration
1 Week
Report Copyright Infringement
  • Comments & Ratings
  • Product Q & A
Loading...
$5.00
Digital Download
Add one to cart
avatar

Math Luvr

22 Followers
Follow

Advertisement

Advertisement

$5.00
Digital Download
Add one to cart
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up