Clear Mountain State Student Survey A sample of 111 undergraduate students answered the following survey: 1. What is your gender? Female. 2. What is your age (as of last birthday)? Male 3. What is your current registered class designation? Freshman Sophomore 4. What is your major area of study? Junior Senior Accounting. Marketing. Economics/Finance IS Other Undecided Management 5. At the present time, do you plan to attend graduate school? Yes No Undecided 6. What is your current cumulative grade point average? 7. What is your current employment status? Full time Part time Unemployed 8. What would you expect your starting annual salary (in $000) to be if you were to seek full-time employment immediat after obtaining your bachelor's degree? 9. For how many social networking sites are you registered? 10. How satisfied are you with the food and dining services on campus? Extremely 1234567 unsatisfied Neutral Extremely satisfied 11. About how much money did you spend this semester for textbooks and supplies? 12. What type of computing device do you prefer to use for your studies? Desktop Laptop Tablet 13. How many text messages do you send in a typical week? 14. How much wealth (income, savings, investment, real estate, and other assets) would you have to accumulate (in milli dollars) before you would say you are rich? The student news service at Clear Mountain State University (CMSU) has decided to gather data about the undergraduate students who attend CMSU. They create and distribute a survey of 14 questions and receive responses from 111 undergraduates. Instructions: Use Excel when necessary and respond in writing to the following: Part 1: 1. For each question asked in the survey, a. Determine whether the variable is categorical or numerical. b. If you determine that the variable is numerical, identify whether it is discrete of continuous. 2. For each question asked in the survey, construct all the appropriate charts. 3. For each numerical variable included in the survey compute all the appropriate descriptive statistics. Write a report summarizing your conclusions. Attach copies of the Excel pages or embed the Excel work in your write-up. PIC COLLAGE