Explore BrainMass
Share

Displaying Data Graphically in Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 16, 2018, 9:29 pm ad1c9bdddf
https://brainmass.com/statistics/statistical-figures/displaying-data-graphically-in-excel-186487

Attachments

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 ...

$2.19
Similar Posting

Hypothesis Development and Five Step Hypothesis Testing

The hypothesis should be developed to include an assessment of women with similar education and work experiences earn less money than men with similar qualifications. The data set and legend are included as an attachment.

Please provide a five-step hypothesis test with the data relevant to the selection (data set and legend attached)

Please provide raw data tables and the results using both graphical and tabular methods of displaying data and results. Excel worksheet and histogram would be appropriate.

The Wage and Wage Earners Data coloumns are as following:

Coloumn A = Wages
Coloumn D = Education
Coloumn H = Sex (woman or man, see legend)
Coloumn I = Work Experience

View Full Posting Details