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


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
