Height Range/IQR Open the file FALL 2022 MATH 1680 Census Data Download FALL 2022 MATH 1680 Census Data. Copy column F of Sheet1 to column A new sheet named "IQR" Make row 1 bold and centered In cell C1, type "Min" In cell C2, enter the formula =MIN(A:A) In cell D1, type "Q1" In cell D2, enter the formula =QUARTILE(A:A, 1) In cell E1, type "Q2" In cell E2, enter the formula =QUARTILE(A:A, 2) In cell F1, type "Q3" In cell F2, enter the formula =QUARTILE(A:A, 3) In cell G1, type "Max" In cell G2, enter the formula =MAX(A:A) The range is the difference between the minimum and the maximum values in a data set.

In cell I1, type "Range" In cell I2, enter the formula =G2-C2 The interquartile range (IQR) is the difference between the first and third quartiles.

In cell J1, type "IQR" In cell J2, enter the formula =F2-D2