Place the following data in Sheet 1. Seven types of root-stock were used in an apple orchard grafting experiment. The following data represent the extensions growth (cm) after four years. Test the claim that the mean growth is the same for all types of root-stock. Write hypothesis steps. Use Excel 1-way ANOVA test to find the test value and p-value. Place the output on the same sheet as the data.
Crop 1 Crop 2 Crop 3 Crop 4 Crop 5 Crop 6 Crop 7
2569 2074 2505 2838 1532 2569 3447
2928 2885 2315 2351 2552 2074 3085
2865 3378 2667 3001 3083 2505 3308
3844 3906 2390 2439 2330 2838 3291
3027 2782 3021 2199 2079 1532 3366
2336 3018 3231 3318 2945 2416 3100
3211 3383 3140 3601 2610 1990 3037
In Sheet 2: Use the Excel directions below to make a scatter plot for the Temperature in Fahrenheit and the number of cricket chirps per sec. Find the Best Fit Line using Excel. State what the slope means with respect to the problem.
Temp 88.6 71.6 93.3 84.3 80.6 75.2 69.7 82 69.4 83.3 79.6 82.6 80.6
Chirps 20 16 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15 17.2 16