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.PreparationDownload 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).PreparationDownload 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.

Assignment: Introduction to Quantitative Analysis: Confidence Intervals In your Week 2 Assignment, you displayed data based on a categorical variable and continuous variable from a specific dataset. In Week 3, you used the same variables as in Week 2 to perform a descriptive analysis of the data. For this Assignment, you will calculate a confidence interval in SPSS for one of the variables from your Week 2 and Week 3 Assignments. To prepare for this Assignment: Review the Learning Resources related to probability, sampling distributions, and confidence intervals. For additional support, review the Skill Builder: Confidence Intervals and the Skill Builder: Sampling Distributions, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane. Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you chose) from Week 2. Choose an appropriate variable from Weeks 2 and 3 and calculate a confidence interval in SPSS. Once you perform your confidence interval, review Chapter 5 and 11 of the Wagner text to understand how to copy and paste your output into your Word document. For this Assignment: Write a 2- to 3-paragraph analysis of your results and include a copy and paste of the appropriate visual display of the data into your document. If you are using the Afrobarometer Dataset, report the mean of Q1 (Age). If you are using the HS Long Survey Dataset, report the mean of X1SES. Based on the results of your data in this confidence interval Assignment, provide a brief explanation of what the implications for social change might be.

Please review Sections 2.2-2.4. Please give examples of how graphs are used in your life at home, business, investments, sports, etc.You may use the information in the textbook or talk about your own personal graphs. Please provide an example or two of those graphs by uploading a picture or siting a source.Then answer your classmates' posts and comment on their description.Please remember to use APA formatting if you use help from the textbook or a website. Try to use your own words!