22 question test, show work and help me understand please.

CompetencyIn this project, you will demonstrate your mastery of the following competency:Apply statistical techniques to address research problemsPerform hypothesis testing to address an authentic problemOverviewIn this project, you will apply inference methods for means to test your hypotheses about the housing sales market for a region of the United States. You will use appropriate sampling and statistical methods.ScenarioYou have been hired by your regional real estate company to determine if your region’s housing prices and housing square footage are significantly different from those of the national market. The regional sales director has three questions that they want to see addressed in the report:Are housing prices in your regional market higher than the national market average?Is the square footage for homes in your region different than the average square footage for homes in the national market?For your region, what is the range of values for the 95% confidence interval of square footage for homes in your market?You are given a real estate data set that has houses listed for every county in the United States. In addition, you have been given national statistics and graphs that show the national averages for housing prices and square footage. Your job is to analyze the data, complete the statistical analyses, and provide a report to the regional sales director. You will do so by completing the Project Two Template located in the What to Submit area below.DirectionsIntroductionPurpose: What was the purpose of your analysis, and what is your approach?Define a random sample and two hypotheses (means) to analyze.Sample: Define your sample. Take a random sample of 100 observations for your region.Describe what is included in your sample (i.e., states, region, years or months).Questions and type of test: For your selected sample, define two hypothesis questions and the appropriate type of test hypothesis for each. Address the following for each hypothesis:Describe the population parameter for the variable you are analyzing.Describe your hypothesis in your own words.Describe the inference test you will use.Identify the test statistic.Level of confidence: Discuss how you will use estimation and conference intervals to help you solve the problem.1-Tailed TestHypothesis: Define your hypothesis.Define the population parameter.Write null (Ho) and alternative (Ha) hypotheses.Specify your significance level.Data analysis: Analyze the data and confirm assumptions have not been violated to complete this hypothesis test.Summarize your sample data using appropriate graphical displays and summary statistics.Provide at least one histogram of your sample data.In a table, provide summary statistics including sample size, mean, median, and standard deviation.Summarize your sample data, describing the center, spread, and shape in comparison to the national information.Check the conditions.Determine if the normal condition has been met.Determine if there are any other conditions that you should check and whether they have been met.Hypothesis test calculations: Complete hypothesis test calculations, providing the appropriate statistics and graphs.Calculate the hypothesis statistics.Determine the appropriate test statistic (t).Calculate the probability (p value).Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.Relate the p value and significance level.Make the correct decision (reject or fail to reject).Provide a conclusion in the context of your hypothesis.2-Tailed TestHypotheses: Define your hypothesis.Define the population parameter.Write null and alternative hypotheses.State your significance level.Data analysis: Analyze the data and confirm assumptions have not been violated to complete this hypothesis test.Summarize your sample data using appropriate graphical displays and summary statistics.Provide at least one histogram of your sample data.In a table, provide summary statistics including sample size, mean, median, and standard deviation.Summarize your sample data, describing the center, spread, and shape in comparison to the national information.Check the assumptions.Determine if the normal condition has been met.Determine if there are any other conditions that should be checked on and whether they have been met.Hypothesis test calculations: Complete hypothesis test calculations, providing the appropriate statistics and graphs.Calculate the hypothesis statistics.Determine the appropriate test statistic (t).Determine the probability (p value).Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.Relate the p value and significance level.Make the correct decision (reject or fail to reject).Provide a conclusion in the context of your hypothesis.Comparison of the test results: See Question 3 from the Scenario section.Calculate a 95% confidence interval. Show or describe your method of calculation.Interpret a 95% confidence interval.Final ConclusionsSummarize your findings: Refer back to the Introduction section above and summarize your findings of the sample you selected.Discuss: Discuss whether you were surprised by the findings. Why or why not?What to SubmitTo complete this project, you must submit the following:Project Two Template: Use this template to structure your report, and submit the finished version as a Word document.Supporting MaterialsThe following resources may help support your work on the project:Data Set: House Listing Price by RegionUse this data for input in your project report.Document: National Statistics and GraphsUse this data for input in your project report.Use these tutorials for support with the Excel functions you will use in the project:Tutorial: Random Sampling in ExcelTutorial: Scatterplots in ExcelTutorial: Descriptive Statistics in ExcelTutorial: Creating Histograms in Excel

Competency  Apply statistics to different quality methods in healthcare.  Course Scenario  Chaparral Regional Hospital is a small, urban hospital of approximately 60 beds, and offers the following:  Emergency room services Intensive care Surgical care Obstetrics Diagnostic services Some rehabilitation therapies Inpatient pharmacy services Geriatric services and Consumer physician referral services Recently, the CEO has been hearing complaints from both patients and staff. You have been hired to design and implement a Quality Improvement Plan to help uncover quality problems and satisfactorily resolve them.  Scenario Continued  Your CEO has requested that you provide employee training on Quality Improvement. You have done an initial survey of patient satisfaction, and the CEO has asked you to explain how the data will be analyzed, using this initial data.  Given the variety of complaints coming from both employees and patients, it is critical for everyone to understand the importance of conducting the survey and obtaining solid data.    Instructions  You are to create an agenda for the training and a memo with bullet points to present the statistical analysis of the initial data. The memo should include an explanation of each of the statistical results. In particular, you should be able to explain what the results mean to the facility.  Determine the percentages of the following:  Percent who responded with a 5 (Great) on "Overall      impression of the visit" Percent who responded with a 2 (Fair) or 1 (Poor) on      "Overall impression of the visit" Percent who responded with a 5 (Great) on      "Willingness to return" Percent who responded with less than 5 on      "Willingness to return" In the area of "Facility and Convenience,"      which indicator had the highest percentage of 5 (Great) responses? Which      had the lowest? In the area of "Staff," which indicator had      the highest percentage of 5 (Great) responses? Which had the lowest? What is the mean waiting time in the reception area?  An agenda can set the tone for a meeting. It is an important tool to ensure meetings are staying on track and meeting all of the objectives. Create a detailed meeting agenda for a meeting you will hold with your supervisor and fellow department heads discussing your findings (Hint: Microsoft Word has many agenda templates).  Make sure to include the following in the agenda:  Explain each statistical example How that data would be used The majority of the agenda should be focused on data      analysis and its use in QI plans