Excel & Statistics 40: Range & Interquartile Range (Variability)

Hi, I am complete beginner to excel 2007 so excuse me if this question is obvious. I can not figure out how to find the range, coefficient of variation, and interquartile range using a set of numbers. Even if someone can point me in the right directions I would appreciate it.

Thanks.

Hello there. I am new to VBA and I need some help. I specifically need help writing a macro to look at "sheet2" in a workbook, determine how many rows and columns I have data in, and then create a named range. So for instance I have a data set that exists in "sheet2". This data set has 2 columns (Name,Number), and there is 20 rows of data. I want to select this data and name a range. This sheet will have a static amount of columns but the total number of rows will be variable and I need this macro to be able to handle this variance. Please Please help. This is the crux.

I'm trying to wean one of our employees off Lotus 123. He wants to be able to
paste/insert a range of cells that have been previously defined/named without
having to go and copy it first. We are using Office 2003.

I have a macro that I wrote that is roughly 1000 lines of code and I have been using it for months now. In the end it gives the correct results. The question I have is why the run time varies so much. Sometimes it takes 1.5 minutes to run and other times it can take 1 hr.

The obvious answer would be that the more information it has to process the long it will take. However, I am always processing roughly 10k records. I have no other appliations running simotaniously and I have rebooted my computer just prior to running the code.

The purpose of this code is to look at hundreds of investment accounts and evaluate a Varity of metrics and write out the results.

I am sure you will want to see the code to make a recommendation but I am really only comfortable sending it via email for a variety of reasons.

Thank you for any help.

Basically, I have two lists and I want to do a lookup function to compare them and find the overlap between them (eventually I'll be making a ven diagram of the two lists). The entries in each of the lists have two basic components: the IPI part (column A and D) and the number part (column B and E). You can merge the two cells (ex. A1 and B1 to produce a merged C1) if that would make the searching easier. The difficult part is that the lookup doesn't need to be exact. I want the lookup function to allow for a margin of error of +/-15 with regards to the numbers in columns B and E. So for example, in list 1 you see IPI12583792 234 and in list 2 you see IPI12583792 232. Clearly these are not the same. However, I want them to be put in the overlap columns I and J, because firstly, the IPIs match, and secondly, 232 is within +/-15 of 234. So, columns A through E are what you start with, and columns G through L are what I want in the end. Note that there may be more than one match in the lists you're searching against. For example, IPI12583792 234, hits both the D3E3 entry AND the D4E4 entry. It's important that the D4E4 entry isn't overlooked even though it comes later in the list. Any help would be very much appreciated!

Basically, I have two lists and I want to do a lookup function to compare them and find the overlap between them (eventually I'll be making a ven diagram of the two lists). The entries in each of the lists have two basic components: the IPI part (column A and D) and the number part (column B and E). You can merge the two cells (ex. A1 and B1 to produce a merged C1) if that would make the searching easier. The difficult part is that the lookup doesn't need to be exact. I want the lookup function to allow for a margin of error of +/-15 with regards to the numbers in columns B and E. So for example, in list 1 you see IPI12583792 234 and in list 2 you see IPI12583792 232. Clearly these are not the same. However, I want them to be put in the overlap columns I and J, because firstly, the IPIs match, and secondly, 232 is within +/-15 of 234. So, columns A through E are what you start with, and columns G through L are what I want in the end. Note that there may be more than one match in the lists you're searching against. For example, IPI12583792 234, hits both the D3E3 entry AND the D4E4 entry. It's important that the D4E4 entry isn't overlooked even though it comes later in the list. Any help would be very much appreciated!

I thought Standard Deviation measured the extent of variability of a set of numbers, but the following sets of numbers both have the same degree of variability, but different Standard Deviations. So what measure should I use?
STDEVP(1, 3, 7, 4) = 2.17
STDEVP(10, 30, 70, 40) = 21.65

Basically, I have two lists and I want to do a lookup function to compare them and find the overlap between them (eventually I'll be making a ven diagram of the two lists). The entries in each of the lists have two basic components: the IPI part (column A and D) and the number part (column B and E). You can merge the two cells (ex. A1 and B1 to produce a merged C1) if that would make the searching easier. The difficult part is that the lookup doesn't need to be exact. I want the lookup function to allow for a margin of error of +/-15 with regards to the numbers in columns B and E. So for example, in list 1 you see IPI12583792 234 and in list 2 you see IPI12583792 232. Clearly these are not the same. However, I want them to be put in the overlap columns I and J, because firstly, the IPIs match, and secondly, 232 is within +/-15 of 234. So, columns A through E are what you start with, and columns G through L are what I want in the end. Note that there may be more than one match in the lists you're searching against. For example, IPI12583792 234, hits both the D3E3 entry AND the D4E4 entry. It's important that the D4E4 entry isn't overlooked even though it comes later in the list. Any help would be very much appreciated!

Hello, I need your help

I have two sheets (sheet1 and sheet 2) and I want too find on sheet3 the difference between those sheets (numbers) ..and to difference to be like this:
sheet1.Range(A1:F12) - sheet2.Range(A1:F12) = sheet3.Range(A1:F12)
in VBA.

thank you