Exercise3 PSC41

# Exercise3 PSC41 - In this activity you will be creating...

This preview shows pages 1–4. Sign up to view the full content.

In this activity, you will be creating numerical and graphical descriptions of data. There are 4 sets of data, on 4 different worksheets (see the tabs at the bottom fo the page). The data were generated by 4 hypothetical studies, each of which is described at the top of i You will use XL formulas to generate numerical descriptions. LEAVE THE FORMULAS IN T DO NOT "hand-enter" the numerical results. We want to see that you know how to input diffe You will need to decide which type of graph to use to describe the results appropriately. Display the graph, and all the numerical results, on one sheet of paper - do not split the page - if you choose to, you can print out the graph separately by creating it in a new wor Save the file as a .xls file, with your name in the file name, and drop it of to digital drop-off by

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

View Full Document
its worksheet THE CELLS. erent functions. e, and especially do not split the graph. rksheet y the due date.
PSC 41 Exercise 3: Describing Data Numerical and Graphic Descriptions Study 1 Use the data below to: a. calculate the mean, median, and mode for each group (1 pt) (1 pt) c. construct a table of the mean values (don't forget the labels!) (1 pt) d. construct a graph depicting the means (1 pt) e. add error bars to your graph representing the standard deviation (1 pt) Control Pair Group 9 16 20 13 19 18 15 16 15 16 17 20 12 17 17 14 14 17 14 18 20 17 18 18 18 17 20 14 20 16 For each group: mean mode median range variance standard deviation b. calculate the range, variance, and standard deviation for each g Study 1 (5 points) A psychologist was interested in examining the benefits of group over individual study on test performance. To this end he sampled a group of 3

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern