Skip to main content
Back

Confidence Intervals for Population Means - Excel quiz

Control buttons has been changed to "navigation" mode.
1/15
  • What two values are needed to construct a confidence interval for a population mean?
    You need the sample mean (x̄) and the margin of error (e).
  • What Excel function is used to find the sample mean of a dataset?
    The equals AVERAGE function is used to find the sample mean.
  • How do you calculate the lower bound of a confidence interval in Excel?
    Subtract the margin of error from the sample mean (x̄ − e).
  • How do you calculate the upper bound of a confidence interval in Excel?
    Add the margin of error to the sample mean (x̄ + e).
  • Which Excel function is used to find the margin of error when the population standard deviation (σ) is known?
    Use the CONFIDENCE.NORM function to find the margin of error.
  • What are the three inputs required for the CONFIDENCE.NORM function in Excel?
    The inputs are alpha (α), population standard deviation (σ), and sample size (n).
  • How is alpha (α) calculated for a confidence interval in Excel?
    Alpha is calculated as 1 minus the confidence level (α = 1 − confidence level).
  • What Excel function is used to find the margin of error when the population standard deviation is unknown?
    Use the CONFIDENCE.T function to find the margin of error.
  • What is the difference between CONFIDENCE.NORM and CONFIDENCE.T functions in Excel?
    CONFIDENCE.NORM uses the population standard deviation (σ), while CONFIDENCE.T uses the sample standard deviation (s).
  • How do you find the sample standard deviation in Excel?
    Use the STDEV function to calculate the sample standard deviation.
  • What does the margin of error represent in a confidence interval?
    It represents the range above and below the sample mean where the true population mean likely lies.
  • If you have a 99% confidence interval, what is the value of alpha (α)?
    Alpha is 0.01, since α = 1 − 0.99.
  • If you have a 95% confidence interval, what is the value of alpha (α)?
    Alpha is 0.05, since α = 1 − 0.95.
  • What does a confidence interval of 6.23 to 7.615 mean in the context of a 99% confidence level?
    It means you are 99% certain the true population mean lies between 6.23 and 7.615.
  • What does a confidence interval of 3.563 to 5.006 mean in the context of a 95% confidence level?
    It means you are 95% sure the true population mean lies between 3.563 and 5.006.