14 Nov Descriptive Statistics Questions
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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.