Complete the following questions please, check the questions and the file attached

Option #2: Quality of Cerámica América SinksCerámica América makes both commercial and home sinks, toilets, and tile throughout Latin America. There have been many complaints that its commercial sinks are of poor quality. Recently, a new type of home sink, Modelo Americano, has been developed. The company hopes that this new model is of better quality. Quality Control tests sinks using the following three tests:Cracked or Chipped Ceramic:Pass (P) or Fail (F)Glaze Quality:Pass (P) or Fail (F)Stress TestPass (P) or Fail (F)A sink gets a “Passing” grade if it passes all three of the above Traditionally, 85% of its commercial sinks have gotten a “Passing” grade. Cerámica América would like to see if its passing rate is better than the traditional rate. Recently, 200 Modelo Americano sinks were randomly chosen from its manufacturing plants. The complete data set is in the file named Sinks.Managerial ReportPrepare a report (see below) for Cerámica América that summarizes your assessment of its Modelo Americano sinks. Be sure to include the following seven items in your report.To summarize the data, compute the proportion of all sinks that“Passed” the Cracked or Chipped test.“Passed” the Glaze Quality test.“Passed” the Stress Test.Develop the 98% confidence interval for the proportion of all Modelo Americano sinks that got a “Passing” grade.Develop the 98% confidence interval for the proportion of all Modelo Americano sinks that passed the Cracked or Chipped test.Develop the 98% confidence interval for the proportion of all Modelo Americano sinks that passed the Glaze Quality test.Develop the 98% confidence interval for the proportion of all Modelo Americano sinks that passed the Stress Test.Conduct a hypothesis test (using either the p-Value Approach or the Critical Value Approach) to determine if the proportion of all Modelo Americano sinks that get a “Passing” grade is larger than the than the traditional “Passing” rate. Use α = 0.02. Do not forget to include the correctly worded hypotheses and show all the steps required to conduct the hypothesis test.What advice would you give to Cerámica América based upon your analysis of the data? What is the magnitude of the improvement (if any)? How can this study be improved?Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics. (link provided at the bottom of the page)Submit your Excel file in addition to your report.Requirements:Paper must be written in third person.Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library is a great place to find resources.Include a title page, introduction, body, conclusion, and a reference page.The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.Document formatting, citations, and style should conform to the CSU-Global Virtual Library CSU-Global Guide to Writing and APA: Introduction. A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper. In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).