What are the Excel mean and standard deviation of the GPA data? Which process is appropriate? ________ Use Excel and the information from parts 4a and 4b to calculate the probability that a randomly selected MSU student has a GPA between 2.95 and 3.7. GPA Max 3.9 Min 1.5 Classes 6 Class width 0.4 LCL UCL MP Frequency 1.5 1.9 1.7 5 1.9 2.3 2.1 5 2.3 2.7 2.5 5 2.7 3.1 2.9 5 3.1 3.5 3.3 5 3.5 3.9 3.7 5
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.
What are the Excel
Which process is appropriate? ________ Use Excel and the information from parts 4a and 4b to calculate the
GPA | |||
Max | 3.9 | ||
Min | 1.5 | ||
Classes | 6 | ||
Class width | 0.4 | ||
LCL | UCL | MP | Frequency |
1.5 | 1.9 | 1.7 | 5 |
1.9 | 2.3 | 2.1 | 5 |
2.3 | 2.7 | 2.5 | 5 |
2.7 | 3.1 | 2.9 | 5 |
3.1 | 3.5 | 3.3 | 5 |
3.5 | 3.9 | 3.7 | 5 |
Step by step
Solved in 3 steps with 1 images