Clear Mountain State Student Surveys - Case Problem for Chapter 2 Pre-Homework Instructions:

I have provided you with additional data Excel data sets for you to practice with (SoftDrink; Restaurant, Stereo, Online Shopping) along with screen based tutorials on Blackboard. Please read the instructions on how to get the values that are displayed on the book using Excel on the last few pages of Chapter 2 before completing this case problem assignment. Once you feel comfortable with using Excel to obtain the values needed, then complete the homework assignment by yourself, or with a partner.

Homework Instructions:

First, go to page 93 and read the Case Problem (Clear Mountain State Student Surveys)with the UndergradSurveydata set under the first question that was developed using a university student survey. Note, the page number may be different if you're using a different format of the book, but it will be the same Case Problem. Second, download the Excel Document (UndergradSurvey). Third, develop at least one type of display graph for each the following variables: gender, age, class, major, grad intention, employment, school spending, and computer. After each graph develop at least one sentence interpreting what the numbers in the chart/graph mean.

NOTE: As a business statistician, you will use your critical thinking skills in deciding on what type(s) of chart or charts to display for each specific variable. However, make sure that the graph type you display is appropriate given the nature of the variable. For instance, I may choose to use a bar chart or pie chart for gender and a self-developed stem-and-leaf display for age. After constructing your graphical displays for each variable, please make sure to create a managerial report summarizing your conclusions. In other words, describe your interpretations of each of the graphs you developed given each of the variables in the survey. For example, if a pie chart shows that the study was comprised of primarily female (80%), then discuss how the survey might have a gender bias in your report.

Notes:

1. Upon completing the assignment, make sure to submit it via Blackboard's Drop Box by 11:59pm on Wednesday (2/1).
2. For each variable of the data set make sure to visually display at least one graph or table to enable you to make sense of each variable. Also, make sure to write out at least a one sentence interpretation for each graph/chart/etc. You may lose points if you do not write out your managerial interpretations for each variable.
3. MyStatLab Advantage (optional) has several video tutorials on how to create and develop different types of charts and graphical displays. You're highly encouraged to view them multiple times to enhance your Excel skills.
4. If you are very unfamiliar with the basics of Excel, please visit the following tutorials provided by the following links:

Basics (2010)

https://www.youtube.com/watch?v=eI_7oc-E3h0

Basics (2013)

https://www.youtube.com/watch?v=dgsjIZKNfEU

Student Survey that was used to collect data for this data set in Excel:

1. What is your gender? Female __ Male __
2. What is your age? __
3. What is your class? Freshman __ Sophomore __ Junior __ Senior __
4. What is your major? ________
5. Are you intending to graduate? Yes __ No __ Not Sure __
6. What is your current employment status? Unemployed __ Part-Time __ Full-Time __
7. How much you spend for school supplies such as textbooks and materials? _____
8. What type of computer do you use? Laptop __ Tablet __ Desktop __

Gender Age Grad Intention Employment ID Class Major Yes Female 20 Junior Other Full-Time Male 23 Senior Management Yes Part-Time Male 21 Junior Other Yes Part-Time Yes Full-Time Male 21 Junior CIS 23 Senior Other Undecided Unemployed Male Female 22 Senior Economics/Finance Undecided Unemployed Part-Time Female 21 Junior Other Undecided Female 22 Senior Other Undecided Full-Time LD CO Female 20 Junior Management Yes Unemployed Undecided Part-Time 10 Female 21 Senior Economics/Finance Yes Full-Time 11 Female 23 Senior Economics/Finance Undecided No Full-Time 12 Male 21 Senior 13 Male 22 Senior International Business Undecided Part-Time 14 Male 22 Senior International Business Undecided Part-Time 15 Male 21 Senior Management Yes Part-Time 24 Senior Management Undecided Part-Time 16 Male Female 19 Junior CIS Undecided Part-Time 17 18 Junior Economics/Finance Undecided Part-Time Male 21 19 Male 19 Junior Economics/Finance Yes Part-Time Female 20 Junior Management Undecided Unemployed 20 21 Female 22 Junior Retailing/Marketing Undecided Part-Time 22 Male 18 Sophomore Accounting Undecided Unemployed 23 Female 22 Senior Retailing/Marketing Undecided Part-Time Full-Time 24 Male 22 Senior Undecided Yes Female 20 Junior Economics/Finance Yes Part-Time 25 26 Yes Full-Time Male 24 Senior Management Male Economics/Finance Yes Full-Time 27 20 Junior 28 Female 20 Junior International Business Yes Part-Time 22 Part-Time 29 Senior Yes Male Retailing/Marketing 20 Sophomore Retailing/Marketing Undecided Part-Time 30 Male Undecided 31 Male 20 Junior Accounting Part-Time 20 Junior Other Yes Part-Time 32 Male Part-Time Male 20 Junior Accounting Yes 33 Senior Retailing/Marketing Yes Full-Time 34 Male 22 Part-Time 35 Female 19 Junior Retailing/Marketing Undecided Part-Time 36 Female 26 Junior Accounting Yes 21 Senior Management Yes Part-Time 37 Male 38 Female 21 Sophomore Accounting Yes Part-Time 39 Male 24 Junior Economics/Finance Yes Part-Time 40 Male 19 Sophomore Retailing/Marketing Yes Unemployed Male 22 Junior Accounting Yes Full-Time 41 20 Junior Retailing/Marketing No Part-Time 42 Female Unemployed 43 Female 22 Senior Retailing/Marketing Undecided Senior No Part-Time 44 Female 21 Retailing/Marketing No Part-Time 45 Female 21 Senior International Business Part-Time 46 Female 21 Senior Management Undecided Junior Retailing/Marketing Yes Unemployed 47 Female 20