Study

Review: Exploratory Data Analysis

  •   0%
  •  0     0     0

  • What Google Sheets function is best used to find the average of a data range?
    =AVERAGE()
  • What does the SORT function do in Google Sheets?
    Arranges data in ascending or descending order
  • What is the main goal of Exploratory Data Analysis (EDA)?
    To summarize and visualize data to find patterns and insights
  • True or False: In EDA, data cleaning and checking for errors are unnecessary steps.
    False
  • True or False: Conditional formatting helps visualize patterns, such as high and low values.
    true
  • To check for missing or blank values, which formula can help?
    =ISBLANK()
  • Which chart is best for showing the distribution of a single numeric variable?
    Histogram
  • Which chart type would best display the relationship between two variables?
    Scatter plot
  • True or False: EDA is done only after statistical analysis is completed.
    False
  • True or False: The MIN() and MAX() functions can be used to find the range of a dataset.
    true