Part E .'ilote: for questions in Part E assume that the three assumptions underlying ANOVA {i.e., randomness and independence, normality and homogeneity of variance} are met. If the degrees of freedom for the denominator are not on the table, use the closest value the table has. 1. An investor has consulted four different financial advisors {advisor} with regard to the expected annual rate of return {return} for each of four ponfolio {portfolio} possibilities she is considering. The financial advisors have been chosen because they are known to range from very conservative {advisor l} to very optimistic {advisor 4}. The advisors' respective estimates for the three portfolios are saved in Dataset. Hint: the variable advisor is the blocking variable. Ponfolio possibilities are aggressive [coded 1}, speculative {coded 2}, hybrid {coded 3} and defensive {coded 4}. Based on the information given, answer the following questions. {a} At the [$13 level of significance, was blocking effective? Follow all the necessary steps and verify your results using ExceltPHStaL {b} Using a I% level of significance, is there a significance difference in the mean expected annual rate of return {return} of ponfolios in the four possibilities {portfolio}? Follow all the necessary steps to perform the test. {c} If your results in {b} indicate that it is appropriate, use the Tukey procedure to determine which groups {i.e., portfolio possibilities} differ in the mean expected annual rate of return. Use a I% level of significance. Follow all the necessary procedure to perform the test. 2. A consumer group asked live drivers {driver} to drive four different models {model} of cars manufactured by Toyota in MRI and report their satisfaction {satisfaction} levels out of 4D. The rating is based on interior and comfort, exterior safety features, engine and gearbox, and reliability and build quality. The drivers' ratings for the four model s of Toyota cars are saved in Datasetd. Hint: the variable driver is the blocking variable. The four different models of cars are Toyota 'faris {coded 1}, Toyota Camry {coded 2}, Toyota Kruger {coded 3} and Toyota Prius {coded 4}. Based on the information given, answer the following questions. {a} At the 5% level of significance, was blocking effective? Follow all the necessary steps and verify your results using ExceltPHStat. {b} Usinga 5% level of significance, is there a significance difference in the mean satisfaction level {satisfaction} between the four models of Toyota cars? Follow all the necessary steps to perform the test. {c} If your results in {b} indicate that it is appropriate, use the Tukey procedure to determine which groups {i.e., models of Toyota cars} differ in the mean satisfaction level. Use a 5% level of significance. Follow all the necessary procedure to perform the test