Question
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
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.
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? ________
1 2 3 4 5 6 7
Extremely
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 millions of
dollars) before you would say you are rich? ________
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started