SOS 101 Lecture Notes - Lecture 6: Histogram
Document Summary
How to make a graph in excel: type your data in two columns, categories in left column, variables in right column, title above right column, highlight everything you typed, go to insert (top bar, click column Select the graph you want: depends on your purpose!! i. e. bar graph wouldn"t help if you wanted to see how something occurred throughout the year (between the bars too) Frequency tables: relative frequency, frequency total number of observations. Frequency distribution table steps: find range, max value - min value, select number of classes. Sub - ranges: usually between 5-20 classes, compute class intervals, width, determine class boundaries, count observations and assign to classes, compute class midpoints. Histogram v. bar graph: histograms, bars touching, number ranges for x-axis, bar graphs, bars separated, categories for x-axis. Line graphs: typically multiple lines, when there are multiple categories.
