Basic descriptive statistics in Excel
Not what you're looking for?
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
Purchase this Solution
Solution Summary
Step by step method for computing basic descriptive of MLB salarie statistics in Excel.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.