our img
our img
our img
1200 Home Page    Contact      Learning Objectives      Term Assignment     
our img
our img
our img
Term Assignment Analysis......
Jeremy Jackson
|     Jan 2nd, 2018
NW 3431
|     New Westminster
Jeremy Jackson: "Life is a group project"


In this section I give you some help on how to analyze your data using MS Excel. Give this section a quick preview now, but don't worry about the details until you have collected your data.

Let’s begin the lecture by opening the Excel file:Psych 1200 Excel Class.xls.

When you open this file, you will see sheet 1 displayed. Sheet 1 shows an example of a case in which we have one IV with two levels and one DV. Your first job is to determine how many levels your IV has. Most of you will have one IV with two levels. This sheet shows you how to analyze the results of an experiment with one IV that has two levels and one DV.

Lets imagine for the sake of this example that the IV is “quality of dress and grooming” and the IV has two levels: A=Low quality dress and grooming and B=High quality dress and grooming. Suppose the researcher is a waitress and on 7 randomly selected work nights she dresses and grooms herself poorly. On 12 nights she dresses and grooms herself well. Now imagine that she gives a survey to her customers at the end of the meal and asks them on a scale of 1-10 how much they liked their server.

The data are displayed in columns A and B of sheet 1. The first 7 rows of data contain level A of the IV (Level A=low quality dress and grooming) and the next 12 rows contain level B of the IV (Level B=high quality dress and grooming). In column B, we see the scores each customer gave the waitress on the 1-10 scale (this is the DV). For instance, we can see that the first customer in level A rated the waitress a 5 on a scale of 1-10. If you have one IV with two levels and one DV, step 1 will be to enter your data into Excel as I have done in the example. Even if you do not have one IV with two levels, keep reading....you will learn how to use Excel by going through this example.

Next I’d like you to calculate averages and SD's for each group. You can see that they are displayed on sheet 1 for this example. You will learn how to do this in the movie.



It will be important for you to comment on any differences you find in your research report. In the example, the difference between the means is large. A mean difference of 2.2 (i.e., 7.1-4.9=2.2) on a scale of 1-10 is fairly important. Mean differences of .5 or less are small. The SD’s are also pretty different as well. A difference in SD’s of .5 or bigger is large. Look for reasons why the SD’s are different (if they are). In this case, the last person in group B rated the waitress as a “1”. This is a very unusually low score – it’s an outlier. This is the reason why the SD is larger for group B than group A. This one unusually low score is creating SPREAD or VARIABILITY in the group B scores. Now, I’d like you to be able to draw a basic histogram of your group averages if you have one IV with 2 levels.

You will learn how to do this in the movie.



Take a look at the graph in the Excel file. Create a graph that looks like this one and label it correctly. For our example the labels would be as follows: Title: Average Waitress Ratings for Low and High Quality Grooming Conditions X-Axis: X=Quality of Dress and Grooming Level A = Low Quality Dress and Grooming Level B = High Quality Dress and Grooming Y-Axis: Average Waitress Rating. This is all the analysis you will need to do if you have one IV with two levels and one DV.



‹ ‹ Back to the Syllabus