Explore BrainMass
Share

Basic descriptive statistics in Excel

This content was STOLEN 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 December 20, 2018, 5:01 am 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