Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[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

Order Now

Related Questions

Family and Marriage Therapy

 I need assistance with a reflection  · Weekly “Reflection” Papers – The purpose of this assignment is to reflect on the material in the readings by sharing your interpretation of a primary topic. You may relate it to a case that you have either worked with or a family experience

Family and Marriage Therapy

I need assistance with a reflection · Weekly “Reflection” Papers – The purpose of this assignment is to reflect on the material in the readings by sharing your interpretation of a primary topic. You may relate it to a case that you have either worked with or a family experience

Family and Marriage Therapy

I need help with a discussion question Discuss one of the patterns that develops in an addicted family that could be addressed in family therapy. *Each experience of grief is unique and complicated. Identify a loss that a family might experience and how family therapy could be helpful.

Family and Marriage Therapy

I need assistance with a discussion question There are many keys to effective therapy. One of the most basic is the need for an individual to use language. By encouraging individuals to route difficult or abstract challenges through the language center in various ways (individual dialogue, the empty chair, journaling,

Family and Marriage Therapy

  I need assistance with a reflection   · Weekly “Reflection” Papers – The purpose of this assignment is to reflect on the material in the readings by sharing your interpretation of a primary topic. You may relate it to a case that you have either worked with or a family experience

DLRL Week 8 Assignment

To prepare: Review the theoretical frameworks resources. Assignment: 1- or 2-page paper, not including title page or references page(s) Create an Overview of Relevant Theories document that contains the following information: Identify the theoretical framework in each article in your annotated bibliography. If not noted there, return to the article

AQR&A Week 8 Workshop

If you are collecting phone or face-to-face interviews, the audio recorder is the most important tool for ensuring accuracy in capturing the interview. In addition, you may or may not want to take notes during the interview. If you are conducting e-mail interviews, format your document using the following guidelines:

AQR&A Week 8 Assignment

The Final Project is a stepwise process, and its goal is to leave you well-prepared by the end of this course to execute on your qualitative research study plan. In Week 8, you will complete Step III of the Final Project. For Step III of the Final Project, you will

Discussion Response

I need a response to two discussion questions.  1. I believe strategic therapists dig down to the root of the problem. In my words, these therapists get to the meat of the matter. I appreciate the fact that this particular therapist is in place to assist the individual/family in need

Human Sexuality

see attachment  How External Influences Affect Our Sexual Development REMINDER:  All coursework is due by 11:59 PM Eastern on Saturday of this last Module. Introduction: In this forum, we will explore the profound impact that external influences have on our sexual development. Our discussion will focus on how various cultural

Interpersonal assign

Journal Assignment (I do not have the textbook, so answer as best you can) Be sure to use MLA format and double space. Choose only one of the questions below, discuss in detail and be sure to provide examples to support your views. You are not limited to the suggestions

Family and Marriage Therapy

I need assistance with a discussion question Experiential therapy is not a specific type of psychotherapy but covers therapeutic techniques that require engaging in some type of activity or action such as role playing, sculpting, rock climbing, or using props.  Experiential therapy encourages clients to delve into underlying issues – such

Sociology Principles

see attachment  Module 7:  Essay After reading the course materials, follow the instructions for the assignment and its submission: Submission Instructions: Write  an essay on the role of education in social mobility in Puerto Rico. · Use a word processor, such as Word, to complete the  Assignment. · Include bibliographic

Sociology Principles

see attachment  Module 7:  Conceptual Domain After reading the course materials, follow the instructions for the assignment and its submission: Submission Instructions: Develop a conceptual map on  sociological perspectives and social stratification systems. · Use a word processor, such as Word, to complete the  Assignment. · You can use an

Family and Marriage Therapy

 I need assistance with a reflection  · Weekly “Reflection” Papers – The purpose of this assignment is to reflect on the material in the readings by sharing your interpretation of a primary topic. You may relate it to a case that you have either worked with or a family experience

Family and Marriage Therapy

I need assistance with a discussion question Sometimes a family in crisis needs a more direct interaction from a helping professional. This is the role of the Strategic Therapist. The strategic therapist is somewhat of a “Drill Seargent” in the counseling environment. They do complete an initial assessment of the presenting

Week 8

Week 8 DisCUSsion 1: The Impact of Industrial Psychology in the Workplace In this Discussion, you will explore how specific principles, models, and/or theories related to selection, assessment, training, and performance evaluation have contributed to improvements in the practice of industrial psychology. Then, in your response to your peers, you

week 7 response

INSTRUCTION: Respond to the colleague below who discussed different theories than you did in one or more of the following ways: · Ask a probing question and provide insight into how you would answer your question and why. · Ask a probing question and provide the foundation, or rationale, for the