Is anyone savvy with Excel? I'm trying to figure out how to calculate median, mean and mode for a range of sales between specific dates. However, I'm not that advanced with Excel and I have not been able to find the answer after a couple of hours of research on the net. All I seem to find is how to calculate the numbers of days, hours, minutes and seconds between two dates using date arithmetic.
What I'm doing is importing sales data from our MLS into Excel and trying to get excel to find, for example, all sales in January and run statistical calculations on their sales price.
What I'm doing is importing sales data from our MLS into Excel and trying to get excel to find, for example, all sales in January and run statistical calculations on their sales price.