Week 2 Quiz :Data Visualization and Communication with Tableau (Excel to MySQL: Analytic Techniques for Business Specialization)Answers 2025

Answer Key

1. Unique human user IDs
   ✔ 17,986
   ❌ 14,433, 16,261, 17,985, None of the above

2. Common property for rows with “State” = 37
   ✔ They all completed 37 tests
   ❌ They all weigh 37 pounds, ❌ Charmers, ❌ Golden Retrievers, ❌ From Estonia

3. Property for “Sign In Counts” > 175
   ✔ They all have an Einstein profile
   ❌ Saint Jean de Monts, ❌ Estonia, ❌ Shih Tzus 190 lbs, ❌ Dog ID fd51b784-7144-11e5-ba71-058fbc01cf0b

4. Personality Dimension with highest average completed tests
   ✔ None of them. All dimensions have similar completion rates
   ❌ Expert, ❌ Socialite, ❌ Renaissance, ❌ Protodog

5. Breeding group vs tests completed
   ✔ None of the above
   ❌ Herding dogs finish most, ❌ Sporting dogs finish most, ❌ Toy dogs least, ❌ Hound dogs least

6. Personality type with strongest representation in sporting group
   ✔ Einstein
   ❌ Socialite, ❌ Protodog, ❌ Expert, ❌ Charmer

7. Median tests completed by breed types
   ✔ All breed types complete a median of 7 tests
   ❌ Popular-Hybrid median 8, ❌ Pure-Breed median 8, ❌ Cross-Breed median 8, ❌ All breed types median 5

8. Average tests fixed vs non-fixed dogs
   ✔ Fixed dogs complete less tests than non-fixed dogs in Cross-Breed & Mixed Breed/I Don’t Know categories
   ✔ Greatest difference occurs in Mixed Breed/I Don’t Know
   ❌ Fixed less in all, ❌ Fixed more in all, ❌ Fixed more in some

9. DNA-tested vs non-DNA-tested dogs
   ✔ DNA-tested dogs completed more tests than non-DNA-tested in all categories except Popular Hybrids fixed
   ✔ Cross-Breed DNA-tested but not fixed mostly Labrador Retriever-Golden Retriever Mixes
   ❌ Cross-Breed mostly Golden Doodles, ❌ Only one dog in Popular Hybrid DNA tested but not fixed

10. African country with deep color (map)
    ✔ ZA
    ❌ AR, ❌ NO, ❌ SA, ❌ N/A

11. US state with most customers
    ✔ California, with New York second
    ❌ Florida, ❌ North Carolina, ❌ Texas, ❌ North Carolina second

12. States with median tests > 13
    ✔ Maine (ME), ✔ North Carolina (NC)
    ❌ North Dakota, ❌ South Dakota, ❌ Wyoming

13. Sensitivity of aggregations to outliers
    ✔ Average aggregations more sensitive to extreme values than median
    ❌ Neither sensitive, ❌ Median more sensitive, ❌ Both equally sensitive

14. ITIs vs number of tests (≤19 tests)
    ✔ Significant positive correlation between median ITIs and number of tests completed
    ✔ Significant positive correlation between average ITIs and number of tests completed
    ❌ Non-significant positive/negative, ❌ Significant negative median

15. ITIs vs number of tests (≤7 tests)
    ✔ Non-significant negative correlation between average ITIs and number of tests completed
    ✔ Significant negative correlation between median ITIs and number of tests completed
    ❌ Significant positive average, ❌ Significant positive median, ❌ Non-significant positive average

Summary Table: Dognition Dataset Insights