By: Prof. Dr. Fazal Rehman | Last updated: August 1, 2024
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
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
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
Which function calculates the kurtosis of a dataset in Excel?
a) SKEW
b) KURT
c) VAR.P
d) STDEV.S
Answer: b) KURT
Which function would you use to perform a linear regression analysis in Excel?
a) SLOPE
b) INTERCEPT
c) LINEST
d) FORECAST
Answer: c) LINEST
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
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
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
Which Excel function calculates the skewness of a distribution?
a) SKEW
b) SKEW.P
c) SKEWNESS
d) SKEW.DIST
Answer: a) SKEW
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