UNITED STATED CENSUS BUREAU For this assignment, you will be analyzing data from the 2012 Statistical Abstract of the U.S. Census Bureau. Specifically, you will be using data from sections of the abstract in Higher Education: Degrees. The link for the data is: https://www.census.gov/library/publications/2011/compendia/ statab/131ed/education.html For Section 303 Master's Degree data, provide answers to the following questions. 1. What is the mode for 2009, Master's degrees? ANSWER The descriptive statistics calculated using excel for the section 303 Master's degree is Column1 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 11452.89706 3680.318981 3523.5 0 30348.68779 921042850.3 23.69771991 4.766963479 178564 0 178564 778797 68 Mode is equal to the maximum occurrence of the number in the sample data. Here the mode of the Master's degree for 2009 is 0. 2. Using only data from 2005, 2008, what would you predict, using a 95% confidence interval, to be the number of Master's degrees earned in the field of Mathematics and Statistics for 2010? Show all of your work, including assumptions and justification for the predictions. Answer Year Masters degree 1 4477 2 4730 3 4884 4 1 =year 2005 4980 Column1 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Margin of error(95%) Lower Limit Upper Limit 4767.75 109.7439 254 4807 #N/A 219.4878 508 48174.91 667 0.055872 957 0.851136 077 503 4477 4980 19071 4 349.2541 5 4767.75 5117.004 15 We have calculated using excel the descriptive statistics of the data, where the mean=4767.75 and the margin of error =349.25415 The lower limit=Mean-Margin of error Upper limit=Mean+Margin of error Thus, we are 95% confident that the number of Master's degree earned in the year 2010 is within the limit 4767.75 to 5117.0045. 3. In examining all of the data in Section 303 Master's degree data, provide a list of conclusions that can be drawn from this data. Answer From all the data listed in the Master's degree we can conclude the following:- a) The number of students obtaining degree either in Masters of Doctoral field increases with every year. It indicates an increase in the education level of US with each year. b)Comparing the data value of the year 1980 and 2009 there has been an increase of 120.34% in Master's degree and 107.62% increase in the number of candidate obtaining Doctoral degree. The largest increase in terms of percentage has been that of health professionals and related clinical science (1375.27%) c) The students are obtaining the least degree in military technologies showing lack of interest in studying military technologies. d) The greatest obtaining Master's degree is in the field of education showing student's interest in obtaining degree in the Educational field. e)The favourite subject of study are -Psychology, Public administration and social service and Social science and history which are in the range of ten thousands