Analytical Techniques d09 cc

xlsx

School

Nova Southeastern University *

*We aren’t endorsed by this school

Course

101

Subject

Statistics

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by DeaconBuffalo4403

Part I: Determining percent Error when using a pipette Group # Average P200 (g) Average P1000 (g) 1 0.0929 0.5200 2 0.1010 0.5180 3 0.0980 0.5230 4 0.0953 0.4938 Percent Error Calculations Group # % error P200 % error P1000 1 7.100 4.000 2 1.000 3.600 3 2.000 4.600 4 4.700 1.240 Average 3.700 3.360 SD 2.753 1.472 Average % Error Data and SD (Class Data) Average % error SD of error P200 3.70 3.70 P1000 3.36 1.47 Now that you have calcu Use the formula "=AVERA Standard deviation (SD) i discreet datapoint and th Hint: review your Excel t Percent error is a calcula what the value should ac Percent Error = m Hint : use the known den intended value ) vs. what Highlight the table to the a 2D bar graph. This is th How to Add Axis Labels: 1. Click on Chart Design. 2. Click on Add Chart Ele 3. Click on Axis Title. 4. Click on Primary Verti 5. Repeat for Primary Ho How to add Error Bars: 1. Click on Chart Design. 2. Click on Add Chart Ele 3. Click on Error Bars. 5. Click on More Error Ba 6. Click Custom - Specify 7. Select the two Standa ORANGE . 8. You should now have Remember to add a figu

ulated percent error for each group , determine what the average percent error is for the class. AGE()" to do so. is used to indicate the extent of deviation for a group as a whole. IE, it measures the difference betwee he mean of the data. Use the formula "=STDEV()" to calculate this value tutorial if you're unfamiliar with how to calculate average and standard deviation ation used to indicate the accuracy of collected data by determining the difference between your data a ctually be. Calculate percent error for each group's mass measurements using this formula: measured value - intended value * 100 intended value nsity of water indicated in your lab manual to determine how much the water should have weighed (the t mass measurements your lab actually got (the measured value ) e left (with the red title text) (SPECIFICALLY THE GREEN PART) and insert he figure required for Homework Assignment Part I. : . ement. tical to add Y axis label. orizontal to add X axis label. . ement. ars Options. y value. ard Deviation values displayed in the table to the left of this text box IN customized error bars! ure number/title and description to the graph as well.

intended 0.1 g (p200) and 0.5 g (p1000) en each and e P200 P1000 3.10 3.20 3.30 3.40 3.50 3.60 3.70 3.80 Variation of percent error in pipetting Measurments Grams

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Part II: Finding the Ideal Wavelength (Class Data) Absorbance (A) Wavelength (nm) Group 1 Group 2 Group 3 Group 4 400 1.252 1.288 1.220 1.158 425 1.383 1.247 1.633 1.453 450 0.896 0.804 1.730 1.095 475 0.706 0.557 1.663 0.893 500 0.499 0.176 1.511 0.618 525 0.100 1.235 1.200 0.223 550 0.755 0.664 0.729 0.814 575 0.282 0.210 0.371 0.329 600 0.474 0.495 0.222 0.516 Ideal wavelength averages (Class Data) Wavelength (nm) 400 1.230 425 1.429 450 1.131 475 0.955 500 0.701 525 0.690 550 0.741 575 0.298 600 0.427 Class Average Absorbance DO NOT USE THIS DATA TO GENERA This data is just meant to be incorporated i using the averages to the left of this text bo able to explain how you were able to identi wavelength of light to use for Part III of this

Average SD 1.230 0.055 1.429 0.161 1.131 0.417 0.955 0.492 0.701 0.571 0.690 0.612 0.741 0.062 0.298 0.069 0.427 0.138 ATE A FIGURE. into your discussion; ox, you should be tify the ideal s lab.

Part III: Determining the glucose concentration of an unknown solution (Class data) Absorbance (A) Tube # Concentration (mg/dL) Group 1 Group 2 Group 3 Group 4 1 100 0.39 0.483 0.36 0.317 2 200 0.838 0.659 0.562 0.639 3 250 1.215 0.952 0.863 0.914 4 500 0.383 0.970 1.906 1.337 5 unknown 1.071 1.063 1.083 0.629 Absorbance Value Averages (Class Data) Absorbance (A) Concentration (mg/dL) Average SD 100 0.39 0.07 200 0.67 0.12 250 0.99 0.16 500 1.15 0.64 Unknown 0.96 0.22 After calculating the each concentration c (with the red title tex smooth lines and ma DO NOT INCLUDE TH TO G ONLY G Insert a trendline (wi chart area, clicking "A the upper ribbon, sel From here, select a li Line equation on cha to determine the gluc SOLVING FOR X . Make sure to add a fi figure description. Ad unknown along your demarcate it using a

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

x= 350.222 Instructions: class average absorbance values for condition, highlight the table to the left xt) and insert a scatterplot with arkers. HE UNKNOWN WHEN SELECTING DATA GENERATE YOUR PLOT. GRAPH THE PART IN BLUE ith a line equation) by selecting the Add chart element" on the left side of lecting "Trendine" > "More options." inear trendline and check the "Display art" box. You will use this line equation cose concentration of the unknown BY figure number/title, axis labels, and a dditionally, the location of the trendline must be noted - you may symbol, such as a star. 50 100 150 200 250 300 350 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 f(x) = 0.001789208633094 x + 0.3295827 f(x) = 0.001789208633094 x + 0.3295827 Glucose unkown soluti Concentration Absorbance