How to create a frequency distribution table on excel

The same steps as for the previous problem were accomplished.

The results of a survey are presented below. Create an Ungrouped Frequency Distribution table with the data from the survey concerning the age of the people, which attend the gym. See results of calculations in the table below.

the last column was obtained by multiplying the sixth column on 100%.

Cp for the sixth column was calculated as a ratio of Cf and N.

The values for the fifth column were obtained starting from the lowest score (0), for which Cf=f, and for other scores Cf was obtained as the sum of Cf for the previous score and the f from the second column for current score.

Fourth column was obtained by multiplying the values from the third column by 100%.

Third column was obtained by dividing values of the second column on the number of answers.

Second column, where quantity of same answers in the survey was put for each score, was created.

First column where all different answers were placed from higher to lower value was created.

Create an Ungrouped Frequency Distribution table with the data from the survey, accomplished among the students of university, which answered the question of how many books they read per year.

The last column is the cumulative percent, where the cumulative proportion is presented as percentages.

The next column is called вЂњcumulative proportionвЂќ and the values of its column are obtained as a ratio of cumulative frequency for each score and the total number of scores.

The cumulative frequency of the highest score should be equal to the total number of scores. The further calculations are to be performed for each score in a sequence from lowest to highest and the cumulative frequency for each next score equals to the sum of the cumulative frequency of the previous score and frequency of this score (from the second column). Calculation of the cumulative frequency, should be started from the lowest value of score, for which the cumulative frequency equals the value of frequency from the second column.

In the next column, known as the cumulative frequency column, the cumulative frequency for each score should be estimated.

The next column, where the relative frequency will be performed in percentages, is to be created.

In order to check the correctness of calculations, the sum of fr should be calculated and should be equal to 1.

The relative frequency can be obtained as follows: fr=f/N, there f is the frequency of each score (from the second column) and N is the total number of scores. Create the third column, where the relative frequency of each score will be inserted.This column is known as the tally of the scores Create the second column with the frequency of each data occurrence.Set the values of data, which are called scores, in the column starting from the lowest value to the highest or vice versa.

The following rules must be completed in order to create an ungrouped frequency distribution (вЂњPsychological statistics. There are two types of frequency distributions: Grouped and Ungrouped (вЂњPsychological statistics. A set of data can be described with a frequency distribution.

How to create a frequency distribution table on excel