Ungrouped Frequency Distribution
Problem 2. Create an Ungrouped Frequency Distribution table with the data from the survey concerning the age of the people, which attend the gym. The results of a survey are presented below.
The data for the ungrouped frequency distribution is in a column given the name "X" and the data for the grouped frequency distribution is in a column given the name "Y". The is available.
1. If you examined this list, you would find that the smallest value is 361 and the largest is 780. An ungrouped frequency distribution (like we created in the previous lab exercise) would require us to list all 420 possible verbal aptitude scores from 361 up to and including 780. The majority of these possible values would have a frequency of zero and the rest would have very small frequencies. Neither the frequency distribution table nor the column chart would help us understand the distribution of verbal aptitude scores. Up until now, you have worked with ungrouped frequency distributions and illustrated them using column charts (also called bar charts).Each frequency corresponded to the number of occurrences of a specific value in the data set. There are too many different values inthis data set to use that approach. Instead, we will create a grouped frequency distribution. Each frequency corresponds to the number of data elementswithin a range (or interval) of specific values.In situations like this, a grouped frequency distribution is used to illustrate the data (rather than an ungrouped frequency distribution). The possible values are grouped into a number of intervals (of equal size) and the number of data values in each interval is counted. That is, each frequency corresponds to the number of data values within the corresponding interval rather than the number of times a particular value occurs in the data set.Step 5: To draw the histogram for an ungrouped frequency distribution of a variate we should assume the frequency corresponding to the variate value x is spread over the interval x- to x+.h:jump from one value to the next.1. Enter this data, in the order listed, into the "Raw Data" column of yourworksheet. (Column C, the "# of M&Ms" column, will be used later as part of the ungrouped frequency distribution.)Some MAT 120 students were asked to record their age (in years) with the following results: 18, 18, 19, 19, 22, 20, 18, 22, 18, 20, 20, 18, 18, 18, 18, 19, 21, 18, 18, 18, 20, 18, 23, 19, 18, 18, 18, 18. Insert a new worksheet named "Ages" and generate an ungrouped frequency distribution based on this data. Illustrate your distribution with a chart.