STA2220 

Office Files

The purpose of using Excel file: Students are from different departments and uses different statistical package later. For example, health science students use  SAS and social science students use SPSS or  Stata. There is no unified statistical software used among them except they all "have to" know how to use Microsoft Excel. It is very plausible that most of the students will have access to Microsoft Office later in their careers as the software has dominated the market. In order to keep the knowledge learned in this course from being obsolete, we intend to reformulate some common statistics procedures, plots, and graphs in Excel such that they are useful for students' careers. 

You need to download the Excel file and enable the macro in order to run the program.  You can also download the PowerPoint Files and press "F5" to see the animation.  Due to a recent  security update, you need to right-click the downloaded files, select "Properties" and "At the bottom of the General tab, select the Unblock checkbox and select OK."  


Stem and Leaf Plot

This excel file illustrates how to plot the stem and leave plot 

StemLeafPlot.xlsm

Vertical Modified Boxplots

This excel file illustrates how to plot the vertical side by side modified boxplots 

ModifiedBoxPlot.xlsm

Horizontal Modified Boxplots

This excel file illustrates how to plot the horizontal side by side modified boxplots 

ModifiedBoxPlot2.xlsm

Illustration of  Law of Large Numbers

This excel file illustrates the cumulative proportion of getting a head will eventually tend to 

Lecture14Supp.xlsx

Sampling Distribution of phat

This excel file illustrates the sampling distribution of phat

Lecture19Supp.xlsx

Binomial Distribution vs Normal Distribution

This excel file illustrates how binomial distribution approach to normal distribution as the sample size increases.

Lecture18Supp.xlsx

Coverage of Confidence Intervals

This excel file illustrates the confidence interval being random and how it covers the true mean

Lecture20Supp.xlsm

Sampling Distribution of phat under Null Hypothesis

This excel file illustrates the sampling distribution of phat

Lecture21.xlsx

Simulation of Pi Value 

This excel file illustrates how to use simulation to estimate pi value 

PiSimulation.xlsm

How to Draw Boxplots 

This PowerPoint  file illustrates how to plot the boxplot 

How2DrawBoxplot .pptx

How to Draw Stem and Leaf Plot

This excel file illustrates how to plot the stem and leave plot 

How2DrawStemplot .pptx

How to Plot the Histogram

This excel file illustrates how to plot the histogram 

How2DrawHistogram.pptx

How to Draw Stem and Leaf Plot

This excel file illustrates how to use the TI-84 to plot the data 

HowToPlotwithTI84.pptm