MATH 221 Week 3 Apply Your Skills assignment

Version: 1 | Last Updated: 8.8.2025 Version: 1 | Last Updated: 8.8.2025 DIRECTIONS On this sheet, you will select a sample of 30 records, which will be used in the remaining worksheets. Note: The dataset is located below these instruc琀椀ons. Watch the demo video on Using a Random Number Generator to obtain a sample. (Copy/paste the URLs to a browser tab or click the ac琀椀ve links located below this box.) To keep the numbers generated by the website visible for reference, paste them into the outlined cell labled "Paste the 30 generated random numbers here...". You may also use any other scien琀椀昀椀c sampling method shared by and approved by your instructor. Demonstra琀椀on VIDEO: h琀琀ps://lms.devry.edu/lms/video/player.html?video=1_3pjt05wl Random Number Generator website: h琀琀ps://www.calculatorsoup.com/calculators/sta琀椀s琀椀cs/random-number-generator.php Click on the down arrow to the right of "Day Number" (in C17) to open the Filter to begin selec琀椀ng exactly 30 of the 120 Day Numbers. Using a sampling method like the one shown in the Step 1 deomonstra琀椀on video ensures your selec琀椀ons are RANDOM. Deselect (uncheck) the (Select All) op琀椀on at the top of the Filter list the 昀椀rst 琀椀me you begin making selec琀椀ons With the 昀氀ter open and no values checked, recheck the selec琀椀on boxes for 30 of the Day Number dataset values that match the 30 numbers obtained from the random number generator in Step 1. Do this by clicking the x on each number that coreresponds to exactly one of the 30 numbers produced by the random number generator unitl all 30 are selected. To verify how many values have been selected at any point, click OK to view the results. The Selected Sample Size value in Column H will update each 琀椀me you click OK in the Filter. You'll use this data sample in the next two sheets in this workbook to answer the ques琀椀ons for the Week 3: Apply Your Skills assignment. Save this Excel 昀椀le to your computer with a new 昀椀lename, such as by adding YourLastName to the end of the current 昀椀lename. Next Step: Go to the Descrip琀椀ve Sta琀椀s琀椀cs worksheet to calculate descrip琀椀ve sta琀椀s琀椀cs. The dataset below lists how many people visited a website daily for 120 days Day Visitors Selected Sample Size: 120 Filter ->> Number 1 250 2 270 Sampling Demonstra琀椀on VIDEO link: h琀琀ps://lms.devry.edu/lms/video/player.html?video=1_3pjt05wl 3 245 Random Number Generator website: h琀琀ps://www.calculatorsoup.com/calculators/sta琀椀s琀椀cs/random-number-generator.php 4 260 5 255 6 275 7 280 8 290 9 265 10 300 11 310 12 320 13 305 14 295 15 280 16 315 17 325 18 310 19 300 20 295 21 290 22 310 23 330 24 345 25 340 26 355 27 360 81 390 82 380 83 370 84 360 85 355 86 365 87 375 88 385 89 395 90 400 91 405 92 395 93 385 94 375 95 365 96 360 97 355 98 350 99 345 100 355 101 365 102 370 103 380 104 390 105 400 106 395 107 385 108 375 109 365 110 360 111 355 112 345 113 335 114 330 115 340