correlation

Hi, I'm hoping someone can help me with the following. In excel I'd like to simulated return series for 2 correlated assets, X&Y, with the following properties, and using a normal distribution: Mean X:0.15%, Std Dev X:7.25% Mean Y:0.55%, Std Dev Y: 5.5% Correlation of X,Y: 0.66 Thanks

So I have two columns of numbers, about 20 in column a and 20 in column b. Their correlation is .06 so very weak almost no relationship. Does anyone know a formula saying as my numbers in column A increase, what percent chance do I have that the numbers in column B increase? I know it would...

I'm trying to run a Pearson Correlation [=pearson(array1,array2)] between two columns (e.g. A and B, rows 1-20) but wanted to skip a few rows in both columns (e.g. 11-15). When I try to write the equation, skipping the rows by holding ctrl+highlighting, the equation writes itself as...

I want to generate random grades for 30 hypothetical students in 3 courses, Math, Chem, and English. I can supply a mean and standard deviation and use NORM.INV and RAND() to compute a random grade in each subject for each student. What I can’t figure out is how to make the grades for each...

Hey How do I calculate the Moran's I and the Geary's C ratio in excel. I don't find a good tutorial on Youtube. Can someone give me 2 simple examples? Thanks Yorick

Morning All I'm trying to use the correlation formula but am unable to get it to work between a date range, this is what I currently have: =CORREL(Account_Opened!$P:$P,Account_Opened!$AV:$AV) There is a from date in A1 on the current sheet and a too date in D1 I'm sure this can be done but...

I have following data: A -> 100 150 123 145 167 200 250 300 270 B-> 290 300 280 276 234 234 288 345 399 How can I perform stationarity,cointegration,Granger's test in Excel?

Hey all, This one will be a tough one to explain... I essentially have 3 columns of data and 40000+ rows of it. Column A measures seconds from time 0 to say 10. Column B is a series of values creating on a graph wavelets from a source detected by receiver one and Column C is the same series of...

Hello, I am having a problem getting the row and column for a specific value in an array. I have about 200 data sets that each contain 400 observations. I need to correlate all of these data sets with each other and find the 100 most highly correlated pairs. Finding the 100 highest is simply a...

I learn engeneering chemistry in Sofia university, so the second semester i have learned statistics. Now i have a coursework, witch includes a list of alcohols with indexes N[c], W, S[ox], X', X'^, TMand Tb witch is in Celsius. First i need to find correlation between them, but i dont know how...

Hi guys My question may sound a bit dumb so please excuse me :stickouttounge: In regression in data analysis isn't multiple r the coefficient of correlation? And if so shouldn't the function CORREL yield the same answer if used on the same data sets Because I tried comparing the number of the...

Hi guys, I'm trying to compare a range of daily values with that of the daily values from the previous 5 years. What I have is the daily increase/decrease (in %) of sales of my company. What I want to do, is have excel use this year's daily sales percentage increase/decrease compared to that...

Hi guys, I'm currently using Excel 2010 on windows 7. My issue is I have a sheet filled with data that has random separations (empty rows) for which I need to calculate correlations of the data in between the empty rows. For example I have data filling the range of D6:AA657 but with empty rows...

Hi, I never really use excel, nor am I any good at it so this question may be seem stupid to many of you. Basically for a school project, I had to make a questionnaire and retrieve data and then plot it in excel, I'm trying to find out if internet speeds at a student's house affects how much...

given 100 samples, to calculate: numbers of hours spent on study is dependent on numbers of hours spent on social networking site. <tbody> x (social networking site) y (study) x^2 xy 6 4 36 16 24 6 4 36 16 24 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 2 36...

Im just getting to grips with macros and VBA in excel im trying to find an automated way to see if there are any correlations between 2 (or more stock) prices ie. Stock A's price moves -> Stock B's price tends to do this Im at a bit of a loss as to were to start with this, could someone...

Hi, i'm having an issue finding a correlation coefficient from 2 datasets (arrays) where the data meets 2 or 3 conditions. i have 2 sheets 'Primary' and 'Twin'. On both sheets i have variables (text) in columns A, J, and K and the data to correlate (numbers) in column F. i want to be able to...

Hi, I'll try and explain this as best as I can. I have a data set with say 5 companies across the top and then data for the next 5days underneath the company headings. On the next sheet I want to show the cross correlation of this data for each company combination. I know how to do this and so...

Is there a VBA code for the Spearman's Rank Correlation Coefficient, where its syntax is =Spearman(Range1, Range2)?

I'm a new user of macros I have recorded a macro were it measures correlation between the cells. My problem is that I have to do that procedure for a lot combinations that's why I record the macro My cells range that is recorded starts from the cells JSL6-JU6. I want to make the same procedure...