Complete the problems below and submit your work in one Word document. Be sure to show all of your work and clearly label all calculations. Calculations completed in Excel must be copied and pasted...

Complete the problems below and submit your work in one Word document. Be sure to show all of your work and clearly label all calculations. Calculations completed in Excel must be copied and pasted into a single Word document. No Excel documents will be graded. Problem 1The performances of a group of interns are evaluated by their supervisors at the end of their internships. Their scores are: 55, 47, 62, 27, 50, 49, 66, 53, 50, 44, 63, 59. Complete the calculations below using this data. Show all of your work and clearly label each of your calculations. the mean the median the range the standard deviation the variance Problem 2The Anxiety General Stress Test (ANGST) has been designed to gauge the level of psychological stress management trainees experience when they are under pressure. For a random sample of trainees the scores are as follows: 47, 49, 53, 53, 54, 58, 61, 64, 75, 81.Complete the calculations below using this data. Show all of your work and clearly label each of your calculations. What is the z score equivalent of ANGST = 81? What is the probability that someone selected at random will score 81 or lower? What percentage of all trainees will score between 60 and 75? Copy and paste your calculations for the three problems from Excel to Word and submit one Word document with your clearly labeled calculations and interpretations.