nogoalstoday
New member
- Joined
- Mar 11, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
So my data consists of two independent variables, one in column a and the other in column b. I am looking to find the average of values in column b that correspond to values in column a that exceed a value.
Sorry if that is hard to understand. Column A features Birthrates by county, and column B features the Highschool dropout rate in the same county. I am trying to figure out how to find the average high school dropout rate in counties with >15% birthrate.
Thanks to anyone who takes the time to read this!
I am an excel noobie, I could do =averageif functions, but I cannot figure out how to do it while including more than one column..
Sorry if that is hard to understand. Column A features Birthrates by county, and column B features the Highschool dropout rate in the same county. I am trying to figure out how to find the average high school dropout rate in counties with >15% birthrate.
Thanks to anyone who takes the time to read this!
I am an excel noobie, I could do =averageif functions, but I cannot figure out how to do it while including more than one column..