Q4. [9 marks] Use the variable Dodgers in the data set "MLBSalary.xlsx" (available on BrightSpace) and answer the following questions. a) Use Excel to produce a histogram. Use 5000, 10000, 15000, and 20000 as the upper class limits. Label the x-axis with "Salary ($)" and the chart title with "Histogram of Dodgers Salary". Attach a screenshot of the histogram. (Don't know how to set the upper class limits? Check out the Excel Manual available on BrightSpace.) [2.5] b) Use Excel to produce a box-and-whisker plot. Label the x-axis with "Salary ($)" and the chart title with "Boxplot of Dodgers Salary". Attach a screenshot of the boxplot. [1.5] c) Use Excel to calculate the mean, median, first quartile, third quartile, and standard deviation. Report their values. [1.5] d) Write out the five-number summary. [1.5] e) Determine if there is any outlier in the data. Make sure show all your calculation steps. [2] Player Phillies Dodgers Rays Red Sox 1 14250 19000 6000 14000 2 10000 15730 5375 13000 3 8583 15217 3898 12500 4 8000 14727 3785 10442 5 7958 10000 2875 10167 6 7786 9517 2750 9250 7 6350 9250 2400 8333 8 6000 9000 2300 8000 9 5500 8000 2250 6000 10 5000 7500 1600 5083 11 3250 7433 1275 4000 12 3000 2000 1000 3850 13 2400 1925 800 3000 14 1700 1115 417 3000 15 900 600 413 2000 16 900 500 412 1275 17 600 454 412 840 18 500 425 405 835 19 480 415 401 800 20 445 411 401 775 21 440 406 400 457 22 425 400 398 422 23 420 393 397 421 24 415 393 396 406 25 395 392 396 405 26 393 390 396 403 27 390 390 392 400 28 390 390 390 396