1.What is the Pearson correlation for the set of data attached in the Excel spreadsheet showing karat size and price of diamonds?What does the correlation coefficient say about the relationship of karat size and price?

Carat

0.3 0.3 0.3 0.3 0.31 0.31 0.31 0.31 0.31 0.31 0.32 0.32 0.33 0.33 0.34 0.34 0.34 0.34 0.34 0.34 0.35 0.35 0.35 0.35 0.36 0.36 0.37 0.37 0.4 0.4 0.41 0.43 0.45 0.46 0.48 0.5 0.5 0.5 0.5 0.5 0.51 0.51 0.52 0.52 0.52 0.52 0.53 0.53 0.53 0.53 0.54 0.54 0.55 0.55 0.55 0.56 0.56 0.57 0.59 0.6 0.62 0.63 0.64 0.66 0.7 0.7 0.7 0.7 0.71 0.71 0.71 0.71 0.72 0.8 0.82 0.84 0.85 0.86 0.89 0.9 0.5 0.5 0.51 0.55 0.56 0.57 0.6 0.63 0.7 0.7 0.7 0.7 0.7 0.7 0.71 0.71 0.71 0.72 0.72 0.73 0.73 0.73 0.73 0.73 0.74 0.74 0.75 0.75 0.75 0.76 0.77 0.78 0.8 0.83 0.9 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.02 1.02 1.02 1.03 1.04 1.04 1.05 1.06 1.06 1.07 1.1 0.18 0.18 0.18 0.18 0.18 0.18 0.19 0.19 0.19 0.19 0.19 0.19 0.19 0.19 0.2 0.2 0.2 0.2 0.21 0.21 0.21 0.21 0.22 0.23 0.23 0.23 0.24 0.25 0.25 0.25 0.25 0.26 0.26 0.26 0.26 0.27 0.27 0.28 0.29 0.29 0.3 0.3 0.3 0.3 0.3 0.31 0.31 0.31 0.32 0.33 0.34 0.34 0.35 0.35 0.4 0.41 0.41 0.47 0.48 0.5 0.51 0.51 0.52 0.55 0.56 0.56 0.58 0.58 0.58 0.7 0.7 0.71 0.76 0.78 1 1.01 1.01 1.01 0.5 0.5 0.51 0.52 0.52 0.53 0.53 0.55 0.56 0.56 0.57 0.57 0.58 0.6 0.6 0.6 0.61 0.62 0.64 0.65 0.66 0.7 0.7 0.7 0.7 0.7 0.71 0.71 0.72 0.73 0.73 0.74 0.8 0.8 0.8 0.8 0.8 0.81 0.81 0.81 0.81 0.81 0.82 0.82 0.85 0.85 0.85 0.86 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.01 1.02 1.06 1.02 1.09

Price ($US)

911.4 1057 1057 882 1148.7 1088.5 998.9 998.9 788.2 788.2 1027.6 841.4 928.9 768.6 1185.1 1085.7 987 888.3 921.2 855.4 1216.6 1115.1 1012.9 878.5 1144.5 1039.5 994 994 1337.7 1067.5 1369.2 1222.9 1100.4 2059.4 1772.4 2450.7 2450.7 2450.7 2305.1 2111.2 2496.9 2243.5 2443 2544.5 2544.5 2392.6 2744.7 2590.7 2436 2384.9 2636.9 2846.2 2896.6 2523.5 2470.3 2566.9 2024.4 2555.7 2641.1 3003.7 4091.5 3080.7 3331.3 3010 3857 3585.4 3585.4 2702.7 4116.7 3910.2 3635.1 3635.1 3684.1 3808.7 3463.6 3993.5 4763.5 4817.4 4696.3 4677.4 2450.7 2402.4 2695.7 2523.5 2730 2390.5 3003.7 4558.4 4060 4399.5 3585.4 3585.4 3585.4 3585.4 4460.4 4116.7 3635.1 4172.7 3963.4 4016.6 3521 3521 3308.9 2954.7 4070.5 3209.5 5157.6 3266.9 3048.5 6919.5 4843.3 3770.2 3382.4 5009.2 5376 10907.4 7993.3 7411.6 6829.9 9739.1 7411.6 7499.1 6636 6927.2 6733.3 6418.3 6442.1 6151.6 5666.5 5472.6 11205.6 7484.4 6897.1 7190.4 6701.1 6407.1 6211.1 6211.1 5918.5 5526.5 7260.4 6766.2 7063 7630 7399.7 6694.1 6146.7 6820.1 6511.4 6261.5 6752.2 576.1 535.5 562.1 562.1 493.5 507.5 676.9 735 676.9 604.1 560 589.4 560 530.6 616 616 493.5 446.6 643.3 804.3 739.9 643.3 838.6 873.6 802.9 696.5 775.6 1039.5 898.1 804.3 757.4 1077.3 955.5 882 784.7 1116.5 863.1 839.3 1029.7 866.6 1106 1021.3 1021.3 852.6 909.3 1139.6 1139.6 935.9 1023.4 1052.1 1241.1 1145.2 1274.7 1078 1593.2 1131.2 1054.2 1855.7 1668.1 2556.4 2605.4 2605.4 2166.5 2594.2 2849 2429 3381.7 2946.3 2674.7 3924.9 3728.2 4312 4266.5 4155.9 6539.4 6799.1 6211.1 5722.5 2644.6 2402.4 2695.7 2342.2 2191 2796.5 2590.7 2470.3 2566.9 2241.4 2279.2 2390.5 2654.4 2747.5 2394.7 2747.5 2531.2 2530.5 2649.5 2550.1 3010 4806.9 4399.5 4060 3857 3042.2 4460.4 3635.1 3963.4 3733.1 4228.7 4070.5 6027.7 4833.5 4833.5 4491.2 4235.7 6100.5 4891.6 4891.6 4546.5 5150.6 4600.4 4950.4 5851.3 4763.5 5397.7 4084.5 9642.5 9835.7 7993.3 7411.6 8187.2 7411.6 7315 6927.2 6442.1 6636 6345.5 6151.6 6151.6 5860.4 5666.5 5472.6 9736.3 8071.7 7484.4 8267.7 7190.4 6995.1 6505.1 6603.1 6407.1 6211.1 5722.5 7557.2 6923 6271.3 6374.9