please complete ANOVA 1: degrees of freedom for Error 2: degrees of freedom for Total 3: SSG, SST, MSG 4: P-value within the accuracy of the tables (i.e. an interval, 0.05 < p-value < 0.1

solve for image  and find critical values

The Cardiac Care Network in Ontario, Canada, wants to determine whether the wait for by- pass surgery is longer than the wait for angiography. A sample of 539 bypass patients waited, on average, 19 days with standard deviation 10 days; a sample of 847 angiography patients waited, on average, 18 days with standard deviation 9 days. What kind of a test should CCN perform? z-interval to estimate the difference in two proportions t-interval to estimate the difference in two means Chi-square test for association t-test for the difference in two means z-test for the difference in two proportions ANOVA

*PLEASE show in excel A different investigator conducts a second study to investigate whether there is a difference in mean PEF in children with chronic bronchitis as compared to those without.  Data on PEF are collected and summarized below.  Based on the data, is there statistical evidence of a lower mean PEF in children with chronic bronchitis as compared to those without?  Run the appropriate test at a=0.05.    Group Number of Children Mean PEF Std Dev PEF   Chronic Bronchitis 25 281 68   No Chronic Bronchitis 25 319 74           Step 1. Set up hypotheses and determine level of significance.   Ho:         H1:         alpha:                   Step 2. Select the appropriate test statistic and give its formula.                                           Step 3. Set up decision rule.                             Step 4. Compute the test statistic                                               Step 5. Conclusion.