BUS 4025 – Assignment 7 For these problems,

BUS 4025 – Assignment 7 For these problems, please use Excel to show your work, and submit the Excel spreadsheet along with your completed assignment. For the following problems, state the null and alternate hypothesis, find the chi-square test statistic, decide whether to reject or fail to reject the null hypothesis, and provide your analysis and conclusions. Results from a survey five years ago that asked how long they had to wait in the waiting room to see their doctor. You randomly selected 250 people and asked them how long they had to wait in the waiting room. Can you conclude at sig. of .01 that there has been a change in claimed or expected distribution? Actual Minutes Actual Percentage Survey Result Minutes Survey Result Frequency 1 – 5 14% 1 – 5 21 6 – 10 18% 6 – 10 39 11 – 15 27% 11 – 15 37 16 – 20 15% 16 – 20 53 21 – 25 11% 21 – 25 40 26 – 30 9% 26 – 30 34 31 and over 6% 31 and over 26 Results from a previous survey asked baseball players on a high school team what they needed help with the most in baseball. To determine whether the distribution is the same, a researcher studied 125 randomly selected players and asked them what they needed the most help with. The results are shown below. At a sig. of .05 are the distributions the same? Actual Percentage Survey Result Bunting 11% 18 Batting Approach 38% 33 Strategy 26% 47 Throwing Velocity 25% 27 For the following problems, find the expected frequencies of each cell in the table, perform a chi-square test for independence, and comment on the relationship between the variables. Assume the variables are independent.