5. The following data are the grades in GEC 05 and GPA (grade point average) of 60 students in the College of Arts and Sciences. GECOS Grade 99 98 98 98 97 96 GPA 95 91 90 GEC 05 Grade 96 91 GPA 99 98 96 Male Female 1 2 1 2 91 90 89 89 89 89 89 89 4 4 88 87 87 86 85 85 90 89 89 88 88 88 7 95 7 8 93 8 91 90 89 89 89 88 88 88 88 87 87 86 86 10 10 11 11 86 12 13 14 15 16 85 85 84 84 84 84 84 12 13 14 15 89 82 81 81 80 80 78 89 89 16 86 88 86 17 18 19 20 17 84 18 19 88 87 84 83 80 80 81 80 80 80 80 80 80 85 85 84 84 84 83 77 20 21 22 23 24 77 77 76 21 22 23 24 79 76 84 76 75 25 26 79 78 25 77 82 26 76 80 80 27 28 76 27 28 29 30 74 76 76 72 76 73 70 79 29 30 75 70 72 78 70 75 Encode your data in Microsoft Excel. Manage your data Using microsoft Excel Add Ins under Descriptive Statistics. Attached your print out in tour answer sheet. Please refer to your print out to dolanswer the following questions. Justify your answers. who performed better in GEC 05? who showed more uniform set of data in GEC 05? who showed better overall academic performance? who showed more variable set of performance?
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
