- Details
- Parent Category: Programming Assignments' Solutions

# We Helped With This Excel Programming Assignment: Have A Similar One?

Category | Programming |
---|---|

Subject | Excel |

Difficulty | Graduate |

Status | Solved |

More Info | Excel Online Help |

## Short Assignment Requirements

## Assignment Description

1. The t table is used when the population standard deviation is known and the z tables is used when the population standard deviation is not known.

Select one:

True

False

2. If alpha is .05 what is the significance level? Answer:

Please refer to the following to answer the questions below.

Information: The owner of Limp Pines Resort wants to know if the average age of its clients has changed in the past decade. Prior research (10 years ago) showed that the population mean was 53 years old with a population standard deviation of 9 years. A random sample of 70 clients is taken. It shows a mean age of 48 years. Perform a hypothesis test at a .1 significance level to see whether there is enough evidence to say that the mean age of clients has changed?

3. Which of the following is the alternative hypothesis?

Select one:

a. µ < 53

b. µ = 53

c. µ > 53

d. µ ≠ 53

4. In this case is it appropriate to calculate a z or t value?

Select one:

a. z

b. t

5. Is this a one sided or two sided test? And, therefore, what is the z critical value to look up?

Select one:

a. Two sided, z_{alpha/2}

b. One sided, z_{alpha}

c. One sided, z_{alpha/2}

d. Two sided, z_{alpha}

6. What is the value of the appropriately calculated z or t value? Answer:

7. What is the appropriate z or t critical value?

Select one:

a. .05

b. 1.645

c. 1.96

d. .95

8. What is the appropriate conclusion from this test?

Select one:

a. Reject the null, at a 10% significance level we conclude that the mean age has not changed in the past decade.

b. Do not reject the null, at a 10% significance level we conclude that the mean age has changed in the past decade.

c. Reject the null, at a 10% significance level we conclude that the mean age has changed in the past decade.

d. Do not reject the null, at a 10% significance level we conclude that the mean age has not changed in the past decade.

Information: Historically, 45% of guests at your resort use at least one item from the mini-bar. In order to increase sales of mini-bar items, you tested having your desk clerks politely remind guests that the items are available. During the experiment, you took a randomly sample of 360 guest stays and found that 160 of the guests had used at least one item from the mini-bar. Is there enough evidence (at a .1 significance level) to say that the proportion of guests using the mini-bar has increased as a result of the test?:

9. What is the alternative hypothesis?

Select one:

a. p = .45

b. p > .45

c. p < .45

d. p ≠ .45

10. Would you use a t or z critical value to perform a hypothesis test?

Select one:

a. t

b. z

11. Which of the following can you conclude from the test?

Select one:

a. At a .1% significance, we can not reject the null and say that the test worked. Therefore, we should stop reminding people about the items.

b. At a .1% significance, we can reject the null and say that the test worked. Therefore, we should continue reminding people about the items.

c. At a .05% significance, we can not reject the null and say that the test worked. Therefore, we should stop reminding people about the items.

d. At a .05% significance, we can reject the null and say that the test worked. Therefore, we should continue reminding people about the items.

12. Traditionally, you clothing brand is very upscale and the clientele that buys it is very affluent. Because of this, you have only sold your merchandise in corporate stores located in super-affluent areas of the country. In order to expand the reach of your brand, you are considering allowing a department store to carry your clothing brand.

You are afraid that the move might dilute your brand, lower its appeal, and shrink the premium your customers are willing to pay. You know that approximately 85% of the general buying populations thinks about your brand as "super upscale". In order to test the possible impact of department store presence, you allow one store to carry your clothing. One month after, you randomly sample 500 members of the general buying population that live near that store. You find that 79% of respondents think about your brand as "super upscale".

The z score for the test sample is -3.78. What does this tell us at a 5% significance?

Select one:

a. We reject the null and it appears that the department store does not lower the perception of your products being "super upscale".

b. We do not reject the null and it appears that the department store does lower the perception of your products being "super upscale".

c. We reject the null and it appears that the department store does lower the perception of your products being "super upscale".

d. We do not reject the null and it appears that the department store does not lower the perception of your products being "super upscale".