I can not for the life of me figure out what I'm doing wrong with Tukey HSD. I provided the Q table I have been given at the bottom as well.

Here I need help with 4-b

8 Exercise 13-41 Static 3.33 First National Bank employs three real estate appraisers whose job is to establish a property's market value before the bank offers a points mortgage to a prospective buyer. It is imperative that each appraiser values a property with no bias. Suppose First National Bank wishes to check the consistency of the recent values that its appraisers have established. The bank asked the three appraisers to value (in $1,000s) three different types of homes: a cape, a colonial, and a ranch. The accompanying table shows the results. Assume that values are normally distributed. (You may find it useful to reference the q table. Appraiser_1 Appraiser_2 Appraiser_] Cape 415 Colonial 530 550 540 Ranch 390 400 380 picture Click here for the Excel Data File a-1. Construct an ANOVA table. (Leave no cells blank. Round "SS" and "MS" to 2 decimal places, and "F' and "p-value" to 3 decimal places.) Answer is complete and correct. ANOVA Source of Variation af MS p-value Rows 37,222.22 20 18,611.11 167.500 0.000 Columns 72.22 20 36.11 0.325 D.740 Error 444.44 40 111.110 Total 37,738.88 a-2. At the 5% significance level, can you conclude that the average values differ by appraiser? O Yes, since the p-value associated with appraiser is less than significance level. O Yes, since the p-value associated with appraiser is greater than significance level. O No, since the p-value associated with appraiser is less than significance level. No, since the p-value associated with appraiser is greater than significance level. a-3. Should the bank be concerned with appraiser inconsistencies? O Yes O No O b. At the 5% significance level, can you conclude that the average values differ by house type? Yes, since the p-value associated with house type is less than significance level. O Yes, since the p-value associated with house type is greater than significance level. O No, since the p-value associated with house type is less than significance level. O No, since the p-value associated with house type is greater than significance level. c. If average values differ by house type, use Tukey's HSD method at the 5% significance level to determine which averages differ. (If the exact value for a, - c is not found in the table, use the average of corresponding upper & lower studentized range values. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) * Answer is complete but not entirely correct. Population Does the Confidence Interval Average Differences Differ? HI - H2 BB.00 142.00 1 Yes 48.67 6 5.34 0 Yes H2 - H. -163.67. -109.66 1 Yes06 X V fx A B C D E F G H K M N O Appraiser_1 Appraiser_2 Appraiser_3 N Cape Cod 425 415 430 423.3333 Colonial 530 550 540 540 Anova: Two-Factor Without Replication Ranch 390 400 380 390 5 SUMMARY Count Sum Average Variance 6 Cape Cod 3 1270 423.3333 58.33333 7 Colonial W 1620 540 100 8 Ranch W 1170 390 100 9 10 Appraiser_: W 1345 448.3333 5308.333 11 Appraiser_ W 1365 455 6825 12 Appraiser 3 1350 450 6700 13 14 15 ANOVA 16 Source of Variat SS df MS F P-value F crit 17 Rows 37222.22 2 18611.11 167.5 0.000139 6.944272 18 Columns 72.22222 2 36.11111 0.325 0.73997 6.944272 19 Error 444.4444 4 111.1111 20 21 Total 37738.89 8 22 23 24 25 26 27Check my work mode : This shows what Is correct or Incorrect for the work you have completed so fa 3,33 The following output summarizes the results for a one-way analysis ofvariance experiment in which the treatments were three palms different hybrid cars and the variable measured was the miles per gallon (mpg) obtained while driving the same route. (You may find it useful to reference the g table.) Exercise 13-23 Algo Hybrid 1: XI = 33, n1 = 20 Hybrid 2: 2 = 45, n2 = 15 Hybrid 3: 23 = 39, n; = 18 Source of variation .93 df MS F pValue Between Groups 1,080.89 2 540.45 20.48 0.0000 Within Groups 1:319.63 50 26.39 Total 2,400.52 52 a. At the 5% significance level, can we conclude that average mpg differs between the hybrids? Yes. since the pvalue is less than the significance level. 9 Yes. since the pvalue is not less than the significance level. No.5ince the pvalue is less than the significance level. No.5ince the pvalue is not less than the significance level. b. Use Tukey's HSD method at the 5% significance level to determine which hybrids' means differ. (If the exact value for an. - cis not found in the table, then round down. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) 0 Answer is complete but: not: entirely correct. Population Men Can we conclude that the Condence Interval hybrids' means differ? 'Fz Route 1 Route 2 Route 3 Anova: Single Factor 29 27 25 30 32 27 SUMMARY 33 28 24 Groups Count Sum Average Variance 30 30 29 Route 1 154 30.8 2.7 32 29 26 Route 2 5 146 29.2 3.7 Route 3 131 26.2 3.7 30.8 29.2 26.2 ANOVA Source of Variat SS df MS F P-value F crit Between G1 54.53333 2 27.26667 8.09901 0.00594 3.885294 Within Gro 40.4 12 3.366667 Total 94.93333 14\fCheck my work mode This shows what ls correct or Incorrect for the work you have completed so f does not Indicate completion. 12 Exercise 13-57 Static 3.33 An employee ofa small software company in Minneapolis bikes to work during the summer months. He can travel to work using one of points three routes and wonders whether the average commute times (in minutes) differ between the three routes. He uses each route for one week and records the commute times. The sample information is in the accompanying data file. lh'picture Click here for the Excel Data File a-1. Construct an ANOVA table. (Leave no cells blank. Round \"55' and "MS" to 2 decimal places, and "F' and "p-value\" to 3 decimal places.) 0 Answer is complete and correct. ANOVA Source of Variation SS of MS F p-value Between Groups 54.53 9 2 9 27.27 9 8.099 9 0.006 9 Within Groups 40.40 0 12 o 3.37 9 a-2. At the 1% significa nce level, do the average commute times differ between the three routes. Assume that commute times are normally distributed. Yes, since the pvalue is less than significance level. 0 Yes, since the p-value is not less than significance level. No, since the pvalue is less than signicance level. No, since the pvalue is not less than significance level. b. Use Tukey's HSD method at the 1% significance level to determine which routes' average times differ. (You may nd It useful to reference the gtabie. If the exact value for n, a is not found In the table, use the average of corresponding upper & lower studentized range values. Negative values should be indicated by a min us sign. Round your answers to 2 decimal places.) 8 Answer is not: complete. Population Mean Do the average Condence Interval Difference times ditfer? \"Route 1 ' FRauis 2 [ . ] N0 9 \"Route 1 ' \"Route 3 i . ] Yes 0 \"Route 2 ' FRauis 3 [ . ] N0 9 Next > %