Search
- Filter Results
- Location
- Classification
- Include attachments
- https://chem.libretexts.org/Courses/Los_Angeles_Trade_Technical_College/Analytical_Chemistry/2%3A_Analytical_Chemistry_2.0_(Harvey)/05%3A_Evaluating_Analytical_Data/5.08%3A_Using_Excel_and_R_to_Analyze_DataIt can be tedious to work problems using nothing more than a calculator. Both Excel and R include functions for descriptive statistics, for finding probabilities for different distributions, and for c...It can be tedious to work problems using nothing more than a calculator. Both Excel and R include functions for descriptive statistics, for finding probabilities for different distributions, and for carrying out significance tests. In addition, R provides useful functions for visualizing your data.
- https://chem.libretexts.org/Bookshelves/Analytical_Chemistry/Analytical_Chemistry_2.1_(Harvey)/05%3A_Standardizing_Analytical_Methods/5.06%3A_Using_Excel_and_R_for_a_Linear_RegressionThe page details methods for performing linear regression analysis using Excel and R. It explains how to fit a straight-line model to data, obtain relevant statistical information, and visualize the r...The page details methods for performing linear regression analysis using Excel and R. It explains how to fit a straight-line model to data, obtain relevant statistical information, and visualize the regression model using Excel. Three approaches in Excel include using built-in functions, employing Data Analysis ToolPak, and programming formulas directly into a spreadsheet.
- https://chem.libretexts.org/Bookshelves/Analytical_Chemistry/Analytical_Chemistry_2.1_(Harvey)/14%3A_Developing_a_Standard_Method/14.04%3A_Using_Excel_and_R_for_an_Analysis_of_VarianceThis page provides guidance on conducting an analysis of variance (ANOVA) using both Excel and R. Excel's Analysis ToolPak simplifies ANOVA, allowing users to input data and parameters to obtain resul...This page provides guidance on conducting an analysis of variance (ANOVA) using both Excel and R. Excel's Analysis ToolPak simplifies ANOVA, allowing users to input data and parameters to obtain results, including statistical measures like mean, variance, F-value, and p-values. R, on the other hand, requires coding but offers additional features like Tukey's honest significant difference test to identify sources of significant differences.
- https://chem.libretexts.org/Ancillary_Materials/Worksheets/Worksheets%3A_Analytical_Chemistry_II/Excel_Tutorial/Excel_Part_1%E2%80%94Writing_Functions%3A_Translating_Chemistry_into_ExcelThe analysis of a plant-food preparation for its potassium ion content yielded the following data: 5.25%, 5.03%, 5.20%, 5.06%, 5.04%, and 5.16%. Using Excel, write the functions and determine the mean...The analysis of a plant-food preparation for its potassium ion content yielded the following data: 5.25%, 5.03%, 5.20%, 5.06%, 5.04%, and 5.16%. Using Excel, write the functions and determine the mean, the standard deviation, and the % relative standard deviation for this set of replicate measurements. Starting with the next row, display the name (in column A) and the formula that you used (in the cell to the right, in Column B) for each different calculation.
- https://chem.libretexts.org/Ancillary_Materials/Worksheets/Worksheets%3A_Analytical_Chemistry_II/Excel_Tutorial/Excel_Part_2%E2%80%94Statistical_Analysis%3A_Putting_the_Pieces_Together_to_Determine_the_Concentration_of_an_Analyte_and_Evaluate_the_Precision_of_the_ResultsYou need an organized way to display the experimental results (above), the calculated values for each replicate, and the statistical analysis of the final results (i.e. The determination of the w/v % ...You need an organized way to display the experimental results (above), the calculated values for each replicate, and the statistical analysis of the final results (i.e. The determination of the w/v % of acetic acid in the sample is just a stoichiometry problem, so do the first one by hand. In order to assess the quality of your precision, you need to determine the mean, the standard deviation, and the % RSD for these w/v %. Smaller values for standard deviation and % RSD reveal better precision.
- https://chem.libretexts.org/Ancillary_Materials/Worksheets/Worksheets%3A_Analytical_Chemistry_II/Excel_TutorialThis Excel tutorial covers working with equations, evaluating the precision and accuracy of results, and generating titration curves.
- https://chem.libretexts.org/Courses/Los_Angeles_Trade_Technical_College/Analytical_Chemistry/2%3A_Analytical_Chemistry_2.0_(Harvey)/06%3A_Standardizing_Analytical_Methods/6.6%3A_Using_Excel_and_R_for_a_Regression_AnalysisAlthough the calculations in this chapter are relatively straightforward—consisting, as they do, mostly of summations—it can be quite tedious to work through problems using nothing more than a calcula...Although the calculations in this chapter are relatively straightforward—consisting, as they do, mostly of summations—it can be quite tedious to work through problems using nothing more than a calculator. Both Excel and R include functions for completing a linear regression analysis and for visually evaluating the resulting model.
- https://chem.libretexts.org/Courses/Lakehead_University/Analytical_I/4%3A_Evaluating_Analytical_Data/4.08%3A_Using_Excel_and_R_to_Analyze_DataIt can be tedious to work problems using nothing more than a calculator. Both Excel and R include functions for descriptive statistics, for finding probabilities for different distributions, and for c...It can be tedious to work problems using nothing more than a calculator. Both Excel and R include functions for descriptive statistics, for finding probabilities for different distributions, and for carrying out significance tests. In addition, R provides useful functions for visualizing your data.
- https://chem.libretexts.org/Courses/Lakehead_University/Analytical_I/5%3A_Standardizing_Analytical_Methods/5.6%3A_Using_Excel_and_R_for_a_Regression_AnalysisAlthough the calculations in this chapter are relatively straightforward—consisting, as they do, mostly of summations—it can be quite tedious to work through problems using nothing more than a calcula...Although the calculations in this chapter are relatively straightforward—consisting, as they do, mostly of summations—it can be quite tedious to work through problems using nothing more than a calculator. Both Excel and R include functions for completing a linear regression analysis and for visually evaluating the resulting model.
- https://chem.libretexts.org/Ancillary_Materials/Worksheets/Worksheets%3A_Analytical_Chemistry_II/Statistics%3A_Excel_ExerciseCreate a histogram showing the distribution of pennies massed by year, with “Year” on the x-axis as a categorical variable, and “Number of Pennies” massed on the y-axis as a numerical variable. Right ...Create a histogram showing the distribution of pennies massed by year, with “Year” on the x-axis as a categorical variable, and “Number of Pennies” massed on the y-axis as a numerical variable. Right click on the chart and use the “Select Data” option: to ensure “Year” is on the x-axis as a categorical variable, and “Number of Pennies” massed on the y-axis as a numerical variable.
- https://chem.libretexts.org/Courses/Los_Angeles_Trade_Technical_College/Analytical_Chemistry/2%3A_Analytical_Chemistry_2.0_(Harvey)/03%3A_Basic_Tools_of_Analytical_Chemistry/3.6%3A_Spreadsheets_and_Computational_SoftwareAnalytical chemistry is an inherently quantitative discipline. Whether you are completing a statistical analysis, trying to optimize experimental conditions, or exploring how a change in pH affects a ...Analytical chemistry is an inherently quantitative discipline. Whether you are completing a statistical analysis, trying to optimize experimental conditions, or exploring how a change in pH affects a compound’s solubility, the ability to work with complex mathematical equations is essential. Spreadsheets, such as Microsoft Excel can be an important tool for analyzing your data and for preparing graphs of your results. Scattered throughout the text you will find instructions for using spreadsheet
