### 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.

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,

• Go to EXCEL

• Click on File

• Click on Options

• 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 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

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.

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

### see attachment  Define Concepts Instructions: Define the following basic concepts related to social

see attachment  Define Concepts Instructions: Define the following basic concepts related to social psychology, using the technical vocabulary of the module. · · · Social influence · Exchange theory · Social influence theory · Conformity · Asch  · Moscovici  · Affiliation · Acceptance · Obedience · Milgram’s studies · Pro-social

### see attachment  Discussion Forum Instructions:  Answer the following questions:  · · What techniques

see attachment  Discussion Forum Instructions:  Answer the following questions:  · · What techniques have some websites used to get people to meet a partner? · Why do people defy the law? · Why have good people do things against their will? · How do we allow ourselves to be influenced

### There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the

There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the consumer. Explore “both sides” of this issue as you research the topic this week.   The Immortal Henrietta Lacks – The Infamous Unit 731

### PLEASE SEE ATTACHMENT!!!!!!!! 1. How does the body respond to stress? Include both immediate physical responses and long-term affects of stress. 2.

PLEASE SEE ATTACHMENT!!!!!!!! 1. How does the body respond to stress? Include both immediate physical responses and long-term affects of stress. 2.   Fully discus at least two aspects of how the current medical system is abused. 3.   Discuss two possible interventions to decrease the impact of daily life stress. 4.

### There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the

There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the consumer. Explore “both sides” of this issue as you research the topic this week.

### attached Anonymous Peer Creation 2 · 23 words ·     Impolite: One time Jason was rude and impolite to his mother. When she

attached Anonymous Peer Creation 2 · 23 words ·     Impolite: One time Jason was rude and impolite to his mother. When she called his name, he said “what do you want?!”

### attached Anonymous Peer Creation 3 · 22 words ·     Eloping: each instance in which someone leaves the room without permission

attached Anonymous Peer Creation 3 · 22 words ·     Eloping: each instance in which someone leaves the room without permission from an adult or a demand to leave the area.

### attached Anonymous Peer Creation 1 · 84 words · Drinking from a straw: Each instance in which Susan puts her lips around a

attached Anonymous Peer Creation 1 · 84 words · Drinking from a straw: Each instance in which Susan puts her lips around a straw, uses the straw to suction water into her mouth, then uses her tongue to swallow it. · Examples: only count when a straw is used to

### There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the

There are many forms of abuse in the current US medical system. Some of these abuses are initiated by medical professional and some are initiated by the consumer. How van we Explore “both sides” of this issue?

### see attachment  Module 5: Managing Time and Stress We all experience stress from a variety of sources in our lives; job

see attachment  Module 5: Managing Time and Stress We all experience stress from a variety of sources in our lives; job stress, home stress, financial stress, you may even be feeling some academic stress realizing you have to participate in a discussion this week! As you prepare your  Anti-Stress Agenda

### see attachment Module 5: Assignment 1-“My Anti-Stress Agenda” Instructions: This assignment aims to

see attachment Module 5: Assignment 1-“My Anti-Stress Agenda” Instructions: This assignment aims to introspect and reflect on the most relevant topics this week. “Discover” your procrastination style and discuss how you intend to overcome it. To achieve this, complete the following test:  Procrastination test. (n.d.). IDRlabs.  to an external site. and review

### see attachment  Module 5: Word Processing Programs and Key Features Instructions: 1. Select two basic functions of word

see attachment  Module 5: Word Processing Programs and Key Features Instructions: 1. Select two basic functions of word processing programs. 2. Use a chart diagram to compare the two basic functions and their key features. You must include at least four characteristics in each column. Write complete sentences and be

### see attachment  Module 5: Microsoft Word, Three Ways After studying the content of the module and the suggested resources,

see attachment  Module 5: Microsoft Word, Three Ways After studying the content of the module and the suggested resources, participate and comment on the multiple versions of Microsoft Word (desktop, online, and mobile). Make an initial contribution paragraph describing the version of Word on your computer, Word online (www.office.com), and

### Please see attached and use all reading materials.  HSCO 509 Cultural Conversation Assignment Instructions Overview It is

Please see attached and use all reading materials.  HSCO 509 Cultural Conversation Assignment Instructions Overview It is important for human resources professionals to be aware of their own cultural identities, acknowledge their values and beliefs, and be prepared to navigate situations involving cultural and value differences. The purpose of this

### Please See attached !  Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with

Please See attached !  Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission of the copyright owner. Further reproduction prohibited without permission. Reproduced with permission of the copyright owner. Further reproduction prohibited

### Select from one of the following categories: Moral Judgement Spiritual and Religious Concepts Creativity Emotional

Select from one of the following categories: Moral Judgement Spiritual and Religious Concepts Creativity Emotional Intelligence Optimism Gratitude Sense of Humor Then find a scale that measures the construct (include name). Describe what the scale entails (type, range of scores, sample items). Include the reliability and validity of the

### See attachment Monday Tuesday Wednesday Thursday Friday Saturday Sunday Time I woke up: Total # of hours slept: How rested I feel on a scale

See attachment Monday Tuesday Wednesday Thursday Friday Saturday Sunday Time I woke up: Total # of hours slept: How rested I feel on a scale of 1 – 10 (0=awful -> 10=great): # of caffeinated drinks today: Time of last caffeinated drink: Exercise or meditation completed today (minutes): Did I

### Need help with making a mental health poster. Overview Combating low quality information with scientific evidence is a

Need help with making a mental health poster. Overview Combating low quality information with scientific evidence is a challenge faced by most human services professionals. Posters can be used to provide easy-to-digest facts in a visually appealing way, as an aid to challenging flawed information. The objective of this assignment