This video will show how to create a frequency table and pie chart about beliefs about the impact of social media. A pie chart and bar chart of these results are shown below:Įxample 1: Creating a frequency table and pie chart in Excel 2016 on Out of a total of 128 responses, 41% (or 52/128) of students reported that Batman would win the battle, followed by Iron Man with 27%, Captain America with 19%, and Superman with 13%. The professional plan comes with advanced reporting and more than 20 document creations and the enterprise plan comes with unlimited users and a single sign-on option.
Now you have a histogram based on the data set. After that, click on the ‘Insert Statistic Chart’ and select Histogram’. After you highlight the data, click ‘Insert’ from the tab list. Below is a frequency table and charts of the results: Displayr offers users access to its online histogram maker for free. Then, while still holding down Shift, hold Ctrl (Command for Mac) + Arrow Down. If you wish to perform an inferential test on the distribution of a single categorical variable, see the chi-squared goodness-of-fit test.Ī researcher asked her class to pick who would win in a battle of superheros. Frequency tables and bar charts can display either the raw frequencies or relative frequencies. Pie charts represent relative frequencies by displaying how much of the whole pie each category represents. They are calculated by dividing the number of responses for a specific category by the total number of responses. Relative frequencies are more commonly used because they allow you to compare how often values occur relative to the overall sample size. These displays show all possible values of the variable along with either the frequency (count) or relative frequency (percentage). Frequency tables, pie charts, and bar charts can be used to display the distribution of a single categorical variable.