Identify statistical tools and methods to collect data:1.Identify the appropriate family of statistical tools that you will use to perform your analysis. (The details concerning the statistical tools must include the methods, and particularly the statistical assumptions of the statistical tools and the category of data). 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? 2 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. 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? Analyze data to determine the appropriate decision for the identified problem:1.Outline the process needed to utilize your statistical analysis to reach a decision regarding the given problem. .Explain how following this process leads to valid, data-driven decisions. In other words, why is following your outlined process important? 2.Thoroughly addressed the requirements given in the addendum using all the data given in addendum and the A-Cat Corp.: Forecasting document including the use of descriptive statistics, a one-sample t-test, ANOVA, and regression analysis equation as the model for forecasting transformer requirements. 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. 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? Recommend operational improvements to stakeholders: Summarize your analysis plan for both internal and external stakeholders. Be sure to use audience-appropriate jargon when summarizing for both groups of stakeholders. Explain how your decision addresses the given problem and how you reached that decision. Be sure to use audience appropriate jargon for both groups of stakeholders. Justify why your decision is the best option for addressing the given problem to both internal and external stakeholders and how it will result in operational improvement. Be sure to use audience-appropriate jargon when communicating with stakeholders. Requirements: You will submit a 3-to 4-page paper and a spreadsheet that provides justification of the appropriate statistical tools that are needed to analyze the company’s data, a hypothesis, the results of your analysis, any references from your hypothesis test, and a forecasting model that addresses the company’s problem and your recommendations to management (6) APA sources is required.

Fully answer each questions. Throughly display all work for each problem. If you have any question, let me know.

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