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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!