[Solved]-Question 4 25 Points Growth Four Different Strains Bacteria Monitored 3 Weeks Terms Cell N Q37192098

Hi, I need some excel help. Thank you in advance.

Question 4 (25 points) The growth of four different strains of bacteria are monitored over 3 weeks in terms of cell numbers and pH values. The data is tabulated. Prepare a plot as follows. Please be noted that the graph has two y axes. The pH values are interpolated using a linear fit. 1 eks 3 weeks 1 week2 we pH 6.7 6.9 7.0 7.2 45 30 32 39 59 38 41 47 Strain 1 Strain 2 Strain 3 Strain 4 36 39 42 Monitoring of Bacterial Growth Over 3 Weeks 80 7.2 ︵ 60 40 6.8 20 6.6 6.4 0 Strain 1 Strain 2 Strain 3 Strain 4 1 week2 weeks 3 weeks Show transcribed image text Question 4 (25 points) The growth of four different strains of bacteria are monitored over 3 weeks in terms of cell numbers and pH values. The data is tabulated. Prepare a plot as follows. Please be noted that the graph has two y axes. The pH values are interpolated using a linear fit. 1 eks 3 weeks 1 week2 we pH 6.7 6.9 7.0 7.2 45 30 32 39 59 38 41 47 Strain 1 Strain 2 Strain 3 Strain 4 36 39 42 Monitoring of Bacterial Growth Over 3 Weeks 80 7.2 ︵ 60 40 6.8 20 6.6 6.4 0 Strain 1 Strain 2 Strain 3 Strain 4 1 week2 weeks 3 weeks

Expert Answer

---

Answer to Question 4 (25 points) The growth of four different strains of bacteria are monitored over 3 weeks in terms of cell numb… . . .