AutoSave OFF AH ? C ... Rent2-7.xIsx - Read-Only Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Share Comments Aria v 10 AA 2 7 V ap Wrap Text General [ Autosum ~ A li Fill Paste BIUV -V MVAv Merge & Center v $ ~ % " 00 20 Conditional Format Cell Insert Delete Format Clear v Sort & Find & Analyze Sensitivity Create and Share Formatting as Table Styles Filter Select Data Adobe PDF C 4 X V fx 1080 A E F G H K L M N P Q R S U V W X Z AA AB AC AD AE Monthly Rents for College Students Undergraduate Graduate 820 1080 LearningStats 710 970 Copyright @ 2019 920 980 700 The McGraw-Hill Companies 750 800 840 940 This spreadsheet is intended solely 820 750 for educational purposes by licensed users of Connect 660 790 990 960 740 870 880 Note: Data are for share of rent if there 880 are multiple occupants in one living 17 Facility. 19 20 22 28 62 D Data Extra Sheet + Ready Average: 896.6666667 Count: 12 Sum: 107608 - + 100%h ezto.mheducation.com 88 x Question 10 - Wk 4 - Practice: Wk 4 Exercises [due Day 5] - Connect *Course Hero Wk 4 - Practice: Wk 4 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work 10 Monthly rent paid by undergraduates and graduate students. Undergraduate Student Rents (n = 10) 820 710 920 700 750 2 840 820 660 990 740 points Graduate Student Rents (n = 12) 1, 08 970 980 860 800 940 750 790 960 870 880 880 eBook Click here for the Excel Data File References (a) Construct a 95 percent confidence interval for the difference of mean monthly rent paid by undergraduates and graduate students, using the assumption of unequal variances with Welch's formula for d.f. (Do not round the intermediate calculations. Round your final answers to 3 decimal places. Negative values should be indicated by a minus sign.) The 95% confidence interval is from to (b) What do you conclude? . We can conclude there is a significant difference in means for undergraduate and graduate rent. We cannot conclude there is a significant difference in means for undergraduate and graduate rent. Mc Graw Hill