Connect to the "Education" data source. Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?
Create a bar chart using field college and Math. Change the Math aggregation to AVG.
Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation
to Avg.
Follow the same for Writing field.
Now from the Analytics menu, drop the Distribution band to the view, select the scope as
entire table, and select the value as 70 percentiles.
Your view will look like this:
70 percentiles are 547.8
Business and public affairs have all the individual subject values lesser than 547.8.
Anglea
4 months agoSharee
4 months agoMerlyn
4 months agoAnglea
5 months agoSharee
5 months agoMerlyn
5 months agoStevie
5 months agoGwen
5 months agoEleonora
6 months agoBecky
6 months ago