The researcher suggests dividing the population of 6,500 stores into 2 strata: stores with weekly sales of $50,000 or less, and those with more than $50,000, where the sum of total sales is $357,315,581 and the strata ratio is 2 to 1.
(a) Arrange the sample by stratum, divide the sample of 30 stores according to these two strata to obtain the size of ( N_h ) and estimate ( S_h^2 ) to determine the size of a stratified sample by proportional allocation with an overall precision of $400 and 95% confidence (create the sample by stratum randomly in Excel in such a way that they comply with the total sales sum, explaining step by step how you did this).
(b) Obtain the stratified sample from the population and again estimate the overall mean and 95% confidence interval.