Descriptive Statistics: Visualizing Data, Relationships between Variables, Measures of Position 

How to Construct a Dot Plot 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.

Constructing a Dot Plot in Excel.zip

Finding Percentiles,Deciles and Quartiles 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.

Percentile, Decile, Quartile & Median using Excel.zip

How to Construct a Box Plots 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.


Box Plot in Excel.zip

Pearson's Coefficient of Skewness and the Skew Function 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.


Skewness Calculator.zip

Measuring Correlation between Variables using the CORREL Function 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.


Correlation in Excel.zip

How to Construct a Contingency Table 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.


Contingency Tables in Excel Using a Pivot Table.zip