Software:Excel-QQ-plot

From BYU-I Statistics Text
Jump to: navigation, search
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.
Excel QQ-Plot L05.jpg