Q1. Compute the mean, median, and standard deviation for the three variables revenues, profits, and number of employees. Assume this data is defined as a population.
Q2. Convert the data for each variable to a z value. Consider Mellon Bank Corporation headquartered in Pittsburgh. How does it compare to the average bank in the study on the three variables? Discuss.
Q3. As you can see by examining the data and by looking at the statistics computed in part a, not all banks had the same revenue, same profit, or the same number of employees. Which variable had the greatest relative variation among the banks in the study?
Q4. Calculate a new variable: profits per employee. Develop a frequency distribution and a histogram for this new variable. Also compute the mean, median, and standard deviation for the new variable. Write a short report that describes the profits per employee for the banks.
Q5. Referring to Question 4, how many banks had a profit-per-employee ratio that exceeded 2 standard deviations from the mean?
Attachment:- Assignment.rar