1 / 7

Section 2.1

Section 2.1. Organizing Qualitative Data. Definitions. Frequency Distribution = lists each category of data and the number of times it occurs for each category Relative Frequency = frequency sum of all frequencies

sera
Télécharger la présentation

Section 2.1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Section 2.1 Organizing Qualitative Data

  2. Definitions • Frequency Distribution = lists each category of data and the number of times it occurs for each category • Relative Frequency = frequency sum of all frequencies • Relative Frequency Distribution = lists each category or data together with the relative frequency

  3. Frequency Distribution (Excel) • Can use the function =COUNTIF to help build the frequency distribution Example: =COUNTIF(A1:A25,”Red”)

  4. Definitions • Bar Graph = Constructed by labeling each category of data on a horiz. Axis and the freq. or rel. freq. of the category on the vertical axis. Rectangles of equal width are drawn for each category. The height of each rectangle is equal to the freq. of that category or relative freq.

  5. Bar Graph from Freq Dist. (Excel) • Put categories in column A, frequencies in column B • Highlight them • “Insert” Tab -> Column -> 2D Clustered Column

  6. Definitions • Pareto Chart = A bar graph whose bars are drawn in decreasing order of frequency or relative frequency. • Side-by-Side Bar Graph = compares two data sets. • Pie Chart = A circle divided into sectors. Each sector represents a category of data. The area of each sector is proportional to the frequency of the category.

  7. Pie Chart from Freq Dist. (Excel) • Put categories in column A, frequencies in column B • Highlight them • “Insert” Tab -> Pie -> Pie

More Related