Clear Mountain State Student Survey The student news service at Clear Mountain State University (CMSU) has decided to ga

[answerhappygod]

Clear Mountain State Student Survey The student news
service at Clear Mountain State University (CMSU) has decided to
gather data about the undergraduate students that attend CMSU. They
created and distributed a survey of 14 questions and received
responses from 111 undergraduates, stored in Excel File
StudentSurvey.xls. The student survey questions are also attached,
so you could see what the data values in the Excel file refer
to.
1. For each question asked in the survey, analyze the student
data by constructing all the appropriate tables and charts. Hints:
• You can use Excel and, for example, develop frequency tables, bar
charts, pie charts, and histograms, and compute numerical measures
we studied in Chapters 2- 3 for each of the given variables
(gender, age, class, major, etc.). You can compute the confidence
interval estimates for the population mean (studied in Chapter 8)
for some of the quantitative variables. In addition, you can pose a
hypothesis regarding some of the quantitative variables and perform
the hypothesis test illustrating the methods we studied in Chapter
9 and you can also perform a regression analysis concept we studied
in Chapter 12. • This data set is an illustration of a real-world
situation and the purpose of the project is for you to apply the
concepts we studied throughout the class to expand and enhance your
understanding of those concepts by working with a particular data
set with a minimal guidance from me. It is up to you to choose
which of the concepts we studied are useful for this particular
problem and to present your findings.

Clear Mountain State Student Survey The Student News Service At Clear Mountain State University Cmsu Has Decided To Ga 1 (128.74 KiB) Viewed 35 times

Clear Mountain State Student Survey Junior IS 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 Senior 4. What is your major area of study? Accounting Economics/Finance 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 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, real estate, and other assets) would you have to accumulate (in millions of dollars) before you would say you are rich?

1100 Laptop 900 Laptop Marketing Marketing 875 Laptop Social Text sn Gender Age Class Major Grad Intention GPA Employment Salary Networking Satisfaction Spending Computer Messages Wealth 1 Female 20 Sophomore Other Yes 2.88 Full-Time 55.0 5 3 850 Laptop 200 2.0 2 Male 23 Senior Management Yes 3.60 Part-Time 30.0 4 4 860 Desktop 50 10.0 3 Male 21 Freshman Other Yes 2.50 Part-Time 50.0 2 4 4 200 70.0 4 Male 21 Sophomore IS Yes 2.50 Full-Time 45.0 4 6 1100 Tablet 250 100.0 5 Male 23 Senior Other Undecided 2.80 Unemployed 45.0 7 4 1000 Laptop 100 1.0 6 Female 26 Senior Economics/Finance Undecided 2.34 Unemployed 83.0 3 3 2 1200 Desktop 0 5.0 7 Female 21 Junior Other Undecided 3.00 Part-Time 55.0 3 3 1000 Laptop 50 0.6 8 Female 30 Senior Other Undecided 3.10 Full-Time 85.0 1 2 700 Tablet 300 1.0 9 Female 20 Sophomore Management Yes 3.60 Unemployed 35.0 0 4 1000 Laptop 400 0.6 10 Female 21 Senior Economics/Finance Undecided 3.30 Part-Time 42.5 11 4 700 Laptop 100 1.0 11 Female 23 Senior Economics/Finance Yes 2.80 Full-Time 55.0 5 5 200 30.0 12 Male 22 Senior Economics/Finance No 3.50 Full-Time 42.0 4 4 3 1000 Laptop 100 4.0 13 Male 22 Senior Marketing Undecided 3.40 Part-Time 45.0 6 6 3 900 Desktop 45 0.7 14 Male 22 Senior Undecided 3.10 Part-Time 45.0 1 3 900 Laptop 150 2.0 15 Male 21 Senior Management Yes 3.20 Part-Time 59.0 0 4 1100 Laptop 400 6.0 16 Male 24 Senior Management Undecided 3.40 Part-Time 50.0 4 4 1000 Desktop 175 1.5 17 Female 19 Freshman IS Undecided 3.68 Part-Time 60.0 10 4 950 Tablet 150 0.5 18 Male 21 Junior Economics/Finance Undecided 3.10 Part-Time 60.0 2 2 3 1100 Laptop 300 10.0 19 Male 19 Sophomore Economics/Finance Yes 3.50 Part-Time 57.0 4 5 1000 Laptop 300 2.0 20 Female 20 Sophomore Management Undecided 3.17 Unemployed 65.0 12 6 800 Laptop 350 0.4 21 Female 22 Junior Marketing Undecided 3.19 Part-Time 60.0 11 3 3 1190 Laptop 50 0.4 22 Male 18 Sophomore Accounting Undecided 2.95 Unemployed 65.0 9 4 4. 1100 Laptop 500 10.0 23 Female 22 Senior Undecided 3.00 Part-Time 60.0 0 4 800 Laptop 35 0.2 24 Male 25 Senior Undecided Yes 2.60 Full-Time 50.0 8 5 900 Laptop 600 1.5 25 Female 20 Junior Economics/Finance Yes 3.00 Part-Time 60.0 7 3 1100 Laptop 300 0.1 26 Male 24 Senior Management Yes 3.30 Full-Time 65.0 0 1 800 Desktop 40 10.0 27 Male 23 Junior Economics/Finance Yes 3.10 Full-Time 70.0 4 5 300 2.0 28 Female 20 Freshman Marketing Yes 2.90 Part-Time 55.0 13 1 1 1400 Laptop 100 1.0 29 Male 22 Senior Marketing Yes 3.33 Part-Time 60.0 9 9 6 6 1600 Laptop 60 100.0 30 Male 20 Sophomore Marketing Undecided 3.10 Part-Time 50.0 4 4 900 Laptop 140 7.0 31 Male 20 Sophomore Accounting Undecided 3.40 Part-Time 60.0 4 3 1000 Laptop 500 5.0 32 Male 20 Junior Other Yes 2.90 Part-Time 52.0 3 1 800 Laptop 300 1.3 33 Male 20 Junior Accounting Yes 3.60 Part-Time 40.0 6 4 700 Laptop 70 0.8 34 Male 22 Senior Marketing Yes 2.57 Full-Time 45.0 5 4 1550 Laptop 800 0.9 35 Female 19 Sophomore Marketing Undecided 3.40 Part-Time 45.0 4 5 1000 Laptop 300 0.1 36 Female 26 Junior Accounting Yes 3.30 Part-Time 65.0 2 4 4. 950 Desktop 300 0.8 37 Male 21 Senior Management Yes 3.05 Part-Time 45.0 3 4 1000 Laptop 100 5.0 38 Female 21 Sophomore Accounting Yes 2.50 Part-Time 65.0 2 3 1000 Laptop 600 0.9 39 Male 24 Junior Economics/Finance Yes 2.75 Part-Time 55.0 7 7 6 1100 Desktop 50 1.0 40 Male 19 Freshman Marketing Yes 2.50 Unemployed 55.0 15 5 800 Laptop 100 1.0 41 Male 22 Junior Accounting Yes 3.20 Full-Time 65.0 4 4 4 1180 Desktop 200 0.5 42 Female 20 Junior No 3.30 Part-Time 35.0 6 6 4 1100 Laptop 350 1.0 43 Female 22 Senior Marketing Undecided 3.50 Unemployed 45.0 5 5 800 Laptop 50 6.0 44 Female 27 Senior Marketing No 3.90 Full-Time 35.0 4 5 600 Laptop 400 1.0 45 Female 21 Senior Marketing No 3.00 Part-Time 35.0 6 5 1150 Desktop 500 0.5 46 Female 21 Senior Management Undecided 3.82 Part-Time 65.0 1 4 1150 Laptop 150 1.0 47 Female 20 Junior Yes 3.50 Unemployed 65.0 5 5 3 200 0.3 48 Male 19 Sophomore Undecided Undecided 2.50 Part-Time 85.0 3 3 4 1000 Desktop 150 3.0 49 Female 21 Senior Economics/Finance Yes 3.20 Part-Time 52.5 2 4 720 Laptop 105 1.0 50 Female 23 Sophomore Economics/Finance Undecided 3.00 Part-Time 50.0 5 5 3 105 0.7 51 Female 21 Junior Management No 3.50 Unemployed 40.0 1 4 1100 Tablet 100 1.0 52 Male 23 Senior Management No 3.00 Part-Time 55.0 4 4 1000 Laptop 200 5.0 53 Female 21 Senior Marketing Undecided 3.70 Part-Time 45.0 3 4 800 Laptop 700 10.0 54 Male 21 Junior Marketing No 3.40 Part-Time 45.0 7 5 1000 Laptop 300 0.5 55 Male 21 Senior Other Yes 3.40 Part-Time 55.0 3 3 4 4 750 Desktop 700 2.5 56 Female 21 Senior Marketing No 3.10 Part-Time 55.0 3 1. 1 800 Desktop 300 3.5 57 Female 21 Senior Marketing Yes 3.40 Part-Time 47.0 6 1 700 Laptop 100 3.8 58 Female 21 Senior Marketing No 2.40 Part-Time 45.0 4 3 1500 Laptop 10 1.0 59 Female 20 Junior IS No 2.90 Part-Time 45.0 4 4 850 Laptop 250 0.1 60 Female 20 Sophomore IS No 2.50 Part-Time 60.0 7 7 4 1000 Tablet 500 1.0 61 Female 23 Senior Accounting Yes 3.50 Part-Time 35.0 6 3 990 Laptop 50 1.0 62 Female 23 Senior Economics/Finance No 3.20 Part-Time 75.0 2 3 750 Laptop 0 2.0 63 Male 24 Junior Economics/Finance Yes 2.70 Full-Time 70.0 6 6 570 Tablet 100 1.0 64 Male 23 Junior Economics/Finance No 3.10 Part-Time 65.0 9 4 650 Laptop 200 10.0 65 Male 18 Freshman Undecided Yes 3.60 Unemployed 55.0 12 4 700 Tablet 500 1.0 66 Male 24 Senior Management No 3.10 Part-Time 50.0 4 4 800 Laptop 0 0.9 67 Male 23 Sophomore Marketing No 2.20 Unemployed 50.0 5 5 4 4 650 Desktop 100 10.0 68 Female 22 Senior Accounting No 3.20 Part-Time 60.0 4 4 5 800 Laptop 100 1.0 69 Female 25 Senior Marketing Yes 2.80 Full-Time 50.0 3 2 2 800 Laptop 0 7.5 70 Male 26 Senior Economics/Finance Yes 3.70 Part-Time 65.0 6 3 800 Desktop 60 1.0 71 Male 19 Freshman Economics/Finance Undecided 2.60 Unemployed 60.0 9 5 5 800 Laptop 400 0.1 Marketing Marketing 850 Laptop 1020 Laptop

9 5 400 600 0.1 1.0 4 4 5 5 8 8 12 6 10 1.0 1.0 10.0 5.0 5 6 0 350 4 6 3 2 5 60.0 55.0 60.0 70.0 55.0 75.0 50.0 60.0 55.0 50.0 50.0 65.0 45.0 60.0 0.5 50.0 3 60 5 4 6 1.0 5 5 1.5 8 5 4 5 6 650 200 650 400 20 2.0 5.0 4 10.0 8 5 65.0 3 6 7 10.0 6.0 10.0 45.0 4 5 250 200 60 400 2 2 4 100.0 55.0 50.0 4 2.0 3 6 4 50.0 60.0 5.0 4 5 1.0 72 71 Male 19 Freshman Economics/Finance Undecided 73 72 Female 24 Senior Management No 74 73 Female 20 Freshman Accounting Undecided 75 74 Male 23 Junior IS Undecided 76 75 Male 23 Senior Management No 77 76 Female 28 Senior Economics/Finance Yes 78 77 Male 25 Senior Management No 79 78 Male 24 Senior Economics/Finance Undecided 80 79 Female 21 Sophomore Undecided Yes 81 80 Female 22 Sophomore Marketing Undecided 82 81 Female 19 Freshman Undecided Undecided 83 82 Male 23 Junior Economics/Finance Yes 84 83 Male 21 Junior Management No 85 84 Male 24 Senior IS Undecided 86 85 Male 22 Junior Economics/Finance Yes 87 86 Female 21 Sophomore Management Undecided 88 87 Male 25 Senior Accounting Yes 89 88 Female 20 Sophomore Marketing Undecided 90 89 Female 22 Junior Marketing Undecided 91 90 Female 23 Sophomore Economics/Finance Yes 92 91 Male 27 Junior Marketing Undecided 93 92 Male 22 Junior Management Undecided 94 93 Female 26 Senior Economics/Finance Yes 95 94 Female 30 Senior Accounting Yes 96 95 Female 22 Sophomore Accounting No 97 96 Male 19 Freshman Economics/Finance No 98 97 Male 24 Junior Accounting Undecided 99 98 Female 20 Sophomore Economics/Finance No 100 99 Male 19 Freshman Economics/Finance Yes 101 100 Male 24 Senior Other No 102 101 Female 22 Junior Management Yes 103 102 Male 20 Freshman Marketing No 104 103 Male 21 Sophomore Marketing No 105 104 Male 23 Junior Other No 106 105 Female 24 Senior Other No 107 106 Female 18 Freshman Management No 108 107 Male 26 Senior Economics/Finance No 109 108 Female 19 Freshman Undecided Undecided 110 109 Female 21 Sophomore Undecided Undecided 111 110 Male 18 Freshman Accounting Undecided 112 111 Female 21 Sophomore Accounting No 2.60 Unemployed 3.10 Part-Time 2.40 Part-Time 3.60 Part-Time 3.10 Part-Time 3.50 Part-Time 2.50 Full-Time 3.40 Part-Time 3.30 Part-Time 3.00 Part-Time 2.80 Unemployed 3.60 Part-Time 3.00 Part-Time 3.30 Part-Time 3.70 Part-Time 2.80 Part-Time 3.40 Part-Time 3.10 Unemployed 2.90 Part-Time 3.50 Part-Time 3.30 Full-Time 2.90 Part-Time 3.60 Part-Time 3.80 Full-Time 2.10 Unemployed 2.80 Part-Time 3.00 Full-Time 3.10 Part-Time 3.80 Unemployed 3.10 Part-Time 3.20 Part-Time 2.70 Part-Time 2.90 Part-Time 3.00 Part-Time 3.20 Part-Time 2.00 Unemployed 2.90 Full-Time 3.30 Unemployed 2.60 Part-Time 3.60 Part-Time 3.40 Part-Time 500 75 55.0 4 800 Laptop 1060 Desktop 800 Laptop 900 Laptop 800 Laptop 900 Desktop 800 Laptop 1175 Laptop 900 Laptop 1000 Laptop 850 Tablet 680 Laptop 700 Laptop 750 Laptop 745 Laptop 715 Laptop 850 Desktop 575 Laptop 2000 Laptop 750 Laptop 800 Laptop 670 Laptop 700 Desktop 800 Desktop 730 Laptop 650 Laptop 1700 Laptop 800 Laptop 900 Laptop 900 Desktop 860 Laptop 640 Laptop 1100 Tablet 800 Laptop 690 Laptop 750 Laptop 850 Laptop 800 Tablet 800 Laptop 900 Laptop 950 Tablet 5 10.0 4 4 50 0.1 3 3 3 5 5 100 30 50 5.0 2.0 50.0 9 4 50.0 65.0 65.0 60.0 55.0 60.0 60.0 65.0 50.0 50.0 45.0 40.0 7 5 6 1.0 1.0 4 4 5 5 0 300 1 1 7 75 5.0 3.0 20.0 7 100 6 75 3.0 3 4 4 7 5 5 210 400 5 5.0 2.5 10.0 0.8 45.0 5 6 8 45.0 4 4 100.0 5 4 4 50.0 45.0 55.0 50.0 45.0 210 525 100 100 750 500 750 200 7 3 3 20.0 50.0 5 4 65.0 8 5 100.0 65.0 5 5 75.0 113