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

Page updated

Report abuse