How can I more effectively set up my table to display an x-axis of concentration values (in scientific notation) vs. absorbance values (in nm) on my y-axis without having my data suddenly fall way out of range?
[Excel-Microsoft 365, Version 2604 (Build 19929.20090)] To preface, I am a current student + novice at excel, and I'm trying to avoid using AI to guess what I'm trying to describe here.
I am making a scatter plot of absorbance vs concentration values for a chromatography experiment. My x-axis is my sample's molarity (in scientific notation ranging from 0.00E0 to 6.00E-5) which were a blank solution, 1E-5, 2E-5, and 4E-5. For each of those I measured absorbance in triplicate. So for each molarity (including the blank) there are 3 absorbance values that were recorded.
I have set my table up in so many different styles and I can't get ahold of my professor nor any classmates right now to help me figure out why my scatterplot keeps looking 'wrong'.
Here is a copy paste of the current table format I'm messing with for my graph:
| Concentration | Red Abs1 | Red Abs2 | Red Abs3 |
|---|---|---|---|
| 0.00E+00 | 0.068 | 0.062 | 0.076 |
| 1.00E-05 | 0.145 | 0.146 | 0.145 |
| 2.00E-05 | 0.293 | 0.317 | 0.302 |
| 4.00E-05 | 0.642 | 0.660 | 0.634 |
My goal is to show the concentration vs. absorbance and I should see a positive slope with my trendline, instead everything keeps turning out flat or has a negative slope or doesn't appear on my graph/is out of range.
(Will update with images if anyone requests - not sure how I could easily share them in my post if anyone wants to help tell me how)
[link] [comments]
Want to read more?
Check out the full article on the original site