Texts: Draw using Excel (if you do not know how to do this, please read the instructions given under this "Assignment" or join office hours). Post this separately from the main report under "Assignment" under "Extra Credit" under "Density vs Concentration Excel Graph".
a) Plot the density and % for the standards using Excel.
a. Write the title on the top of the graph.
b. Label the x and y axis and include units.
c. Show the equation of the line and R value.
d. Post a copy of the graph.
b) Calculate the % of the soda and unknown solution using the equation.
Write the equation of the line and R^2 value. Does your R^2 value you obtained show good precision for your data? Explain. Show the calculation of % of sugar for the unknown solution and soda using the equation obtained from the graph.
i) Unknown sucrose solution:
%
Show calculation using the equation of the line.
ii) Soda:
%
Name or type of soda:
Show calculation using the equation of the line.