Explore BrainMass

Explore BrainMass

    Displaying Data Graphically in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED 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 March 4, 2021, 8:41 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.49

    ADVERTISEMENT