Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Statistics

Need help with finding correlation coefficient. 

COMPETENCY ASSESSMENT
Introduction Assessment Rubric and Minimum Submission Requirements

This competency assessment assesses the following Outcome(s):

MM207M3: Determine the relationship between two variables.

GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English.

It is time to demonstrate what you have learned in this module! One of the concepts we covered in this module was the interpretation
and calculation of the relationship between any two variables. You will be required to calculate correlation coefficients. You will also be
required to interpret and compare relationships between pairs of variables using the associated correlation coefficients. You will be
required to create scatter plots and interpret scatter plots, such as whether the two variables in the scatter plot are related, the apparent
strength of the relationship, and whether the direction of the relationship is positive or negative. The assessment will also cover linear
regression. You will have to use regression equations for prediction and will have to understand and interpret such equations.
Throughout this module and on assessments, you are welcome to use Excel as you wish.

You will be completing the Competency Assessment in MyLab. You will be applying concepts from logic to answer the questions about
a variety of real life applications and situations.

Please note the following when completing the Competency Assessment:

The Competency Assessment must be completed in one sitting. You do not have the option to save and come back to finish the
assessment.
You have unlimited attempts to successfully complete the Competency Assessment.
The Competency Assessment will be manually scored by your instructor.
Within the Competency Assessment you will NOT find support resources, such as solved examples that were available in the
MyLab These support resources are not available in the Readiness or Competency Assessments.

Part 2
Excel is an excellent and powerful tool that can be used to investigate correlation and regression. For this assignment, complete the
following.

1. Choose any Excel dataset from Content > Course Resources. Include the name of the dataset. From that dataset, select any two
quantitative variables that you suspect will be related (such as age and height for example). What is the name of the dataset you
have chosen? Which two variables did you choose?

2. Next, using Excel, calculate the correlation coefficient (r value) between the two variables. Recall that the Excel “formula” for
correlation is “=CORREL”. What is the r value for the two variables that you have chosen? Is it positive or negative? Is it strong,
medium, or weak? Note that it is best to have an r value that is medium or strong. It is recommended that you try a few different
variables until you find two variables with an r value between .5 and 1 (or between -.5 and -1).

3. Next, use Excel to create a scatterplot for the two variables. You decide which variable will be dependent (y) and which will be
independent (x). On the scatterplot, include the “trendline” and the “equation for the line” using Excel options. Attach your
scatterplot to your post.

4. Finally, using the equation of the line that you generated above, substitute any reasonable value for x (your chosen independent
variable) and solve the equation for y (your chosen dependent variable). It is up to you to determine which of your two variables is x
and which is y. What prediction do you get? Show all of your work. In other words, type out the equation, substitute a value for x,
and show your solution for y.

5. Write 2 – 3 paragraphs that describe what your equation represents. Discuss which variable is the independent variable and which
is the dependent variable. Why do you think the dependent variable might “depend” on the independent variable? Explain how your
equation can be used to estimate values for the dependent variable. Finally, explain the difference between correlation and cause.
Give an example of two variables that are related, but are not causal. Your paragraphs should follow the conventions of Standard
English (correct grammar, punctuation, and spelling). Your writing should be well ordered, logical and unified, as well as original
and insightful. In addition to fulfilling the specifics of the Assignment, APA citation style* should be followed.

7/23/24, 10:18 AM
Page 1 of 2

You can find numerous APA resources in the Writing Center Writing Reference Library on the Research, Citation, and Plagiarism page
.

Submitting Your Assessment Part 2:
When you are ready to submit your Course Assessment Part 2, click on the Course Assessment Dropbox.

7/23/24, 10:18 AM
Page 2 of 2

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

I need help with discussion

1 Title Student name Faculty name Due date Question 1 Minimum: 2.71 Maximum: 4.25 Question 2 Quartile 1: 3.435 Quartile 2: 3.59 Quartile 3: 3.84 Question 3 Sample mean: 3.58 Median: 3.5900 Standard deviation: 0.310135 Question 4 Confidence Interval Lower Limit: 3.46653 Confidence Interval Upper Limit: 3.6981 Question 5 Null

Linear Algebra I

1.(10 points) Given the following system of linear equations 4 3 14 16 4 2 7 8 2 3 2 3 2 1 3 2 1 = + = + + = + + x x x x x x x x (a) Solve the following system of equations by

Mathematics – Algebra Assignment

Instructor: Student: _________________________________ Instructor: Dr. Freddy Suarez Instructor: Dr. Freddy Suarez Instructor: Dr. Freddy Suarez Instructor: Dr. Freddy Suarez

Mathematics Numerical analysis homework

Create a Graph Chart Using software (Excel, Numbers, Google Sheets, etc.) to display the satisfaction level of the patients on the excel chart uploaded  create the Graph Chart correctly with the appropriate number of sectors, appropriate title, and percentage callouts.  also highlight the percentage to support the answer.  See attached

Displaying Data

Create a Pie Chart Using software (Excel, Numbers, Google Sheets, etc.) to display the satisfaction level of the patients on the excel chart uploaded  create the Pie Chart correctly with the appropriate number of sectors, appropriate title, and percentage callouts.  also highlight the percentage to support the answer. 

QUANTITATIVE MEDIATION & MODERATION ANALYSIS

One of the most advanced quantitative methods that can be applied to public administration data is mediation and moderation:  1)  What are the advantages of applying this analysis?  2) (a)How do an inadequate design, (b)a flawed analysis strategy, and (c)lack of attention to assumptions affect the use of mediation and

Practicing Graphing

My “practice work” is in the attached PDF  Graphing Module 6 – Correlation Using a program like Microsoft Excel, Google Charts, or an equivalent chart building program and the following data, correlate the following data. Your score will be graded on accuracy to the data and showing your work that

QUANTITATIVE MULTIPLE REGRESSION

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!! PADM 810 Quantitative Analysis Report: Structure of Assignments 1. Use the following structure for your research article: Abstract, Introduction, Literature Review/Theory, Methods, Results, Discussion, and Conclusion. Include a robust discussion section distinct from your conclusion. 2. Give your article a

statistics question for data set

You should think about guessing a value of the population mean (your null hypothesis) and using the sample mean in the data to invalidate your presumption.

Forum: DISCUSSION Post 3: Geometry

  A right triangle is removed from the rectangle in the figure below.  When the triangle is removed, it creates the shaded region.  Find the  area of the shaded region.   Part I – What is the area of the triangle (20%) Part II – What is the area of

I need help with discussion

MAT210 – Week 3 Assignment Template Week 3 Assignment – The Foundation of Data-Driven Decisions Name: [Add your name] Professor Name: [Add your professor’s name] Date: [Add the Date Submitted] You would like to determine whether eating before bed influences sleep patterns. List each of the seven steps for conducting

Project 5

14 questions with multiple parts. Bid price will be stay as listed MGF2106 – Project 5 Directions: This project contains multiple parts, and each part of the project contains several questions. Answer each question to the best of your ability. Record your answer for each question in the proper format

METHODS ABSTRACT PART TWO

Abstract Assignment Grading Rubric (40 points possible) Title Page – 1 Point (Must have PERFECT APA formatting!) Part One – Submit answers to questions posted on Canvas (16 points total). Part Two – Abstract (2 points each item, or 16 points total) a. Include the word “Abstract” at the top