The data attached is for a sample of companies in specialty, food and staples, and multiline retailers. (Source: TDAmeritrade Stock Screener, accessed on 7/20/2020, data for Retail Apparel, Department, and Hyperstore industries)

1.Make an ungrouped frequency distribution for Price/Sales.use the frequency distribution to find the mean, median, mode and standard deviation for Price/Sales ratio. (Note the boldface - must show and describe steps for how you USED the frequency distribution to compute the statistics)

2.Organize the data for Profit Margin in a grouped frequency distribution using -20 to -15 as the class limits of the first class.Make a relative frequency histogram. Describe the shape of the histogram.Predict, from the shape of the histogram, whether the mean is greater than the median or vice-versa.Calculate the mean and the median.Was your prediction correct?<>

3.Organize the data for Return on Equity in classes beginning with the class limits of -150 to -126. Draw an ogive for this data.Use your ogive to estimate the median.Then, find the actual median using the original data.Did the ogive provide a good estimate of the median?(Ogive is a graph of percentiles- it associates cumulative relative frequency with UPPER class boundary for each class)

4.(a)Determine the proportion of the Market Cap data that lies within 1, 2, and 3 standard deviations of the mean.Determine, using the empirical rule, if the Market Cap data is approximately normally distributed.

(b)Determine the proportion of the Revenue Growth data that lies within 1, 2, and 3 standard deviations of the mean.Determine, using the empirical rule, if the Revenue Growth data is approximately normally distribution

5.Find the z-score for Kohl's for Profit Margin.Also, find the z-score for Kohl's for Price/Sales. Describe, in a few sentences, the meaning of these z-scores being as specific to this context as possible.