Examlex

Solved

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

question 49

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.
Hypothesised Difference 0Level of Significance 0.05Group 1 Number of Successes 160 Sample size200Group 2 Number of Successes 172Sample Size 250Intermediate Calculations Group 1 Proportion 0.8Group 2 Proportion 0.688 Difference in Two Proportions0.112Average Proportion 0.737777778 Test Statistic2.684103363Two-Tailed Test  Lower Critical Value1.95996398Upper Critical Valuse 1.959963985p-Value 0.007272462\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 90% confidence interval estimate of the difference in the population proportion of satisfied guests between the two resorts.


Definitions:

Neonates

Newborn babies, especially those less than a month old.

Speech Sounds

The auditory symbols used in language communication, produced by the movement of the speech apparatus.

Axons

Long, threadlike parts of nerve cells along which impulses are conducted from the cell body to other cells.

Neurons

Specialized cells in the nervous system that transmit information to other nerve cells, muscle, or gland cells.

Related Questions