make a scatter plot with the given criteria and data. use excel. **Table 2. Effect of Substrate Concentration on Enzyme Activity**This table displays the results of an experiment evaluating the effect of substrate concentration on enzyme activity. Each tube contains a different concentration of sucrose in the substrate solution. The reaction score ranges from 0 to 4, indicating the level of enzyme activity. The color in each tube changes relative to the substrate concentration, which is visually represented alongside the reaction score.| Tube # | Substrate Solution | Color | Reaction Score (0-4) ||--------|---------------------|-------------------------|----------------------|| 1 | 1% sucrose | Turquoise | 1 || 2 | 2% sucrose | Dark blue green | 2 || 3 | 4% sucrose | Reddish brown | 3 || 4 | 8% sucrose | Brighter reddish brown | 4 || 5 | Distilled water (0%)| Blue | 0 |**Analysis:**- **Tube 1**: With 1% sucrose, the solution is turquoise, scoring 1 in reaction intensity.- **Tube 2**: At 2% sucrose, a dark blue green color appears, scoring 2.- **Tube 3**: A higher concentration (4% sucrose) results in a reddish brown color with a score of 3.- **Tube 4**: The highest sucrose concentration (8%) results in the brightest reddish brown, achieving the maximum score of 4.- **Tube 5**: With distilled water (0% sucrose), the solution remains blue with a score of 0, indicating no enzyme activity.The data suggest that increasing substrate concentration enhances enzyme activity, reaching a peak at the highest tested concentration. - Also use Microsoft Excel to prepare a **scatter plot** of activity on a scale of 0 to 4 vs. sugar concentration (%) from the data recorded in Table 2. (Keep in mind that the independent variable in this experiment is sucrose concentration, not test tube #.)**Remember that a graph must have a descriptive legend and have both the x and y-axis labeled.**

Name: make a scatter plot with the given criteria and data. use excel. **Ta
Uploaded: 2024-03-20T06:43:04.000Z
Channel: Bartleby
Description: make a scatter plot with the given criteria and data. use excel. **Table 2. Effect of Substrate Concentration on Enzyme Activity**This table displays the results of an experiment evaluating the effect of substrate concentration on enzyme activity. E