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

SOLVED

## Short Assignment Requirements

Theme is Hypothesis. Answer the attached 12 multiple choice questions in word doc.Use the attached excel chart to do so. You will need the excel tool and the word doc, the other file (resource) might not be needed for the task but I still attached it. Pls let me know about your price calculations.

## 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:

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, zalpha/2

b. One sided, zalpha

c. One sided, zalpha/2

d. Two sided, zalpha

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".

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

 Regular homework \$20 - \$150 Advanced homework \$100 - \$300 Group project or a report \$200 - \$500 Mid-term or final project \$200 - \$800 Live exam help \$100 - \$300 Full thesis \$1000 - \$3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for \$100, we could tell that the price is \$200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On