COBU 260 Spring 2021 Complete the assignment using Excel worksheet. **Other than the Frequency column, every cell must be computed using Excel formulas Attach your Excel file (one file) and submit. ****Do not embed Excel object in this Word file; do your work in a separate Excel file. The following table represents the Frequency Distribution and Cumulative Distributions for this data set: 12, 13, 17, 21, 24, 24, 26, 27, 27, 30, 30, 35, 37, 38, 39, 43, 44, 46, 53, 58 Using Excel formulas: Compute the Total for the frequencies. Compute the relative frequency for each class. Compute the Total for the relative frequencies. Compute the percentage for each class Compute the Total for the percentages. Compute the cumulative frequency for each class. Compute the cumulative percentage for each class. Class Frequency Relative Frequency Percentage Cumulative Frequency Cumulative Percentage 10 but less than 20 20 but less than 30 30 but less than 40 40 but less than 50 50 but less than 60 TOTAL
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.
COBU 260 Spring 2021
Complete the assignment using Excel worksheet.
**Other than the Frequency column, every cell must be computed using Excel formulas
Attach your Excel file (one file) and submit.
****Do not embed Excel object in this Word file; do your work in a separate Excel file.
The following table represents the Frequency Distribution and Cumulative Distributions for this data set: 12, 13, 17, 21, 24, 24, 26, 27, 27, 30, 30, 35, 37, 38, 39, 43, 44, 46, 53, 58
Using Excel formulas:
- Compute the Total for the frequencies.
- Compute the relative frequency for each class.
- Compute the Total for the relative frequencies.
- Compute the percentage for each class
- Compute the Total for the percentages.
- Compute the cumulative frequency for each class.
- Compute the cumulative percentage for each class.
|
Class |
Frequency |
Relative Frequency |
Percentage |
Cumulative Frequency |
Cumulative Percentage |
|
10 but less than 20 |
|
|
|
|
|
|
20 but less than 30 |
|
|
|
|
|
|
30 but less than 40 |
|
|
|
|
|
|
40 but less than 50 |
|
|
|
|
|
|
50 but less than 60 |
|
|
|
|
|
|
TOTAL |
|
|
|
|
|
The relative frequency can be calculated as,
Relative frequency =
Cumulative frequencies = For the cumulative frequency we add all of the previous frequencies to the frequency for the current row.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
