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
Vertical Modified Boxplots
This excel file illustrates how to plot the vertical side by side modified boxplots
Horizontal Modified Boxplots
This excel file illustrates how to plot the horizontal side by side modified boxplots
Illustration of Law of Large Numbers
This excel file illustrates the cumulative proportion of getting a head will eventually tend to
Sampling Distribution of phat
This excel file illustrates the sampling distribution of phat
Binomial Distribution vs Normal Distribution
This excel file illustrates how binomial distribution approach to normal distribution as the sample size increases.
Coverage of Confidence Intervals
This excel file illustrates the confidence interval being random and how it covers the true mean
Sampling Distribution of phat under Null Hypothesis
This excel file illustrates the sampling distribution of phat
Simulation of Pi Value
This excel file illustrates how to use simulation to estimate pi value
How to Draw Boxplots
This PowerPoint file illustrates how to plot the boxplot
How to Draw Stem and Leaf Plot
This excel file illustrates how to plot the stem and leave plot
How to Plot the Histogram
This excel file illustrates how to plot the histogram
How to Draw Stem and Leaf Plot
This excel file illustrates how to use the TI-84 to plot the data