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

Discussion Board

 Respond to the following: Research and discuss basic Prevention Theories and their importance to social work practice. Prevention vs Intervention.  

Discussion Board

   1. A summary of the education and practice experience of the social worker. 2. Tips for building expertise in that area of specialized practice. 3. Discussion of one ethical dilemma that social worker has faced in practice and how they resolved the dilemma. 4. How the social worker addresses

Wk 1-D

  Read this 2013 Forbes Magazine articleLinks to an external site. on the definition of leadership.  With the above article in mind, and after having heard the Chancellor and Dr. Kline speak about leadership and reading all of the different leadership concepts, think about the following questions: Do you agree

PSY 5130 Week 1 Discussion Board

See attached Early Childhood Physical Development The sensory system of the young child develops early in life. Watch the video clips Inside the Living Body and review Chapters 3, 4, 5.5, 5.6, and 5.7 in the course textbook. · Discuss the way in which the various sensory systems develop and

2-2 CAPSTONE

Reading and Resources1.html Required Resources Article:  Learn How to Make a Mind Map to Enhance Productivity This article provides an introduction to the use of mind maps. Article:  Creating Logical Flow When Writing Scientific Articles This article suggests organizing ideas in a logical progression. Article:  How to Write a Psychology

2-2 CHILD

2-2 Journal: Treatment vs. Intervention Consider the readings and resources which have been identified as relevant to this journal assignment and look at the differences between medicinal treatment and psychological interventions for ADHD treatment. Supplement with any additional resources you find in your research on this topic. Which path would

2-1 CHILD

2-1 Discussion: ADD/ADHD and the Classroom Review the readings and resources from this module and address the following: In your post, discuss your thoughts on working with children or adolescents with ADHD in the classroom setting. Should teachers be trained to work with these students in a different manner compared

Psychosis in Children

Research in recent years has emerged to support early diagnosis of psychotic disorders in young children and adolescents. Discuss how a definitive diagnosis can be made in young children, and adolescence, and considerations in treatment (pharmacological and non-pharmacological). Support your statements with a minimum of two scholarly articles (less than

WK 7 Discussion Personality Theory

 Choose at least two (2) different theoretical perspectives that have been covered in this course and discuss how the cultural, societal, and historical contexts within which the theories are derived have influenced their major tenets and framework.    Kelland, M. (2017, July 07). Personality Theory. OER Commons. Retrieved October 15, 2024, from  

general psychology

see attachment  HI to all the classmates and to the professor, My name is Miguel Quintana I am 25 years old. I was born in Cuba. I moved to the United States when I was five years old with my parents and both of my sisters, looking for a better

general psychology

see attachment Memory and Cognition View the PowerPoint slides that accompany this lecture: Memory and Cognition PPT Download Memory and Cognition PPT Memory and Cognition PDF Download Memory and Cognition PDF   Read Sanderson, C. A., & Huffman, K. (2019).  Real world psychology (3rd ed.). Wiley. ISBN-13: 978-1119577751  to an external

college algebra

see attachment   Module 1: Functions Discussion Instructions: Please review  the class discussion directions . They tell you how to prepare and reflect before responding to the prompt below. They also include detailed guidelines on how you must react to classmates and then reply to the responses you receive. Please pay

Social Development5

Prosocial and Altruistic Behavior Chapter 11 offers ideas about the development of prosocial and altruistic behavior, beginning in infancy. Four determinants of prosocial development are discussed: biological influences, environmental influences, cultural influences, and the empathy/perspective taking that is facilitated by maturation.   Find a recent news story about someone who

Social Development6

Causes of Aggression Chapter 12 discusses two broad influences on the development of aggression — biological origins, social influences, and combined biological/social influences (e.g., the interaction of genes and environmental triggers). Find a recent news story in which someone was aggressive and/or antisocial, harming others. Briefly state the facts of

Social Development4

Social Influences on Gender Typing As discussed in the textbook Chapter 10, most cultures emphasize different characteristics as valued and important for boys/men and girls/women. They also differ in how flexible these expectations are, and how accepting they are of norm violations. How were you socialized with respect to norms

Psy 5130 Week 1 Journal

See attached Prenatal Development With the evolution of Google, accessible information, the study of genetics, prenatal tests, social media, and many other sources of information for new parents, the process of preparing for a healthy baby can be overwhelming. For this first journal assignment, reflect on the substance and theoretical

Abnormal Psychology help

Include different classification systems such as DSM5 and ICD10 and how it’d be better and easier if classification systems were universal