For problems involving Analysis of Variance, you must (1) state the type of ANOVA, (2) state the dependent variable, (3) distinguish each causal variable (factor) as fixed or random, (4) present your results in an ANOVA table, (5) explicitly state each null hypothesis that you are testing, and (6) state whether you accept or reject these null hypotheses, (7) include a sentence or two of interpretation.
Mold spores are an important allergen throughout the United States. The spores are produced by fungi that typically grow in damp areas of houses, frequently in the basement. The toxicity of spores can be measured as a continuous variable. A mycologist is interested in whether toxicity varies among houses and whether there is variability between fungal colonies within a house. He randomly selects 12 houses within Lawrence, Kansas. From each house, he collects 3-5 colonies. Each colony is then cultured in the lab and 4 measurements of toxicity are taken for each colony. Perform an appropriate statistical analysis to address the following questions:
(1) What fraction of the total variance in toxicity exists among houses?
(2) What fraction of the total variance in toxicity exists among colonies within houses?
(3) What fraction of the total variance in toxicity is due to other causes?
| House | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 5 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 6 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 7 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 8 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 9 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 10 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 11 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | 12 | | | colony | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | 4 | | 4 | | 4 | | 4 | | 5 | | 5 | | 5 | | 5 | | 1 | | 1 | | 1 | | 1 | | 2 | | 2 | | 2 | | 2 | | 3 | | 3 | | 3 | | 3 | | | sample | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | 1 | | 2 | | 3 | | 4 | | | toxicity | | 9.298 | | 8.8321 | | 10.151 | | 11.9695 | | 12.5622 | | 13.1564 | | 12.8354 | | 12.7085 | | 13.8574 | | 13.6735 | | 13.9577 | | 14.014 | | 19.6143 | | 12.1099 | | 11.1607 | | 14.3877 | | 9.6303 | | 11.5251 | | 13.5257 | | 13.2456 | | 11.5212 | | 16.6228 | | 13.449 | | 12.8039 | | 8.9916 | | 14.0592 | | 11.734 | | 18.3754 | | 16.6488 | | 12.7427 | | 15.247 | | 13.7793 | | 15.4971 | | 10.9496 | | 15.395 | | 15.4436 | | 13.6633 | | 8.5723 | | 11.5221 | | 13.753 | | 12.3472 | | 11.8054 | | 12.7951 | | 10.2802 | | 14.6209 | | 9.3425 | | 17.6556 | | 14.0799 | | 11.1747 | | 14.0067 | | 10.0835 | | 13.7145 | | 12.7371 | | 8.7069 | | 12.9197 | | 10.2389 | | 13.2238 | | 15.1896 | | 14.0563 | | 13.9206 | | 15.2879 | | 14.7543 | | 17.5757 | | 16.4506 | | 12.8807 | | 15.8013 | | 13.3892 | | 15.4365 | | 13.5821 | | 10.0251 | | 8.6979 | | 11.7054 | | 8.6632 | | 14.8384 | | 10.4613 | | 11.172 | | 11.0196 | | 15.6936 | | 11.4945 | | 12.4015 | | 11.8484 | | 12.7177 | | 13.7413 | | 16.9046 | | 14.727 | | 16.5471 | | 15.6806 | | 13.398 | | 14.0476 | | 13.5422 | | 10.2526 | | 11.5225 | | 11.0306 | | 14.2919 | | 15.3419 | | 15.0655 | | 10.0176 | | 11.8189 | | 9.53 | | 13.3368 | | 13.3577 | | 12.4494 | | 12.2015 | | 13.8225 | | 11.8399 | | 12.8012 | | 19.0153 | | 11.4946 | | 18.0754 | | 8.6662 | | 10.1189 | | 7.8228 | | 7.5518 | | 11.5254 | | 8.6214 | | 6.7189 | | 4.1149 | | 6.7526 | | 5.0211 | | 6.251 | | 3.5414 | | 7.9716 | | 4.5155 | | 6.3223 | | 7.3432 | | 8.1353 | | 5.8623 | | 4.4216 | | 7.916 | | 7.7745 | | 7.2963 | | 8.4648 | | 10.1527 | | 9.4531 | | 5.973 | | 8.1629 | | 5.9986 | | 6.7521 | | 5.0924 | | 4.2639 | | 4.5311 | | 6.4798 | | 4.6597 | | 5.3074 | | 8.6838 | | 0.2127 | | 3.5381 | | 7.5896 | | 3.3183 | | 8.2087 | | 6.2731 | | 7.7664 | | 10.5198 | | 8.8524 | | 5.4754 | | 9.3287 | | 8.6138 | | 8.0518 | | 6.7825 | | 3.8927 | | 4.9189 | | 5.1434 | | 6.4783 | | 7.3827 | | 4.325 | | 3.3353 | | 3.5781 | | 6.2514 | | 5.5349 | | 8.1731 | | 8.0694 | | 6.2324 | | 7.8887 | | 9.121 | | 5.855 | | 7.1001 | | 7.6603 | | 7.842 | | 9.5557 | | 6.2851 | | 4.0366 | | 7.4916 | | 7.1382 | | 3.9934 | | 6.2179 | | 6.5281 | | 10.0345 | | 11.0995 | | 10.5485 | | 9.2001 | | 10.1601 | | 11.9453 | | 11.7117 | | 7.1942 | | 6.4935 | | 2.9066 | | 8.2559 | | 9.7269 | | 5.5186 | | 7.7939 | | 7.8775 | | 6.4918 | | 4.8564 | | 5.3798 | | 9.6104 | | 4.5269 | | 13.0787 | | 12.5245 | | 10.1599 | | 5.841 | | 3.6059 | | 8.1057 | | 7.8589 | | 7.8185 | | 9.7366 | | 5.5255 | | 9.0103 | | 6.8941 | | |
please send the excel file at - naarbhaiya@gmail.com.
I am unable to copy the data in excel. And its time taking to write all the data manually in excel. So, please send me the file so that I can solve it.