Find the value of the linear correlation coefficient r. The paired data below consist of the costs of advertising (in thousands of dollars) and the number of products sold (in thousands). Cost 9 2 3 4 2 5 9 10 Number 85 52 55 68 67 86 83 73

Respuesta :

Answer:

0.708

Step-by-step explanation:

The calculation of linear correlation coefficient r is shown below:-

Cost        Number

9                 85

2                 52

3                  55

4                  68

2                  67

5                  86

9                  83

10                 73

linear correlation coefficient r = 0.70772136

or

= 0.708

For better understanding find the spreadsheet at attached and follow some steps to reach the answer

Step 1 Put the values of cost and number

Step 2

Step 2 Go to data, select data analysis now click on Correlation and click ok

Step 3 Select the range from A2 to B9

Step 4 Then click OK to get the result

Ver imagen andromache
Ver imagen andromache

The value of the linear correlation coefficient, r, as calculated using Microsoft excel is: 0.708.

(See image attached below)

How to find the Linear Correlation Coefficient, r, using Excel Spreadsheet

  • Step 1: Open Microsoft excel spreadsheet
  • Step 2: Enter the cost of advertising on one column, and the number of products sold on another column.
  • Step 3: Select a blank cell and input the formula: =CORREL(B3:B10, C3:C10)
  • Step 4: Press "enter" to get the value of the linear correlation coefficient.

Therefore, the value of the linear correlation coefficient, r, as calculated using Microsoft excel is: 0.708.

(See image attached below)

Learn more about linear correlation coefficient on:

https://brainly.com/question/17062103

Ver imagen akposevictor