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

DQ

see attached Discussion Board #8: Informative Speech Organization Examples LAST WEEK:  You browsed through examples of informative presentations to get a sense of the presenter’s type of speech, subject choice, and purpose. Now, we’ll use the organizational information introduced during the PK presentations to build your understanding of how presentations

Yes or NO

see attached  Read Cluster 14 in your text as well as the cluster 14 power point. Then submit your typed response to the Homework assignment by the due date listed. Homework Yes or No Do you think homework should be assigned? Whether you say yes or no, provide an explanation

L&CP Week 3 Assignment

Instructions Respond to the following questions. What is the importance, if any, of officer intent and motive in the “objective standard of reasonable force” under the current state of the law? Contrast the definition of probable cause with that of reasonable suspicion. Complete the following questions: Compare and contrast Fourth

Controversial Treatments Chelation Therapy

  1 Controversial Treatments: Reflection Paper and Video Presentation Liadanay Velazquez Department of Social and Behavioral Sciences, Capella University PSY7710: Ethics in Applied Behavior Analysis Instructor Name Assignment Due Date Controversial Treatments: Reflection Paper and Video Presentation (Please note, all italicized writing in this template is for instructional purposes. You

psychology

PSYC 320 Behavior Modification Project: Baseline Phase Report Assignment Instructions Overview To assess your baseline as you begin the experiment, you need to observe your target behavior before you ever treat it or try to modify it – in other words do not change anything you do. Thus, you will

psych brain functioning (Les)

Module 3: Critical Thinking/Application Prompts     Instructions Each week, you will be presented with a series of critical thinking prompts and application prompts. Please copy/paste the prompts into an offline document (Word, for example) and compose your responses offline (be sure to save your work).  Then click on the “Submit

Psychology week two assignment

  Hi Barbara, Nice start with clear outcomes. As you draft Section 1 of your assignment, just remember to include some credible statistics describing the scope of the problem the program addresses.

Feedback keiland

       If the CHANCE program were highly successful, success would mean that adolescents who are survivors of human trafficking experience lasting emotional healing, safety, and self-sufficiency. Youth would show stronger self-worth, consistent school or job engagement, and the ability to form trusting relationships with supportive adults. Families and foster caregivers

psych wk 2 less

Main post (due Friday, November 7, by 11:59 PM):  leslie Please read the following information related to concussions and then answer the questions below: The brain sits in the cranium, surrounded by cerebral fluid. When a severe blow to the head occurs, the brain may collide with the cranium, then

Social Media

I need help understanding the paragraph format Overview In this assignment, you will write a 3–5 page paper on the effects of social media on the developing mind. Preparation Topic Selection Choose one of the following topics: · Internet use among elementary age children (ages 5–11). · Social media use

psychology

Behavior Modification Project: Research Paper Assignment Instructions Overview You will write a 4-6-page, current APA formatted, research paper that will aid you in the Behavior Modification Project. You should reference your textbook and at least 6 additional peer-reviewed empirical research journal articles. The research paper will include a title page,

assitant needed E Kenniqua

Shared Writing: Psychological Disorders One of your authors once attended a training session where the instructor shared that they did not believe in the DSM or in using diagnoses. This person believed that diagnoses were much like rumors in that they had the potential to lead toward specific beliefs and

Week 11

Post a brief description of the culture in which you immersed yourself. Next, explain how the Immersion Project assisted you in understanding and respecting other cultures in general and helped you further develop cultural humility.

Summary

Use the attachment to complete work.  Instructions: Answer the question in two paragraphs. In a social work perspective, also using community-based approaches or programs in the response. Use opinions, and facts and provide information regarding the diagnosis. Initial Post Prompt Question: How can social workers help Asian clients living with

assitant needed E Kenniqua

please see attachment 1 We have covered several areas of research that have prompted various levels of controversy, and for various reasons. You have read about the possible comorbidity of ADHD and bipolar disorders in children. You have also read about genetics research in psychological disorders. How might this knowledge impact your personal behavior

follow the instructions attached

Week 6 Assignment Start Assignment Due Sunday by 11:59pm Points 100 Submitting a file upload File Types docx, doc, and pdf Identify an event related to your chosen Hot Topic Module in which compassion was surprisingly shown or not shown. That is, choose an instance from current events or history

Prof Double R

 I NEED TWO PARAGRAPH For your initial post, review the videos A Class Divided and Social Development: Crash Course Sociology #13. Then respond to the following: Based on the content in “A Class Divided,” are children immune to the attitudes and behaviors of other group members? Explain. In what ways

L&CP Week 2 Assignment

Instructions Respond to the following questions. Does the use of a drug sniffing dog during a routine traffic stop violate the Fourth Amendment? Would the result be different if an individual had to be transported to a location where a drug sniffing dog was available? When does the Fourth Amendment