The sample size calculated is n= 82 Animal ID Feedlot ID The sample size calcula

Question

The sample size calculated is n= 82

Animal ID

Feedlot ID

The sample size calculated is n= 82

Animal ID

Feedlot ID

1859 3 7028 2 7374 5 2920 1 9174 6 1939 5 6667 3 2418 2 9533 6 1991 4 9628 3 7186 5 2159 4 9480 5 1008 4 7994 6 4891 7 5865 5 3789 1 4322 6 4647 3 3775 4 3809 5 2350 2 3609 4 2377 6 9653 1 7184 7 7082 6 1830 6 9470 1 1965 5 7938 6 3652 3 1952 5 9314 2 9662 4 4894 3 7600 1 6878 1 5086 5 4562 2 3834 4 4112 3 7554 1 8587 2 4992 4 9445 5 9626 7 7876 2 1656 7 2902 6 5218 6 7625 2 2907 4 4607 4 1626 3 7294 3 7659 1 5853 3 7209 1 1779 6 9379 3 2022 3 6520 7 4328 7 6372 3 8395 6 9514 4 7057 2 1687 4 1954 3 2477 2 9782 6 5849 5 9883 5 9172 2 5982 6 3301 3 4853 7 9953 3 5170 6 9103 4 1288 3 8800 4 9185 5 3775 3 6437 7 5701 2 9194 6 5613 4 7721 6 3793 3 7779 1 5827 1 3996 1 6574 7 8668 5 2887 4 6211 5 8806 7 5025 6 3018 6 2723 1 4735 2 6714 2 5895 4 4022 7 9268 4 7645 1 6572 2 1723 3 4260 1 8557 2 1732 3 8172 6 6124 4 7093 6 1285 6 6143 1 5658 5 6775 5 8720 3 8700 6 6734 6 3000 4 2372 3 1305 4 5153 5 3370 3 5298 1 3635 1 8023 4 4709 3 9016 7 8265 6 2036 6 3924 7 6460 1 5157 2 9490 1 2854 4 5996 5 6775 2 8933 3 2550 3 8848 1 5903 5 8012 4 6610 6 3147 4 6261 1 9488 2 6430 5 1629 4 1500 1 9000 7 7332 4 6233 1 4924 7 2781 1 8755 1 4840 7 7376 4 2620 5 1414 6 4615 3 1206 5 2585 3 2863 3 2224 7 7499 1 7790 6 9734 2 9413 1 8210 1 3343 7 8542 3 5786 3 8669 5 6651 3 8417 6 5687 6 4596 2 7697 5 8175 3 5412 4 6667 2 5437 2 1542 4 7424 2 4984 3 3643 1 9151 5 2156 7 4532 3 2754 5 4907 6 5204 3 6890 4 4098 6 2009 3 3929 2 3831 4 7256 3 1433 5 6250 6 9449 4 5589 1 7586 2 9228 4 1672 5 9262 1 6796 7 3395 7 9657 4 7704 7 4205 2 9830 7 5935 2 5918 5 5399 6 3808 2 6568 6 3179 7 8222 1 5643 6 5043 1 4834 5 5215 2 3132 2 6783 4 8286 2 4785 7 7526 3 4035 5 7985 2 5999 4 4094 5 1032 5 1765 6 9840 4 6490 2 6445 3 9794 5 4002 5 1652 5 2158 5 3464 1 4442 1 9853 6 7598 5 3702 3 1033 4 4472 4 9322 2 3626 1 2196 7 2176 2 7452 7 3449 2 8346 2 4467 5 5566 6 7058 2 4191 6 5508 1 7168 6 5319 2 4709 4 7163 3 8980 5 5249 2 3457 2 2285 4 3738 5 4895 6 4124 5 4192 6 8231 5 1610 3 3171 5 4329 1 5609 2 5183 3 1008 6 1879 6 3842 4 5640 7 1484 4 8307 5 6837 7 5734 3 5486 4 1704 4 1050 7 8796 2 5121 6 4556 4 6183 1 7053 5 1063 5 3950 7 6967 7 6778 4 8810 6 1534 4 6157 1 5926 6 3321 4 6965 3 9553 3 6581 1 1619 6 6282 2 4404 5 2260 6 9441 4 7811 2 8956 2 6595 5 6679 1 3441 2 6598 3 3899 1 6661 4 5848 7 5614 1 7398 5 6700 5 9102 7 9528 4 1676 3 2920 2 9164 5 9204 3 9792 1 4917 5 1471 7 9032 6 1537 6 9768 6 1623 7 1552 7 2830 5 9997 3 1793 6 6659 3 3099 4 1102 7 5605 2 6981 5 4216 1 3879 7 3345 3 3706 5 7934 7 9889 4 2266 6 5312 3 8802 3 4019 2 9810 2 3292 2 2863 2 2516 2 2492 1 3029 4 5355 6 7403 5 3808 7 3266 3 4659 4 7091 6 5269 7 5186 4 8213 6 9745 7 5066 1 9122 5 5092 7 8009 1 1222 7 6291 4 7189 6 2237 1 6271 7 4532 4 1894 3 1582 1 2425 7 2009 7 5998 3 5604 1 7899 2 6662 6 7245 4 1212 6 2948 3 2949 1 1929 6 6036 6 2904 5 4750 2 5401 1 3410 2 2537 5 6921 1 2750 2 3032 2 1269 6 4321 5 8013 2 2690 4 6076 1 2829 4 5360 6 3469 3 9006 7 7370 5 9317 3 6699 6 5056 4 7193 5 9630 4 1355 4 2883 3 2092 1 2648 4 2882 6 1647 4 4235 6 6616 7 5235 4 5653 2 6910 3 6441 1 1478 1 3293 1 1013 2 9574 5 9550 2 3861 1 5336 6 2110 6 4857 2 6688 7 2354 1 9634 6 9485 2 For the second part of this assignment, use the provided Microsoft Excel worksheet to select a simple random and systematic sample using the sample size you calculated. For the systematic sample you want to select every seventh animal.

Explanation / Answer

Steps for Microsoft excel:

1. Go to Data, then go to Data analysis.

2. Select Sampling, Select your input data range and select suitable sampling method.

SIMPLE RANDOM SAMPLE SYSTEMATIC SAMPLE SERIAL NO. ANIMAL ID Feedlot ID SERIAL NO. ANIMAL ID Feedlot ID 1 4329 1 1 6667 3 2 7398 5 2 9480 5 3 1552 7 3 4647 3 4 9194 6 4 7184 7 5 9840 4 5 1952 5 6 6076 1 6 4562 2 7 7554 1 7 9626 7 8 6581 1 8 4607 4 9 8557 2 9 9379 3 10 9228 4 10 7057 2 11 1732 3 11 9172 2 12 4984 3 12 1288 3 13 2863 3 13 5613 4 14 1765 6 14 8668 5 15 1212 6 15 4735 2 16 4205 2 16 1723 3 17 3292 2 17 1285 6 18 5614 1 18 3000 4 19 4019 2 19 8023 4 20 7659 1 20 5157 2 21 2863 3 21 8848 1 22 6430 5 22 6430 5 23 4098 6 23 2781 1 24 4895 6 24 1206 5 25 8172 6 25 9413 1 26 5235 4 26 8417 6 27 1212 6 27 5437 2 28 7554 1 28 4532 3 29 9553 3 29 3929 2 30 1008 4 30 7586 2 31 2492 1 31 7704 7 32 2176 2 32 6568 6 33 6616 7 33 3132 2 34 8668 5 34 5999 4 35 1626 3 35 9794 5 36 8587 2 36 7598 5 37 9480 5 37 2176 2 38 4022 7 38 4191 6 39 6595 5 39 5249 2 40 9953 3 40 8231 5 41 1285 6 41 1879 6 42 6662 6 42 5486 4 43 1991 4 43 7053 5 44 5786 3 44 6157 1 45 1939 5 45 6282 2 46 4532 3 46 6679 1 47 1647 4 47 7398 5 48 7790 6 48 9204 3 49 9883 5 49 1623 7 50 9883 5 50 1102 7 51 2948 3 51 7934 7 52 4442 1 52 3292 2 53 6890 4 53 3808 2 54 4735 2 54 9745 7 55 1433 5 55 7189 6 56 4891 7 56 2009 3 57 9194 6 57 2948 3 58 4328 7 58 3410 2 59 8557 2 59 8013 2 60 1008 4 60 7370 5 61 4321 5 61 2883 3 62 1008 4 62 5235 4 63 3395 7 63 9574 5 64 9653 1 64 2354 1 65 1013 2 65 9174 6 66 3706 5 66 7186 5 67 4853 7 67 3789 1 68 6783 4 68 2377 6 69 7053 5 69 7938 6 70 4192 6 70 6878 1 71 2585 3 71 4992 4 72 9032 6 72 7625 2 73 1050 7 73 7209 1 74 3171 5 74 8395 6 75 7398 5 75 5849 5 76 5336 6 76 5170 6 77 4562 2 77 5701 2 78 6967 7 78 3996 1 79 6598 3 79 3018 6 80 6441 1 80 7645 1 81 2266 6 81 6124 4 82 9953 3 82 8700 6

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.