Statistics and Excel Functions Quiz

Which of the following statistical functions counts the number of numeric values in a range?

• COUNTA

• COUNT

• COUNTIF

• COUNTBLANK

The median of the dataset {4, 9, 2, 6, 7, 3} is:

• 5

• 6

• 4

• 7

Which Excel function is used to calculate the standard deviation of a dataset?

• =VAR

• =STDEV

• =AVERAGE

• =COUNT

The Chi-Squared test of independence is used to determine:

• The correlation between two continuous variables

• If the observed data matches an expected distribution

• If two categorical variables are related

• The probability of a normal distribution

If the p-value from a hypothesis test is greater than 0.05, what should you conclude?

• Reject the null hypothesis

• Fail to reject the null hypothesis

• The test is invalid

• The result is statistically significant

Which measure is used to quantify the amount of variation in a dataset?

• Mean

• Mode

• Standard Deviation

• Quartile

In a linear regression equation y=mx+c, what does the 'm' represent?

• The y-intercept

• The slope of the line

• The dependent variable

• The mean of y-values

What does bootstrapping help estimate?

• Mean and median only

• Population distribution by resampling

• The relationship between two variables

• The minimum and maximum values in a dataset

In a K-means clustering algorithm, the clusters are formed by:

• Assigning data points randomly to groups

• Minimizing the distance to cluster centroids

• Calculating correlation coefficients

• Using the average function in Excel

A confidence interval provides:

• A single estimated value for a population parameter

• A range of values likely to contain the population parameter

• The exact population mean

• A probability distribution function