3,893 questions
Stratified Random Sampling in power query
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 61%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
BANU KUMAR
0
Reputation points
Good Morning. Hope you are doing well.
I need help on Stratified random sampling from the attached data. That data has 60000 records.
Stratified Random should cover All Keying ID based on Volume Processed on Keying Type and Site.
minimum sample should be 385 or 0.5 percentile of the Volume percentage
Please find the attached pdf for reference
Microsoft 365 and Office | Excel | For business | Windows
{count} votes
-
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff2024-02-19T02:31:11.2933333+00:00 Hi, There is no attachment, please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
-
BANU KUMAR 0 Reputation points
2024-02-22T18:49:14.6533333+00:00 i had attached a pdf file
-
BANU KUMAR 0 Reputation points
2024-02-22T18:59:24.6566667+00:00 Good Morning. Hope you are doing well. I need help on Stratified random sampling from the attached data. That data has 60000 records. Stratified Random should cover All Keying ID based on Volume Processed on Keying Type and Site. minimum sample should be 385 or 0.5 percentile of the Volume percentage |Site|Keying Type|Keying ID| | -------- | -------- | -------- | |Site|Keying Type|Keying ID| |ATL|SUP|| |BOS|CHECK|| |CAN||| |CHI||| |DAL||| |LAC||| |STL|||
Thanks and Regard Banu Uday Kumar 9866647450
-
BANU KUMAR 0 Reputation points
2024-02-22T19:00:55.6133333+00:00 Please provide your email address, so that i can send the entire data sheet
-
BANU KUMAR 0 Reputation points
2024-02-23T18:42:01.36+00:00 ******@gmail.com
Sign in to comment