There are three ways of presenting data: Tabular Method Graphical Method Textual Method
Learning Outcomes: At the end of this module, you should be able to: Describe the tabular method of presenting data Construct a frequency distribution table for group and ungrouped data Construct a stem-and-leaf plot Write the correct syntax of the countif command in Excel and use it to find the frequency of a particular data set
TABULAR PRESENTATION It is a systematic and logical arrangement of data in the form of Rows and Columns with respect to the characteristics of data. It is an orderly arrangement which is compact and self-explanatory.
Parts of a Table
Frequency Distribution Table grouping of the data into categories showing the number of observations in each of the non-overlapping classes.
Example 1 Twenty applicants were given a performance evaluation appraisal. The data set is:
Important Make sure that the data encoded in Excel are the same for its string. The string “High” is different from “high”. The exact match is being counted by the countif command.
Frequency Distribution for Ungrouped Data Ungrouped data is raw data. It has not been sorted into groups.
Frequency Distribution for Grouped Data Grouped data is data that has been organized into groups from the raw data.