Quiz: Unit 5, Section A – Data Handling and Analysis

  1. Which of the following is a qualitative data type?
    1. Height
    2. Color
    3. Age
    4. Temperature

    Answer: B

  2. What is the primary advantage of using surveys for data collection?
    1. Provides in-depth insights
    2. Time-consuming process
    3. Cost-effective for large samples
    4. High risk of interviewer bias

    Answer: C

  3. In a frequency table, what does cumulative frequency represent?
    1. The sum of all frequencies
    2. The frequency of each individual value
    3. The total number of observations
    4. The cumulative total of frequencies up to a certain point

    Answer: D

  4. Which of the following best describes the purpose of a pie chart?
    1. To compare categories over time
    2. To show trends with lines
    3. To represent proportions of a whole
    4. To display raw numerical data

    Answer: C

  5. What is the formula to calculate the relative frequency in a frequency table?
    1. \frac{\text{Frequency}}{\text{Total Number of Categories}}
    2. \frac{\text{Total Number of Observations}}{\text{Frequency}}
    3. \frac{\text{Frequency}}{\text{Total Number of Observations}}
    4. \frac{\text{Total Number of Observations}}{\text{Total Frequency}}

    Answer: C

  6. Which feature of Google Sheets allows multiple users to edit a document at the same time?
    1. Conditional formatting
    2. Version history
    3. Real-time collaboration
    4. Chart editor

    Answer: C

  7. What is a primary disadvantage of using interviews for data collection?
    1. Limited depth of information
    2. Time-consuming and resource-intensive
    3. Cost-effective for large samples
    4. Lack of real-time data

    Answer: B

  8. Which Google Sheets function is used to find the average of a range of cells?
    1. =SUM()
    2. =AVERAGE()
    3. =COUNT()
    4. =MAX()

    Answer: B

  9. In which scenario would observation be the most suitable data collection method?
    1. When in-depth personal insights are needed
    2. When quantifiable data is required
    3. When real-time behavior is being studied
    4. When quick responses from a large audience are necessary

    Answer: C

  10. What is the primary purpose of using spreadsheets like Google Sheets in data analysis?
    1. To perform manual calculations
    2. To create static data reports
    3. To organize, analyze, and visualize data efficiently
    4. To replace all database management systems

    Answer: C