From BYU-I Statistics Text
- Here is how to make a Q-Q plot in Excel:
- Open the data file (BattingAverages.xlsx)
- Copy the data you needs from this file (the column labeled BattingAvg)
- Open the file QuantitativeDescriptiveStatistics.xls
- Click on the tab labeled “QQ Plots”
- Paste the data into Column A of the QQ plots worksheet
- Sort Column A in order from smallest to largest.
- The graph on the right will be your Q-Q plot.