requirement: code in sas excel data

\"HE: LLILII'uy, pl'll AA UII. DlChUUl'u 1. An investigator is interested in determining which factors affect germination rate in a new variety of cilantro seed. Five factors {14: amount of light per day, B: soil type, C: amount of water per day, D: temperature, and E: mulch type), each with two levels, are considered. An experiment with a 2""1 fractional factorial design is performed. Briey. 15 large planters are randome assigned to the treatments listed in the rst column in the table on the left below. 111 each potI 101] randome selected cilantro seeds are planted (in the assigned soil type) and subjected to the assigned conditions of its treatment for 14 days. After 14 days, the number of seeds that germinated is determined for each pot. Below. two tables are provided. In the table on the left, the rst column provides the treatments and the second column provides the number of seeds that germinated. The table on the right provides the estimates and sums of squares for some of the effects in this experiment. Treatment Observation Effect Estimate SS (1) 57' A 11.75 552.25 QB 43 B -15.25 930.25 be 41 C -2.00 16.00 of) 51 D ? ? cs 57 E {1.50 1 .00 no 44 AB 12.25 600.25 54:! 37 AC 0.00 0.00 (1506 53 AD 13.25 702.25 (in? 71 131E - 1.50 9.00 dd 93 BC 41.50 1 .00 5d 42 BD ? ? abde 71 BE {L50 1 .00 ed 57 CD '? T (Lode 9'0 CE 9.75 380.25 bade 42 DE 0.50 1.00 chad 53 squares of their aliases). f. Use SAS to create a Q-Q plot of the effect estimates. Provide a list of appropriate effects to be included in a final model such that inference can be made on those effects (confounded with the effects of their aliases). NOTE: When determining which effects to include in the final model, also consider the aliases of these effects. This may help you decide whether or not to include additional effects. g. Create the complete ANOVA table corresponding to the final model you proposed. De- termine which effects in this model are significant at the 5% significance level. NOTE: You may use SAS to complete this problem or perform calculations by hand