Class 1 ExercisesAccess here the spreadsheet that will be used for the next exercises1. What is the average number of dengue cases for cities with more than zero cases?2. How many cities are above the latitude coordinate of -30 degrees?3. What is the total population of the cities below latitude -24 degrees?4. How many cities have longitude above -20 degrees?5. How many cases occur on average for cities below -20 degrees longitude?Class 2 ExercisesAccess here the spreadsheet that will be used for the next exercises1. How many trees are of native origin?2. What is the alternative name of the Gochnatia polimorpha tree?3. What is the scientific name of the Pau-brasil tree?4. Which family has the most trees?5. How many trees have more than 70 cm of CBH and good phytosanitary condition?6. How many trees have "tree tree distance" between 1 and 3 meters?7. What is the average "tree tree distance" for trees of native origin?8. What is the sum of the heights of trees of native origin, from the Fabaceae family, with good phytosanitary condition?9. Use the SEARCH or SPLIT formula and check in which observations the word "copa" appears10. Use the SEARCH or SPLIT formula and check in which observations the word "Uma" appearsNow using Pivot Table:11. Separate the authors into a tab by number of trees12. Separate the trees into a tab by origin with the total sum of heights. Filter to show only trees from the "Fabaceae" familyClass 3 ExercisesAccess here the spreadsheet that will be used for the next exercises1. Which page has the highest bounce rate?2. Which page has the lowest % exit?3. Which page has the third highest number of unique views?4. Which page has the longest time on page?5. Which article page has the shortest time on page?Create a column that divides the time in seconds on a page by the bounce rate and another that divides it by the exit rate6. Which page has the highest value in this new column linked to bounce rate?7. Which page has the lowest value in this new column linked to exit rate?Now using Pivot Table:8. Which page has the highest number of pageviews?9. Which medium produces the highest number of pageviews?10. Which pages have the highest bounce rate?11. Which article pages have the highest bounce rate?12. Which article pages have the shortest time on page?
Melden Sie sich an und nehmen Sie an der Unterhaltung teil
— Kommentare 0
, Reaktionen 1
Sei der erste der kommentiert