Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Psychology Unit 5 Assignment: Running and Interpreting a Correlation Using Excelv

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
ALL RIGHTS RESERVED

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Help needed

See attachments  Please respond to this topic using the attached PowerPoint for notes. This is a discussion post, not a formal paper. 100% NO PLAGIARISM or AI!!!!! This should only be maybe 1 or 2 paragraphs at the most. List the primary strengths of the experimental research design. In particular,

Professional Orientatn/Ethics

You will write an article review, relevant to this week’s learning module and readings. You will select the article yourself by searching the UWA Library Databases. The article you choose should be a research article (has a hypothesis that is empirically tested). Pick an article relevant to a topic covered in

Psychology Assignment

Please follow the instructions , No Ai Or chatsgpt Due Sunday by 10:59pm Points 90 Submitting a text entry box or a file upload Attempts 0 Allowed Attempts 2 Start Assignment  Back to Week at a Glance ( PERCEPTIONS OF SOCIAL CLASS In Week 1, you considered the way

Journal Ass

Part 1 Journal Assignment 1 Nico (For this part of the assignment, I have attached textbook for part 1. As mentioned in your syllabus, you will keep a journal throughout the semester to discuss your thoughts and share your experiences as they relate to concepts discussed in each module. Due

field of practice

How does this discussion help Assignment: Human service agencies vary broadly in their missions. An essential step in selecting your field site is identifying the human problems or needs you want to learn more about. This dimension of an agency’s or a professional’s identity is called the  field of practice

Discussion

Please follow instructions < No Ai or Chat   Due Jan 21 50 points Week 3: Discussion  Back to Week at a Glance ( INFLUENCE OF MEDIA ON STEREOTYPES In Week 1, you considered constructionism, which suggests that political, legal, and economic social processes influence perceptions of race

Psychology Assignment

Please follow instructions no Chatgpts or AI . Please Due Sunday by 10:59pm Points 95 Submitting a text entry box or a file upload Attempts 0 Allowed Attempts 2 Start Assignment  Back to Week at a Glance ( OBJECT RECOGNITION This week’s Assignment focuses on how we recognize and

Psychology Assignment

Please no Ai Due Sunday by 10:59pm Points 95 Submitting a text entry box or a file upload Attempts 0 Allowed Attempts 2 Start Assignment  Back to Week at a Glance ( BEHAVIORAL AND PSYCHOPHYSIOLOGICAL STUDY TECHNIQUES Think about how you might watch or measure someone’s behavior to learn

topic 3

licensing board questions in the state of Florida Class, Do you know the name of your state licensing board? Provide the name, along with a link to their website. Do you know which test your state requires for associate licensure? Do you know how many practicum hours are required, in

Psychology Assignment

Please follow instructions and no AI generated  INTRODUCTION TO COGNITIVE PSYCHOLOGY Welcome to your first exploration of cognitive psychology – the study of how we think, learn, remember, and make decisions. Emerging in the mid-20th century as a response to behaviorism, cognitive psychology shifted the focus toward internal mental processes,

Making Tough Decisions

For this assignment, you will compare/contrast two controversial topics in lifespan development.  For the first one, your patient is a 43-year-old female. She is 4 months pregnant for the first time, and she never expected to get pregnant as she believed herself to be infertile. She has enjoyed 2 glasses

Topic 1 DQ 2 Response

Topic 1 DQ 2 Response to Josiah Mastriano Humanity has a diverse set of worldviews: from atheistic, to polytheistic, to monotheistic. These differences in perspectives narrow even further into cultural diversity, which is something that should be celebrated as a clinical mental health counselor (GCU, 2025a). However, a student needs

DQ1 Response

DQ1 Response to peer Katie Mayorga  My selected video was over navigating. I found this video provided a decent amount of overview into properly navigating the LMS, including class calendar, discussion boards, the syllabus, just to name a few. I found it particularly useful to learn that I can view

Topic 1 DQ 3

Assessment Description Throughout the counseling program, you will be using Zoom to demonstrate counseling skills and attend synchronous components. Please review the two Class Resources “GCU Zoom Resources: Counseling and Social Work” and “Zoom Access” to answer this discussion question. What concerns do you have using Zoom in your counseling

DE Week 4 Discussion

As our homes, cities, and vehicles become more digitally connected, they generate vast amounts of data that can serve as digital evidence. The evolution of smart technology impacts digital forensics and investigations. For this discussion consider how automated systems in our living spaces, urban environments, and transportation networks create digital

Psychology Homework

Week 7 Assignment: Decision Making Analysis Paper 1. Create a one-paragraph hypothetical scenario that illustrates one of the following types of dilemmas or challenges. ● A moral dilemma (e.g., deciding whether to report a coworker for unethical behavior) ● A practical problem (e.g., choosing between job offers with different benefits)

Psychology

Write as a freshman in college Week 7 Assignment: Decision-Making Analysis Paper Points 50 Submitting a text entry box or a file upload Available 1. Create a one-paragraph hypothetical scenario that illustrates one of the following types of dilemmas or challenges. ● A moral dilemma (e.g., deciding whether to report