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
[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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Finding an X value with a given Y valueI'm just so confused (and incredibly stupid). I need to use Excel for every lab experiment in my class but every time I have to work on the graph it is just so confusing. Creating the line and labeling it with the data was hard enough. I am being asked to find the concentration of a copper sulfate pentahydrate solution whose absorbance is 0.150 on this line but I don't know how... How do I pinpoint a specific point on the line? https://preview.redd.it/1yrohp0r7ekg1.png?width=661&format=png&auto=webp&s=dfd60c33e46cae303439afe2d7a8e9cbd56506df submitted by /u/spencereidisgod [link] [comments]
- Column graph with different experimental groups, fractions, needing average and error bars on MacHi I'm trying to create a graph for a biology lab in which we were examine 5 different cellular fractions and finding the percentage of an enzyme present in each fraction. For this question we were provided with this table for which we have to generate a column graph which compares the percentage of enzyme units in the different fractions. Making sure we include error bars indicating the standard deviation for each sample. https://preview.redd.it/3q6p5xm3jxhg1.png?width=1070&format=png&auto=webp&s=7a263465a3e2664be1e9272ab3d1c76b375e3414 We were also provided with an example of what the graph should look like (see below). This shows the average activity for each fraction. https://preview.redd.it/w7blzccnjxhg1.png?width=992&format=png&auto=webp&s=f7237846843ec18167166db54ca0f793915a65b3 I am terrible at using excel and I've tried a few different ways to try get my graph similar to this. https://preview.redd.it/a7t01de3kxhg1.png?width=662&format=png&auto=webp&s=30d19de47bcb1034cd6e5b85ea5b0b2ca006d702 This first attempt I know is obviously wrong. I selected all my data and created a column chart. https://preview.redd.it/p52zirmtiyhg1.png?width=854&format=png&auto=webp&s=c2d10f031e3e6bf43898e2ec3ecb32979d880c2d Attempt #2 led me here. I created this by making a smaller table with just the averages and creating a column graph from there. While this looks more accurate I can't add error bars of any kind to it so there's not much hope. https://preview.redd.it/tb1pc85yiyhg1.png?width=828&format=png&auto=webp&s=4250c5fe3187c7b54d2f12e8b4ebdfac666b8e71 My third attempt gave me this. I pressed the switch row column button and now I can have error bars, but I can't make them error bars based off of the calculated standard deviations, so they aren't correct. Maybe I'm being silly but I've tried to search up how to do this but I can't seem to figure it out. Most of my searches have said I need to put in custom error bars but that is not an option for me. Any help would be greatly appreciated thank you. submitted by /u/whathehelisahuflepuf [link] [comments]