A. Calculate the sample correlation coefficient and interpret rxy using data in excel file and information in screenshots

B. Specify the competing hypothesis

C. Calculate the test statistic and find the p value

D. At the 5% significance level, what is the conclusion of the test?

1 Ch14_Q09_V16_Data File Q . Search Sheet Home Insert Page Layout Formulas Data Review View X Cut Calibri (Body) * 11 . A- A- Wrap Text General 141 2 AutoSum AP. Copy Fill Paste Format Merge & Center $ % 2 00 .0 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter D6 X V fx A B C D E F G H J K L M N O P Q Property Taxes Size 21811 2427 17418 2482 18295 182 15658 1048 13937 5663 33642 2562 15298 2280 16722 1996 10 18233 2085 11 16727 1359 12 15194 1394 13 36019 3080 14 31063 2900 15 42199 3339 16 14378 1541 17 38971 1026 18 25399 4052 19 22909 2488 20 16104 3544 21 29218 281 22 23 24 25 26 27 28 29 30 31 Property_Taxes Sheet2 Sheet3 + Ready + 141%Students Home x Topic: Week 6 Discussion Boar x Connect X Business Statistics Quiz 12.pdf x New Tab X + > C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activit... * K Error ii: Apps ye Swimsuit Sale: Sw. @ > How To Hold Th... b New In | The hotte. Chiffon Ruched St.. Clothing - Dresse.. LookBookStore -.. A Women's Maxi Dr.. f Clothing New Arri... Week 6 Homework - Chapter 14 Saved Help Save & Exit Submit Check my work A realtor studies the relationship between the size of a house (in square feet) and the property taxes (in $) owed by the owner. The table below shows a portion of the data for 20 homes in a suburb 60 miles outside of New York City. [You may find it useful to reference the t table.] 20 property points Taxes Size 21, 811 2,427 17, 418 2, 482 eBook 29,218 2, 812 Print References Click here for the Excel Data File a-1. Calculate the sample correlation coefficient xy. (Round intermediate calculations to at least 4 decimal places and final answers to 4 decimal places.) Sample correlation coefficient a-2. Interpret (xy- O The correlation coefficient indicates a positive linear relationship. O The correlation coefficient indicates a negative linear relationship. The correlation coefficient indicates no linear relationship. Mc Graw Students Home x Topic: Week 6 Discussion Boar x Connect X Business Statistics Quiz 12.pdf x New Tab X + > C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activit... * K Error ii: Apps e Swimsuit Sale: Sw. @ > How To Hold Th... b New In | The hotte. Chiffon Ruched St.. Clothing - Dresse.. LookBookStore -. Women's Maxi Dr.. f Clothing New Arri. Week 6 Homework - Chapter 14 Saved Help Save & Exit Submit Check my work b. Specify the competing hypotheses in order to determine whether the population correlation coefficient between the size of a house and property taxes differs from zero. 20 points OH0: 0xy = 0; HA: 0xy * 0 OH0: Oxy 2 0; HA: exy 0 Print c-1. Calculate the value of the test statistic. (Round intermediate calculations to at least 4 decimal places and final answer to 3 References decimal places.) Test statistic c-2. Find the p-value. O p-value Students Home x Topic: Week 6 Discussion Boar x Connect X Business Statistics Quiz 12.pdf x New Tab X + > C D A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activit... * K Error ii: Apps ye Swimsuit Sale: Sw.. @ > How To Hold Th... b New In | The hotte. Chiffon Ruched St... Clothing - Dresse... LookBookStore -... Women's Maxi Dr. f Clothing New Arri.. Week 6 Homework - Chapter 14 Saved Help Save & Exit Submit Check my work c-1. Calculate the value of the test statistic. (Round intermediate calculations to at least 4 decimal places and final answer to 3 decimal places.) 20 points Test statistic eBook Print References c-2. Find the p-value. O p-value