placeholder image to represent content

3Is - Quarter4 - Quiz 1

Quiz by C C

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
7 questions
Show answers
  • Q1

    In the formula =COUNTIF(A1:A5, B1), what will be the output if the values in range A1 to A5 are 1, 2, 3, 3, 5) and B1 is 3?

    The output will be 3 if the value of B1 is 3.

    The output will be 1 if the value of B1 is 5.

    The output will be 3.

    The output will be 2.
    45s
  • Q2

    Which of the following statements is/are true?

    To get the spread of your data is to measure the central tendency of your data set.

    To get the middle of your data is to measure the variability of your data set.

    The level of measurement decides which descriptive statistics can be applied on your data.
    The higher the level of measurement, the lesser mathematical operations that you can apply.
    45s
  • Q3

    Which of the following tools is/are used to measure the central tendency of a nominal data?

    Median

    Mean

    Tool to get the most frequent response value.
    Mode
    45s
  • Q4

    Which of the following tools is/are used to measure the central tendency of a ratio data?

    Median, mode

    Frequency

    Mean, median, mode
    Mean, median
    30s
  • Q5

    Given the following 3Is grade of 10 TVL students- 80, 85, 80, 75, 78, 75, 90, 90, 80, 80. Which of the following statements is/are correct?

    The frequency of students who got 75 is 2.

    The frequency of students who got 90 is 3.

    The frequency of students who got 80 is 4.

    The frequency of students who got 85 is 2.

    30s
  • Q6

    Given the following 3Is grade of 5 TVL students- 80, 85, 80, 75, 78 entered in Sheet1 cells A2 to A6 respectively. Which ofthe following statements is/are correct to get the average grade?

    It can be manually computed as 80+85+80+75+78/5=79.6

    It can be manually computed as (80+85+80+75+78)/5=79.6

    The average grade when computed manually is 78.

    It can be computed using the formula =AVERAGE(A2colonA6)
    45s
  • Q7

    Given the worksheet in MS Excel with the data as shown in the picture. The data for sex is coded as 1 for Male and 2 for Female. What is the correct formula to get the frequency of Male respondents?

    Question Image
    =COUNTIF(C2colonC5;1)
    =COUNTIF(C2colonC6;1)

    =COUNTIF(C2colonC5;2)

    =COUNTIF(B2coloB6;2)

    45s

Teachers give this quiz to your class