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

psych week 5 Nicole

Main Post (due Thursday, February 19, by 11:59 PM):  My country is Columbia Refer to the conformity and social norms section starting on p. 533 in your textbook. Then review the following two articles in Psychology Today: How Cultures Make People Conform & Social Conformity and Group Pressure 1. What

Psychology

See attached. Preparation Choose one of the following myths: · Bad parenting causes psychological disorders. Focus on anxiety disorders or schizophrenia. · Depression is caused by personal weakness. Focus on major depressive disorder or bipolar disorders. · Electroconvulsive shock therapy (ECT) is cruel or barbaric. Focus on major depressive disorder

Week 6

Can someone help me complete this? Instructions Week 6: CBT a. Discuss Aaron Beck’s cognitive therapy. What are the basic principles and goals of this form of therapy? b. Discuss the concept of a “collaborative relationship” in the CBT model. c. Discuss the application of exposure therapy for anxiety disorders.

Communication Theory

see attachment Assignment: Exercise (Include Video) Within this activity, we intend to exercise your understanding of the theoretical-methodological aspects of communication in organizations, studied in the module… It represents the opportunity to demonstrate your mastery of said contents.  Make a video and upload it to the Canvas platform. (for more details

Psychology

See attached. 5-7 pages Assessment #2: Preparation Choose one of the following controversial statements: · Obesity is caused by a lack of willpower. · There are large differences between men and women’s cognitive ability. · Only women should compete in women’s sports. · Topic of your choice related to the

Mod 6 Diversity

see attached “Diversity in Addressing Family Violences” You will submit a presentation 8-10 slides OR a brief video on a topic of interest to you that relates to your career (but not about the career as a topic) with visuals that cover the following: 1. Title  2. Introduction to your

Article Review

Article Review This file is too large to display.View in new window

KH-7

DB Question:  Termination of treatment can be tricky. Oftentimes, clients are not ready to discontinue treatment believing they require continued support. Under what conditions should treatment be discontinued? How should this be done? What are some of the ethical issues associated with the end of treatment? What would be the

Psychology

Please see attached. 1-3 pages. Select one brain structure from the list below to focus on in your teaching aid: · Broca’s area. · Wernicke’s area. · Thalamus. · Hypothalamus. · Pons. · Reticular formation. · Cerebellum. Develop a teaching aid to explain to a 10-year-old child the way the

Meg 5

Imagine that you are the mental health provider (e.g., counselor, psychologist, psychiatrist) who is presenting a case to your colleagues. Choose one of the four cases and provide the requested information. Remember to include at least one professional reference in addition to the DSM-5-TR (2022). Using the DSM-5-TR (2022) is

psych

Chapter 4 Assignment Case Study: The Five I’s of Microbiology in Action Introduction: Microbiology plays a critical role in understanding and controlling the spread of infectious diseases. The Five I’s – Inoculation, Incubation, Isolation, Inspection, and Identification – are fundamental steps in the study and identification of microorganisms. In this case

Help Needed

See attachment ANSWER THE QUESTIONS USING THE FOLLOWING TEXTBOOK AND PLEASE NUMER EACH ANSWER TO CORRESPOND WITH THE QUESTIONS: Reference Patton, L.D., Renn, K. A., Guido, F.M., and Quaye, S.T. (2016). Development of students in college: Theory, research, practice (3rd ed.). Jossey-Bass. ISBN: 978-1-118-82181-7 1.  From Chapter 10, what attitudes

FIVE

What are the essential elements of a contract? Do you believe that a scholarship between a student-athlete and a college or university constitutes a contract? If so, do you believe both parties have equal bargaining power in this situation? Why do you think we see so many problems with sport

Developmental psychology

This assignment is the development of a Literature Review. All students are required to write a literature review paper on a topic approved by the instructor. The paper MUST be typed, in APA 7 format, and be 7 – 10 pages in length with no fewer than 10 references. The

Art review 2

Article review #2. This can be an article of your choice from any research data base. You are free to select any article related to the subject matter of this course. Please adhere to all of the guidelines below. A detailed description of what is expected is listed here for

Biopsychosocial Spiritual Assessment

Can I get help with this assignment? SOWK 550 Genogram Example Key: Pope, N.D. & Lee, J. (2017). A Picture is worth a thousand words. The New Social Worker 113(1), 117-143.  image1.png

Week 5

Can someone please help me compete this Instructions Week 5: Person-Centered Approach a. Discuss the primary defining features of the person-centered approach. to define the concept of unconditional positive regard. b. What is the view of human nature from the person-centered approach? c. Describe the purpose and methods of motivational

Week 5

Can someone help me complete this? Instructions Week 5: Person-Centered Approach a. Discuss the primary defining features of the person-centered approach. to define the concept of unconditional positive regard. b. What is the view of human nature from the person-centered approach? c. Describe the purpose and methods of motivational interviewing.