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
Get step-by-step solutions from verified subject matter experts
