Hi Andy,
I can definitely help you with subtracting curves in Excel. Here are the steps you can follow:
- First, make sure that your data is organized in two columns: one for the x-values and one for the y-values.
- Create a new column next to your y-values column and enter the baseline values for each corresponding x-value. If the baseline is consistent from data set to data set, you can copy and paste this column for each new data set.
- Subtract the baseline values from the y-values by entering the formula
Formula:
"=y-value - baseline"
in a new column next to your baseline column. This will give you the corrected y-values. - Create a scatter plot with your x-values as the x-axis and the corrected y-values as the y-axis.
- You can also add error bars to your plot to show the variability in your data.