Explore BrainMass

Explore BrainMass

    Displaying Data in a Histogram

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

    I need help in how to display the following data in a histogram.

    Can you provide step by step advice on how I can go about solving this problem?

    1. Display the frequency distribution of the salaries graphically in a histogram (choose intervals to use along the horizontal axis) and tell what is the mean, median and skew of the distribution.

    The High school Basket ball team salaries for 2005 are listed below:

    7.88M 7.70M 4.20M 6.60M 6.19M 920K

    5.37M 1.35M 870K 760K 950K 4.16M

    2.65M 1.97M 5.22M 720K 1.61M 720K

    3.55M 1.65M 1.58M 810K 850K 470K

    600K 590K 340K 510K 470K 850K

    400K 600K 390K 450K 370K 1.66M

    280K 950K 990K 720K 1.30M 410K

    580K 300K 300K 440K 270K 540K

    960K 460K 290K

    © BrainMass Inc. brainmass.com June 3, 2020, 8:57 pm ad1c9bdddf
    https://brainmass.com/statistics/histogram/displaying-data-in-a-histogram-159546

    Solution Preview

    I simply entered the data into excel then wrote everything in thousands so 500k = 500 and 5M = 5000. I then used Excel's histogram tool. I ...

    Solution Summary

    Using the power of Excel, this solution shows how to display a frequency distribution histogram for basket ball team salary data.

    $2.19

    ADVERTISEMENT