Question: Using the 0.05 level of significance, is there a difference in the mean rate of return among the three types of stock? Q1:The test statistic
Using the 0.05 level of significance, is there a difference in the mean rate of return among the three types of stock?
Q1:The test statistic is:
Q2: The 95% confidence inter is ____________+- ___________
Can someone explain what I need to do in excel to answer this. I don't know how to get the critical value.

A stock analyst wants to determine whether there is a difference in the mean rate of return for three types of stock: utility, retail, and banking stocks. The following output is obtained: Analysis of Variance source DF 53 F' P Factor 2 86.419 13.09 0.001 Error 13 42 . 95 Total 15 129 . dd Individual 95! CIs For Kean Based on Pooled StDev Level I-Iean StDev ---------- + ---------- + ---------- + ------ Utility 17.400 1.916 Retail 11.620 0.356 Banking 15 .400 Pooled StDev a 1.819
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
