### Our Services

Get 15% Discount on your First Order

# PSY341 – Research Methods in the Social Sciences Unit 5 Assignment: Running and Interpreting a Correlation Using Excel Points: 100 Overview:

PSY341 – Research Methods in the
Social Sciences

Unit 5 Assignment: Running and Interpreting a Correlation Using Excel

Points: 100

Overview:

For this assignment, you will apply your knowledge of correlational research by running
a correlation statistic (Pearson r) using a sample data set.

Directions for Enabling Data Analysis ToolPak.

See instructions for Downloading Microsoft Office provided in Unit 4. You will need to
use the Data Analysis ToolPak feature within Excel to run the correlation. This is an
add-on feature for Excel that you need to enable manually. To enable the ToolPak,
follow the instructions below:

• Go to EXCEL

• Click on File

• Click on Options

• Click on Add-Ins

• Click on Analysis ToolPak

• Click Go

• Check Analysis ToolPak

• Click OK

• Data Analysis should appear on the upper right of your toolbar.

Instructions:

The Psychology 101 instructor is interested in determining if there is a correlation
(relationship) between hours spent studying and grades on the midterm exam. They
collect data from all 25 of their PSY101 students. Students were asked to indicate on a
survey the number of hours spent studying for the midterm exam as well as their exam
score. The data collected from students is listed below:

Hours Spent Studying Midterm Exam Score
0 59
0 49
0 39
0 47
0 45
1 61
1 79
1 63
1 67
1 72
2 87
2 84
2 86
2 88
2 85
3 92
3 94
3 91
3 92
3 91
4 100
4 100
4 100
4 97
4 98

Part A
For the data set above, run a correlation in Excel.
Directions for Running a Correlation in Excel

• Open Excel
• Enter the Data Set Above
• Go to Data
• Go to Data Analysis
• Click on Correlation
• Select your Input Range
• Select Output Range (Select Area of Cells for Graph to Appear)
• Click OK

Review the “Creating a Scatterplot and Running a Pearson r Correlation in Excel”
found in the Unit 5 Readings and Resources on Blackboard.

Then, after the following questions:

1. What is the correlation coefficient between hours spent studying and midterm
exam grades? Provide the Pearson r value. (25 points)

2. Is this a positive or negative correlation? Alternatively, is there no correlation
between variables? Explain your choice. (25 points)

3. Is the correlation between variables weak, moderate, or strong? Explain your
answer, using the chart below to help you. (25 points)

Part B
Graph a scatter plot of the correlation. Add a title and label your Y axis and X axis
describing what the graph is showing. (25 points)

Directions for Graphing a Scatterplot
Review the “Creating a Scatterplot and Running a Pearson r Correlation in Excel” found
in the Unit 5 Readings and Resources on Blackboard.

Requirements:

• Answer all the questions in Part A and Part B.
• Submit a Word document with your answers.

Be sure to read the criteria below by which your work will be evaluated before
you write and again after you write.

© 2022 Post University, Waterbury, CT

Evaluation Rubric for Unit 5 Excel Assignment

CRITERIA Deficient Needs
Improvement

Proficient Exemplary

0 Points 25 Points
Correlation
Coefficient
(Pearson r
Statistic)

The correlation
coefficient (Pearson
r statistic) is not
stated OR is stated
but incorrect.

N/A N/A The correlation
coefficient (Pearson
r statistic) is stated
and correct.

0 points 1 – 11 points 12 – 24 points 25 points
Direction of
Correlation

The direction of the
correlation (positive,
negative, or no
correlation) is not
given nor is it
explained. OR The
direction is given but
the explanation is
inaccurate.

The direction of
the correlation
(positive, negative,
or no correlation)
is accurate, but an
explanation is not
provided.

The direction of the
correlation
(positive, negative,
or no correlation) is
explained and is
accurate, but the
explanation is
somewhat lacking
in detail.

The direction of the
correlation (positive,
negative, or no
correlation) is
thoroughly
explained, and the
explanation is
accurate.

0 points 1 – 11 points 12 – 24 points 25 points
Strength of
Correlation

The strength of the
correlation (weak,
moderate, or strong)
is not given nor is it
explained. OR The
strength is given but
the explanation is
inaccurate.

The strength of the
correlation (weak,
moderate, or
strong) is accurate,
but an explanation
is not provided.

The strength of the
correlation (weak,
moderate, or
strong) is explained
accurately, but the
explanation is
somewhat lacking
in detail.

The strength of the
correlation (weak,
moderate, or strong)
is thoroughly
explained, and the
explanation is
accurate.

0 points 1 – 11 points 12 – 24 points 25 points
Graph of
Correlation

Graph of correlation
is not provided or is
provided but does
not accurately
illustrate the
correlation between
variables and is
missing all important
components such as
a title and labeled
axes.

Graph of
correlation is
provided and
accurately
illustrates the
correlation
between variables.
Graph is missing
most of the
important
components, such
as a title and
labeled axes.

Graph of
correlation is
provided and
accurately
illustrates the
correlation between
variables. Graph is
missing some
important
components, such
as a title, and/or
labeled axes.

Graph of correlation
is provided and
accurately illustrates
the correlation
between variables.
Graph includes a
title and labeled
axes.

• Overview:
• Directions for Enabling Data Analysis ToolPak.
• Instructions:
• Part A
• Directions for Running a Correlation in Excel
• Part B
• Directions for Graphing a Scatterplot
• Requirements:
• Evaluation Rubric for Unit 5 Excel Assignment

Order a Similar Paper and get 15% Discount on your First Order

## Related Questions

### Additionally, relying on boosters might hinder your personal skill development. I believe it’s more rewarding to climb the ranks through your efforts,

Additionally, relying on boosters might hinder your personal skill development. I believe it’s more rewarding to climb the ranks through your efforts, learning from both victories and defeats NML  . If you’re looking to improve, consider joining communities, watching tutorials, or finding mentors.

### Critical  Evaluation of a  Research Paper The purpose of this assignment is to demonstrate your ability to evaluate one

Critical  Evaluation of a  Research Paper The purpose of this assignment is to demonstrate your ability to evaluate one quantitative or qualitative nursing research article of interest from any refereed nursing journal. Writing a critical review of a journal article can help to improve your writing and analytical skills. By

### Review the project goals and examples at the A River of VoicesLinks to an external site.,” a national movement that focuses on countering divisions of

Review the project goals and examples at the A River of VoicesLinks to an external site.,” a national movement that focuses on countering divisions of race, culture, and background through poetry, artwork, videos, music, and dance. Submit your own “I Am From” poem, song, or creative writing (aim for 250 words.) Consider contributing

### Research – System Analysis and design Assignment #7.1 – Change Management and and Change Control Research a scholarly paper or

Research – System Analysis and design Assignment #7.1 – Change Management and and Change Control Research a scholarly paper or professional video on “Change Management”  and reflect on only one (1) of the following topics: · “Impact”: How is the impact of change management on systems projects?  · “CCB”: Who

### THE VALUE OF NURSING INFORMATICS AND PROJECT MANAGEMENT FOR NURSING PRACTICE Transforming Nursing-Spring THE VALUE OF

THE VALUE OF NURSING INFORMATICS AND PROJECT MANAGEMENT FOR NURSING PRACTICE Transforming Nursing-Spring THE VALUE OF NURSING INFORMATICS AND PROJECT MANAGEMENT FOR NURSING PRACTICE Read a selection of your colleagues’ responses and respond to two of your colleagues by expanding upon their responses or sharing additional or alternative perspectives.  PEER #1 · Kimberly Riley TuesdayMay

### Analyze the specifics of the US healthcare system in terms of populations served, policy applied and funding available Implement quality measurement

Analyze the specifics of the US healthcare system in terms of populations served, policy applied and funding available Implement quality measurement and process improvement programs to improve health outcomes. Apply sound project management principles to support the design of organizational processes.

### What are two things you can take away from this class that will be useful to your career? Do you think you will work with the elderly population

What are two things you can take away from this class that will be useful to your career? Do you think you will work with the elderly population during your career? Why or why not? Would you recommend this class to other students? Why or why not?

### Biostatistics 24TW3 Introduce yourself to the group ( I work at an Emergency room as a healthcare administrator at University of

Biostatistics 24TW3 Introduce yourself to the group ( I work at an Emergency room as a healthcare administrator at University of Maryland ) and explain your background. Describe your professional goals. Include what you hope to accomplish by the end of the course. Do you have any experience running statistical

### ANTH350 WEEK 2 RESOURCES

ANTH350 WEEK 2 RESOURCES

### Instructions are attached  Cultural Plunge Paper This assignment exposes you to unfamiliar dimensions of diversity or to a

Instructions are attached  Cultural Plunge Paper This assignment exposes you to unfamiliar dimensions of diversity or to a marginalized group about whom you have less knowledge or exposure. You should identify events that are open to the public or, at a minimum, open to individuals who are not members of

### Can someone edit my paper and fix the citations. I want to get a 100% on my assignment, and in order to do that, the citations make sense, and the

Can someone edit my paper and fix the citations. I want to get a 100% on my assignment, and in order to do that, the citations make sense, and the statistics need to be fact checked and cited as well. Please keep the current citations used to help restructure this

### Infant Observation This file is too large to display.View in new window

Infant Observation This file is too large to display.View in new window

### Week 8: End-of-Course Reflection Paper This reflection entry is your final assignment for LAWS310. You will write an essay in the first person. The final

Week 8: End-of-Course Reflection Paper This reflection entry is your final assignment for LAWS310. You will write an essay in the first person. The final essay should be 2-3 pages long. Answer the following:   What were your expectations at the start of this course? Describe your experiences during this course

### CHEM 146 Lab 3 Worksheet | 2 Lab 3 Worksheet GRADE ____ /25 p Your

CHEM 146 Lab 3 Worksheet | 2 Lab 3 Worksheet GRADE ____ /25 p Your name: Instructions. Carefully review the material on pages 3 – 8 of the CHEM 146 Lab 3 Manual (especially the fully worked examples). In this online activity, you are processing and analyzing data identical to

### PSYC 621 Research Paper: Final Submission Assignment Instructions Overview Organizing and integrating information

PSYC 621 Research Paper: Final Submission Assignment Instructions Overview Organizing and integrating information from multiple sources is an important part of developing a strong research paper. As graduate students, it is important to be able to develop this process for writing and developing a research paper. This assignment will provide

### IRAC Worksheet IRAC Format Facts: ISSUE: #1: #2: #3 RULE of LAW: ANALYSIS: CONCLUSION: worldwide.erau.edu All rights are

IRAC Worksheet IRAC Format Facts: ISSUE: #1: #2: #3 RULE of LAW: ANALYSIS: CONCLUSION: worldwide.erau.edu All rights are reserved. The material contained herein is the copyright property of Embry-Riddle Aeronautical University, Daytona Beach, Florida, 32114. No part of this material may be reproduced, stored in a retrieval system, or transmitted

### Discuss two ways that societal incidents of the past 10 years have impacted student acquisition of knowledge, skills, and attitudes needed to function in

Discuss two ways that societal incidents of the past 10 years have impacted student acquisition of knowledge, skills, and attitudes needed to function in current home and school settings. Support your points with at least one piece of scholarly research.

### demonstrate your comprehension of the theories and frameworks we’ve discussed/read/engaged in any form that suits them and their learning style by writing a

demonstrate your comprehension of the theories and frameworks we’ve discussed/read/engaged in any form that suits them and their learning style by writing a poem based on Foundations in Hip Hop/Studie