Descriptive Statistics:  Percentages, Frequency Tables, Frequency Distributions, & Histograms

Simple Percentage Calculation using Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Simple Percentage Calculation Start and Solution File.zip

 Percentage Calculation including a Missing Number using Excel

Instructions: Download the question and start file, from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Percentage - Missing Value - Question and Solution File.zip

How to Construct a Frequency Table in Excel using the Countif Statement

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.


Frequency Table - Countif Statement - Question and Solution Files.zip

How to Construct a Relative Frequency Table using Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Relative Frequency Table using Excel - Question & Solution File.zip

How to Construct a Frequency Distribution Table in Excel using the COUNTIFS Statement

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Frequency Distribution Table - COUNTIFS Statement.zip

How to Construct a Frequency Distribution Table using a PivotTable in Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Frequency Distribution Using a Pivot Table.zip

How to Construct a Cumulative Frequency Distribution Table using Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.


How to Create a Cumulative Frequency Distribution Table.zip

How to Construct a Simple Histogram using Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.


Simple Histogram Excel - Question and Solution.zip

How to Construct a Frequency Distribution Table Based on An Existing Histogram using Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Frequency Distribution Table using Excel - Question & Solution File.zip

How to Construct a Frequency Polygon in Excel

Instructions: Download the question and start file from the link on the right, and then follow the instructions contained in the youtube video in the far right.

Frequency Polygon in Excel - Question and Solution.zip

How to Construct a Cumulative Frequency Distribution Table and a Cumulative Frequency Polygon using Excel

Instructions: Download the question and start file from the link on the left, and then follow the instructions contained in the youtube video in the far left.


Cumulative Frequency Distribution Table in Excel - Question & Solution File.zip

How to add a Secondary Axis to a Frequency Polygon in Excel

Instructions: Download the question and start file from the link on the left, and then follow the instructions contained in the youtube video in the far left.


Adding a Secondary Axis - Question and Solution File.zip

How to Read from a Cumulative Frequency Polygon

Instructions: Download the question and start file from the link on the left, and then follow the instructions contained in the youtube video in the far left.


How to read a Cumulayive Frequency Polygon - Question and Solution File.zip

How to Determine the Appropriate Number of Classes for a Histogram or Frequency Distribution Table

Instructions: Download the calculator file from the link on the left, and then follow the instructions contained in the youtube video in the far left.


Class Number Calculator and Worked Example.zip

How to Determine the Appropriate Class Interval Width in a Histogram or Frequency Distribution Table

Instructions: Download the calculator file from the link on the left, and then follow the instructions contained in the youtube video in the far left.


Class Width Calculator -Question & Solution File.zip