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 eachthe 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:

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 __

20 points Did the student submit an Excel spreadsheet to develop effective visual graphs for every single variable in the Case Study data set (8 total)? 1 2 3 4 5 points

Did the student complete the relative frequency/percentage frequency of the variables in the data set in a professional manner? 1 2 3 4 5 points

Did the student demonstrate ability in creating effective pie charts, bar charts, pareto, etc. charts/graphsfor the variables in this survey? 1 2 3 4 5 points

Did the student demonstrate the ability to manually create at least one stem-and-leaf display for one of the variables? 1 2 pointsDid the student interpret each graph that was developed in at least one sentence in an effective manner? 1 2 3 points

Reference link: https://docs.google.com/spreadsheets/d/1NVGTWq21S70pobXcOiMvPR-oQpHFgpJe-1ZbbcRe734/edit?usp=sharing