Does the random paired data below show a linear correlation? x y 4 17.66 5 20.3 6 18.64 7 19.58 8 18.62 9 20.86 10 24.1 11 24.54 When in doubt, assume the original claim is "There is linear correlation." We will use significance level .05. P-value =        (round to four decimal places.)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 11PPS
icon
Related questions
Question

Does the random paired data below show a linear correlation?

x y
4 17.66
5 20.3
6 18.64
7 19.58
8 18.62
9 20.86
10 24.1
11 24.54

When in doubt, assume the original claim is "There is linear correlation."

We will use significance level .05.

P-value =        (round to four decimal places.)

Expert Solution
Step 1

State the hypotheses.

Statistics homework question answer, step 1, image 1

 

Use EXCEL to obtain the value correlation coefficient r:

EXCEL procedure:

  1. Go to EXCEL
  2. Go to Data>Data Analysis.
  3. Choose Correlation.
  4. Enter the range as $A$1:$B$9.
  5. Check the option Labels in First row.
  6. Click OK.

EXCEL output:

Statistics homework question answer, step 1, image 2

From the EXCEL output, the value of the correlation coefficient is 0.8348.

 

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Knowledge Booster
Non-parametric Tests
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill