Explore BrainMass

Explore BrainMass

    Basic descriptive statistics in Excel

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

    Please see attachment

    This research could affect the players of Major League Baseball (MLB) and the fans. The teams that have a lower salary have a lower win rate per year this affects there draft pick they cannot afford well-known plays with high batting averages. These teams have to pick medioka players during the draft, causing the investors and sponsors to back away from the teams, which cause financial difficulties.

    1) Calculate the measures of central tendency, dispersion, and skew for data

    2) Display your descriptive statistical data using graphic and tabular techniques
    a) Line graph
    b) Bar graph

    © BrainMass Inc. brainmass.com June 3, 2020, 11:59 pm ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/basic-descriptive-statistics-excel-312031

    Attachments

    Solution Preview

    Please see the attached files.

    Data analysis using descriptive statistics (Excel)

    This research could affect the players of Major League Baseball (MLB) and the fans. The teams that have a lower salary have a lower win rate per year this affects there draft pick they cannot afford well-known plays with high batting averages. These teams have to pick medioka players during the draft, causing the investors and sponsors to back away from the teams, which cause financial difficulties.

    1) Calculate the measures of central tendency, dispersion, and skew for data

    2) Display your descriptive statistical data using graphic and tabular techniques
    a) Line graph
    b) Bar graph
    see attachment
    Answer
    The measures of central tendency Mean is given by the formula

    Measure of dispersion standard deviation is given by
    Measure of skewness = where
    The details are given below
    Salary
    Team Salary -mil :X

    Boston $123,505,125.0 2544351150097680.00 128341045608930000000000.00
    New York Yankees $208,306,817.0 18290737680378800.00 2473698877077310000000000.00
    Oakland $55,425,762.0 311092033522428.00 -5486979462911790000000.00
    Baltimore $73,914,333.0 723809139156.07 615794908304042000.00
    Los Angles Angels $97,725,322.0 608202343821143.00 14999339464364900000000.00
    Cleveland $41,502,500.0 996100714522536.00 -31437997671017600000000.00
    Chicago White Sox $75,178,000.0 4470842699269.34 9453314032290250000.00
    Toronto $45,719,500.0 747697795931469.00 -20445095836297300000000.00
    Minnesota $56,186,000.0 284852141820336.00 -4807610045218230000000.00
    Tampa ...

    Solution Summary

    Step by step method for computing basic descriptive of MLB salarie statistics in Excel.

    $2.19

    ADVERTISEMENT