opy the table to Excelthen for each part using Excel formula to do the questions belowand make sure to apply DCOVA, which stands forDefine, Collect, Organize, Visualize, and Analyze.
1. Find themean and standard deviation,
2. What didyou observe and what that means in term of Cholesterol levels for apatient.
3. Find thefive-number summary ( Minimum, Q1, Q2, Q3, andMaximum)
4. Interpretyour result in term of cholesterol level
5. Findinterquartile range (IQR) and what that means?
6. Draw abox-and-whiskers plot for data given
7. Do youhave any outliers? Explain the method used to identify theoutliers
| | Table : Cholesterol Levels: |
| 270 | 236 | 210 | 142 | 280 | 272 | 160 |
| 220 | 226 | 242 | 186 | 266 | 206 | 318 |
| 294 | 282 | 234 | 224 | 276 | 282 | 360 |
| 310 | 280 | 278 | 288 | 288 | 244 | 236 |
