Question one Show all formulas and calculations. If you do the calculations in Excel please copy across the relevant Tab

[answerhappygod]

Question one
Show all formulas and calculations. If you do the
calculations in Excel please copy across the relevant
Table/Output
Over time a retailer has determined that 20% of all customers
entering the store will make a purchase.
In order to increase sales volume the retailer has introduced a
new store layout. Over the course of one week they monitored 1500
customers to see if they made a purchase. They are now interested
to see if the proportion of customers making a purchase has grown
to more than 0.25.