Question: Instructions : Please enter the following information into an Excel spreadsheet. Don't hesitate to utilize pivot tables, graphs, and/or charts to display the information. Additionally,
Instructions:Please enter the following information into an Excel spreadsheet. Don't hesitate to utilize pivot tables, graphs, and/or charts to display the information.
Additionally, perform an analysis of the data and, Via Microsoft PowerPoint presentation, describe the information/results in a meaningful way. Finally, email your Excel spreadsheet and Microsoft PowerPoint presentation to your point of contact at UnityTec.
Data:The information below were collected from a survey sent to state college students in 5 states:
Washington, Oregon, Texas, Utah, and Wyoming. Each state sampled 5 students. The survey asked them to rate their overall satisfaction with their undergraduate experience and to indicate their GPA.
Washington
Student 1: Unsatisfied, 2.1
Student 2: Neutral, 1.9
Student 3: Unsatisfied, 1.8
Student 4: Unsatisfied, 1.8
Student 5: Very Satisfied, 3.3
Oregon
Student 1: Satisfied, 3.0
Student 2: Neutral, 1.9
Student 3: Very Satisfied, 3.8
Student 4: Satisfied, 4.0
Student 5: Satisfied, 2.8
Texas
Student 1: Neutral, 2.6
Student 2: Very Unsatisfied, 1.9
Student 3: Neutral, 2.5
Student 4: Unsatisfied, 2.0
Student 5: Very Unsatisfied, 2.0
Utah
Student 1: Very Satisfied, 4.0
Student 2: Very Satisfied, 3.1
Student 3: Satisfied, 2.9
Student 4: Very Satisfied, 3.9
Student 5: Satisfied, 2.7
Wyoming
Student 1: Neutral, 2.9
Student 2: Neutral, 3.2
Student 3: Neutral, 2.1
Student 4: Neutral, 1.8
Student 5: Satisfied, 2.1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
