Question: Use this excel spreadsheet example to answer the questions. Enter the data in the blue highlighted area and the results will show in the yellow
Use this excel spreadsheet example to answer the questions. Enter the data in the blue highlighted area and the results will show in the yellow highlighted area. Data Mean 3.5000 2 Median 3.5000 Mode (Returns more than one mode) Sample Variance 3.5000 5 Sample Standard Deviation 1.8708 Population Variance 2.9167 Population Standard Deviation 1.7078 To find boundary for outliers Range 5.0000 Count (n) 6.0000 1.5 IQR 4.5 Min 1.0000 Lower boundary Q1-1.SIQR -2.5000 Quartile 1 2.0000 Upper boundary Q3+1.5IQR 9.5000 Median 3.5000 Quartile3 5.0000 Max 6.0000 3.0000 Identify outliers in your given data set. If the data is not between the lower and upper boundary then it is an outlier
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
