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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!