word file contain Questionsexcel file contain statistics dataRequired: from 200 - 300 words essay answering Questions

Testing for Correlation and Bivariate RegressionAs you begin the Assignment, be sure and pay close attention to the assumptions of the test. Specifically, make sure that your variables are metric level variables that can easily be interpreted in these tests.For this Assignment, you will examine correlation and bivariate regression testing.To prepare for this Assignment:Review this week’s Learning Resources and media program related to regression and correlation.Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you choose) found in the Learning Resources for this week.Based on the dataset you chose, construct a research question that can be answered with a Pearson correlation and bivariate regression.Once you perform your correlation and bivariate regression analysis, review Chapter 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 correlation and bivariate regression results for each research question. 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. Do not forget to evaluate if the correlation and bivariate regression assumptions are met and report the effect size. In your analysis, display the data for the output. Based on your results, provide an explanation of what the implications of social change might be.Use proper APA format, citations, and referencing for your analysis, research question, and display of output.

Submit a paper and a spreadsheet that provides a justification of the appropriate statistical tools needed to analyze the company’s data, a hypothesis, the results of your analysis, any inferences from your hypothesis test, and a forecasting model that addresses the company’s problem. For additional details, please refer to the Milestone Two Guidelines and Rubric document in the Assignment.Guidelines and Rubrics section of the course. Milestone 2: Guidelines and RubricThe final project for this course is the creation of a statistical analysis report Operations management professionals are often relied upon to make decisions regarding operational processes. Those who utilize a data driven, structured approach have a clear advantage over those offering decisions based solely on intuition.You will be provided with a scenario often encountered by an operations manager.Your task is to review the “A Cat Corp.: Forecasting” scenario, theaddendum, and the accompanying data in the case scenario and addendum.In Module Seven,you will submit your selection of statistical tools and data analysis,which are critical elements III and IV. You will submit a 3 to 4 page paper and a spreadsheet that provides justification for the appropriate statistical tools needed to analyze the company’s data, a hypothesis, the results of your analysis, any inferences from your hypothesis test, and a forecasting model that addresses the company’s problem.Specifically the following critical elements must be addressed: III.Identify statistical tools and methods to collect data:A.Identify the appropriate family of statistical tools that you will use to perform your analysis. What are your statistical assumptions concerning the data that led you to selecting this family of tools? In other words, why did you select this family of tools for statistical analysis? B.Determine the category of the provided data in the given case study. Be sure to justify why the data fits into this category type. What is the relationship between the type of data and the tools?C.From the identified family of statistical tools, select the most appropriate tool(s) for analyzing the data provided in the given case study.D.Justify why you chose this tool to analyze the data. Be sure to include how this tool will help predict the use of the data in driving decisions.E.Describe the quantitative method that will best inform data driven decisions. Be sure to include how this method will point out the relationships between the data. How will this method allow for the most reliable data?IV.Analyze data to determine the appropriate decision for the identified problem:A.Outline the process needed to utilize your statistical analysis to reach a decision regarding the given problem.B.Explain how following this process leads to valid data driven decisions In other words, why is following your outlined process important?C.After analyzing the data sets in the case study, describe the reliability of the results.Be sure to include how you know whether the results are reliable.D.Illustrate a data driven decision that addresses the given problem. How does your decision address the given problem? How will it result in operational improvement?Guidelines for Submission:Your paper must be submitted as a 3to 4 page Microsoft Word document and attached spreadsheet with double spacing, 12 point Times New Roman font, one inch margins, and at least six sources cited in APA format.***See addendum above2 hours agoATTACHMENTS