Demonstrations and activities for Psyc 220 Fall 2003

Walter vom Saal

This file was most recently updated: ---- 9/10/03

This is a preliminary list of some of the demonstrations and activities we will do in Psyc 220. It does not necessarily include all that we will do.

More details for each demonstration or activity are available by clicking the appropriate links in the left column below.

SUGGESTION #1: USE SAVE, NOT OPEN. in order to keep a copy of these sheets on your own computer (or on your p drive), when you click on the item below you should not select OPEN, but instead select SAVE, and then save the sheet on your computer (or p drive) using a name that is meaningful to you..

SUGGESTION #2: SAVE TWO COPIES. You also may want to open the file and then select File > Save As to save it under a second, different name. For example, you might save the original file as "USING EXCEL - ORIGINAL" and save another copy as "USING EXCEL - REVISED." You could then keep the first version as the original and the second version as one you want to modify and play with.

 

Title Description and notes
Using Excel

Combines two items. First, some instructions on using Excel to compute functions (such means, tests, or correlations), and second, some examples of potentially misleading statistics based on changing axes.
Correlations #1 preliminary demonstration of some correlations
Correlations #2 more demonstration of some correlations. NOTE: until I get this changed, click on "Don't Update" when this opens.
T-test vs. correlation This Excel spreadsheet uses several related data sets to illustrate the difference between a t-test and a correlation. The example used is a group of students who took an SAT test twice, and questions are asked about the relation between scores on Test 1 and scores on Test 2.
   

dw8/26/03 rev9/10/03