(Solved): Would you please help with a detailed explanation, I have this data need cluster sampling in Excel a ...

Would you please help with a detailed explanation, I have this data need cluster sampling in Excel and answer the 3 questions, thank you????

To perform a cluster sample, the data should be arranged into groups that can each represent the population. A random group is then selected for the sample. In Excel, the best way to have a cluster sample is to number each of the groups, then use Excel to select one of those numbers. To do this, use the RANDBETWEEN function. Random members from the corresponding group(s) will make up the sample. The number of groups to select to create your sample will be specified for your group. You have been provided with several large data sets. You will be assigned a data set and sampling process. Copy your data to a new spreadsheet. Select your sample as indicated for your data set then copy and paste your sample to a new sheet. Answer the following questions for your data and submit your file for marking by the due date. 1. Is the sample data qualitative or quantitative? Justify your answer. 2. If the data is quantitative, classify it as discrete or continuous. Justify your answer. 3. What level of measurement is the data have you collected? Justify your answer.