Due 04/28/2021Now that you have identified the business problem, translated it into an analytics problem, identified the data needs, and acquired the data, you will use data that you have found (or with the company's permission you can use its data for analysis) to resolve the analytics problem. Using one or more of the following software applications (IBM SPSS Modeler, SPSS Statistics, Excel, PowerBI, Tableau, or R), analyze the data so that the findings can be used to address the established business problem in your company.Conduct an exploratory data analysis and provide a draft outline describing the key features of the data and any significant relationships and information contained in the data set that you found. You are required to include specific screenshots of graphs, tables, etc., that are provided:How did you verify that the data was reliable before proceeding?What problems did you find and how did you address them?What relationships did you find in the data?Are there any missing data?How are you going to summarize data samples?Analyze trends with respect to any appropriate characteristics that you may have discovered. Include relevant line graphs, pie charts, bar charts, and scatter plots.What have you done to prevent the Simpson’s paradox?Next, you will work on a descriptive analytics. Supplement your description with appropriate charts/figures and finalize by creating an appropriate dashboard with PowerBI or Tableau. Include a summary that provides a detailed overview of the data behavior you have identified based upon the analysis. Indicate any causal relationships you found.Segment the data accordingly, if needed, to help describe the data behavior. Did you have to redo your sample? Can you identify any data anomalies? If there are anomalies, what do they represent and how do you avoid them?Indicate the steps you have taken to investigate the quality of the data and indicate any variables you have transformed or discarded as a result. Provide the raw software files (Tableau or PowerBI) that you used for this assignment.Then, synthesize the information from your draft outline to complete, in 1,500–2,000 words, the relevant components in the Data Diagnostics and Descriptive Summary section of the "Capstone Project Thesis Template."Assignment Submission Needs:- draft outline- raw data Excel files- screenshots- updated Data Diagnostics and Descriptive Summary section of the "Capstone Project Thesis Template."Separate Questions for reflection:Due 04/24/2021 Question 1- Reflect on collection of data, data cleansing and preparation activities, and selection and application of models, including challenges/struggles, procedures, approach, etc. How do you know that the data you are collecting will be useful? Due 04/26/2021 Question 2- When summarizing your data, how did you decide which visualization tool you would use to best communicate this information (bar graph or line graph)?

This is a Case Study which need you to finish 4 questions in the end of second picture and third picture. You must familiar with Quantitative approaches to decision. All answers need to be calculated and need to show in the ONE EXCEL FILE.

Develop simulation model for a PERT/CPM assignment based on problem 14 from chapter 11. Use the attached template (it has probability distributions of duration of activities A through D that you should consider) and perform 120 recalculations/trials using the Data Table feature of Excel. Calculate the following summary statistics:the estimate of the average length (duration) of the projectthe standard deviation of the project length (duration)minimum, maximum and range of the project length (duration)Calculate the probability that the project will be completed in 36 weeks or less.Display summary statistics and the probability of project completion in 36 weeks or less ON TOP OF THE SHEET.On a separate sheet (rename it PERT_chart) create a histogram showing frequency distribution of project length (duration).