CompetencyGiven a real-life application, develop a hypothesis test for a population parameter and its interpretation.InstructionsScenario (Information repeated for deliverable 01, 03, and 04)A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:A listing of the jobs by titleThe salary (in dollars) for each jobIn prior engagements, you have already explained to your client about the basic statistics and discussed the importance of constructing confidence intervals for the population mean. Your client says that he remembers a little bit about hypothesis testing, but he is a little fuzzy. He asks you to give him the full explanation of all steps in a hypothesis testing and wants your conclusion about a claim that the average salary for all jobs in the state of Minnesota is less than $75,000.Background information on the DataThe data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.What to SubmitYour boss wants you to submit the spreadsheet with the completed calculations. Your research and analysis should be present within the answers provided on the worksheet.

In this week, you will explore probability as it relates to an observed occurrence. You also will explore the concept of the sampling distribution as well as confidence intervals of specific data. Finally, you explore the results of data to determine implications for social change. Learning Resources Required Readings Frankfort-Nachmias, C., Leon-Guerrero, A., & Davis, G. (2020). Social statistics for a diverse society (9th ed.). Thousand Oaks, CA: Sage Publications. Chapter 5, “The Normal Distribution” (pp. 151-177) Chapter 6, “Sampling and Sampling Distributions” (pp. 179-209) Chapter 7, “Estimation” (pp. 211-240) Wagner, III, W. E. (2020). Using IBM® SPSS® statistics for research methods and social science statistics (7th ed.). Thousand Oaks, CA: Sage Publications. Chapter 3, “Selecting and Sampling Cases” Chapter 5, “Charts and Graphs” Chapter 11, “Editing Output” Magnusson, K. (n.d.). Welcome to Kristoffer Magnusson’s blog about R, Statistics, Psychology, Open Science, Data Visualization [blog]. Retrieved from http://rpsychologist.com/index.html As you review this web blog, select the Interpreting Confidence Intervals – new d3.js visualization link, once you select the link, follow the instructions to view the interactive for confidence intervals. This interactive will help you to visualize and understand confidence intervals. Note: This is Kristoffer Magnusson’s personal blog and his views may not necessarily reflect the views of Walden University faculty. Walden University Library. (n.d.). Course Guide and Assignment Help for RSCH 8210. Retrieved from http://academicguides.waldenu.edu/rsch8210 For help with this week’s research, see this Course Guide and related weekly assignment resources. Datasets Your instructor will post the datasets for the course in the Doc Sharing section and in an Announcement. Your instructor may also recommend using a different dataset from the ones provided here. Optional Resources Rice University, University of Houston Clear Lake, and Tufts University. (n.d.). Online Statistics Education: An Interactive Multimedia Course of Study. Retrieved from http://onlinestatbook.com/2/estimation/ci_sim.html Use this website for your practice as you consider confidence intervals and how the width changes. Also, consider why the width might be important. Skill Builders: Confidence Intervals Sampling Distributions To access these Skill Builders, navigate back to your Blackboard Course Home page, and locate “Skill Builders” in the left navigation pane. From there, click on the relevant Skill Builder link for this week. You are encouraged to click through these and all Skill Builders to gain additional practice with these concepts. Doing so will bolster your knowledge of the concepts you’re learning this week and throughout the course. Discussion: The Importance of Relationships As its name implies, confidence intervals provide a range of values, along with a level of confidence, to serve as an estimate of some unknown population value. Since it is rare to have access to the entire population, you must frequently rely on the confidence interval of the sample to make some inference about the population of interest. Before making accurate inferences to the population, we need to fully understand how the three key components of the interval—variability in the data, sample size, and confidence level—impact the width of the interval. For this Discussion, you will explore the relationship between these components and understand the trade-off between reducing risk in our confidence of estimates and increasing precision. To prepare for this Discussion: Review Chapters 6 and 7 of the Frankfort-Nachmias & Leon-Guerrero text and in Chapter 7, p. 188, consider Hispanic migration and earnings and focus on how different levels of confidence and sample size work together. Review Magnusson’s web blog found in the Learning Resources to further your visualization and understanding of confidence intervals. Use the Course Guide and Assignment Help found in this week’s Learning Resources to search for a quantitative article related to confidence intervals. Using the SPSS software, General Social Survey dataset and choose a quantitative variable that interests you. Using SPSS: Take a random sample of 100. Calculate the 95% confidence interval for the variable. Calculate a 90% confidence interval. Take another random sample of 400. Calculate the 95% confidence interval for the variable. Calculate a 90% confidence interval. Post your results, the mean of Age to verify the dataset you used, and an explanation of how different levels of confidence and sample size affect the width of the confidence interval. Next, consider the statement, “Confidence intervals are underutilized” and explain what the implications might be of using or not using confidence intervals. Provide examples based on the results of your data. Also, use your research to support your findings.

Final Project: Regression and Correlation Analysis Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following. The week 6 spreadsheet can be helpful in this work.Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret.Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable.Determine the correlation coefficient. Interpret.Determine the coefficient of determination. Interpret.Test the utility of this regression model by completing a hypothesis test of b=0 using α=0.10. Interpret results, including the p-value.Based on the findings in steps 1-5, analyze the ability of the independent variable to predict the dependent variable.Compute the confidence interval for b, using a 95% confidence level. Interpret this interval.Compute the 99% confidence interval for the dependent variable, for a selected value of the independent variable. Each student can choose a value to use for the independent variable (use same value in the next step). Interpret this interval.Using the same chosen value for part (8), estimate the 99% prediction interval for the dependent variable. Interpret this interval.What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.Describe a business decision that could be made based on the results of this analysis. In other words, how might the business operations change based on these statistical results.All DeVry University policies are in effect, including the plagiarism policy.Final Project report is due by the end of Week 7.Final Project is worth 130 total points. See grading rubric below.Summarize your results from Steps 1-11 in a 3-page report. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.Submission: The Word document, summary report should be submitted for questions 1-11. The Excel output can be included as an appendix, if needed.Format for report:Summary ReportSteps 1-11 addressed with appropriate output, graphs and interpretations. Be sure to number each step 1-11.