F17 Example Quiz 2 Soln.xlsx - Fund Student Group Lowest...

This preview shows page 1 - 17 out of 51 pages.

FundStudent GroupLowest CostMiddle CostYes Undergrad1917No 19233840I copied this from the Excel Workbook Chi-Square Worksheets Eand pasted the Values onlyDataLevel of Significance0.05Number of Rows2Number of Columns3Degrees of Freedom2ResultsCritical Value5.9914645471Chi-Square Test Statistic2.6283928571p-Value0.2686901482Do not reject the null hypothesisExpected frequency assumptionis met.
Highest Cost0.50.4250.6270.50.5750.41845Excel Guide for Chapter 12
3
uates and MBA students
TypeOne-Year ReturnThree-Year ReturnShort-term3.45.5Short-term3.54.5Short-term2.65.0Short-term4.07.8Short-term5.76.3Short-term3.07.9Short-term4.46.8Short-term5.37.4Short-term4.26.5Short-term2.64.8Long-term21.314.8Long-term21.318.7Long-term20.314.4Long-term24.614.2Long-term7.011.0Long-term25.114.7Long-term9.511.2Long-term10.011.5Long-term11.411.8Long-term5.112.3World8.57.9World6.511.3World6.97.6World8.99.8World9.911.1World9.79.6World4.35.0World5.19.3World6.310.5World6.16.4
1 YearShort-termLong-termWorld3 Year3.421.38.53.521.36.52.620.36.94.024.68.95.77.09.93.025.19.74.49.54.35.310.05.14.211.46.32.65.16.1
Short-term Long-term World5.514.87.94.518.711.35.014.47.67.814.29.86.311.011.17.914.79.66.811.25.07.411.59.36.511.810.54.812.36.4
Anova: Single FactorSUMMARYGroupsCountSumAverageVarianceShort-term1038.73.87 1.1267777778Long-term10155.615.56 58.747111111World1072.27.22 3.7262222222ANOVASource of VariationSSdfMSFP-valueBetween Groups724.780666672 362.39033333 17.0938537841.5975E-005Within Groups572.40127 21.200037037Total1297.181666729H1: At least one is differentp-value < 0.05 reject Ho1.59751282535174E-005<0.05reject HoThere is evidence to conclude at least one mean return between one-year short term , long term, and worHo: µ1= µ2= µ3
F crit3.3541308285rld funds are different
Tukey Kramer Multiple ComparisonsSampleSampleGroupMeanSize13.8710215.561037.2210Other DataLevel of significance0.05Numerator d.f.3Denominator d.f.27MSW21.200037Q Statistic3.5I copied this page from the Tukey-Kramer Excel Guide.There is a significant difference between Group 1 and 2 (Short term and Lo
AbsoluteStd. ErrorCriticalComparisonDifferenceof DifferenceRangeResultsGroup 1 to Group 211.69 1.4560232 5.0960814Means are differentGroup 1 to Group 33.35 1.4560232 5.0960814Means are not differentGroup 2 to Group 38.34 1.4560232 5.0960814Means are differentong term one year rates of return) and Group 2 and 3 (Long-term and World one year rateThus, with 95% confidence we c
es of return)conclude that the mean distance for club 1 is greater
.
Anova: Single FactorSUMMARYGroupsCountSumAverageVarianceShort-term1062.56.25 1.5672222222Long-term10134.613.46 5.7026666667World1088.58.854.305ANOVASource of VariationSSdfMSFP-valueBetween Groups266.6542133.327 34.5559256630.000000036Within Groups104.17427 3.8582962963Total370.82829H1: At least one is differentp-value < 0.05 reject Ho0.000000036<0.05reject HoThere is evidence to conclude at least one mean return between three-year short term , long term, anHo: µ1= µ2= µ3
F crit3.3541308285nd world funds are different
Fund NumberMarket CapTypeAssetsRF018LargeGrowth469.10RF028LargeGrowth46.80RF041LargeGrowth5287.50RF045LargeGrowth170.90RF053

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture