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?

Our take

To effectively set up your table for a scatter plot of absorbance versus concentration values in Excel, ensure your data is organized and formatted correctly. With concentration values ranging from 0.00E+00 to 4.00E-05 in scientific notation, and three absorbance readings for each molarity, your table should clearly list these values side by side. Check that your y-axis (absorbance) is appropriately scaled to avoid data appearing 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.00E⁰ 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)

submitted by /u/Wabbstarful
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#rows.com#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#absorbance#concentration#Excel#scatter plot