Assessment 2 – Hypothesis Testing for Differences Between GroupsOverview Perform hypothesis testing on the differences between two groups and create an Excel document. Write a 2–3-page analysis of the results in a Word document and insert the results into this document.Note: You are strongly encouraged to complete the assessments in this course in the order they are presented. Hypothesis testing is a foundational statistical technique used to make decisions about a hypothesis. A hypothesis test compares two mutually exclusive statements (null hypothesis, alternative hypothesis) where only one is true. Hypothesis testing can determine statistical significance by examining the probability that a given result would occur under the null hypothesis. For this assessment, you will perform hypothesis testing on the differences between two groups.By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:Competency 1: Plan for data collection, measurement, and analysis.Generate a hypothesis about the difference between two groups in a dataset.Identify the appropriate statistical test in a dataset.Competency 2: Analyze data using computer-based programming and software.Performs appropriate statistical test of the difference between two groups in a dataset.Competency 3: Interpret results of data analysis for value-based health care decisions, policy, or practice.Interpret the results of a data analysis and state whether to accept or reject the null hypothesis based on the p-value and an alpha of .05.Write a narrative summary of the results that includes practical, administration-related implications of the hypothesis test.Competency 5: Communicate audience-appropriate health management content in a logically structured and concise manner, writing clearly with correct use of grammar, punctuation, spelling, and APA style.Write clearly and concisely, using correct grammar, mechanics, and APA formatting.Resources Statistical SignificanceFrey, B. B. (Ed.). (2018). Significance. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.Gallo, A. (2016, February 16). A refresher on statistical significance. Harvard Business Review Digital Articles, 2–9.Simpson, S. H. (2015). Creating a data analysis plan: What to consider when choosing statistics for a study. Canadian Journal of Hospital Pharmacy, 68(4), 311–317. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC45522...Hypothesis TestingFrey, B. B. (Ed.). (2018). Hypothesis testing. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.Hypothesis Tester.Real Statistics Using Excel. (n.d.). Null and alternative hypothesis. Retrieved from http://www.real-statistics.com/hypothesis-testing/...Elliott. E. C. (n.d.). Understanding statistical hypothesis testing. Retrieved from https://www.stattutorials.com/understanding-hypoth...Gonzalez-Chica, D. A., Bastos, J. L., Duquia, R. P., Bonamigo, R. R., & Martínez-Mesa, J. (2015). Test of association: Which one is the most appropriate for my study? Anais brasileiros de dermatología, 90(4), 523–528. Retrieved from https://www.ncbi.nlm.nih.gov/pmc/articles/PMC45605...Quantitative Skills Center: Interpreting Statistical Data.p ValueFrey, B. B. (Ed.). (2018). p value. In The SAGE encyclopedia of educational research, measurement, and evaluation (Vols. 1–4). Thousand Oaks, CA: Sage.Elliott, E. C. (n.d.). Interpreting statistical p-values. Retrieved from https://www.stattutorials.com/p-value-interpreting...Interpreting Results Evaluation of Analytic Results.Interpreting Results of Inferential Techniques.Matching Statistical Tests to Hypotheses.Significance TestsOrr-Depner, R. (n.d.). Learning about 2-sample t-tests with Guitar Hero | Transcript. Retrieved from https://www.sophia.org/tutorials/learning-about-2-...Scheer, A. (n.d.). The basics of significance tests | Transcript. Retrieved from https://www.sophia.org/tutorials/sec-91-the-basics...StatisticsLectures.com. (n.d.). Statistical vs practical significance. Retrieved from http://www.statisticslectures.com/topics/statistic...Tutorials for Statistical Data Analysis. (n.d.). Two sample (independent group) t-test using Mcrosoft Excel. Retrieved from https://www.stattutorials.com/EXCEL/EXCEL_TTEST1.h...TextbookKros, J. F., & Rosenthal, D. A. (2016). Statistics for health care management and administration: Working with Excel (3rd. ed.). San Francisco, CA: Jossey-Bass. Available in the courseroom via the VitalSource Bookshelf link.Preparation Download the Assessment 2 Dataset [XLSX]. The dataset contains the following variables:clinic1 (total number of visits per month for clinic 1) .clinic2 (total number of visits per month for clinic 2).InstructionsAn investor needs to make a decision on whether to acquire one of two medical clinics based on their productivity, as measured by the total number of visits per month. You have been asked whether there is a significance difference in the total number of visits per month between clinic 1 and clinic 2.For this assessment, perform hypothesis testing on the differences between two groups in the Assessment 2 Dataset. Create an appropriately labeled Excel document with your results. Also write an analysis of the results in a Word document. Insert the test results into this document (copied from the output file and pasted into a Word document). Refer to Copy From Excel to Another Office Program for instructions.Submit both the Word document and the Excel file that shows the results.Grading CriteriaThe numbered assessment instructions outlined below correspond to the grading criteria in the Hypothesis Testing for Differences Between Groups Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed.Generate a hypothesis about the difference between two groups in a dataset.State null hypothesis and alternative hypothesis as an explanation and math equation.Identify the appropriate statistical test in a dataset.Provide your statistical rationale.Perform appropriate statistical test of the difference between two groups in a dataset.Interpret the results of a data analysis and state whether to accept or reject the null hypothesis based on the p-value and an alpha of .05.Interpret p-value and statistical significance.Write a narrative summary of the results that includes practical, administration-related implications of the hypothesis test.Additional RequirementsYour assessment should meet the following requirements:Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.Length: 2–3 pagesResources: Not required.APA format: Cite your sources using current APA format.Font and font size: Times Roman, 10 point.

Answer Questions #1 - 8. You do not need to show your work. #1) Find the expected value for the probability model shown below. Value $2 $4 $8 $30Probability 0.25 0.5 0.17 0.08 #2) Find the missing value (???) in the probability model shown below. Value $2 $5 $8 $11Probability 0.18 0.33 ??? 0.28 #3) In the probability model given below, the expected value is - $1.55. Find the missing value, x. Value $4 -$5 x -$8 Probability 0.20 0.45 0.15 0.20 #4) A large number of people were polled and asked which of four different animals were their favorite. 13% said Penguin, 21% said Iguana, 22% said Parrot, and 44% said Turtle. Suppose you decide to carry out a simulation given these percentages. You decide to select two digits at a time. Which would be a proper assignment of digits for these teams? a) 01-13 = Penguin, 01-21 = Iguana, 01-22 = Parrot, 01-44 = Turtleb) 00-13 = Penguin, 14-34 = Iguana, 35-56 = Parrot, 57-99 = Turtlec) 01-13 = Penguin, 14-35 = Iguana, 36-58 = Parrot, 59-99 & 00 = Turtled) 01-13 = Penguin, 14-34 = Iguana, 35-56 = Parrot, 57-99 & 00 = Turtlee) None of These #5) The expected value for the following scenario is $1.60. Write two different equations that give both a simplified equation using the expected value and a simplified equation for the total of all probabilities in the probability model. Value $3 -$4 $17Probability x y 0.08 #6) Suppose that there are 513 students who are currently enrolled in AP Calculus and that we are looking for five randomly selected students to survey about their experiences in AP Calculus. The digit combinations 001-513 are assigned to represent the 513 students currently enrolled in AP Calculus. Using the random digits below, what are the numbers of the five students that will be selected for the survey? 71548 15233 53946 68713 72468 27601 13703 88692 Student 1 = #_____, Student 2 = #_____, Student 3 = #_____, Student 4 = #_____, Student 5 = #_____ #7) If you buy a ticket in a certain lottery game, 30% of the players will get paid $1, 20% of the players will get paid $6, and 5% of the players will get paid $55. All other players get paid nothing. What is the expected amount that a player of this lottery game will get paid? #8) In a certain card game you draw one card off a standard deck of 52 cards. If you draw a spade you get paid $12, if you draw a red Ace you get paid $20, and if you draw a red Queen you get paid $38. If you draw anything else, you get paid nothing. What should this game cost if it is to be a fair game? Use fractions in your work and then calculate the answer as a decimal rounded to 4 decimal places.