Insert a Pivot TableĪfter you input the data you use into an Excel spreadsheet or receive a spreadsheet with the data already in it, you can create a Pivot Table. Below are steps you can use to create a frequency distribution table in Excel: 1. Using data you collect in an Excel spreadsheet, you can create a Pivot Table and then change that table into a frequency distribution. Related: How To Create a Cumulative Frequency Distribution Table in 3 Steps How to make a frequency distribution table in Excel For example, you may have 32 values in the first category, 23 in the next and five in the last. The first category is "1-1,000," the second is "1,001-2,000" with the pattern continuing until "9,001-10,000." The table itself tells you how many values are in those ranges. For example, you can set a scale with categories of 1,000 starting at one, and ending at 10,000 if you're working with numerical values between those endpoints. View more jobs on Indeed View More What is an Excel frequency distribution table?Īn Excel frequency distribution is a tool for looking at how data you have varies across specific ranges of values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |