excel formula: 1. For the case where ? is unknown, a left-tailed test with a sample size of 15 at a 85% confidence level; t = ? 2. The manager of an insurance firm is considering a new bonus plan to increase sales. Currently, the mean sales rate per insurance agent is five insurance per month. The
Please answer the following using excel formula:
1. For the case where ? is unknown, a left-tailed test with a sample size of 15 at a 85% confidence level; t = ?
2. The manager of an insurance firm is considering a new bonus plan to increase sales. Currently, the mean sales rate per insurance agent is five insurance per month. The correct set of hypotheses for testing the effect of the bonus plan is __?
Choices:
a.None of the provided options is correct
b.H0: ?=5 and Ha: ?≠5
c. H0: ?≤5 and Ha: ?>5
d. H0: ?≥5 and Ha: ?<5
3. The level of significance is the __?
Choices:
a. same as the confidence coefficient
b. None of the provided options is correct
c. maximum allowable probability of Type II error
d. maximum allowable probability of Type I error same as the p-value
4. "The
Choices:
a. the first and third
b. first and fourth quartiles
c. second and third quartiles
d. None of the options provided is correct
e. first and second quartiles"
Step by step
Solved in 3 steps