Question 121

Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?
  • Question 122

    A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below:

    Which of the following functions would the analyst consider appropriate to flag "Yes" for every salesperson who has a number above 1,000,000 in the Quantity_sold column?
  • Question 123

    Which one the following is not considered an aggregate function?
  • Question 124

    Which of the following is used for calculations and pivot tables?
  • Question 125

    Which of the following would be used to store unstructured data from different sources?