Please apply excel formula where applicable with steps for me to follow and apply in the future.A Bridals states that the average cost of a wedding is $26,271. One concerned bride hopes that the average is less than reported. To see if her hope is correct, she surveys 19 recently married couples and finds that the average cost of weddings in the sample was $24,740. Assuming that the population standard deviation is $5724, is there sufficient evidence to support the bride's hope at the 0.10 level of significance? Write the null and alternative hypotheses using the correct notation. Perform the hypothesis test. If you use FORMULAS, write the formula you use BEFORE you substitute the variables with values. Round your answer(s) appropriately. In a complete sentence, state whether the null hypothesis should be rejected or not rejected (e.g., fail to reject). Give a reason to support your answer citing specific work/answers from above. The bride is hopeful that the average cost of the wedding is less than $26,271, especially since the mean from the survey she conducted was $24,740, a few thousand dollars less than the mean given on the wedding website. Is the bride's hope supported by the results of the hypothesis test…yes or no? Using complete sentences, clearly state your answer (yes or no) and give a reason to support your answer citing specific work/answers from the previous parts you used to make your decision.

We have given that Sample size n=19 sample mean = 24740 Population standard deviation = 5724

Answered: Please apply excel formula where…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Please apply excel formula where applicable with steps for me to follow and apply in the future.

A Bridals states that the average cost of a wedding is $26,271. One concerned bride hopes that the average is less than reported. To see if her hope is correct, she surveys 19 recently married couples and finds that the average cost of weddings in the sample was $24,740. Assuming that the population standard deviation is $5724, is there sufficient evidence to support the bride's hope at the 0.10 level of significance?

Write the null and alternative hypotheses using the correct notation.

Perform the hypothesis test.
If you use FORMULAS, write the formula you use BEFORE you substitute the variables with values. Round your answer(s) appropriately.
In a complete sentence, state whether the null hypothesis should be rejected or not rejected (e.g., fail to reject). Give a reason to support your answer citing specific work/answers from above.

The bride is hopeful that the average cost of the wedding is less than $26,271, especially since the mean from the survey she conducted was $24,740, a few thousand dollars less than the mean given on the wedding website. Is the bride's hope supported by the results of the hypothesis test…yes or no? Using complete sentences, clearly state your answer (yes or no) and give a reason to support your answer citing specific work/answers from the previous parts you used to make your decision.

Expert Solution