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!

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

https://brainmass.com/statistics/descriptive-statistics/basic-descriptive-statistics-excel-312031

#### Solution Preview

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