IM3.7B.3 MOE
The pdf below contains 100 rectangles of various areas. To select a random sample of 10 rectangles, we're going to use a spreadsheet function to generate lists of random numbers, then find the areas of those rectangles, then calculate the mean area of our sample.[br][br]1. In cell A1, type [b]=randombetween(0,99)[/b] and press [b]return[br][/b]2. Hold your cursor over the square in the bottom right corner of this cell to get the [b]+[/b] cursor, then drag down to cell A10.[br][br]You should now have a list of 10 random numbers between 0 and 99. Find the areas of those rectangles and list them in column B.
1. Calculate the mean and [b]sample[/b] standard deviation (s, not σ) of the areas by selecting column B and choosing 1 variable analysis, then show statistics.[br]2. Use the sample standard deviation to estimate the population standard deviation using this formula: [br][math]\sigma\approx\frac{s}{\sqrt{n}}[/math][br]3. Use this estimate to estimate the margin of error for your sample (2 standard deviations).[br]4. Report: What does this MOE tell you?
IM3.7B.3 Rectangles