SECTION 5C HIGHLIGHTS
Vocabulary: Frequency Table, bin, Frequency, Relative Frequency, Cumulative Frequency, qualitative data, quantitative data, Bar Graph, Pie Chart, Histogram, Line Chart, Time Series Diagram
Assignment: Read about Statistical Tables and Graphs
in Section 5C of the text. Using Excel create the statistical graphs for
page 341 of “Further Applications” EX(37-40) .
Do pp. 339-342 RQ(1,2), BSC(15,17-25), WP(49).
.
Web Project #49 LINK: STATISTICAL ABSTRACTS OF THE UNITED STATES
Notes:
A frequency table is used to organize raw data into bins. The tables
we will use have four
columns: Bin definition, Frequency, Relative Frequency and Cumulative
Frequency.
SAMPLE
DISTRIBUTIONS
Qualitative data is data that grade the qualities of categories and Quantitative data is data that represents an actual count or measurement.
A Bar Graph is most commonly used to compare data that may be separated into
several categories.
A Pie Chart is most commonly used to present the manner in which some whole is
broken into parts.
A Histogram is similar to a bar graph, however the bars follow an ordered
progression. HISTOGRAM EXPERIMENTS
A Line Chart serves the same purpose as a histogram, however instead of bars to
represent data, a line chart connects a series of dots.
A Time Series Diagram may be either a histogram or a line chart upon which the
horizontal axis represents time.
Skills to be mastered:
1. Student should be able to analyze and answer questions regarding a Bar
Graph.
2. Student should be able to analyze and answer questions regarding a Pie
Chart.
3. Student should be able to analyze and answer questions regarding a
Line Chart.
4. Student should be able to analyze and answer questions regarding a
Time Series Diagram.
5. Create a Bar Graph with Excel.
6. Create a Pie Chart with Excel.
7. Create a Scatter Plot with Excel.
8. Student should be able to distinguish between qualitative and
quantitative data.
9. Student should be able to create a frequency table from a set of data.