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

MA 2025 MOD 1 ASSN

  Overview: For this assignment, you will utilize statistical technology to work with a series of datasets. You are welcome to use the technology of your choice including Excel, Desmos, and Google Sheets.  Please follow the instructions below. Once you have completed the assignment, submit your completed document (in .docx

MA 2025 MOD 1 DB

  Choose Your Topic: Select one of the ideas above or come up with your own topic that you feel represents an interesting aspect of your life. Collect Your Data: Gather the necessary data for your chosen topic. Make sure your data is accurate and relevant. Select a Graph Type:

Level Case 1 Wyatt

  Mr. Goldberg has been teaching a unit on fractions. He was pleased that all of his students seemed to quickly master adding and subtracting two fractions. However, when he began teaching the students how to multiply fractions, a small number of them did not readily learn the content. But

peritmetr

  whatsthe peritmter of this trapezoid EFGH the points are E(-2,2) F(5,2) G(2,-2) H(-2,-2)

can you write a data table for this data and complete it?

 Age Amount from previous year Amount Linda added from savings that year Amount invested for that year Interest rate for that year Amount at year end 22 998.01 500 1498.01 11.00% 1662.79 23 1662.79 600 11.25% 24 700 11.50% 25 800 11.75% 26 27 28 29 30 31 32 33

R studio

MthStat 568/768 �Multivariate Statistical Analysis �Spring 2025 Homework 5 Due Wednesday, April 9 1. Consider the spambase data set, where emails are classi�ed as spam or not, and 57 feature variables are measured on each of them (see full description on p. 259 of the book). (a) Split the data

math

You must post before seeing replies. Edit history will be available to instructors. Due Apr 14 20 points 6 Replies (6) Career based on Math Path View Split Screen All Search entries or author… Newest First Answer all parts to the prompt below.  Entire activity taken from Winning at Math

Stats project

10 slides total, I’ve already done 3 slides. Two of them need small corrections that have been suggested by Professor. 

Mathematics – Numerical analysis can you complete a math assignment

Assignment/Problem Set #3 (Correlation on Chapter 5) Students must provide answers to each question beneath the question. Students must show all work including all SPSS outputs and interpret the outputs. This means that you cannot submit only answers. All variables must be labeled, you can abbreviate the names of the

Math

Help Statistics: Exam 2 Name:_________________________________ Round final answers to the fourth and write as a probability (decimal) unless otherwise stated. Problem 1 1. You have the opportunity to play two games. Create a probability distribution (table) and compute the expected value for each game. Round to the second. o Game

Math

Need this asap Statistics: Exam 2 Name:_________________________________ Round final answers to the fourth and write as a probability (decimal) unless otherwise stated. Problem 1 1. You have the opportunity to play two games. Create a probability distribution (table) and compute the expected value for each game. Round to the second.

Mathematics Purchasing a Vehicle Assignment

  Part 1: Comparing New to Used  Purchasing a new vehicle can greatly affect your financial situation. You will gain a better understanding of the car-buying process and the components that affect your monthly payments. You will compare the costs of buying a new vehicle and a used vehicle in the same

Mathematics three assignments

here are three assignments needed soon MATH325 Lab 5 Using Microsoft Excel to conduct ANOVA procedures The steps required for completing the deliverables for this assignment, including screen shots that correspond to these instructions, are outlined below. Complete the questions below and paste the answers from Excel below each question

math

You must post before seeing replies. Edit history will be available to instructors. Due Mar 31 20 points 9 Replies (9) Studying Math is like… View Split Screen All Search entries or author… Newest First Read the following passage summarized from Winning at Math by Paul Nolting and then answer

SPSS

I need imputing some number in the spss program and generating the tables 

Categorical Statistics

Just need this done by someone who knows what they’re doing, this is for undergrad. I may have to defend/explain my project so explanations of what you did would help. Thanks