Advanced statistical functions Excel MCQs

By: Prof. Dr. Fazal Rehman Shamil | Last updated: August 1, 2024

  1. Which function in Excel is used to calculate the standard deviation of a dataset?
    a) AVERAGE
    b) STDEV.P
    c) VAR
    d) MEDIAN
    Answer: b) STDEV.P
  2. What does the Excel function NORM.S.DIST return?
    a) The normal distribution for a specified mean and standard deviation
    b) The standard normal distribution
    c) The inverse of the normal distribution
    d) The cumulative distribution function
    Answer: b) The standard normal distribution
  3. Which function would you use to calculate the correlation coefficient between two datasets in Excel?
    a) CORREL
    b) COVAR
    c) PEARSON
    d) T.TEST
    Answer: a) CORREL
  4. Which function calculates the kurtosis of a dataset in Excel?
    a) SKEW
    b) KURT
    c) VAR.P
    d) STDEV.S
    Answer: b) KURT
  5. Which function would you use to perform a linear regression analysis in Excel?
    a) SLOPE
    b) INTERCEPT
    c) LINEST
    d) FORECAST
    Answer: c) LINEST
  6. What does the Excel function CHISQ.TEST return?
    a) The cumulative distribution function of the chi-square distribution
    b) The probability of observing a chi-square statistic
    c) The inverse of the chi-square distribution
    d) The mean of the chi-square distribution
    Answer: b) The probability of observing a chi-square statistic
  7. Which function in Excel would you use to calculate the exponential distribution?
    a) EXPON.DIST
    b) EXP.DIST
    c) LOG.DIST
    d) POISSON.DIST
    Answer: a) EXPON.DIST
  8. What does the function T.INV.2T return in Excel?
    a) The two-tailed inverse of the t-distribution
    b) The t-value for a given probability
    c) The cumulative probability of the t-distribution
    d) The mean of the t-distribution
    Answer: a) The two-tailed inverse of the t-distribution
  9. Which Excel function calculates the skewness of a distribution?
    a) SKEW
    b) SKEW.P
    c) SKEWNESS
    d) SKEW.DIST
    Answer: a) SKEW
  10. Which function is used to find the probability that a value from a normal distribution is less than or equal to a given value?
    a) NORM.DIST
    b) NORM.INV
    c) NORM.S.INV
    d) NORM.S.DIST
    Answer: a) NORM.DIST

Related Posts: