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 and respond in writing in Word 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 EVEN questions asked in the survey:

a. construct all the appropriate charts.

b. for each numerical variable, compute all the appropriate descriptive statistics.

A sample of 111 undergraduate students answered the following survey:

1-What is your gender? Female ________ Male ________

2-What is your age (as of last birthday)? ________

3-What is your current registered class designation?

Freshman ________ Sophomore ________ Junior ________ Senior ________

4-What is your major area of study?

Accounting ________ Economics/Finance ________ IS ________ Management ________ Marketing ________ Other ________ Undecided ________

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 immediately 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? ________

1234567 Extremely Neutral Extremely unsatisfied 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,realestate,andotherassets)would you have to accumulate(in millions of dollars) before you would say you are rich? ________