ZochSteveo
New Member
- Joined
- Dec 21, 2024
- Messages
- 18
- Office Version
- 2024
- Platform
- MacOS
Hi everyone.
I was wandering if anyone could help me. I am currently working on a very large dataset involving temperatures and relative humidity. It is for my dissertation at university. As a part of the process I need to clean the data.
I have two options for this. I am going to attempt to clean the data by finding the average of the list of values, as well as its standard deviation. And then any numbers that are 2 times the standard deviation away from the average I am going to consider as outliers.
Please could someone advise me on how I could write a formula for every cell that will check if the value is two times the standard deviation away from the average. Or advise another suggestion. I will try and attach a photo to show what it is that I am dealing with, in order for it to make more sense.
I was wandering if anyone could help me. I am currently working on a very large dataset involving temperatures and relative humidity. It is for my dissertation at university. As a part of the process I need to clean the data.
I have two options for this. I am going to attempt to clean the data by finding the average of the list of values, as well as its standard deviation. And then any numbers that are 2 times the standard deviation away from the average I am going to consider as outliers.
Please could someone advise me on how I could write a formula for every cell that will check if the value is two times the standard deviation away from the average. Or advise another suggestion. I will try and attach a photo to show what it is that I am dealing with, in order for it to make more sense.