You are provided with data that includes all 50 states of the United States. Your task is to draw a sample of:20 States using Random Sampling (2 points: 1 for random number generation; 1 for random sample)10 States using Systematic Sampling (4 points: 1 for random numbers generation; 1 for generating 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.) 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. Data: No. States ALABAMA ALASKA ARIZONA ARKANSAS CALIFORNIA COLORADO CONNECTICUT DELAWARE FLORIDA GEORGIA HAWAII IDAHO ILLINOIS INDIANA IOWA KANSAS KENTUCKY LOUISIANA MAINE MARYLAND MASSACHUSETTS MICHIGAN MINNESOTA MISSISSIPPI MISSOURI MONTANA NEBRASKA NEVADA NEW HAMPSHIRE NEW JERSEY NEW MEXICO NEW YORK NORTH CAROLINA NORTH DAKOTA OHIO OKLAHOMA OREGON PENNSYLVANIA RHODE ISLAND SOUTH CAROLINA SOUTH DAKOTA TENNESSEE TEXAS UTAH VERMONT VIRGINIA WASHINGTON WEST VIRGINIA WISCONSIN WYOMING Microsoft Excel snapshot for random sampling: Also note the formula used for the last column is visible in the formula bar.Upload to Blackboard a Microsoft word file that provides separate paragraphs, comprising at least two lines, for each of the following:Random sampling (1 point)Systematic sampling (1 point)Advantages of random sampling (1 point)Advantages of systematic sampling (1 point) G7×Aс1No.States21 ALABAMAfx =INDEX($D$2:$D$51, F7)BRand No. Random Sample0.5296685 NEW HAMPSHIREDEFGpopulation50sample1032 ALASKA0.4493186 OKLAHOMAk5+3ARIZONA0.707914 KANSAS54 ARKANSAS 0.4831379 NORTH DAKOTA65 CALIFORNIA 0.7277162 INDIANARandom SampleSample Name76 COLORADO 0.5865002 MISSISSIPPI5INDIANA67:ONNECTICU 0.7640596 ILLINOIS8 DELAWARE 0.5783029 MISSOURI10MARYLAND15COLORADO D2xfx =INDEX($B$2:$B$51, RANK(C2, $C$2:$C$51))A1No.123BStatesсRand No.2ALABAMA0.92595752632ALASKA0.37299997643ARIZONA0.94132304454 ARKANSAS0.071266381DRandom SampleCALIFORNIANORTH CAROLINAARKANSASWASHINGTON

Part 1: Random Sampling (Excel - Sheet 1)Goal: Select 20 states using simple random sampling.Step 1:…

Answered: G7 × A с 1 No. States 2 1 ALABAMA fx…

Holt Mcdougal Larson Pre-algebra: Student Edition 2012

1st Edition

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

Chapter11: Data Analysis And Probability

Section11.2: Box-and-whisker Plots

Problem 1E

See similar textbooks

Related questions

Question

You are provided with data that includes all 50 states of the United States. Your task is to draw a sample of:
- 20 States using Random Sampling (2 points: 1 for random number generation; 1 for random sample)
- 10 States using Systematic Sampling (4 points: 1 for random numbers generation; 1 for generating 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.) 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. Data: No. States ALABAMA ALASKA ARIZONA ARKANSAS CALIFORNIA COLORADO CONNECTICUT DELAWARE FLORIDA GEORGIA HAWAII IDAHO ILLINOIS INDIANA IOWA KANSAS KENTUCKY LOUISIANA MAINE MARYLAND MASSACHUSETTS MICHIGAN MINNESOTA MISSISSIPPI MISSOURI MONTANA NEBRASKA NEVADA NEW HAMPSHIRE NEW JERSEY NEW MEXICO NEW YORK NORTH CAROLINA NORTH DAKOTA OHIO OKLAHOMA OREGON PENNSYLVANIA RHODE ISLAND SOUTH CAROLINA SOUTH DAKOTA TENNESSEE TEXAS UTAH VERMONT VIRGINIA WASHINGTON WEST VIRGINIA WISCONSIN WYOMING Microsoft Excel snapshot for random sampling:
  Also note the formula used for the last column is visible in the formula bar.
- Upload to Blackboard a Microsoft word file that provides separate paragraphs, comprising at least two lines, for each of the following:

Random sampling (1 point)

Systematic sampling (1 point)

Advantages of random sampling (1 point)

Advantages of systematic sampling (1 point)

G7
×
A
с
1
No.
States
2
1 ALABAMA
fx =INDEX($D$2:$D$51, F7)
B
Rand No. Random Sample
0.5296685 NEW HAMPSHIRE
D
E
F
G
population
50
sample
10
3
2 ALASKA
0.4493186 OKLAHOMA
k
5
+
3
ARIZONA
0.707914 KANSAS
5
4 ARKANSAS 0.4831379 NORTH DAKOTA
6
5 CALIFORNIA 0.7277162 INDIANA
Random Sample
Sample Name
7
6 COLORADO 0.5865002 MISSISSIPPI
5
INDIANA
6
7:ONNECTICU 0.7640596 ILLINOIS
8 DELAWARE 0.5783029 MISSOURI
10
MARYLAND
15
COLORADO

D2
xfx =INDEX($B$2:$B$51, RANK(C2, $C$2:$C$51))
A
1
No.
123
B
States
с
Rand No.
2
ALABAMA
0.925957526
3
2
ALASKA
0.372999976
4
3
ARIZONA
0.941323044
5
4 ARKANSAS
0.071266381
D
Random Sample
CALIFORNIA
NORTH CAROLINA
ARKANSAS
WASHINGTON

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here