Use the QUARTILEINC function to get the quartile for a given set of data. If youre in Excel you can go to File Open or you can right-click the file in your. The QUARTILE function accepts 5 values for the quart argument as shown the in the table below.
Excel returns the value 1125.
Enter the quartile function. Use the QUARTILE function to get the quartile for a given set of data. Use the QUARTILEEXC function to get the quartile for a given set of data. QUARTILEINC Function Explanation.