CompetencyFormulate and evaluate hypothesis tests for population parameters based on sample statistics using both Critical Regions and P-Values, and be able to state results in a non-technical way that can be understood by consumers of the data instead of statisticians.Dealing with Two PopulationsInferential statistics involves forming conclusions about a population parameter. We do so by constructing confidence intervals and testing claims about a population mean and other statistics. Typically, these methods deal with a sample from one population. We can extend the methods to situations involving two populations (and there are many such applications). This deliverable looks at two scenarios.Concept being StudiedYour focus is on hypothesis tests and confidence intervals for two populations using two samples, some of which are independent and some of which are dependent. These concepts are an extension of hypothesis testing and confidence intervals which use statistics from one sample to make conclusions about population parameters.What to SubmitYour research, calculations, and analysis should be presented on the spreadsheet provided.Grading RubricFFCBA01234Not SubmittedNo PassCompetenceProficiencyMasteryNot SubmittedDid not correctly solve a majority of the problems or at least one problem left blank.Correctly solved a majority of the problems.Correctly solved almost all the problems.All problems are solved correctly.Not SubmittedVery few steps are provided to explain how to solve the problem OR the steps provided have several errors.Fairly complete and detailed steps are provided to explain how to solve the problem OR the steps provided have some errors.Mostly complete and detailed steps are provided to explain how to solve the problem.Complete and detailed steps are provided to explain how to solve the problem.Not SubmittedExplanations generally lack a basic understanding of the statistical concepts or lack of proper terminology.Explanations demonstrate a basic understanding of most of the statistical concepts and terminology, but some explanations may be incomplete or incorrect.Explanations demonstrate a proficient understanding of most of the statistical concepts and terminology, but with small errors.Explanations demonstrate a mastery of understanding of the statistical concepts and terminology.Not SubmittedThe majority of variables, equations, and expressions are not properly formatted.The majority of variables, equations, and expressions are properly formatted.Almost all variables, equations, and expressions are properly formatted.All variables, equations, and expressions are properly formatted.

Excel.Chapter 6: problems 6.1a &b; 6.7 a .Chapter 7: problems 7.1a&b; 7.4a & b.Please show your calculations for these problems. Problems attached.

Course Project- Written PortionWelcome to the project. Introduce your scenario and data set.Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.Classify the variables in your data set.Which variables are quantitative/qualitative?Which variables are discrete/continuous?Describe the level of measurement for each variable included in your data set.Discuss the importance of the Measures of Center and the Measures of Variation.What are the measures of center and why are they important?What are the measures of variation and why are they important?Calculate the measures of center and measures of variation. Interpret your results in context of the selected topic.MeanMedianModeMidrangeRangeVarianceStandard DeviationDiscuss the importance of constructing confidence intervals for the population mean.What are confidence intervals?What is a point estimate?What is the best point estimate for the population mean? Explain.Why do we need confidence intervals?Based on your selected topic, evaluate the following:Find the best point estimate of the population mean.Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.Write a statement that correctly interprets the confidence interval in context of your selected topic.Based on your selected topic, evaluate the following:Find the best point estimate of the population mean.Construct a 99% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.Write a statement that correctly interprets the confidence interval in context of your selected topic.Compare and contrast your findings for the 95% and 99% confidence interval.Did you notice any changes in your interval estimate? Explain.What conclusion(s) can be drawn about your interval estimates when the confidence level is increased? Explain.Discuss the process for hypothesis testing.Discuss the 8 steps of hypothesis testing?When performing the 8 steps for hypothesis testing, which method do you prefer; P-Value method or Critical Value method? Why?Perform the hypothesis test.If you selected Option 1:Original Claim: The average salary for all jobs in Georgia is less than $65,000.Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.If you selected Option 2:Original Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.Based on your selected topic, answer the following:Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.Is the test two-tailed, left-tailed, or right-tailed? Explain.Which test statistic will you use for your hypothesis test; z-test or t-test? Explain.What is the value of the test-statistic? What is the P-value?What is the critical value?What is your decision; reject the null or do not reject the null?Explain why you made your decision including the results for your p-value and the critical value.State the final conclusion in non-technical terms.ConclusionRecap your ideas by summarizing the information presented in context of your chosen scenario.Option 1Data set for option 1Option 2Data set for option 2