# correlation

1. ### Testing for positive correlation in excel (Economics)

I want to test for positive correlation between scoring a value of less than 19 in the column "Choice_2" and scoring a value of 1 in the column "vaa_dummy". To separate out the subjects who answered a value of less than 19 in column "choice_2" i created a dummy, which gave value equal to 1 if...
2. ### Rank (Spearman) Correlation of Non-Adjacent Values in Excel in Single Formula

Rank (Spearman) Correlation of Non-Adjacent Values in Excel in Single Formula 1. In a single formula, I am trying to get the Rank (Spearman) correlation between two arrays. One of the arrays contains non-adjacent values. I can get the Pearson correlation with this formula...
3. ### VBA Correlation matrix with Paramarray

Hello, I have an excel sheet with multiple columns and I need to create correlation matrix for some columns that are not necessarily next to each other. I tried to replace the range with paramarray in an UDF, but didn't work and I have no idea about how to solve this problem. Function...
4. ### How do I create Simularity/Correlation Matrix using Non-Numeric Data

Hello, I am trying to create a matrix of constituents in our database comparing their Relationships to other constituents. I have a list of constituents, and each one has a list of people they have relationships with (represented here are constituent IDs for people attached to their record as a...
5. ### How to analyse correlations?

Price change % is my column of interest. I would like to measure whether or not there are correlations between Price change % and any of the other columns. What visualisations would be best for this? What I've tried so far is creating pivot tables and grouping by Production year, Category...
6. ### Standard deviation of correlation matrix

I am looking to get the standard deviation of each correlation coefficient in a matrix. The matrix is complete (as in each pairwise correlation in included twice) but i want the standard deviation including only each coefficient once. The matrix will vary in size and can be quite large so i...
7. ### Correlation between two columns, ignoring errors

Hi all, I want to check the correlation between two columns (column B and I), taking out all the values that give an error. Furthermore if a certain nth value in column B (I) gives an error, the corresponding nth value in column I (B) should also be ignored. I did it this way but it gaves a...
8. ### Predicting sales figures from quotes

Hi all Probably quite a basic question for you experts on here but I'm trying to solve the following problem: I have values of quotes and values of sales for c.30 weeks worth of data: Example, Week 1 Quotes: £3m Sales: £1m Week 2 Quotes: £4m Sales: £2m etc...
9. ### Fill out 'complete correlation table"

Hi All... I need the correlation table to be completely fill out so that I can ADD the full columns to do a few functions. Is there a way to copy and transpose the numbers over? Thxs
10. ### Dynamic Correlation (possible PivotTable)

I am trying to figure out a way to do dynamic correlation between variables by choosing start and end date, (Vertical Column A), and doing correlation between 2 different columns of values. The kicker is there is also a column of identifiers in Column B. So i'd like to select correlation between...
11. ### worksheetfunction.index array form

I am working with the lines: ArrX = Application.WorksheetFunction.Index(X, 0, 2) ArrTemp = Application.WorksheetFunction.Index(TempSample, 0, 2) DistanceMeasure = (1 - Application.WorksheetFunction.Correl(ArrX, ArrTemp)) * 100 I would like to be able to run a simple correlation using...
12. ### Correlation using lookups

<tbody> A - Month B - Date C - Period D - Price A E -Price b =date(year(B2),month(B2),1) 01/01/2010 1 32.22 33.01 =date(year(B3),month(B3),1) 01/01/2010 2 30.72 31.78 =date(year(B4),month(B4),1) 01/01/2010 3 30.91 30.65 =date(year(B5),month(B5),1) 01/01/210 4 25.91...
13. ### How to calculate the Correlation of multiple Dictionaries?

Hello everyone: I have some dictionaries with values, and I need to calculate the correlation between the values of dictionaries. Let's see the code: Sub Test() Dim Dic1 as New Scripting.Dictionary Dim Dic2 as New Scripting.Dictionary Dim Dic3 as New Scripting.Dictionary Dim Dictionaries as...
14. ### Aggregating addresses by subdivision while keeping owner name intact

I have a list of just over 6,200 names and addresses that I need to separate into their respective community subdivision, but I need to keep the owners names with those addresses. This is in order to add postal/zip codes and cities to the addresses. Is there a way to do this? For example, I need...
15. ### Modified Correlation Matrix output

I have a UDF for correlation matrix (enclosed); can it be modified to replace the non-result 0's (zeros) with "n/a"? For example, When I use the function I get a 1-sided correlation matrix for -- - data: <tbody> x1 x2 x3 x4 1.0000 1.0000 2.0000 4.0000 4.0000 3.0000 4.0000...
16. ### Correlation between two sets of categorical variables

Hi, Been researching this for a while and can't find an example of how to set this up with Excel formula. I have two sets of categorical variable (ie yes/no answers) and I want to find the correlation between them Example: <tbody> Filled out notes field Did not fill out notes field...
17. ### Semipartial Correlation UDF

I need help in modifying the appended Partial Correlation UDF to Semipartial Correlation UDF. A note on Semipartial Correlation (and Partial) can be found at http://www.listendata.com/2017/03/partial-correlation.html The Partial Correlation UDF is: Function pCorrel(R) Dim iRows As Integer...
18. ### Next number in Sequence or correlation between 3 sets of sequences

I'm looking for a formula to find the correlation from one number to the next and also the next number in the sequence. The formula should be for each independent column. Additionally, the three columns values are from one entity just three different measurements. <style...
19. ### Correlation Meaning of Survey Data

Hey, So I calculated a survey average based off of 10 questions asked scored 1-10. I have 2,000 surveys and took the correlation of each individual score vs the total average scores. What does this tell me? What do the results mean? Is this a way to measure impact? Example: Total Score...
20. ### Weighting Correlation Co-Efficients to measure performance

Hi, I have some interesting data based on soccer that I am trying to use to measure performance based on the correlation coefficients. I have data for each player in the English Premier League that shows how many goals they have scored and with this range of other data that contributes to...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back