Instructions
1. Download this Excel file and rename it as FirstName_LastName_DDMMYYYY.
Click “Enable Editing” and do computations. When done, upload your file for grading.
2. Compute the required statistics using the provided formulas. Keep four decimal places.
You can copy and paste these formulas but don’t forget to remove the invisible now quotation mark at the beginning.
3. Draw the boxplots for each kind of water. Show title, median,Q1,Q3, minimum, and maximum on the chart.
4. Give a brief comment on:
a. What the pH indicator is.
b. Why it is important.
c. Which kind of water has higher value of pH.
d. Which kind of water has greater variability of the pH. (Hint: Use the interquartile range IQR)
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount