Question: HELLO tutor, please help me this question. MUST answer BY EXCEL and show step by step. Thank you so much Forest City Casino is interest
HELLO tutor, please help me this question. MUST answer BY EXCEL and show step by step. Thank you so much
Forest City Casino is interest in determining the percentage of their weekend visitors who spend more than $1,000 at their casino. Based on the sample below, establish a95% confidence interval for the percentage of weekend customers who spend more than $1,000.
a.What is the LOW end of the estimate? answer to 2 decimal in percent form
b.What is the HIGH end of the estimate?answer to 2 decimal in percent form
| Forest City Casino Weekend Customer Spend Survey | ||||||||||
| $500 | $525 | $550 | $725 | $925 | $700 | $550 | $650 | $875 | $725 | $325 |
| $350 | $350 | $275 | $725 | $800 | $225 | $650 | $225 | $100 | $400 | $950 |
| $925 | $575 | $300 | $400 | $150 | $850 | $900 | $750 | $250 | $1,675 | $550 |
| $900 | $275 | $900 | $900 | $850 | $550 | $100 | $700 | $275 | $300 | $175 |
| $825 | $725 | $350 | $700 | $275 | $275 | $200 | $475 | $850 | $600 | $4,725 |
| $600 | $625 | $600 | $725 | $375 | $825 | $125 | $350 | $725 | $300 | $500 |
| $800 | $125 | $500 | $525 | $225 | $550 | $125 | $625 | $825 | $675 | $150 |
| $150 | $450 | $875 | $475 | $425 | $300 | $400 | $8,950 | $150 | $825 | $600 |
| $100 | $475 | $6,300 | $250 | $125 | $750 | $425 | $775 | $375 | $450 | $100 |
| $500 | $975 | $200 | $250 | $250 | $550 | $750 | $600 | $175 | $850 | $525 |
| $525 | $325 | $875 | $175 | $175 | $400 | $250 | $250 | $125 | $625 | $925 |
| $775 | $550 | $575 | $3,050 | $300 | $400 | $800 | $875 | $950 | $775 | $325 |
| $925 | $700 | $200 | $875 | $725 | $350 | $300 | $725 | $975 | $150 | $425 |
| $450 | $300 | $800 | $375 | $350 | $800 | $175 | $450 | $300 | $925 | $100 |
| $600 | $575 | $775 | $525 | $900 | $950 | $750 | $650 | $625 | $250 | $375 |
| $250 | $375 | $125 | $725 | $425 | $9,500 | $275 | $550 | $875 | $625 | $1,900 |
| $450 | $250 | $775 | $375 | $800 | $950 | $200 | $900 | $150 | $450 | $725 |
| $900 | $475 | $600 | $625 | $100 | $500 | $300 | $600 | $175 | $925 | $250 |
| $425 | $450 | $200 | $225 | $375 | $3,625 | $225 | $4,575 | $575 | $800 | $225 |
| $325 | $925 | $400 | $450 | $350 | $925 | $925 | $725 | $775 | $800 | $750 |
| $200 | $150 | $100 | $500 | $925 | $625 | $125 | $775 | $450 | $200 | $225 |
| $375 | $600 | $175 | $225 | $875 | $900 | $575 | $8,100 | $775 | $625 | $625 |
| $5,925 | $4,875 | $800 | $100 | $325 | $700 | $425 | $725 | $525 | $950 | $975 |
| $100 | $825 | $500 | $750 | $350 | $800 | $500 | $650 | $625 | $275 | $300 |
| $375 | $650 | $400 | $3,400 | $200 | $525 | $125 | $725 | $125 | $275 | $5,025 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
