How to Create a QQ Plot in Excel

In this video I explain how to create and interpret a QQ plot in Excel.

Here is the formula I used to calculate the theoretical quantiles:
=NORM.S.INV((ROW(A2)-ROW($A$2)+0.5)/COUNT($A$2:$A$31))

Here is the formula I used to calculate the QQ line values:
=QUARTILE.INC($A$2:$A$31,1)+(B2-NORM.S.INV(0.25))*(QUARTILE.INC($A$2:$A$31,3)-QUARTILE.INC($A$2:$A$31,1))/(NORM.S.INV(0.75)-NORM.S.INV(0.25))

Видео How to Create a QQ Plot in Excel канала Zach's Math Zone