Part 1
· Use the data to create a relative frequency table and histogram for all the data. Use .05 as the span of your rows (so you’d have below 83.75, 83.75 < 83.80, and so on.) Talk about the characteristics of the distribution. Visually check the data for a normal distribution or alternative distribution and share your findings.
· Your results from last time showed that none of the sample means were outside of the acceptable range, even though some of the blocks of samples had a number of individual scores that were outside the acceptable range. Explain why you think this occu
ed.
· Last time you found the probability of a number of individual events. This time your boss has asked you what is the combined probability of finding a rope outside of the acceptable range (below 83.75 and above 84.2) for each sample.
Part 2
Based upon all the means being within range, your boss asks you to estimate confidence intervals, at the level of 95% confidence, for all the means you calculated in Project 1. Look at your results and discuss your findings. In particular, address any issues you see with confidence intervals that are outside the acceptable ranges set by quality control.
Part 3
· Conduct hypothesis tests for the following:
· H1: µ ≠ 84
· H1: µ < 84
· H1: µ > 84
· Calculate the hypothesis tests at both alpha levels of .10 and .05. Make sure you state the null and alternative hypotheses.
Part 4
Run a one factor ANOVA that compares the morning and afternoon (before and after lunch) quality samples. Then run a two factor ANOVA that compares the morning and afternoon quality samples on each day of the week (remember these are related populations).
Part 5
After conducting all these tests, analyze your findings to report if there is a problem in the rope manufacturing process. Make recommendations for the company based upon your results.
Submission Instructions
Submit your answers in an excel file with all your formulas. Written responses should be labeled and in a text box.