Question

The accompanying table lists the word counts measured from men and women in 56 couple relationships. Construct a​ scatter plot, find the value of the linear correlation coefficient​ r, and find the​ P-value of r. Determine whether there is sufficient evidence to support a claim of linear correlation between the two variables. Use a significance level of a=0.05.

I need to understand how to solve this question using excel (not minitab)

Men   Women
27,295   20,108
18,158   24,942
7,305   7,533
25,723   18,914
28,347   14,595
5,442   17,399
24,114   9,330
20,390   20,843
27,841   15,109
22,647   20,464
9,196   13,474
9,165   12,332
12,756   17,794
19,710   23,009
16,815   7,196
7,152   18,213
19,557   25,208
10,835   18,055
21,368   18,701
19,763   16,066
18,811   28,045
17,781   10,791
9,960   16,414
8,083   2,891
28,137   12,482
11,845   17,384
14,083   12,564
10,104   19,608
15,295   19,499
16,287   11,547
14,066   34,988
11,350   9,503
20,545   12,446
16,307   10,441
13,333   27,713
16,319   22,519
12,829   18,739
10,838   20,824
18,842   19,473
9,070   15,613
15,123   18,951
7,076   10,283
17,576   15,247
11,222   14,402
18,463   29,143
16,214   36,757
16,783   24,757
36,658   32,773
15,013   24,955
46,847   30,273
23,027   19,752
11,918   9,947
13,067   22,361
10,370   14,630
4,655   14,751
22,499   28,956

The linear correlation coefficient r is _____. ​(Round to three decimal places as​ needed.)

The test statistic is _______. ​(Round to two decimal places as​ needed.)

The​ P-value is ______. ​(Round to three decimal places as​ needed.)

Because the​ P-value of the linear correlation coefficient is less than or equal to or greater than the significance​ level, there is or is not sufficient evidence to support the claim that there is a linear correlation between words spoken by men and women in couples.

Answer 1