: Am isted below cncmpany distributes Computer Chips in boxes. The number of chi

Question

: Am isted below cncmpany distributes Computer Chips in boxes. The number of chips produced per week for 64 weeks are 8 88337 85471 79289 80601 81740 874 73704 74441 65039 74385 67564 64034 72434 68871 88912 87813 90196 81610 9138 91224 71148 62982 85342 63761 66117 67089 75100 7881 88231 95876 92100 69345 71458 6960 83347 78122 5960 69031 71435 79127 7321 702772252 8082 74023 6989 8681 68033 7293579016 72189 72487 6933 65959 79585 74834 y Calculate the First quartile, Second quartile, Third quartile, Interquartile, and ALL required Other values before you raw the Box Plot in order to find if there are any outliers. (10 POINTS

Explanation / Answer

The last column in the image is not shown in full. I am giving the Excel procedure with formulas to calculate the required values so that student can easily do it.

Procedure:

1. Enter the values in column A of Excel, this will be from cell A1 to cell A64 because there are 64 values in the dataset.

2. Use the formula QUARTILE(A1:A64,1) to find the first quartile.

3.

Use the formula QUARTILE(A1:A64,2) to find the second quartile.

4.

Use the formula QUARTILE(A1:A64,3) to find the third quartile.

5. Use the formula MINIMUM(A1:A64) to find the minimum value as it is required to draw boxplot and MAXIMUM(A1:A64) to find the maximum value.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.