ExamGecko
Question list
Search
Search

List of questions

Search

Question 97 - Desktop Certified Associate discussion

Report
Export

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?

A.
Business
Answers
A.
Business
B.
Communication
Answers
B.
Communication
C.
Education
Answers
C.
Education
D.
Public Affairs
Answers
D.
Public Affairs
Suggested answer: A, D

Explanation:

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.

asked 23/09/2024
Mikolaj Roeper
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first