Part Specific Gravity 4. Complete the following table by calculating the song in of s and og solutions. The values of specifie gravity should be transferred from your Data Sheet Show all your concerto calculations Solution Water Concentration O (w/v) sugar Specific Gravity Standard sugar solution 1 Standard sugar solution #2 Standard sugar solution #3 Calculations: 5. Using a graphing program such as Microsoft Excel, graph the concentration % vs the specific gravity of the four solutions listed above. This should be a linear relationship so Excel can calculate the trendline for the data, be sure to show the trendline equation on your graph. A proper graph should fill a normal sheet of paper, have a title and labeled axes. The axes should be expanded to fit the range of your data (and not more). Print a copy of your graph and attach it to your report to hand in. 6. Determine the sugar concentration for soda and Gatorade by using your graph and/or trendline. Be sure to explain fully how you determined these values (including any calculations). Concentration of Sugar in Soda Concentration of Sugar in Gatorade 34 ougar Solution Specific Gravity 1.0440 1.0320 1.Ollo Soft/Sports Drinks Solution Decarbonated Soda Specific Gravity 1.0420 10 ) 1.0220 Gatorade Decarbonated Soda Type of soda Tue Volume of Serving Size 360mL Mass of Sugar in the Serving Size Gatorade Volume of Serving Size 100 360mL Mass of Sugar in the Serving Size Part Specific Gravity 4. Complete the following table by calculating the song in of s and og solutions. The values of specifie gravity should be transferred from your Data Sheet Show all your concerto calculations Solution Water Concentration O (w/v) sugar Specific Gravity Standard sugar solution 1 Standard sugar solution #2 Standard sugar solution #3 Calculations: 5. Using a graphing program such as Microsoft Excel, graph the concentration % vs the specific gravity of the four solutions listed above. This should be a linear relationship so Excel can calculate the trendline for the data, be sure to show the trendline equation on your graph. A proper graph should fill a normal sheet of paper, have a title and labeled axes. The axes should be expanded to fit the range of your data (and not more). Print a copy of your graph and attach it to your report to hand in. 6. Determine the sugar concentration for soda and Gatorade by using your graph and/or trendline. Be sure to explain fully how you determined these values (including any calculations). Concentration of Sugar in Soda Concentration of Sugar in Gatorade 34 ougar Solution Specific Gravity 1.0440 1.0320 1.Ollo Soft/Sports Drinks Solution Decarbonated Soda Specific Gravity 1.0420 10 ) 1.0220 Gatorade Decarbonated Soda Type of soda Tue Volume of Serving Size 360mL Mass of Sugar in the Serving Size Gatorade Volume of Serving Size 100 360mL Mass of Sugar in the Serving Size
