Excel Practice

Question 1

What is the equation for the sample mean (x_bar)?

Answer 1

=AVERAGE()

Question 2

What is the equation for the sample (s) standard deviation?

Answer 2

=STDEV.S()

Question 3

What is the equation for sample size(n)?

Answer 3

=COUNT()

Question 4

In null hypothesis tests, what is the equation for the sampling distribution mean?

Answer 4

=x_bar

Question 5

In null hypothesis tests, what is the equation for sampling distribution SD (SE)”?

Answer 5

= sample SD / SQRT(n)

Question 6

In null hypothesis tests, what is the equation for the Z-statistic?

Answer 6

=(x_bar - u0) / SE

Question 7

For possible alternate hypotheses testing, what equation do you use to test if the population mean is greater than the null hypothesis mean?

Answer 7

=NORM.S.DIST(z-statistic,TRUE)

Question 8

For possible alternate hypotheses testing, what equation do you use to test if the population mean is less than the null hypothesis?

Answer 8

=1-NORM.S.DIST(z-statistic,TRUE)

Question 9

For possible alternate hypotheses testing, what equation do you use to test if the population mean does not equal the null hypothesis mean?

Answer 9

=@*NORM.S.DIST(-ABS(z-statistic),TRUE)

Question 10

To find center and variability values of the following list, what equations are used?
sample size
mean
median
mod
min
max
range
standard deviation

Answer 10

Sample size = COUNT()
Mean = AVERAGE()
Median = MEDIAN()
Mode = MODE()
Min = MIN()
Max = MAX()
Range = MAX()-MIN()
Stan. Deviation = STDEV.S()

Question 11

In estimating a large sample mean, what is the equation for alpha (significance level)?

Answer 11

1-level of confidence

Question 12

What is the level of confidence percentage?

Answer 12

The predetermined value of your choice. You repeat the experiment over and over until you reach this value for high confidence that your device works.

Question 13

In estimating a large sample mean, what is the equation for the margin of error?

Answer 13

=CONFIDENCE.NORM(alpha, sample SD, sample size)

Question 14

In estimating a large sample mean, how do you find the lower bound of the confidence interval?

Answer 14

=(sample mean) - (margin of error)

Question 15

In estimating a large sample mean, how do you find the upper bound of the confidence interval?

Answer 15

=(sample mean) + (margin of error)

Question 16

For linear regression, what is the correlation coefficient(r) equation?

Answer 16

=CORREL(Y values, X values)

Question 17

For linear regression, what is the slope equation?

Answer 17

=SLOPE(Y values, X values)

Question 18

For linear regression, what is the intercept equation?

Answer 18

=INTERCEPT(Y values, X values)

Question 19

For linear regression, what is the coefficient of determination(r^2) equation?

Answer 19

=RSQ(Y values, X values)