Hi,
I have created two plots/curves in excel based on a set of hundreds of data points. My task is two average these two curves and plot the average. I would be able to do that by extracting this data from both curves at specific x-axis intervals, i.e. 0, 10, 20, 30, etc. Then I can simply average the extracted data and have excel plot it. I have tried plot fitting but it seems unreasonable because of the complex nature of the data. For example, the x values start from 0, go up to 17.5, then go to 22.8, and so on. Is there a way I can extract the y values based on specific x-values (I'm thinking directly from the graph)? Any tips would be appreciated. Thanks.
I have created two plots/curves in excel based on a set of hundreds of data points. My task is two average these two curves and plot the average. I would be able to do that by extracting this data from both curves at specific x-axis intervals, i.e. 0, 10, 20, 30, etc. Then I can simply average the extracted data and have excel plot it. I have tried plot fitting but it seems unreasonable because of the complex nature of the data. For example, the x values start from 0, go up to 17.5, then go to 22.8, and so on. Is there a way I can extract the y values based on specific x-values (I'm thinking directly from the graph)? Any tips would be appreciated. Thanks.