Bio-111 intro to cell Hello There, I\'m confused with this post lab assignment a
ID: 88464 • Letter: B
Question
Bio-111 intro to cell
Hello There, I'm confused with this post lab assignment and I don't know how to solve it also not a majoring in bio. Please help me out if you have an idea about this subject, no need for broad answer, narrow answers will do, also when you answer the question please explain what exactly i need to submit, or should i just copy your answers. THANK YOU. Need someone who is majoring or majored biology. "just got confused because ealier i recieved an answer just the graphs and its not only about that"
These are the notes we took in class, it has all the information you need i think, Let me know if theres anything else missing
Week 3 Post-Lab Assignment For this week's assignment you will need to hand in 5 graphs, Follow the instructions below to Fenerate these graphs. 5 points per graph) 1. Do the Excel tutorial b w. Hand In he graphs from Exercise 1 and Exe clse 2 at the next clan s period 2. Using Excel plot out your data from the portion of the lab where you determ ned the extinction coefficient of Blue (BPB This will yield a graph similar to the on that you made by hand during lab. Turn in this Eraph at the next class period 3. sing Excel plot out your data from the pipetting exercise. You should generate two graph One in which you analyze data for mass vs. volume for water and one in which you analyze the date you collected for mass vs. for glycerol. For both graphs make sure to calculate averages and standard deviations for the masses from your three replicates of the experiment. You should graph out the average values and use the standard deviations to include error bars on your graph (as in Exercise 2 of the Excel Tutorial). Make sure to insert a trend line on your graph and, using the equation of this line, determine the density (slope of the line) for both water and 50% glycerol. Hand in these two graphs at the next class eriod. Excel Tutoria The skills you learn today about using Excel will be important for analyzing and presenting you data for the lab reports you will be required to write We will first go through four exercises using Excel. The first exercise involves plotting a single set of data. In the second exercise, you will be calculating a average and standard deviation and displaying these data on a graph Exercise 1: Plotting a set of data and producing a curve Below is an Excel TN table in which column A cont uins the WM. concentration of solution for six different sam Column B show he absorbance for each of the x solution Ah SArtanca I.2G Enter these values into a new Exce Page Layout spreadsheet. 2) Highlight the label and values in column A Format Paint first, then while holding down the control key (Ctrl), also highlight the label und values in A concentration column B. Highlighting done by holding down the left mouse button and dragging the Absorban point (cross) over the areas you wish to bighlight. After highlighting, both column should be lightly shaded, as seen in the image to the left. excep for the initial cell. 0.2 3) After the two columns are highlighted, go to the top left corner of the Excel window and click on "Insert", found to the right of the "Home" tab. Once you are in the "Insert" menu, you will have chart subtypes to choose from und you will use "scatter" which compares pairs of values. Click on the small arrow beneath the word "scatter" to get the choice of scatter plots possibleExplanation / Answer
Explanation of this experiment: According to Beer’s Law, under ideal conditions, a substance’s concentration and its absorbance are directly proportional. So a high-concentration solution absorbs more light, and solution of lower concentration absorbs less light. Since concentration and absorbance are proportional, Beer’s Law makes it possible to determine an unknown concentration of phosphate after determining the absorbance. The overall goal of this lab was to make a calibration curve with a plot of absorbance vs. concentration, and be able to determine the phosphate concentrations in samples of interest.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.