No. 1 States ALABAMA 2 ALASKA 3 ARIZONA 4 ARKANSAS 5 CALIFORNIA 6 COLORADO 7 CONNECTICUT 8 DELAWARE FLORIDA HAWAII IDAHO ILLINOIS 9 10 GEORGIA 11 12 13 14 15 16 17 18 19 20 INDIANA IOWA KANSAS KENTUCKY LOUISIANA MAINE MARYLAND 21 MASSACHUSETTS MICHIGAN MINNESOTA MISSISSIPPI MISSOURI MONTANA NEBRASKA NEVADA NEW HAMPSHIRE 24 26 27 29 30 31 NEW MEXICO 33 34 43 44 45 46 47 48 49 50 *22*LØF@PRT~~~382888588888588GF¥¥¥¥GGGGR NEW JERSEY 36 37 39 NEW YORK NORTH CAROLINA NORTH DAKOTA OHIO OKLAHOMA OREGON PENNSYLVANIA RHODE ISLAND 40 SOUTH CAROLINA 41 42 SOUTH DAKOTA TENNESSEE TEXAS UTAH VERMONT VIRGINIA WASHINGTON WEST VIRGINIA WISCONSIN WYOMING Business Statistics Assignment: Sampling Techniques Topic: Sampling Techniques - Random Sampling and Systematic Sampling Software Required: Microsoft Excel Assignment Description: 1. Upload to Blackboard a Microsoft word file that provides separate paragraphs, comprising at least two lines, for each of the following: Question Answer - Elaborate as much as you can. You can take the help from online resources, but you must write in your own words. Random sampling (1 point) Systematic sampling (1 point) Advantages of random sampling (1 point) Advantages of systematic sampling (1 point)
You are provided with data that includes all 50 states of the United States. Your task is to
draw a sample of:
o 20 States using Random Sampling (2 points: 1 for random number generation; 1 for
random sample)
o 10 States using Systematic Sampling (4 points: 1 for random numbers generation; 1
for random sample different from the previous answer; 1 for correct K value
calculation table; 1 for correct sample drawn by using systematic sampling) (For
systematic sampling, do not use the original data directly. Instead, first randomize the data, and then
use the randomized dataset to draw your sample. Furthermore, do not use the random list previously
generated, instead, generate a new random sample for this part. For more details, please see the
snapshot provided at the end.)
Upload a Microsoft Excel file with two separate sheets. One sheet provides random sampling
while the other provides systematic sampling. Excel snapshots that can help you in organizing
columns are provided on the next page
Step by step
Solved in 2 steps