Displaying Data Graphically in Excel
Not what you're looking for?
Please see attached.
Utilize graphical representation to present data, show all your work:
2.19
Construct a histrogram, a frequency polygon, and an ogive for the following frequency distribution.
Class Interval Frequency
50-under 60 13
60-under 70 27
70-under 80 43
80-under 90 31
90-under 100 9
2.21
Construct a stem and leaf plot of the following data.
Let the leaf contain one digit.
312 324 289 335 298
314 309 294 326 317
290 311 317 301 316
306 286 308 284 324
2.22
An examination of rejects shows at least 10 problems. A frequency
tally of the problems follows. Construct a Pareto chart for these data.
Problem Frequency
1 673
2 29
3 108
4 379
5 73
6 564
7 12
8 402
9 54
10 202
2.31
The top music genres according to SoundScan for a recent year are
R&B, Alternative (rock), Music, Rap, and Country. These and other music genres along with
the number of albums sold in each (in millions) are shown.
Genre Albums Sold
R&B 146.4
Alternative 102.6
Rap 73.7
Country 64.5
Soundtrack 56.4
Metal 26.6
Classical 14.8
Latin 14.5
Construct a pie chart for these data displaying the percentage of the whole that each of these games represents.
Purchase this Solution
Solution Preview
Please see the attached Excel spreadsheet.
2.19
Construct a histrogram, a frequency polygon, and an ogive for the following frequency distribution.
Class Interval Frequency Cumulative Frequency
50-under 60 13 13
60-under 70 27 40
70-under 80 43 83
80-under 90 31 114
90-under 100 9 123
HISTOGRAM OGIVE
To make a histogram, make a bar graph using the frequency values from the chart. An ogive is like a frequency polygon, only you place the dots at the cumulative frequencies. The cumulative frequencies are found by adding the frequencies in the table to the frequencies above them.
FREQUENCY ...
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.