I need help creating a line graph in excel for trial 1 only. I need to find the average reaction rates for trial 1 for temperature, pH, and concentration. Picture of excel graph would be appreciated,
I need help creating a line graph in excel for trial 1 only. I need to find the average reaction rates for trial 1 for temperature, pH, and concentration. Picture of excel graph would be appreciated,
Introduction to General, Organic and Biochemistry
11th Edition
ISBN:9781285869759
Author:Frederick A. Bettelheim, William H. Brown, Mary K. Campbell, Shawn O. Farrell, Omar Torres
Publisher:Frederick A. Bettelheim, William H. Brown, Mary K. Campbell, Shawn O. Farrell, Omar Torres
Chapter30: Nutrition
Section: Chapter Questions
Problem 30.43P
Related questions
Question
Hi, I need help creating a line graph in excel for trial 1 only. I need to find the average reaction rates for trial 1 for temperature, pH, and concentration. Picture of excel graph would be appreciated, thank you.

Transcribed Image Text:The image shows a table comparing the time of starch disappearance under different conditions. The data is split into three sections: concentration, pH, and temperature, with trials one and two, as well as an average column.
### Concentration
| Concentration | Trial One (Seconds) | Trial Two (Seconds) | Average (Seconds) |
|---------------|---------------------|---------------------|-------------------|
| 0.50% | 60 | 60 | |
| 0.25% | 90 | 80 | |
| 0.125% | 120 | 90 | |
| 0.063% | 140 | 100 | |
| 0.031% | 160 | 120 | |
### pH
| pH | Trial One (Seconds) | Trial Two (Seconds) | Average (Seconds) |
|----|---------------------|---------------------|-------------------|
| 2 | 360 | 360 | |
| 7 | 0 | 0 | |
| 9 | 0 | 0 | |
| 11 | 240 | 270 | |
### Temperature (Celsius)
| Temperature | Trial One (Seconds) | Trial Two (Seconds) | Average (Seconds) |
|-------------|---------------------|---------------------|-------------------|
| 4 | 70 | 70 | |
| 22 | 10 | 40 | |
| 37 | 20 | 60 | |
| 95 | 340 | 110 | |
### Explanation
The table measures the time it takes for starch to disappear under various conditions. Each section presents two trials, but the average times for each condition are not filled in. The columns labeled "Trial One" and "Trial Two" record the time in seconds for each experiment corresponding to different concentrations, pH levels, and temperatures.
- **Concentration**: As the concentration decreases, the time for starch disappearance generally increases.
- **pH**: The starch disappears quickly (0 seconds) at pH 7 and 9, indicating an optimal condition at neutral to slightly alkaline levels. At both low pH (2) and high pH (11
Expert Solution

Step 1
To create line graphs for trial one.
Step by step
Solved in 4 steps with 6 images

Similar questions
Recommended textbooks for you

Introduction to General, Organic and Biochemistry
Chemistry
ISBN:
9781285869759
Author:
Frederick A. Bettelheim, William H. Brown, Mary K. Campbell, Shawn O. Farrell, Omar Torres
Publisher:
Cengage Learning

Chemistry for Today: General, Organic, and Bioche…
Chemistry
ISBN:
9781305960060
Author:
Spencer L. Seager, Michael R. Slabaugh, Maren S. Hansen
Publisher:
Cengage Learning

Chemical Principles in the Laboratory
Chemistry
ISBN:
9781305264434
Author:
Emil Slowinski, Wayne C. Wolsey, Robert Rossi
Publisher:
Brooks Cole

Introduction to General, Organic and Biochemistry
Chemistry
ISBN:
9781285869759
Author:
Frederick A. Bettelheim, William H. Brown, Mary K. Campbell, Shawn O. Farrell, Omar Torres
Publisher:
Cengage Learning

Chemistry for Today: General, Organic, and Bioche…
Chemistry
ISBN:
9781305960060
Author:
Spencer L. Seager, Michael R. Slabaugh, Maren S. Hansen
Publisher:
Cengage Learning

Chemical Principles in the Laboratory
Chemistry
ISBN:
9781305264434
Author:
Emil Slowinski, Wayne C. Wolsey, Robert Rossi
Publisher:
Brooks Cole

Chemistry: Principles and Practice
Chemistry
ISBN:
9780534420123
Author:
Daniel L. Reger, Scott R. Goode, David W. Ball, Edward Mercer
Publisher:
Cengage Learning

Organic Chemistry: A Guided Inquiry
Chemistry
ISBN:
9780618974122
Author:
Andrei Straumanis
Publisher:
Cengage Learning