1. Express the mathematical function for the straight line with the correct number of significant figures in the slope and y-intercept. y=- 2. What was the rate of heating for this sample of water (°C/sec)? Rate of Heating 3. Show a calculation or explain how to determine the initial temperature of the water (at the beginning of the experiment, before any data was collected) using the linear regression analysis. Include a correct unit label.

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...
icon
Related questions
Question
1. Using Excel, set up a spreadsheet with the following data
and prepare a graph which includes a linear regression
analysis with the trendline displayed on the graph:
Time(sec) Temp (°C)
30.0
27.3
60.0
40.2
90.0
53.7
120.0
67.4
150.0
79.8
180.0
91.3
Transcribed Image Text:1. Using Excel, set up a spreadsheet with the following data and prepare a graph which includes a linear regression analysis with the trendline displayed on the graph: Time(sec) Temp (°C) 30.0 27.3 60.0 40.2 90.0 53.7 120.0 67.4 150.0 79.8 180.0 91.3
Part B: QUESTIONS from Excel Graphing Exercise
Use the results of the linear regression analysis to answer the following questions.
1. Express the mathematical function for the straight line with the correct number of
significant figures in the slope and y-intercept.
y =
2. What was the rate of heating for this sample of water (°C/sec)?
Rate of Heating
3. Show a calculation or explain how to determine the initial temperature of the water (at
the beginning of the experiment, before any data was collected) using the linear
regression analysis. Include a correct unit label.
Initial Temperature
4. The water never reached the boiling point because, unfortunately, the student stopped
recording data before the water began to boil. According to the trendline, how much
time would have elapsed before the water boiled (100.0°C)? Show the calculation here
and insert a text box and arrow to identify this point on the graph.
Time to boiling point
5. What was the temperature of the water after 100.0 seconds of heating? Show the
calculation here and insert a text box and arrow to identify this point on the graph.
Temperature after 100.0 s
55
26
Transcribed Image Text:Part B: QUESTIONS from Excel Graphing Exercise Use the results of the linear regression analysis to answer the following questions. 1. Express the mathematical function for the straight line with the correct number of significant figures in the slope and y-intercept. y = 2. What was the rate of heating for this sample of water (°C/sec)? Rate of Heating 3. Show a calculation or explain how to determine the initial temperature of the water (at the beginning of the experiment, before any data was collected) using the linear regression analysis. Include a correct unit label. Initial Temperature 4. The water never reached the boiling point because, unfortunately, the student stopped recording data before the water began to boil. According to the trendline, how much time would have elapsed before the water boiled (100.0°C)? Show the calculation here and insert a text box and arrow to identify this point on the graph. Time to boiling point 5. What was the temperature of the water after 100.0 seconds of heating? Show the calculation here and insert a text box and arrow to identify this point on the graph. Temperature after 100.0 s 55 26
Expert Solution
steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Knowledge Booster
Sample Preparation in Analytical Chemistry
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, chemistry and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
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