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

Nikki Intropersonal Module 4

Nikki Journal Assignment 3 (Intropersonal Comm) Part A Be sure to use MLA format and double space. Choose only one of the questions below, discuss in detail and be sure to provide your real-life examples to support your views.  You must include at least two concepts or terms from Module 4

Psych (Nikki)

Psych Module 4 Part A Main Post (due Saturday, February 7, by 11:59 PM) Assigned Country is Columbia Read the section in your textbook discussing the various ways culture impacts our memory on p. 282-285 and refer back to it for the following questions: (Note: the textbook and e-book pages

Earl Interpersonal

Part A Journal Assignment Comp 120 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 listed below; you may write about any concept

Psychology 16personalities & O*NET Interest Profiler Assignment

The purpose of this assignment is to familiarize students with using resources and technology to assist in career counseling and development. Students will take the 16personalities.com personality assessment, along with the O*NET Profiler assessment, and this assignment reflecting upon that information. See attachment.

Comprehensive Career Assessment

 Create an assessment battery for a hypothetical client seeking career counseling and guidance. Include the types of assessments you would use and the rationale for your choice of each assessment. You must use at least 3 quantitative assessments and 2 qualitative assessments (i.e., clinical interview, card sort, etc.). Each assessment

Meg 3

Create a school-based program to encourage girls to resist the messages they are exposed to every day that pressure them to be thin and to dislike their bodies. (2) Describe a follow-up procedure to measure the outcomes of your program, its degree of success.

psy (les wk 4)

PART A Read the section in your textbook discussing the various ways culture impacts our memory on p. 282-285 and refer back to it for the following questions: (There is no back, so answer_ (Note: the textbook and e-book pages do not line up. While in the e-book, the actual

Pschology

Can I have help with this question? Week 4 Paper a. Discuss the primary defining features of the Gestalt approach. b. Describe some of the core techniques in this form of therapy. c. What are the strengths and limitations of this approach Week 5 Paper a. Discuss the primary defining

PSYCH (C)

PART A Copy the below into Word to complete and paste the completed assignment into the grading module. Learning Objectives Test Yourself Answer these Learning Objective Questions to improve your retention of the concepts (McDaniel et al., 2009, 2015). 1. What is the place of consciousness in psychology’s history? 2.

AD stress critical thinking

Arionna STress Part A 1) Robert Epstein presents a model in the chapter that has has four trainable skill sets to use to manage stress.  Which of these skills do you do well?  Which of these skills do you need further development?  How do you know?  Be sure to give

Communication Theory

see attachment Exercise (Include Video) Instructions: With this activity, we intend to exercise your understanding and explanation possibilities of the contents of this module. It represents the opportunity to demonstrate your mastery of said content.  Make a video and upload it to the Canvas platform. (for more details click the following  guide

Communication Theory

see attachment Discussion: Identification of Examples Instructions: 1. With this activity, we intend to exercise your understanding and application possibilities of the contents of this module. It represents the opportunity to demonstrate mastery, not just theory, of this module.  2. Complete the table that is presented in the Forum that has

HW 4

Please be sure to upload the document with your answers in it. Double check your submission, accidentally submitting a blank assignment is not a valid excuse.  Please write your responses in a different color than black (any color is fine!).

Cultural Immersion Project

This is my proposal. Review the attached documents for assignment details and the grading rubric for the actual assignment. See attachments. I have selected African American women ages 40–60 who are experiencing perimenopause and menopause as my cultural immersion group.  I chose this group because midlife African American women share

Psychology ABA 505- Assignment 2

ABA 505-Behavior Change Procedures Assignment 2 For this assignment, you will write a paper that presents a detailed analysis of the basic concepts of operant learning.  Please include these topics in your paper: 1. Basic Procedures, Principles, and Processes   a. Define the 4 basic types of consequences that can be used in consequence-based interventions and

Psychology ABA 505- Assignment 1

ABA 505 Behavior Change Procedures Assignment 1 For this assignment, you will describe how to use prompting and fading effectively in the two scenarios provided below. Be sure to include the answers to the following questions in the descriptions of your prompting and fading procedures.   Questions: 1. Decide how you

Communication Theory

see attachment  Discussion: Identification of Examples Instructions: 1. With this activity, we intend to exercise your understanding and application possibilities of the contents of this module. It represents the opportunity to demonstrate mastery, not just theory, of this module.  2. Complete the table that is presented in the Forum that has