Writing Homework Help

Lab 4 is based on content related to Descriptive Statistics focused on measures of central tendency, dispersion, and relative position. In addition, students are assessed on their ability to detect and ‘treat’ outliers.

There are 3 tabs of data that need to be analyzed using these descriptive statistics. Use Lab 4 excel file (Week 9 module on Canvas) to answer the questions.

1. What is the average salary of EPL players in GBP (round to the nearest whole number)?

2. What is the standard deviation of EPL player salaries in GBP (round to the nearest whole number)?  

3. What is the coefficient of variation (CV) for EPL player salaries (round to two decimal places)?

4. What is the average salary of MLB payers in USD (round to the nearest whole number)?

5. What is the standard deviation of MLB player salaries in USD (round to the nearest whole number)?

6. What is the coefficient of variation (CV) for MLB player salaries (round to two decimal places)

7. Based on your analysis, which league has more variation in player salaries?

English Premier League (EPL)

Major League Baseball (MLB)

Cannot be determined from this analysis

8. What is the average revenue of the 29 nonprofit organizations providing sport-based youth development programs in Philadelphia (round to the nearest whole number)?

9.What is the skewness value associated with this data (round to the nearest two decimal places)?

10. What is the kurtosis value associated with this data (round to two decimal places)?

11.Based on the kurtosis and skewness value, should we be concerned about the distribution of this data?

Yes, the kurtosis value is outside the acceptable range but the skewness value is fine.

Yes, the skewness value is outside the acceptable range but the kurtosis value is fine.

Yes, the skewness and kurtosis values are both outside the acceptable ranges.

No, the skewness and kurtosis values are both within the acceptable ranges.

12. Since Employee 1 has the highest sales volume we can conclude that they performed the best within their industry segment.

True

False

13. What is Employee 1’s zScore within the Apparel industry segment?

14.Calculate the percentile rank for each employee within their respective industry segment. Which employee ranked the highest within their segment?

15.Calculate the percentile rank for each employee within their respective industry segment. Which employee ranked the lowest within their segment?