The sample size calculated was n= 82 Animal ID Feedlot ID 1859 3 7028 2 7374 5 2

Question

The sample size calculated was 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 to follow in microsoft excel :

1. Go to Data then go to Data analysis.

2. Select Sampling.

3. Enter the input range of data 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.