Question: The company realized that they had a problem, so they started collecting more data to determine the potential causes of the variation in hold times. After completing a process map, the process improvement team thought that the hold time was influenced by whether there were two (rather than one) of the five technical assistants working had 3 months or less of experience. It has been the policy of the company for many years that no more than one of the five person team could have less than 3 months experience. When they looked at the times that were above the upper spec limit, 75% of the excessive times were when 2 or more "new" people were working. They were able to demonstrate this by creating a bar chart where the categories along the x-axis were for the number of "new" people working and the count of excessive times were tallied.

The next question was to determine the conditions when there were long hold times. One team member suggested that he thought the excessive hold times were related to the weather conditions across the nation. So the team went back in time and collected data over the last 30 months of operation. They collected the data on the hold times versus the proportion of the country that had severe weather. The data is in columns labeled ‘Hold Times’ and ‘Weather’. How much of the variation in hold times is due to weather conditions? What is the regression equation? Does it appear that the weather has an impact on hold times at a significance level of 5%? Validate your answer and include the appropriate output.

Price: $2.99

Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document