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

AQR&A Discussion Week 4

This week’s readings discuss conditional probabilities, conditional odds, logits, odds ratios, relative risk, and slopes. These can all be confusing terms but the good news is that all these values have some relationship to each other. Researchers have their own opinions on which values makes the most sense to report. 

AQR&A Assignment Week 4

To prepare for this Assignment: Review the datasets provided. Construct a research question based on one of those datasets. Use one independent variable and one dependent variable to conduct your simple logistic regression analysis. Remember that your dependent variable must be dichotomous/binary. Think about how you might use the odds

Work Psychology -Leadership, Engagement and Motivation

Case study with at least 25-30 references 7 3. ASSESSMENT Assessment Briefing – 2024/25 Module Code and Module Name MPSY4181 Leadership, Engagement and Motivation Assessment Type and Weighting Case Study Deadline or Assessment Period 20th March, 2025 Word Limit 3,000 words Assessment Description Waltham’s is a leading retailer specialising in

feed back lien

  Nice work presenting the four scales of measurement. Why is it that despite ratio scale being at the highest level of information, is not commonly achieved in research? According to Kline et al. (2005), research aims for interval scale but achieves ordinal level. If I am interested in measuring

Discussion Board

 There are both supporters of and critics of managed care, and the research has been mixed. Discuss at least two pros and cons of managed care. 

discussion board

 Contact a child welfare social worker and interview them about their experiences in their field of practice.  Include these areas in your interview: cultural factors in assessment; legal and policy implications and challenges in practice; and ethical considerations in practice.  Your initial posting should summarize the key points from your

6070-4d

  Post a potential solution to the ethical scenario that draws on ethical leadership and the NASW Code of Ethics. Provide justification for your choices using a specific NASW ethical standard. Additionally, explain the type of power you would utilize in achieving the solution.  (scenario) You have been told that the

Detailed

See attachment Assignment Questions: “What do individuals need to do to be prepared economically for their older years?” · Identify the age that you are starting from and how long this individual will be able to plan for retirement, etc. · Be specific in your responses. Utilize information available on-line,

psych 421

Chapter 5 – Artificially Modeling the mind (200 words) Hello; for this week, please, read chapter 5 and answer the following questions: 1. How do artificial neural network models work alongside neuroscientific techniques to help us study the brain? What do they add to our understanding? 2. Why do you think

feed back prof

 his is a good start but there are some areas that need more detail. I’m going to focus on self-esteem. You mention how others define self-esteem but I’d like you to discuss difficulties in defining self-esteem. Also, how would you define self-esteem after looking at Rosenberg’s scale and others? Do

Discussion

· Discussion 1 · · · Should Russ Saffold intervene to help his team handle this crisis? If so, what type of leadership action should he take, and why? · What leadership actions, if any, should team members take? · What should Russ Saffold do, if anything, to mitigate the

Psychology Can someone help me with my critical thinking homework?

Open Quick Links Quick Links Page Landmarks Content Outline Keyboard Shortcuts Current Location SP25MI Critical Thinking (PHI-300-B) Course Content Week 9 – Conflict Resolution Menu Management Options Course Menu: SP25MI Critical Thinking (PHI-300-B) Getting Started Home Start Here Course Information My Course Annoucements Course Content My Grades Email Collaborate Technical

Psychology Can someone help me with my critical thinking homework?

Open Quick Links Quick Links Page Landmarks Content Outline Keyboard Shortcuts Current Location SP25MI Critical Thinking (PHI-300-B) Course Content Week 9 – Conflict Resolution Menu Management Options Course Menu: SP25MI Critical Thinking (PHI-300-B) Getting Started Home Start Here Course Information My Course Annoucements Course Content My Grades Email Collaborate Technical

world cultures

see attachment  Introduction After the death of Alexander in 323 B.C.E, his empire was divided among his generals. For the next few hundred years the Greek culture settled in the customs of the people it had invaded through Alexander. However, while this was happening the Roman people were starting to

world cultures

see attachment  I nstructions: 1. Look up the consequences of Julius Caesar’s assassination. 2. Come up with a scenario in which Caesar wouldn’t have been assassinated. 3. Think three possibilities of your own and explain why you think those. 4. Submit your assignment in Word and in the space provided

english

see attachment  CRAAP Test: Is Your Source Worthy of Inclusion in Your Essay Research? If you want to succeed at your assignments or research, you should only use quality information. Use the following criteria, also known as the  CRAAP Test, to evaluate any information source critically. Video: Evaluating SourcesLinks to

english

see attachment  CRAAP Test: Is Your Source Worthy of Inclusion in Your Essay Research? If you want to succeed at your assignments or research, you should only use quality information. Use the following criteria, also known as the  CRAAP Test, to evaluate any information source critically. Video: Evaluating SourcesLinks to

english

see attachment  Discussion Etiquette Guidelines: 1. Think and edit before you post. 2. DON’T SHOUT: TYPING IN ALL CAPS IS AGGRESSIVE.  3. Participate, but don’t dominate. 4. Cite your sources. · Imagine sending as a text message one of these guidelines to the main character in a movie who reacted