{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Exercise 3-instructions

Exercise 3-instructions - PSC41(2 Winter 2010 Exercise 3...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
PSC41(2) – Winter 2010 Exercise 3: Describing Data In this activity, you will be creating numerical and graphical descriptions of data. Step 1. Open the Excel file titled “Exercise 3.xls”. Step 2. Save the file as “YourName.xls” Step 3. Open the file and look at the bottom of the worksheet. You’ll see several tabs labeled Data Set 1, 2, 3 or 4. These tabs are “worksheets” within the same Excel file. Step 4. Enter your name and ID # at the top of Data Set 1 Step 5. Open each tab individually and look at its contents. You should see that each worksheet starts with a description of a study. If you don’t see a description of the study, make sure that the scroll bar on the right is all the way to the top of the document. For example, Data Set 1 begins with the following: Study 1: A psychologist was interested in examining the benefits of group over individual study on test performance. To this end he sampled a group of 30 freshmen. Participants were first presented with a chapter taken from an Introductory Psychology textbook. They were the given 2 hours to study the chapter and were randomly assigned to one of 3 study conditions: alone (control condition), with a peer (pair condition) or with a group of 4 other freshmen (group condition). At the end of study time, participants were asked to answer 20 multiple choice questions on the studied material. The raw number of correct responses for each participant is reported below. Step 6. Start with Data Set 1. Read about the study and answer the questions within the Excel file. Then move on to Data Sets 2, 3 and 4. a. If you are uncomfortable with Excel and have trouble using the formulas, please read the information on pages 2-7 of this file. You can also rely on Google search to answer most questions about Excel and Excel formulas. b. You will need to decide which type of graph to use to describe the results appropriately.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
c. Do all the calculations within Excel (use Excel formulas). We will check your posted Excel files to make sure that you used the formulas and didn’t simply write in the numbers. If we don’t see your formulas, you will receive no credit for the assignment. Step 7. Print each worksheet to turn in before class a. You’ll need to open each worksheet separately and print them separately. b. Make sure that all the data fit within the left and right margins of the page when it prints out. Display the graph, and all the numerical results, on one sheet of paper – Try not to split the page, and especially do not split the graph. You can move the graph around so that it is below the table & other numbers and print the graph on a second page. That will help it stay in the margins. (You can also delete the study description, if that helps, but make sure you leave the questions, and the dataset) c. Please staple the pages together before coming to class.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}