Online Access Free Desktop-Certified-Associate Exam Questions

Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?

• A.Retail
• B.Wholesale
• C.Education
• D.Entertainment

Connect to the "Life Expectancy at birth" data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after
2000 for New Zealand.

• A.78.03
• B.78.303
• C.78.286
• D.78.56

Which of these chart types are primarily used to compare measures against goals?

• A.Pareto chart
• B.Bullet graphs
• C.Histogram
• D.Bar-in-Bar Chart

Connect to the "Education" data source. Create a histogram using the Total score field and having a bin size of
100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]

• A.1000
• B.1600
• C.1500
• D.900

Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?

• A.0.133134
• B.0.180067
• C.0.167531
• D.0.294316