correlation

Dear experts, I'm trying to create a correlation scatter-graph where each data-point belongs to a separate category. My data is laid out in three columns like this: A Category, B x-axis value, C y-axis value I have no trouble creating a standard correlation scatter when I select column B and...

Good day, I have a data set with roughly 250,000 rows with 147 distinct attribute labels and 1 data point per row. I'd like to run the same attributes across the vertical and horizontal axes of my pivot table (easy to do by just mirroring the attribute labels in 2 different columns) and have the...

Hi I'm trying to do some fairly simple statistics using excel and I'm struggling to find the built in functions. I have 2 columns of data and want to calculate the correlation co-efficient of the two data sets, one against the other. This if fairly simple. I also want to calculate the...

i have this set of data where user defines the start row for data(Column A) and last row for data. based on that we do some calculations and store results in column e, f and g. The column H contains the correlation between F and G. The user defines how many rows (say n)should we consider for...

Hello, I am wiritng a macro that will calculate correlation based on user input which determines how many items should be used from the two arrays to calculate the correlation. e.g. data starts from row 2 in excel sheet Column A Column B 100 cells with data 100...

Hello, I am wiritng a macro that will calculate correlation based on user input which determines how many items should be used from the two arrays to calculate the correlation. e.g. data starts from row 2 in excel sheet Column A Column B 100 cells with data 100...

For a data correlation, I have added a trendline to the plotted data with R2, and also used the linest function on the same data. The two R2 values match when there is an intercept, but when the correlation is forced through the origin the R2 values differ by up to 2%. Any ideas why this is...

So I ran a regression on different "type" scenarios and got the following. I see that the R-Square is not a great fit (<95%) but I was hoping I might be able to use this regression to figure out some relationships and make some determinations about which "Type" would yield the best results. In...

Hi, Could someone please explain to me how to use the correaltion analysis on Excel 2007? Im Struggling. I merely want a graph showing the correlation between 2 sets of data. Thanks in advance :)