During our course we have explored a number of different statistical applications and tools. In this week's forum you are to share how you intend to use one or more of the tools that we have examined in our course. Be specific. Be sure to include a description of the situation, the way in which you will employ the statistical tool you have selected, and provide some commentary about why you think the approach you have selected is appropriate and will prove to be useful. This is your opportunity to consider--and then share--how you will employ the knowledge that you have gained during our course. I look forward to hearing from you.Please keep in mind that my evaluation of your post will be based on the extent to which you participated and fostered a positive and effective learning environment--for yourself and others. Your initial post(6 points) must contain comments regarding the rationale for using the specific statistical tool you have chosen and provide insights as to why that particular tool is appropriate.

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

GB513-1: Illustrate business situations through graphs and tables. This Assignment requires you to use Excel to answer the questions and create the charts as specified in the file below. However, when presenting reports in business, you will find that most managers will prefer to read Word documents or PowerPoint slides rather than go through Excel sheets. Being able to move your work from Excel to Word is a valuable skill. For this Assignment, prepare a report by copying all your charts and comments to a Word document and submit that Word file as your Assignment. Clearly label all questions and charts as well as your answers. Make sure to review your grading Rubric. Using Data Analysis in Excel Before any data analysis can be performed using Excel, the Data Analysis Tool must first be installed on your computer. This will help you to successfully follow this tutorial. Once the tool is installed, you can input data to create descriptive statistics. Follow the steps in the video tutorial and try to get the correct result. Question 1 According to T-100 Domestic Market, the top seven airlines in the United States by domestic boarding in a recent year were Southwest Airlines Co. with 81.1 million, Delta Air Lines Inc. with 79.4 million, American Airlines, Inc. with 72.6 million, United Airlines, Inc. with 56.3 million, Northwest Airlines Corp. with 43.3 million, US Airways with 37.8 million, and Continental Airlines with 31.5 million. Using Excel, construct a pie chart and a bar graph to depict this information. Question 2 The U.S. Department of the Interior releases figures on mineral production. The following are the 15 leading states in nonfuel mineral production in the United States in 2008. State Value ($billions) Arizona 8.95 Nevada 6.48 Florida 4.2 Utah 4.17 California 4 Texas 3.8 Minnesota 3.72 Alaska 2.98 Missouri 2.58 Colorado 2.45 GB513: Business Analytics 2 of 3 Michigan 2.96 Wyoming 2.37 Georgia 2.05 New Mexico 1.81 Pennsylvania 1.68 a) Using the appropriate tool in the data analysis toolpak in Excel, calculate the descriptive statistics. Include the summary statistics table in your report. b) Briefly define the meaning of each of the metrics in the summary report you get. c) Comment on all of the figures in the report. What do you learn from these metrics? What are they telling you about this data set? Is it symmetrical, flat, or skewed? Does it have outliers? Question 3 Suppose Procter & Gamble sells 20 million bars of soap per week, but the demand is not constant and production management would like to get a better handle on how sales are distributed over the year. Let the following sales figures given in units of million bars represent the sales of bars per week over 1-year (in no particular order). a) Construct a histogram chart to represent the data using the appropriate tool from the data analysis tool pack. Make sure to specify your own bin ranges otherwise Excel will automatically pick them for you and you will have very strange bin ranges with confusing decimal points. Make a list of numbers in multiples of 5, starting from 10 up to 40; then, show where the bin numbers are in the histogram dialog box. b) Creating a chart is not useful in and of itself unless it is properly interpreted. Write a brief analysis of the graph. What do you see in the graph that might be helpful to the production and sales people? 17.1 14.3 17 25.2 14.4 12.2 11.9 26.3 15.4 10.9 12.8 13.5 17.4 21.5 39.8 30.6 15 20.4 20.7 25.2 13.8 20.3 21.3 26.2 20.6 13.8 22.5 26.9 18.4 23.6 21.4 32.8 20 19.1 23.4 26.3 20.9 20.4 23.1 26.6 11.1 15.4 14.8 24.3 12.5 20.3 21.4 26.2 14.7 24.4 24 23.8