'j [Zb pts.) 'l'he Excel Midterm Uata Hie 1n UH includes the total compensatlon (1n imJLIions) ot CEU's of 17C! large public companies and the investment returns in 2512. E. Find the descriptive measures of the two data sets and describe the shape of the data sets based on comparison of Mean and Median. Find the Coefficient of Variation for the two data sets and determine which set has higher variability. Find the histogram of the two sets. For Total Compensation use Bins {5,10,15, ..., 4D) and for Return use Bins (4G,3{},21],...., l,110,120). Describe the shapes based on histograms. Find the ratio of \"Returnffotai compensations\" in a new column. Based on this ratio, list top 5 corporations with highest ratio and 5 with lowest ratios. List 3 companies that you would invest in. Find the Coefficient of variation for Retin'nfTotal Comp. and compare with answers in part (b). What can you conclude? Construct scatter plot of Compensation (X) vs. Return (Y). Find best fitted linear line and R2. Is CED compensation a good indicator of corporate performance? Explain