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.
Carlota
2 months agoDevorah
2 months agoAleta
2 months agoCherilyn
2 months agoLeota
30 days agoChauncey
1 months agoGussie
2 months agoJose
2 months agoDevorah
2 months agoCortney
2 months agoJacinta
2 months agoMarquetta
2 months agoJosefa
2 months agoNoemi
3 months agoShad
2 months agoBilli
2 months agoAlisha
2 months agoColton
2 months agoFrankie
3 months agoGlory
3 months ago