Question: ASSIGNED PROBLEM 3: You wish to learn the average number of pounds of garbage disposed of in a week by the people on Concordia St.
- ASSIGNED PROBLEM 3: You wish to learn the average number of pounds of garbage disposed of in a week by the people on Concordia St. within 2 pounds. Using the standard deviation from problem 1as an estimate, how large of a sample should you get?
- ASSIGNED PROBLEM 4: You wish to learn the proportion of homes on Concordia St. that recycle within 10% and with 99% confidence. How large of a sample should you get?
please give the formulas for how the results came.
Use Garbage.xls file which consists of data from 60 fictional homes on Concordia St. It includes variables regarding the household size, the pounds of each type of garbage disposed in a week, the total weight of their garbage each week, and whether or not the household recycles.
HHSIZE 2 FOOD 1.04 3.68 PLAS 0.27 1.41 2.19 2.83 2.19 1.81 3.05 2.98 63 1.46 9.62 4.41 2.73 9.31 3.59 5.36 YARD 038 0 0.24 0.63 0.15 4 58 4.76 0.13 3.86 07 13.45 0.74 0.82 6.14 TEXT 0.06 0.46 05 2.26 0.55 0.36 0.21 0.81 RECYCLE NO NO NO YES YES YES YES YES 3 5 4 2 5 5 4 4 5 3 5 5 2 4 YES 0.37 2.1 2.93 2.44 2.17 1.41 2 PAPER 241 7.57 9.55 8.82 8.72 6.96 11.42 16.08 6.38 13.05 11.36 15.09 28 6.44 5.86 11.08 12.43 6.05 1361 6.98 14.33 13.31 6.67 17.65 1273 9.83 16.39 6.33 9.19 0.93 4 3 3 2 2. 4 5 5 3 297 2.04 0.65 2.13 0.63 1.53 4.69 1.45 2.68 3.53 1.49 2.31 0.92 0.89 0.8 0.72 266 4.37 0.92 METAL 1.09 1.04 2.57 3.02 1.5 2.1 3.57 2.32 1.89 3.26 3.99 2.04 0.99 2.96 1.5 2.43 2.97 1.42 3.6 4.48 1.36 2.11 2.02 3.27 4.95 1 1.55 1.41 1.05 1.31 2.5 2.35 3.69 3.61 1.49 1.36 1.73 0.94 1.33 2.62 1.25 0.26 4.41 3.22 1.86 1.76 2.83 2.74 4.63 1.7 3.29 1.22 3.2 3.09 2.58 1.67 0.85 1.52 1.37 1.32 GLASS 86 3.46 4.52 4.92 6.31 2.49 5.81 1.96 17.67 3.21 4.94 3.1 1.39 5.21 2.03 1.74 3.99 6.26 3.52 2.01 2.21 0.25 6.85 2.33 5.45 2.04 4.98 3.54 1.06 2.7 1.14 12.24 5.67 2.43 4.02 6.45 1.89 1.78 2.93 1.82 2.89 0.99 1.93 3.61 2.53 3.76 1.32 2.64 12.33 1.79 3.99 7.06 2.52 1.75 5.64 1.90 6.46 6.72 5.78 9.72 5.52 11.92 4.58 4.76 7.85 29 2.87 5.09 3.17 24 132 2.07 4 4.25 0.42 0.44 0.2 0.27 0.39 2.47 0.86 0.96 0.11 0.17 0.46 0.68 0.28 0.67 0.54 0.2 0.03 0.01 0.06 0.02 4.73 1.15 0.63 0.04 147 0.22 0 0 2 0.58 0.02 0 0.83 0 0.42 2.04 3.85 0.33 0.64 0 787 3 2 OTHER 4.66 2.34 36 1265 2.18 2.14 10.83 4.14 0.25 11.61 1.15 4.15 1.03 14.43 9.55 2.54 9.2 0 1.32 0.18 1.62 0.4 0.03 4.03 19.89 0.12 1.48 0.04 0.03 0.71 0.01 0.78 1.17 0 0 2.02 0.58 0.05 0.59 0.49 0.16 0 4.6 1.12 2.45 0.04 2.03 1.14 15.65 0.59 133 6.02 0.55 2.13 1.46 1.13 1.04 1.61 2 TOTAL 10.76 19.96 27.6 38.11 27.9 21.9 49.27 33 27 35.54 44 44 45.17 33.07 10.35 44.44 24.13 37.6 38.96 17.17 31.6 23.11 27.56 30.96 23.22 42.99 51.9 20.2 36.8 19.02 15.43 20.71 17.01 45.35 49.37 18.06 17.41 23.67 19.13 20.99 21.18 29.06 14.95 4.43 24.82 20.8 25.79 14.62 28.41 27.17 54.47 13.12 45.77 34.79 37 26 51.58 24.81 26.18 11.25 28.15 11.14 11.7 2 5 2 2. 2 2 2 9.45 12 32 20.12 7.72 6.16 7.98 NO YES YES NO YES NO YES YES YES NO YES NO YES NO YES YES YES YES YES YES NO NO YES YES NO YES NO YES NO YES YES YES NO YES YES YES YES NO YES YES YES NO YES NO YES NO YES NO YES NO YES 0.12 1.45 1.68 1.53 1.73 3 3 2 2 3 5 1.87 8.13 3.51 4.21 3.34 0.77 1.14 1.45 6.54 0.92 5.14 4.59 2.94 0.68 0.3 0.02 0.01 0.36 0 4.73 269 0.34 0.92 0 0 1.12 5.6 1.07 0.12 0 09 8.08 10.99 13.11 3.26 1.65 10 8.96 9.46 5.88 8.26 12.45 10.58 5.87 8.78 11.03 12.29 20.58 12 56 9.92 3.45 9.09 3.69 261 4 3 3 5 3 5 5 4 5 5 1.44 1.36 0.38 1.74 235 2.3 1.14 288 2.13 5.28 148 3.36 2.83 287 2.96 1.61 1.58 1.15 1.28 0.58 0.74 0.12 0.39 0.64 0 0.04 0.08 0.09 0.65 0 0.35 0.41 2.94 0.27 1.71 1.95 1.87 1.52 0.21 0.2 0.02 0.96 0 0 10.44 5.91 16.81 5.01 1.32 0.47 43 o 9.25 4.02 1.38 1.59 0.85 8.87 3.64 3.03 2 3.89 4.83 0.13 0 0 0.00 0.17 2 2 3.37 0.46 HHSIZE 2 FOOD 1.04 3.68 PLAS 0.27 1.41 2.19 2.83 2.19 1.81 3.05 2.98 63 1.46 9.62 4.41 2.73 9.31 3.59 5.36 YARD 038 0 0.24 0.63 0.15 4 58 4.76 0.13 3.86 07 13.45 0.74 0.82 6.14 TEXT 0.06 0.46 05 2.26 0.55 0.36 0.21 0.81 RECYCLE NO NO NO YES YES YES YES YES 3 5 4 2 5 5 4 4 5 3 5 5 2 4 YES 0.37 2.1 2.93 2.44 2.17 1.41 2 PAPER 241 7.57 9.55 8.82 8.72 6.96 11.42 16.08 6.38 13.05 11.36 15.09 28 6.44 5.86 11.08 12.43 6.05 1361 6.98 14.33 13.31 6.67 17.65 1273 9.83 16.39 6.33 9.19 0.93 4 3 3 2 2. 4 5 5 3 297 2.04 0.65 2.13 0.63 1.53 4.69 1.45 2.68 3.53 1.49 2.31 0.92 0.89 0.8 0.72 266 4.37 0.92 METAL 1.09 1.04 2.57 3.02 1.5 2.1 3.57 2.32 1.89 3.26 3.99 2.04 0.99 2.96 1.5 2.43 2.97 1.42 3.6 4.48 1.36 2.11 2.02 3.27 4.95 1 1.55 1.41 1.05 1.31 2.5 2.35 3.69 3.61 1.49 1.36 1.73 0.94 1.33 2.62 1.25 0.26 4.41 3.22 1.86 1.76 2.83 2.74 4.63 1.7 3.29 1.22 3.2 3.09 2.58 1.67 0.85 1.52 1.37 1.32 GLASS 86 3.46 4.52 4.92 6.31 2.49 5.81 1.96 17.67 3.21 4.94 3.1 1.39 5.21 2.03 1.74 3.99 6.26 3.52 2.01 2.21 0.25 6.85 2.33 5.45 2.04 4.98 3.54 1.06 2.7 1.14 12.24 5.67 2.43 4.02 6.45 1.89 1.78 2.93 1.82 2.89 0.99 1.93 3.61 2.53 3.76 1.32 2.64 12.33 1.79 3.99 7.06 2.52 1.75 5.64 1.90 6.46 6.72 5.78 9.72 5.52 11.92 4.58 4.76 7.85 29 2.87 5.09 3.17 24 132 2.07 4 4.25 0.42 0.44 0.2 0.27 0.39 2.47 0.86 0.96 0.11 0.17 0.46 0.68 0.28 0.67 0.54 0.2 0.03 0.01 0.06 0.02 4.73 1.15 0.63 0.04 147 0.22 0 0 2 0.58 0.02 0 0.83 0 0.42 2.04 3.85 0.33 0.64 0 787 3 2 OTHER 4.66 2.34 36 1265 2.18 2.14 10.83 4.14 0.25 11.61 1.15 4.15 1.03 14.43 9.55 2.54 9.2 0 1.32 0.18 1.62 0.4 0.03 4.03 19.89 0.12 1.48 0.04 0.03 0.71 0.01 0.78 1.17 0 0 2.02 0.58 0.05 0.59 0.49 0.16 0 4.6 1.12 2.45 0.04 2.03 1.14 15.65 0.59 133 6.02 0.55 2.13 1.46 1.13 1.04 1.61 2 TOTAL 10.76 19.96 27.6 38.11 27.9 21.9 49.27 33 27 35.54 44 44 45.17 33.07 10.35 44.44 24.13 37.6 38.96 17.17 31.6 23.11 27.56 30.96 23.22 42.99 51.9 20.2 36.8 19.02 15.43 20.71 17.01 45.35 49.37 18.06 17.41 23.67 19.13 20.99 21.18 29.06 14.95 4.43 24.82 20.8 25.79 14.62 28.41 27.17 54.47 13.12 45.77 34.79 37 26 51.58 24.81 26.18 11.25 28.15 11.14 11.7 2 5 2 2. 2 2 2 9.45 12 32 20.12 7.72 6.16 7.98 NO YES YES NO YES NO YES YES YES NO YES NO YES NO YES YES YES YES YES YES NO NO YES YES NO YES NO YES NO YES YES YES NO YES YES YES YES NO YES YES YES NO YES NO YES NO YES NO YES NO YES 0.12 1.45 1.68 1.53 1.73 3 3 2 2 3 5 1.87 8.13 3.51 4.21 3.34 0.77 1.14 1.45 6.54 0.92 5.14 4.59 2.94 0.68 0.3 0.02 0.01 0.36 0 4.73 269 0.34 0.92 0 0 1.12 5.6 1.07 0.12 0 09 8.08 10.99 13.11 3.26 1.65 10 8.96 9.46 5.88 8.26 12.45 10.58 5.87 8.78 11.03 12.29 20.58 12 56 9.92 3.45 9.09 3.69 261 4 3 3 5 3 5 5 4 5 5 1.44 1.36 0.38 1.74 235 2.3 1.14 288 2.13 5.28 148 3.36 2.83 287 2.96 1.61 1.58 1.15 1.28 0.58 0.74 0.12 0.39 0.64 0 0.04 0.08 0.09 0.65 0 0.35 0.41 2.94 0.27 1.71 1.95 1.87 1.52 0.21 0.2 0.02 0.96 0 0 10.44 5.91 16.81 5.01 1.32 0.47 43 o 9.25 4.02 1.38 1.59 0.85 8.87 3.64 3.03 2 3.89 4.83 0.13 0 0 0.00 0.17 2 2 3.37 0.46 Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
