Question: Use the scoring worksheet in the scoring.xlsx data set to answer the following 5 questions. The scoring data set represents a sample of scoring for

Use the scoring worksheet in the scoring.xlsx data set to answer the following 5 questions. The scoring data set represents a sample of scoring for 50 basketball players in the Fictitious Basketball League in Fantasy Land, Wisconsin on November 28, 2019. The population mean and standard deviation are unknown for the League. Credit will be provided for professionalism and accuracy. 1) (10 pts) Construct a histogram of the points scored. Discuss the results.

2) (15 pts) Given the tools of Excel and Appendix of chapter 3 of the textbook, provide a descriptive statistics table of the scoring data.

a) What is the mean, median, standard deviation of scoring?

b) Is the data skewed? Does scoring appear to be normally distributed? Explain.

Use the scoring worksheet in the scoring.xlsxUse the scoring worksheet in the scoring.xlsxc) Produce a boxplot of scoring. Describe the results.

scoring.xl g.xlsx File Edit Insert Format He Qa Calibri Scoring B C D scoring.xlsx File Edit Insert Format Calibri f B NE Free Throws 0 3 4 5 6 7 8 9 10 11 12 1 0 1 0 1 0 1 0 0 0 1 0 0 1 0 0 0 1 14 16 17 18 19 20 24 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!