Lab stuff, Weblinks,  Text CD  Math 251 , Fall 2011   Hit reload to get most current version

Macmillan 101 , Learning Center, Cleveland lab PC's , +Macmillan 110 (Macintosh) lab   have SPSS
  You can access from those machines a Math 251 IPS7e folder. 
It  is on \\,  a "Network drive," in
  Users\ssievers\MATH251 Class Materials\Math251 IPS7e
             How to connect (on a Wells machine) to Morganstore
Contents of Math 251 IPS7e folder   
  Data Sets: 
In SPSS form (.por--"SPSS portable".  Resave in standard .sav form) And as text, Excel files.
  SPSS for Class:
Files for use with SPSS handouts, etc.
  RegressionDemosExcel:  Used in Ch. 2
  OtherDemosExcel:  used later, mostly
  Transformations2-6IPS4   Section 2-6, on the web or your disk, not on paper.  Pdf is here.  SPSS files and solutions for Section 2-6,  taken from the 4th edition because the 5th edition solutions aren't available.  You'll get a handout with the HW for this section.
You may take copies of any of this for use on your own computer (but SPSS is only on lab machines).

Website:  Loads very slowly.  Trouble making it work?  The previous edition's applets have many of the same datasets as the 7th.  The more basic book   has "older" applets, work fine for all but the "statistical calculator" and "two-asset portfolio" applets". 
Disk with book:  Mostly mirrors the website. Website may have some newer things.  If it doesn't open automatically, double click on IPS7e.htm. 

Applets (website or disk)
Under Student Categories or Student tools,  choose "Statistical Applets."   I know we'll use these: 
One-variable Statistical Calculator, 
Mean & Median,
Normal Density,
Simple Random Sample: 
For example, To pick a sample from a "Population" list labeled 1 to 138, enter 138 in the top box, hit Reset. Put the size of the desired sample in the bottom box.  Hit Sample.  The sample numbers move to the right-hand column.  To pick a different sample, hit Reset, then Sample.
This can be used to allocate units for an experiment like this;  Suppose 12 units and 3 treatments.  Each treatment should get 12/3 = 4 units. Put 12 in the population box, 4 in the sample box.  Hit Sample to choose the 4 numbers for the units to get treatment 1.  Hit Sample again (don't Reset) and it will choose the 4 from the remaining pool to get treatment 2.  The remaining 4 will get treatment 3.  You can select and copy (Ctrl-c) the sample numbers into a Word document.
Probability  For a fair coin, leave probability at .5.  It accumulates tosses until you hit Reset.
Also Confidence interval
  P-value of a test of significance

Excel spreadsheets: (also in Math 251 Class Material/Math251-IPS7e, when it becomes available)
TableA,    TableC(binomial), TableD(t-distribution)
 What happens in normal distribution tails, beyond z = 3.49?  NormalTails.htm

Regression and correlation:
    Regression, least squares
    Slope of the regression line
Sample means:
Normal and Xbar, compared
Normal and t compared
two-sample t procedures 

Other links:
 Sampling distributions, Central Limit Th.  Rice U. Applet 
           (do Sample: Animated sample; Distribution of means: n =5, then n = 25. Do Sample 5, 1000, 10000 after idea clear. )

Datasets and collections of datasets (posting as I become aware of them, check them out)

Datasets and collections of datasets (posting as I become aware of them) 

These are some sites I've visited this term, that have potentially great data.
  Searchable databases give lots of info by country  (CO2 emissions for example), downloadable to Excel

International Energy Association:  They really want to sell you the latest data, but some is free and easily downloadable. may have been the source for CO2 emissions for some Moore books.  An excel (.csv) download of data is here.

Statistics Canada:  everything!   is the general website.   is just the tables, apparently.

Pew research on a bunch of internet topics:, on the right sidebar is a Download Data choice, read that page before downloading..

Gay marriage opinion polls:  Most data here are just categorical, but there is good time series data also.

Older good links, which I haven't checked for currency.
DASL ( is an on-line library of datafiles and stories that illustrate the use of basic statistical methods.  These have some pre-analyzed “answers” but there is probably more to find out from the data than what they present. I looked through these—there are certainly interesting ones here.  The parent site,, has links to many interesting data sets (some of which have enough information to be useful to you.) + has a GetData  link if you have trouble with the files in Datasets.

Two parts, Datafiles, and Stories.  Each Datafile has one or more Stories (context for the file).

If you list all Topics, you’ll get topics of the Stories.  Pick one and get a list of Stories relevant to that topic.  Click on a link for the desired Story and get the Story page.  There’s a link to the Datafile (and the Datafile page has a link to the Story page). 

Datafiles: The source information is given, n, and then a listing in text form of the data.  Variable values are (usually?) separated by spaces.  Copy and paste the data part only into a text editor or Word,  and save as a Text file. (Get rid of any leading or trailing irrelevant lines.) Then SPSS should be able to import it; but check to make sure it’s done the import process correctly!   has datasets without so much background and machinery as the above.   has 232 potentially useful datasets, many with detailed suggestions for analysis; but again there are probably more things to find out than they present.

World Bank: /  Huge amounts of wonderful data for all the countries of the world (not all questions have answers from all countries/years) 
  Some of the World Bank databases require paid subscriptions but many don't.  Try Data Resources box, lower right, or Quick Query. Mostly you want to get to a Data Query engine where you can choose countries, variables ("series") and years ("time)You can download the data you've selected into excel, massage it there, then import to SPSS.  A search on "world bank statistics" gives related searches that may not be redundant.

the Population Reference Bureau has similar data and more.  The DataFinder tab allows you to select; tables can be downloaded to Excel, you can combine them there.  To get an overview of the kinds of things, see the PDF

The National  Center  for Education Statistics  (NCES) is a trove of data;  Fast Facts tab gives a list of some of what's there,  summarized and shortened data tables, with links to the rawer data;   Tables & Figures allows searches if you have an idea in mind; Data Tools has ways to build your own tables, e.g. by State.  Most tables seem to be downloadable either to Excel or text (.csv--comma separated values--format)

Some other compendia of datasets, from googling "Statistical data sets", and elsewhere “A sampler of WWW resources for teaching statistics”—links to lots of resources (some of which may not work anymore).

 - - - - - - -  
  If you're interested in databases for a particular topic or issue, they do exist--though often what you get is predigested results, and you want raw data for the project.  It may be that faculty or thesising seniors in your  field if interest can point you to relevant databases.

Sievers home  Math251-Fall11/Weblinks251.htm  11am 9/21/11
This page belongs to Sally Sievers who is solely responsible for its content. Please see our statement of responsibility.