Instruction 10-8
the Following Micosoft Excel Output Contains the Results

question 97

Short Answer

Instruction 10-8
The following Micosoft Excel output contains the results of a test to determine if the proportions of satisfied guests at two resorts are the same or different.
$$\begin{array}{l}\begin{array} {| l | l |} \hline \text {Hypothesised Difference }&0\\\hline \text {Level of Significance }&0.05\\\hline \text {Group 1 }&\\\hline \text {Number of Successes }&160\\\hline \text { Sample size}&200\\\hline \text {Group 2 }&\\\hline \text {Number of Successes }&172\\\hline \text {Sample Size }&250\\\hline \text {Intermediate Calculations }&\\\hline \text {Group 1 Proportion }&0.8\\\hline \text {Group 2 Proportion }&0.688\\\hline \text { Difference in Two Proportions}&0.112\\\hline \text {Average Proportion }&0.737777778 \\\hline \text { Test Statistic}&2.684103363 \\\hline \text {Two-Tailed Test }&\\\hline \text { Lower Critical Value}&-1.95996398 \\\hline \text {Upper Critical Valuse }&1.959963985 \\\hline \text {p-Value }&0.007272462\\\hline \end{array}\end{array}$$
-Referring to Instruction 10-8,construct a 95% confidence interval estimate of the difference in the population proportion of satisfied guests between the two resorts.

---

Definitions:

Prison Sentence

The punishment assigned by a court, typically involving incarceration, for someone convicted of a crime.

Physically Attractive

The attribute of being appealing or pleasing in appearance to the sensory perceptions of others.

Alpha Level

The probability of incorrectly rejecting the null hypothesis that is used by a researcher to decide whether an outcome of a study is statistically significant (most commonly, researchers use a probability of .05).

Statistical Significance

Rejection of the null hypothesis when an outcome has a low probability of occurrence (usually .05 or less) if, in fact, the null hypothesis is correct.