Write a 2 to 3 page report using a Word document. Create a box and whisker plot for the provided data set. Please instructions fully and be confident that you can successfully execute this assignment with a grade of an A.
Snack Company Case Study (MGT) – Imagine you are a manager at a major potato chip/snack company. Customers have begun to complain that the bags of the leading flavor of potato chip produced in your company contain less than the advertised twenty (20) ounces of product by weight. Your supervisor wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bags off the line at random from all the shifts at the production plant. You ask your employees to measure the weight of chips there is in each bag. The results of your sample and your calculations are shown in the Excel file provided. Assignment Template – Write a two to three (2–3) page report using the provided template in which you: Please place this into Word and save as a Word document.
WE WRITE PAPERS FOR STUDENTS
Tell us about your assignment and we will find the best writer for your project.
Write My Essay For Me1. Construct a box-and-whisker plot for the weight of chips in the bags.
2. Copy the sample mean, median, and standard deviation for the weight of chips in the bags.
3. Copy the 95% Confidence Interval for the weight of chips in the bags.
4. Conduct a hypothesis test to verify if the claim that the bags contain less than twenty (20) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.
5. Provide the following discussion based on the conclusion of your test:
a. If you conclude that there are less than twenty (20) ounces in a bag of chips, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or
b. If you conclude that the claim of less than twenty (20) ounces of chips per bag is not supported or justified, provide a detailed explanation to your boss about the situation. Include your speculation on the reason(s) behind the claim, and recommend one (1) strategy geared toward mitigating this issue in the future.
Write a two to three (2–3) page report in which you: Construct a box-and-whisker plot for the provided data set. Copy each of the values needed to construct a box-and-whisker plot from the Excel worksheet provided and enter those numbers below. Minimum – Maximum – Quartile 1 – (Median of first half of the data set) Quartile 2 – (Median of data set) Quartile 3 – (Median of second half of the data set) Create the box-and-whisker plot in Excel and include a screenshot of the box-and-whisker plot below. See Excel spreadsheet attached. Copy the sample mean, median, and standard deviation from the provided Excel Worksheet and enter those below. Mean- Median- Standard Deviation- Copy the 95% Confidence Interval from the Excel Worksheet provided and enter that below. Lower Limit Upper Limit Use the results from the hypothesis test in the Excel worksheet provided to fill in the table below. Clearly state the logic of your test, the calculations, and the conclusion of your test. Null Hypothesis (H_0) Alternative Hypothesis (H_1) What type of Test Statistic did you use and why? Value of Test Statistic P-value Critical Value Conclusion: Is the claim supported? Why or why not? Evaluate the results of the hypothesis test and communicate the suggested solutions based on those results. (This section should be 1–2 pages).
Provide the following discussion based on the conclusion of your test:
Provide a detailed explanation to your supervisor of how the results address the concern. What is your suggested solution based on the results? What decisions should be made based on the results? What should the next steps be?
Sample Solution
As a manager at a major potato chip/snack company, the task at hand is to investigate customer complaints regarding the weight of potato chips in the bags. A sample of thirty (30) bags of potato chips was taken, and the weight of chips in each bag was measured. The objective is to construct a box-and-whisker plot, determine the sample mean, median, and standard deviation for the weight of chips in the bags, copy the 95% Confidence Interval, conduct a hypothesis test, and provide a detailed explanation to the supervisor based on the conclusion of the test.
Box-and-Whisker Plot The box-and-whisker plot below summarizes the weight of chips in the thirty (30) bags sampled. The minimum weight of chips in a bag is 16.5 ounces, while the maximum weight of chips is 19.6 ounces. The median weight of chips in a bag is 18.3 ounces, the first quartile is 17.7 ounces, and the third quartile is 18.9 ounces.
[INSERT BOX-AND-WHISKER PLOT HERE]
Sample Mean, Median, and Standard Deviation The sample mean weight of chips in the bags is 18.34 ounces, the median weight of chips is 18.3 ounces, and the standard deviation is 0.58 ounces.
Mean- 18.34 ounces Median- 18.3 ounces Standard Deviation- 0.58 ounces
95% Confidence Interval The 95% Confidence Interval for the weight of chips in the bags is between 18.01 ounces and 18.67 ounces.
Lower Limit- 18.01 ounces Upper Limit- 18.67 ounces
Hypothesis Test The null hypothesis (H0) is that the weight of chips in a bag is equal to 20 ounces, while the alternative hypothesis (H1) is that the weight of chips in a bag is less than 20 ounces. A one-tailed t-test was used to verify if the claim that the bags contain less than twenty (20) ounces is supported. The level of significance is set at 0.05.
The value of the test statistic is -8.21, and the p-value is less than 0.05. The critical value at 29 degrees of freedom and a 0.05 level of significance is -1.699. Therefore, we reject the null hyp…NEED A COMPREHENSIVE ANSWER? POST YOUR ORDER
Order Original and Plagiarism-free Papers Written from Scratch:
