Question: 1) Use Excel's Data Analysis function to determine the correlation coefficient - Under Data, select Data Analysis, and then select Correlation - Under Input Range,

1) Use Excel's Data Analysis function to determine the correlation coefficient - Under Data, select Data Analysis, and then select Correlation - Under Input Range, highlight the B and C columns and then check 'Labels in first row' - Under Output Range, select the column in blue below - Hit Enter Correlation Coefficient : Q2 Q6 Q2 1 Q6 -0.075211679 1 2) Use the correlation coefficient to determine the direction of the relationship Direction: negative 3) Refer to your text book and, using the correlation coefficient, determine the strength of the relationship Strength: very weak 4) Write a descriptive and conclusionary paragraph about the correlation between the independent and dependent variable.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

You are a statistician contracted to sample and analyze weights of the 5 lb bags of coffee. You collect the following data: 5.84 5.00 4.48 5.14 5.78 3.98 6.16 6.02 5.52 4.56 4.33 5.63 5.27 4.25 5.43...

Using excell spreadsheet: 5.84 5.00 4.48 5.14 5.78 3.98 6.16 6.02 5.52 4.56 4.33 5.63 5.27 4.25 5.43 5.78 4.57 5.03 4.60 5.00 5.82 4.23 5.86 5.22 4.89 5.33 5.53 4.72 5.07 5.60 5.05 5.35 4.28 5.64...

STAT_6A_Practice Score: 3.8/14 4/7 answered Question 5 Have you ever wondered what factors make it easier for some cats to be more successful in catching prey? Scientists Michelle Harris and Karen...

Calculate the t statistics using formula, with r value calculated in part c)(round to 3 decimal places).ii.Use Excel to find the critical value (round to 3 decimal places) and state the degree of...

Please help solve the below problems. Response 1: Use the TI calculator LinReg command to find the correlation coefficient for a classmate's data set and explain what it tells us about the line of...

answer it please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/Ea6JKeTr8SFHt2qszPDUavcBHxD6zFZUCXvCFivFNs4Kuw?e=h6i4EF 5 Write a formula in the yellow cell...

https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/Ea6JKeTr8SFHt2qszPDUavcBHxD6zFZUCXvCFivFNs4Kuw?e=Tedkm4 5 Write a formula in the yellow cell immediately be ow that...

Could you please help me with this lab TA signature \& TA initials on any changes made to the data are required or the data is invalid. Record the concentration of the provided crystal violet...

Security Valuation Project Due date: April 30,2018 1. Go to and enter the ticker symbol for Intel Corporation (stock symbol: INTC) in the box just below the Home and Investing tabs. After clicking...

Which (if any) of the functions could be linear or exponential? Find formulas for those functions. g(x) = h(x) = X -2 -1 0 1 2 1 f(x) g(x) h(x) 26 16 8 23 24 12 20 36 17 54 14 81 15 18 17 Neither...

In Problems 1-6, find the least squares line. Graph the data and the least squares line. y2332 x1234

Care One is a well-known medical practice that serves a rural community that does not have a hospital. The physicians must admit patients to a hospital in the next town that is 30 miles away. Dr....

You have been asked to determine the amount available for the unsecured claims, calculate the cents on the dollar that the unsecured creditors are estimated to get, and calculate the estimated...