Given the accompanying data, use Excel's function options to find the sample covariance and the sample correlation coeff
Posted: Sun Oct 03, 2021 12:44 pm
Given the accompanying data, use Excel's function options to find the sample covariance and the sample correlation coefficient. (Round your answers to 2 decimal places.) OOO AutoSave OFF Ch Click here for the Excel Data File Home Insert Draw >> Tell me Share 0 Comments A 三、 % Sample covariance Correlation coefficient Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number E8 X Vfx A B с D E F G H 1 1 х 2 26 3 20 4 4 53 6 25 7 13 8 30 9 28 10 12 11 5 12 5 13 1 14 28 y 96413 85859 38851 30846 43078 79588 138118 122792 66903 53097 46146 33339 110998 129450 83950 146507 159054 221086 13305 30867 15 23 16 21 17 28 18 25 19 30 20 22 21 16