using excel data analyis tool for two way anova woithout replication
a-1
Anova: Two-Factor Without Replication | |||||
SUMMARY | Count | Sum | Average | Variance | |
Row 1 | 3 | 212 | 70.66666667 | 276.3333333 | |
Row 2 | 3 | 208 | 69.33333333 | 145.3333333 | |
Row 3 | 3 | 214 | 71.33333333 | 81.33333333 | |
Row 4 | 3 | 216 | 72 | 169 | |
Row 5 | 3 | 216 | 72 | 256 | |
Column 1 | 5 | 357 | 71.4 | 3.8 | |
Column 2 | 5 | 288 | 57.6 | 11.3 | |
Column 3 | 5 | 421 | 84.2 | 10.2 | |
ANOVA | |||||
Source of Variation | SS | df | MS | F | P-value |
Rows | 14.9333 | 4 | 3.7333 | 0.346 | 0.8397 |
Columns | 1769.7333 | 2 | 884.8667 | 82.059 | 0.0000 |
Error | 86.2667 | 8 | 10.7833 | ||
Total | 1870.9333 | 14 |
b)
Level of significance | 0.05 |
Numerator d.f. | 3 |
Denominator d.f. | 8 |
MSE | 10.7833 |
q-statistic value | 3.7728 |
critical value = q*√(MSE/2*(1/ni+1/nj))
confidence interval = mean difference ± critical
value
if confidence interval contans zero, then means are not
different.
confidence interval | |||||||
population mean difference | critical value | lower limit | upper limit | result | |||
µ1-µ2 | 13.800 | 5.9344 | 7.866 | 19.734 | means are different | ||
µ1-µ3 | -12.800 | 5.9344 | -18.734 | -6.866 | means are different | ||
µ2-µ3 | -26.600 | 8.3926 | -34.993 | -18.207 | means are different |
CH13 Q7 Given a recent outbreak of illness caused by E. coli bacteria, the mayor in...
CH13 Q7 Given a recent outbreak of illness caused by E. coli bacteria, the mayor in a large city is concerned that some of his restaurant inspectors are not consistent with their evaluations of a restaurant's cleanliness In order to investigate this possibility, the mayor has five restaurant inspectors grade (scale of O to 100) the cleanliness of three restaurants. The results are shown in the accompanying table. (You may find it useful to reference the g table.) Restaurant Inspector...
6 Given a recent outbreak of illness caused by E. coli bacteria, the mayor in a large city is concerned that some of his restaurant inspectors are not consistent with their evaluations of a restaurant's cleanliness. In order to investigate this possibility, the mayor has five restaurant inspectors grade (scale of O to 100) the cleanliness of three restaurants. The results are shown in the accompanying table. (You may find it useful to reference the g table.) 12.5 Restaurant Inspector...
Given a recent outbreak of illness caused by E. coli bacteria, the mayor in a large city is concerned that some of his restaurant inspectors are not consistent with their evaluations of a restaurant's cleanliness. In order to investigate this possibility, the mayor has five restaurant inspectors grade (scale of O to 100) the cleanliness of three restaurants. The results are shown in the accompanying table. (You may find it useful to reference the q table.) Restaurant Inspector 72 68...
Exercise 13-39 Static Given a recent outbreak of illness caused by E. coli bacteria, the mayor in a large city is concerned that some of his restaurant inspectors are not consistent with their evaluations of a restaurant's cleanliness. In order to investigate this possibility, the mayor has five restaurant inspectors grade (scale of 0 to 100) the cleanliness of three restaurants. The results are shown in the accompanying table. (You may find it useful to reference the g table.) Restaurant...
First National Bank employs three real estate appraisers whose job is to establish a property's market value before the bank offers a 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...
CH13 Q2 a. Given the following information obtained from four normally distributed populations, construct an ANOVA table. (Round intermediate calculations to at least 4 decimal places. Round "SS" to 2 decimal places, "MS" to 4 decimal places, and "F' to 3 decimal places.) ANOVA Source of Variation Between Groups Within Groups Total df MS p-value 0.018 0.00 0
CH13 Q10 A consumer advocate examines whether the longevity of car batteries (measured in years) is affected by the brand name (factor A) and whether or not the car is kept in a garage (factor B). Interaction is suspected. The results are shown in the accompanying table Brand Name of Batter Kept in Garage? Yes No 7, 8, 6 7, 6, 7 9, 7, 10 7, 7, 6 5, 4, 5 6, 6, 6 he a-1. Construct an ANOVA table....
CH13 Q3 The following statistics are computed by sampling from three normal populations whose variances are equal: (You may find it useful to reference the t table and the g table.) a. Calculate 99% confidence intervals for μ 1-2, μ1-#3, and μ2-#3 to test for mean differences with Fisher's LSD approach. (Negative values should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places. Round your answers to 2 decimal places.) Population Mean Differences Can...
CH13 Q4 The following statistics are calculated by sampling from four normal populations whose variances are equal: (You may find it useful to reference the t table and the g table.) r1 = 137, n1 = 4; Tz = 144, n2 = 4; = 136, n3 = 4; T4 = 124, n4 = 4; MSE = 57.4 a. Use Fisher's LSD method to determine which population means differ at a- 0.01. (Negative values should be indicated by a minus sign....
A one-way analysis of varlance experlment produced the following ANOVA table. (You may find it useful to reference the g table). SUMMARY Count Groups Column 1 Column 2 olumn 3 Source of Variation Between Groups Within Groups Total Average 8.89 1.31 2.35 SS 8.65 df 15 17 MS 4.33 0.26 16.65 8.6882 12.48 a. Conduct an ANOVA test at the 1% significance level to determine if some population means differ. o Reject Ho, we can conclude that some population means...