QUESTION 38 Which function within a spreadsheet tool creates a dynamic table from a source data table that an analyst can customize to examine subsets of data. Solver O Pivot table Conditional formatting Dynamic table QUESTION 39 Given the table below, to determine the number of stores with revenue greater than $1000, an analyst would use which of the following functions? Average daily revenue per store Store number #1 $1500 #2 $1000 #3 $800 #4 $2000 Sum Average Count Standard deviation QUESTION 40 In 1985, a research institute conducted a study of 30 students, all of whom were born in 1980. The researcher recorded information such gender, height, favorite ice-cream flavor and religion for all 30 subjects. After 20 years, the research institute contacted the same subjects to determine if gender and religion was a factor in determining whether or not the subjects attended college as well as whether or not the subjects got married. Which of the following statements is true about the study. The study was qualitative and true experimental. The study was quantitative and cross-sectional. The study was longitudinal and cross-sectional The study was quantitative and longitudinal. The study was qualitative and longitudinal QUESTION 41 The bubble chart in this graph is used to measure how many variables? 100 New York City Airbnbs by Price, Rating & Beds 0 1 O2 O 3 04 QUESTION 42 Percentage change is a common technique in which of the following types of data analysis? Cluster Sum Conditional formatting Trend