Fluent Essays

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. data_analysis_health_care_decisions_assignment_2_grading_rubrics.pdf data_analysis_health_care_decisions_assignment_2_details_and_instructions.docx data_analysis_health_care_decisions_assignment_2_dataset.xlsx Unformatted Attachment Preview 12/31/2019 Hypothesis Testing for Differences Between Groups Scoring Guide Hypothesis Testing for Differences Between Groups Scoring Guide CRITERIA NONPERFORMANCE BASIC PROFICIENT DISTINGUISHED Generate a hypothesis about the difference between two groups in a dataset. Does not generate a hypothesis about the difference between two groups in a dataset. Generates a hypothesis about the difference between two groups in a dataset but it is incomplete or contains errors. Generates a hypothesis about the difference between two groups in a dataset. Generates a hypothesis about the difference between two groups in a dataset. Ensures the hypothesis is clearly stated, is complete, and includes null and alternative hypotheses. Identify the appropriate statistical test in a dataset. Does not identify the appropriate statistical test of the difference between two groups in a dataset. Incorrectly identifies the appropriate statistical test of the difference between two groups in a dataset. Identifies the appropriate statistical test of the difference between two groups in a dataset. Identifies the appropriate statistical test of the difference between two groups in a dataset and provides rationale and justification for the selected test. Perform appropriate statistical test of the difference between two groups in a dataset. Does not perform appropriate statistical test of the difference between two groups in a dataset. Incorrectly performs appropriate statistical test of the difference between two groups in a dataset. Performs appropriate statistical test of the difference between two groups in a dataset. Performs appropriate statistical test of the difference between two groups in a dataset and provides concise, logical reasoning for the selected test that includes an explanation of the test statistic and significance level. Interpret the results of a data analysis and state whether to accept or reject the null hypothesis based on the pvalue and an alpha of .05. Does not interpret results of a data analysis or state whether to accept or reject the null hypothesis based on the pvalue and an alpha of .05 Interprets results of a data analysis but the interpretation is incomplete, inaccurate, or logically inconsistent with the data. Interprets results of a data analysis and states whether to accept or reject the null hypothesis based on the p-value and an alpha of .05. Interprets results of a data analysis and states whether to accept or reject the null hypothesis based on the pvalue and an alpha of .05 that is complete. Provides a perceptive and clearly articulated conclusion and includes an assessment of caveats and limitations. Write a narrative summary of the results that includes practical, administrationrelated implications of the hypothesis test. Does not write a narrative summary of the results that includes practical, administrationrelated implications of the hypothesis test. Writes a narrative summary of the results but it contains incorrect or insufficient administration-related implications of the hypothesis test. Writes a narrative summary of the results that includes practical, administrationrelated implications of the hypothesis test. Writes a scholarly narrative summary of the results that includes practical, administration-related implications of the hypothesis test. Draws valid, fully justified conclusions well supported by scholarly literature. https://courserooma.capella.edu/bbcswebdav/institution/MHA-FP/MHA-FP5017/190700/Scoring_Guides/a02_scoring_guide.html 1/2 12/31/2019 CRITERIA Write clearly and concisely, using correct grammar, mechanics, and APA formatting. Hypothesis Testing for Differences Between Groups Scoring Guide NONPERFORMANCE Does not write clearly and concisely, using correct grammar, mechanics, and APA formatting. BASIC PROFICIENT DISTINGUISHED Writes in a manner that is unclear and disorganized, includes errors in grammar and mechanics that inhibit effective communication, or contains incorrect or improperly formatted source citations and references. Writes clearly and concisely, using correct grammar, mechanics, and APA formatting. Writes clearly and concisely. Ensures grammar, mechanics, and APA formatting are error free. https://courserooma.capella.edu/bbcswebdav/institution/MHA-FP/MHA-FP5017/190700/Scoring_Guides/a02_scoring_guide.html 2/2 Assessment 2 – Hypothesis Testing for Differences Between Groups Overview 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: • o o • o • o o • o 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, administrationrelated 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 Significance • • • Frey, 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/PMC4552232/ Hypothesis Testing • • • • • • Frey, 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/null-hypothesis/ Elliott. E. C. (n.d.). Understanding statistical hypothesis testing. Retrieved from https://www.stattutorials.com/understanding-hypothesis-testing.html 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/PMC4560542/ Quantitative Skills Center: Interpreting Statistical Data. p Value • • Frey, 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.html Interpreting Results • • • Evaluation of Analytic Results. Interpreting Results of Inferential Techniques. Matching Statistical Tests to Hypotheses. Significance Tests • • • • Orr-Depner, R. (n.d.). Learning about 2-sample t-tests with Guitar Hero | Transcript. Retrieved from https://www.sophia.org/tutorials/learningabout-2-sample-t-tests-with-guitar-hero Scheer, A. (n.d.). The basics of significance tests | Transcript. Retrieved from https://www.sophia.org/tutorials/sec-91-the-basics-of-significance-tests StatisticsLectures.com. (n.d.). Statistical vs practical significance. Retrieved from http://www.statisticslectures.com/topics/statisticalpractical/ 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.html Textbook • Kros, J. F., & Rosenthal, D. A. (2016). Statistics for health care management and administration: Working with Excel (3rd. ed.). San Francisco, CA: JosseyBass. 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). Instructions An 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 Criteria The 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 performancelevel descriptions for each criterion to see how your work will be assessed. 1. Generate a hypothesis about the difference between two groups in a dataset. o State null hypothesis and alternative hypothesis as an explanation and math equation. 2. Identify the appropriate statistical test in a dataset. o Provide your statistical rationale. 3. Perform appropriate statistical test of the difference between two groups in a dataset. 4. 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. o Interpret p-value and statistical significance. 5. Write a narrative summary of the results that includes practical, administrationrelated implications of the hypothesis test. Additional Requirements Your assessment should meet the following requirements: • • • • • Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately. Length: 2–3 pages Resources: Not required. APA format: Cite your sources using current APA format. Font and font size: Times Roman, 10 point. clinic1 140 126 30 130 193 137 168 99 135 184 118 109 93 136 102 24 99 104 134 80 30 44 156 150 150 95 51 205 30 92 173 49 137 27 150 182 184 152 147 76 161 143 127 166 139 92 clinic2 169 151 175 115 167 153 115 194 216 149 122 155 185 150 141 135 87 42 96 111 234 158 130 148 105 108 114 113 131 114 61 175 135 198 149 92 127 170 167 175 263 138 161 166 88 152 145 176 186 48 92 69 168 27 157 83 139 132 85 97 125 145 129 157 183 50 185 149 157 185 127 110 66 141 125 111 150 162 94 138 162 134 83 157 134 137 76 115 51 150 25 137 148 136 121 174 90 179 171 85 134 123 134 64 153 106 192 115 150 151 166 105 159 160 52 167 103 178 174 80 128 172 154 170 152 95 111 144 136 191 193 144 168 94 126 208 136 201 171 148 207 189 104 197 131 151 202 214 111 204 189 159 188 174 ... Purchase answer to see full attachment