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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock