1 Video Data From The Office For National Statistics Show That The Mean Age At Which Men In Great Britain Get Married Wa 1 (32.63 KiB) Viewed 34 times
1 Video Data From The Office For National Statistics Show That The Mean Age At Which Men In Great Britain Get Married Wa 2 (35.4 KiB) Viewed 34 times
1 Video Data From The Office For National Statistics Show That The Mean Age At Which Men In Great Britain Get Married Wa 3 (39.69 KiB) Viewed 34 times
1 Video Data from the Office for National Statistics show that the mean age at which men in Great Britain get married was 34.0. A news reporter noted that this represents a continuation of the trend of waiting until a later age to wed. A new sample of 47 recently wed British men provided their age at the time of marriage. These data are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions Open spreadsheet Do these data indicate that the mean age of British men at the time of marriage exceeds the mean age in 2013? Test this hypothesis at a = 0.1. What is your conclusion? Use the obtained rounded values in your calculations. Sample mean: Jyears (to 2 decimals) Sample standard deviation: years to 4 decimals) (to 3 decimals) p-value (Upper Tall): (to 3 decimals) 3 Because p-value a=0.1, we fail to reject H. There is insufficient evidence to conclude that the mean age at which British men get married exceeds what it was in 2013. t-value: Check My Work Reset Problem
D E Formulas Sample size 47 Sample mean #N/A #N/A 34 #N/A MNA Age 39 28 28 37 35 34 28 40 35 40 34 38 30 31 39 40 27 32 39 28 35 31 31 35 37 26 27 30 40 Sample Standard Deviation Hypothesized Mean Test Statistic Degrees of Freedom D-value (Lower Tail) p-value (Upper Tail) D-value (Two Tal) Level of Significance (alpha) Reject Null Hypothesis? #N/A UNA WNIA 0.1 WNA Data Range AA B Data
A 00 B С D E LO 29 30 31 32 33 + 34 35 36 37 38 39 40 41 42 43 44 45 46 17 30 40 34 27 35 29 40 28 28 26 32 38 38 40 33 33 37 37 40 38 00 Voetes 19 50 51
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!