correlate

Hello, i would greatly appreciate any help! My question is as follows: I would like to find the correlation between being female, that is value=1 in column A, and answering >=11 in column C. How can i do this? I don`t understand how to use the corrolation command with conditions. I`m right in...

Hello Everyone, I have a list of Jobs and Hours worked. I need do correlate all the job numbers into a list and add up the total hours. Typically I have 6 columns (Job No#/Hours)with jobs across 7 rows for the days. I have a dedicated bunch of rows below to populate the list. Your help...

(Win 7 Excel 2013) Hey Guys. I have raw data that has three rows (account numbers, tickers, and values) and I am trying to set up a macro that will paste the values from one sheet into another. But the raw data is ever changing (tickers change, accounts are added, ect) so the cells are not the...

I have a dataset with multiple layers where certain data points correlate to a single piece then that single piece correlates to multiple points. I am trying to flatten the data set so that all base items correlate to the final item in the total quantities. This is how the data is currently...