Homework Help is Here – Start Your Trial Now!
Science
Chemistry
Excel Assignment After reading the excel tutorial under documents, answer the following questions in an excel spreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard upon completion. 1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, AYg M and St. dev M) in Excel: 0.025 L HNO, Vol NaOH (mL) (0.09876 M) Moles NaOH Moles HNO, Molarity HNO, Trial 1 23.51 Trial 2 22.95 Trial 3 22.82 Trial 4 23.23 Average M St. dev M

Excel Assignment After reading the excel tutorial under documents, answer the following questions in an excel spreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard upon completion. 1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, AYg M and St. dev M) in Excel: 0.025 L HNO, Vol NaOH (mL) (0.09876 M) Moles NaOH Moles HNO, Molarity HNO, Trial 1 23.51 Trial 2 22.95 Trial 3 22.82 Trial 4 23.23 Average M St. dev M

Chemistry
Chemistry
10th Edition
ISBN:9781305957404
Author:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Chapter1: Chemical Foundations
Section: Chapter Questions
Problem 1RQ: Define and explain the differences between the following terms. a. law and theory b. theory and...
See similar textbooks
icon
Related questions
Question
100%

Please help

Excel Assignment After reading the excel tutorial under documents, answer the following questions in an excel spreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard upon completion. 1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, AYg M and St. dev M) in Excel: 0.025 L HNO; Vol NaOH (mL) (0.09876 M) Moles NaOH Moles HNO3 Molarity HNO3 Trial 1 23.51 Trial 2 22.95 Trial 3 22.82 Trial 4 23.23 Average M St. dev M
Transcribed Image Text:Excel Assignment After reading the excel tutorial under documents, answer the following questions in an excel spreadsheet. Submit the spreadsheet to assignments in your lab section on Blackboard upon completion. 1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, AYg M and St. dev M) in Excel: 0.025 L HNO; Vol NaOH (mL) (0.09876 M) Moles NaOH Moles HNO3 Molarity HNO3 Trial 1 23.51 Trial 2 22.95 Trial 3 22.82 Trial 4 23.23 Average M St. dev M
2. In one of the experiments this semester we will need to create a graph, find the best-fit slope for the data and determine how well the data fits the best-fit line. We will prepare solutions with known concentrations (mol/L) and measure the absorbance of each solution. We will use an instrument that measures how much light a compound absorbs at a specific wavelength (color). Copy the data in the table below in excel and create a scatter plot of absorbance versus concentration. Make sure the plot has the following features: y axis showing absorbance, x axis showing concentration in ppm plot created a separate sheet in the workbook proper títle labeled axes sensible scales on the axes no gridline a colorless background to the plot solid green squares as data markers a line of best fit (trendline) which passes through the origin set y intercept to zero the equation of the line and R? value to the four decimal places Concentration (parts per million, ppm) Absorbance 20 0.736 15 0.556 10 0.702 0.206 2 0.084 3. Based off your R? value, make a statement about the quality of data. In other words, how well does your data fit a linear relationship?
Transcribed Image Text:2. In one of the experiments this semester we will need to create a graph, find the best-fit slope for the data and determine how well the data fits the best-fit line. We will prepare solutions with known concentrations (mol/L) and measure the absorbance of each solution. We will use an instrument that measures how much light a compound absorbs at a specific wavelength (color). Copy the data in the table below in excel and create a scatter plot of absorbance versus concentration. Make sure the plot has the following features: y axis showing absorbance, x axis showing concentration in ppm plot created a separate sheet in the workbook proper títle labeled axes sensible scales on the axes no gridline a colorless background to the plot solid green squares as data markers a line of best fit (trendline) which passes through the origin set y intercept to zero the equation of the line and R? value to the four decimal places Concentration (parts per million, ppm) Absorbance 20 0.736 15 0.556 10 0.702 0.206 2 0.084 3. Based off your R? value, make a statement about the quality of data. In other words, how well does your data fit a linear relationship?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Chemistry
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
Chemistry
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Organic Chemistry
Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education
Chemistry: Principles and Reactions
Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning
Elementary Principles of Chemical Processes, Bind…
Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY
SEE MORE TEXTBOOKS