Part 1: Using the preliminary data collected in the Topic 2 assignment, 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. For example, if you are comparing sports teams, one member of the group might compare the Tigers and the Rams, while another member of the group might compare the Sharks and the Eagles. 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: 1. Summary of the business scenario. 2. Definition of the variables and sources. 3. Rationale for the type of hypothesis tests used. 4. Null and alternative hypothesis. 5. Two hypothesis tests with results that include test statistic, critical value(s), and p-value. 6. Box plot visuals for each hypothesis test. 7. Interpretation of the statistical results of the hypothesis tests. 8. 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. 9. 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. While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance. Benchmark Information This benchmark assignment assesses the following programmatic competencies: B5 Business Administration 2.3: Use quantitative techniques and tools to analyze dato relevant to business decision moking. [MC3] B5 Business for Secondary Education 7.3: Use appropriate computer applications to perform mathematical calculations relevant to solving business problems.Let X and Y be statistically independent Gaussian-distributed ran- dom variables, each with zero mean and unit variance. Define the Gaussian process Z(t) = X cos(2nt) + Y sin(2nt). (a) Determine the joint probability density function of the random variables Z1(t) and Z2(t) obtained by observing Z(t) at times t, and t2, respectively?2 (15) Indicate whether the following are true or false: (a) COV(X, Y) = COV(Y, X) for all random variables X and Y. (b) If two random variables are jointly Gaussian, they must be marginally Gaussian. (c) If two random variables are marginally Gaussian, they may be jointly Gaussian. (d) The pdf of X+Y always equals the convolution of the pdfs of X and Y (e) If two random variables are independent, they must be uncorrelated