DATA

3. (4 points) Consider given data file (data.xlsx) and answer questions below. a- Use MSExcel and create a scatter plot from points. Points must be color coded using the label column. b- Can you come up with a line equation that separates two categories? Plot your line on the part a graph - What is the average and standard deviation of the first and the second columns? d- Are these two columns (features) are correlated? Justify your answer. F1 F2 Label -9.47 -1.65 0 1 -2.40 0.49 -1.14 0.04 1 1 1 0.59 1.75 0.99 1 1 0 0 0 -1.52 -3.07 2.05 -2.56 -0.48 -10.74 -11.16 -11.35 -0.14 1.30 -6.04 -1.12 0.75 -7.72 -10.38 -10.96 -10.84 1 1 -3.97 -1.22 -0.53 0.52 -1.81 -0.45 -2.66 1.55 -1.31 -0.47 -0.90 -2.87 -2.60 0 1 1 0 0 0 0 0 -9.72