Description I provide the data, just need you to discuss and answer it.  Using the data provided, ...

---

Description I provide the data, just need you to discuss and answer it.  Using the data provided, calculate the following descriptive statistics: (You may use EXCEL to complete this work. Show all formulas and work in your answer). 1) mean, median, and mode 2) Range, Variance, and Standard Deviation 3) Calculate standard scores for each individual (z and t scores) . Discuss the distribution and identify characteristics of the distribution (e.g., is it a normal or skewed distribution - be sure to discus the why of your decision) in one paragraph. Write this paragraph using a scientific voice in the writing and use scientific notation. Look for outliers and unusual scores in the data. Write a paragraph or two discussing your findings and interpreting the data. Be sure to compare z or t scores and note significance in your comparisons.  UNFORMATTED ATTACHMENT PREVIEW Student Name Elizabeth John Phillip Juanita Chris Stephanie Kari Deon Antonio Douglas Andrea Joel Maureen Michael Emily Ben Latonya Maria Briana Bob Patricia Roberto Sam Sharon Martyn Adam Jennifer Jeffrey Rowena Matthew Midterm Exam Grade 92 86 68 88 77 64 82 79 85 62 72 86 89 94 82 79 82 71 87 57 66 88 78 74 93 82 99 61 85 97 Final Exam Grade M_X-XBAR 90 11.83 76 5.83 58 -12.17 87 7.83 77 -3.17 64 -16.17 72 1.83 68 -1.17 84 4.83 62 -18.17 66 -8.17 74 5.83 69 8.83 94 13.83 65 1.83 68 -1.17 46 1.83 71 -9.17 65 6.83 57 -23.17 65 -14.17 72 7.83 64 -2.17 65 -6.17 93 12.83 77 1.83 84 18.83 61 -19.17 55 4.83 89 16.83 Z 1.07 0.53 -1.10 0.71 -0.29 -1.46 0.17 -0.11 0.44 -1.64 -0.74 0.53 0.80 1.25 0.17 -0.11 0.17 -0.83 0.62 -2.09 -1.28 0.71 -0.20 -0.56 1.16 0.17 1.70 -1.73 0.44 1.52 T 60.68 55.26 39.02 57.07 47.14 35.41 51.65 48.94 54.36 33.60 42.63 55.26 57.97 62.48 51.65 48.94 51.65 41.72 56.16 29.09 37.21 57.07 48.04 44.43 61.58 51.65 66.99 32.70 54.36 65.19 Z T 65.73 53.97 38.86 63.21 54.81 43.90 50.61 47.25 60.69 42.22 45.58 52.29 48.09 69.08 44.74 47.25 28.78 49.77 44.74 38.02 44.74 50.61 43.90 44.74 68.25 54.81 60.69 41.38 36.34 64.89 1.57 0.40 -1.11 1.32 0.48 -0.61 0.06 -0.27 1.07 -0.78 -0.44 0.23 -0.19 1.91 -0.53 -0.27 -2.12 -0.02 -0.53 -1.20 -0.53 0.06 -0.61 -0.53 1.82 0.48 1.07 -0.86 -1.37 1.49 Bin 55 60 61 65 66 70 71 75 76 80 81 85 91 95 96 100 More Frequency 0 1 1 2 1 1 1 2 0 4 0 6 6 3 0 2 0 w333q Bin 55 60 61 65 66 70 71 75 76 80 81 85 91 95 96 100 More Histogram Frequency F_X-XBAR 18.73 4.73 -13.27 15.73 5.73 -7.27 0.73 -3.27 12.73 -9.27 -5.27 2.73 -2.27 22.73 -6.27 -3.27 -25.27 -0.27 -6.27 -14.27 -6.27 0.73 -7.27 -6.27 21.73 5.73 12.73 -10.27 -16.27 17.73 8 6 4 2 0 Frequency Bin Frequency 2 2 1 7 1 3 1 3 1 2 0 2 3 2 0 0 0 Midterm Exam Grade Final Exam Grade Mean 80.17 Mean 71.27 Standard Error 2.02 Standard Error 2.17 Median 82.00 Median 68.50 Mode 82.00 Mode 65.00 Standard Deviation 11.08 Standard Deviation 11.91 Sample Variance122.76 Sample Variance141.86 Kurtosis -0.57 Kurtosis -0.37 Skewness -0.42 Skewness 0.29 Range 42.00 Range 48.00 Minimum 57.00 Minimum 46.00 Maximum 99.00 Maximum 94.00 Sum 2405.00 Sum 2138.00 Count 30.00 Count 30.00 BIN 55 61 66 71 76 81 91 96 60 65 70 75 80 85 95 100 Frequency Histogram 8 6 4 2 0 Frequency Bin Purchase answer to see full attachment Explanation & Answer: 2 Paragraphs User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.