Preparing Data for Correlation Analysis
Use Microsoft Excel or Google Sheets to examine the following seven original data sets describing Maine public PK-12 schools: The data from all seven of these data sets have been collapsed and condensed through a process researchers call “data cleaning” or “data cleansing” into one summary data set:
( I will upload all 8 data sets saved in excel to analyze for paper)
Explore the summary data set and make notes on differences you can see between it and the original data sets.
In approximately 750-1,000 words, address the following:
· Describe the broad differences between the original data sets and the cleaned summary data set.
· What steps appear to have been taken to create the summary data set, and why you think those actions might have been taken?
· What kinds of errors might be introduced as the data are collapsed from seven original sets into one single, summary set?
· What do you believe researchers should keep in mind in order to ensure that they “clean” data in an ethical, responsible manner?