Benchmark – Hypothesis Testing
I have included all required math data
complete two hypothesis tests relevant to the specific requirements of your scenario. To ensure tests are not duplicated, collaborate with the other members of your group to identify specifically which data each person in the group will be utilizing in the hypothesis tests. Using Excel, complete the two hypothesis tests using different data sets at a .05 level of significance. Generate a box plot for each test. The accuracy of formulas and the box plot visuals will be assessed.
Part 2
Statistical analysis can create a number of ethical challenges. Review the “Ethical Guidelines for Statistical Practice,” “Statement on the Integration of Faith and Work,” and the servant leadership and conscious capitalism study materials. Consider the principle of “do no harm” and how, through application of a Christian worldview perspective, ethical challenges related to sampling methods, treatment of outliers, selection of levels, or significance can be anticipated and addressed to ensure that statistical analysis is completed effectively, efficiently, and ethically.
Provide a 750-1,000 summary of the hypothesis tests and ethical issues related to statistical analysis. The summary should address the following:
Summary of the business scenario.
Definition of the variables and sources.
Rationale for the type of hypothesis tests used.
Null and alternative hypothesis.
Two hypothesis tests with results that include test statistic, critical value(s), and p-value.
Box plot visuals for each hypothesis test.
Interpretation of the statistical results of the hypothesis tests.
Discussion of potential ethical dilemmas associated with each hypothesis test, including explanation of how the principle of “do no harm” and a Christian worldview perspective could be applied to ensure the statistical analysis was completed ethically. Include discussion of how sampling methods, treatment of outliers, selection of levels, or significance, etc. should be addressed for ethical compliance.
Summary of the hypothesis testing results and how these can be applied to the specified business scenario.
Submit the Excel spreadsheet and Word summary document.
Week 2
Overall Attendance (Year/Season)
2015 2016 2017 2018 2019 2020
Teams
Denver Nuggets 16068 15923 16095 17506 17962 18190
Golden State Warriors 18954 19365 19305 19240 19193 17773
Houston Rockets 18099 17861 17556 18137 17989 18074
Los Angeles Clippers 18623 18492 18488 17373 17279 18461
Los Angeles Lakers 18306 19073 18570 18796 18929 18936
Phoenix Suns 17254 16994 17451 17243 16638 16622
Utah Jazz 17982 18341 18442 17708 17911 17767
Data Table
Mean 18025.1666666667
Median 17946.5
Skewness 0.5806967092
Standard Deviation 301.8750845411
Min 17708
Max 18442
Median 17946.5
Q1 17803
Q3 18251.25
Overal Team Attendance
2015 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 16068 18954 18099 18623 18306 17254 17982 2016 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 15923 19365 17861 18492 19073 16994 18341 2017 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 16095 19305 17556 18488 18570 17451 18442 2018 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 17506 19240 18137 17373 18796 17243 17708 2019 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 17962 19193 17989 17279 18929 16638 17911 2020 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 18190 17773 18074 18461 18936 16622 17767
Overal Attendance Comparison
2015 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 16068 18954 18099 18623 18306 17254 17982 2016 Teams Denver Nuggets Golden State Warriors Houston Rocket s Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 15923 19365 17861 18492 19073 16994 18341 2017 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 16095 19305 17556 18488 18570 17451 18442 2018 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 17506 19240 18137 17373 18796 17243 17708 2019 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 17962 19193 17989 17279 18929 16638 17911 2020 Teams Denver Nuggets Golden State Warriors Houston Rockets Los Angeles Clippers Los Angeles Lakers Phoenix Suns Utah Jazz 18190 17773 18074 18461 18936 16622 17767
Alexandria Tardiff did this table and graphs
Week 3
Overall Attendance (Year/Season)
2015 2016 2017 2018 2019 2020 Mean
Teams Attendance Average for 2020 10
Denver Nuggets 16068 15923 16095 17506 17962 18190 16957.3333333333
Golden State Warriors 18954 19365 19305 19240 19193 17773 18971.6666666667
Houston Rockets 18099 17861 17556 18137 17989 18074 17952.6666666667 Number of trials (n) 20
Los Angeles Clippers 18623 18492 18488 17373 17279 18461 18119.3333333333 Probablility of success (p) Probability of attendance over the average 0.5
Los Angeles Lakers 18306 19073 18570 18796 18929 18936 18768.3333333333
Phoenix Suns 17254 16994 17451 17243 16638 16622 17033.6666666667
Utah Jazz 17982 18341 18442 17708 17911 17767 18025.1666666667 X f(x) Cumulative
0 0.0000010 0.0000010
1 0.0000191 0.0000200
Utah Jazz 2020 last 20 games 2 0.0001812 0.0002012
Wins 6 3 0.0010872 0.0012884
Loses 14 4 0.0046206 0.0059090
Average 10 5 0.0147858 0.0206947
6 0.0369644 0.0576591
7 0.0739288 0.1315880
8 0.1201344 0.2517223
9 0.1601791 0.4119015
10 0.1761971 0.5880985
11 0.1601791 0.7482777
12 0.1201344 0.8684120
13 0.0739288 0.9423409
14 0.0369644 0.9793053
15 0.0147858 0.9940910
16 0.0046206 0.9987116
17 0.0010872 0.9997988
18 0.0001812 0.9999800
19 0.0000191 0.9999990
20 0.0000010 1.0000000
QUESTION 2 probability of 0 events 0.0000010
probability of <5 events 0.0059090 probability of>= 10 events 0.5880985
QUESTION 3 value of X of 20% of data 5
value of X of top 10% of data 13
95% of data lies between two values of x 6 and 14
