Question: Characterize the data provided in the attached Excel sheet ( usa_colleges_data.xls ) using following target classes: Private universities in California Public universities in California The

Characterize the data provided in the attached Excel sheet (usa_colleges_data.xls) using following target classes:

Private universities in California

Public universities in California

The characterization should be based on following attributes:

Number of universities/colleges

Average of Math SAT

Average of Verbal SAT

Average of stud./fac. Ratio

Average of out-of-state tuition

Average of % fac. w/PHD

You can use Excel Pivot Table and Pivot Chart to characterize the results

What knowledge can you deduce from this characterization?

Please a new answer and the steps, the pictures, and the words are clear.

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

Students Have Also Explored These Related Databases Questions!