Unformatted text preview: have the row number of the last cell. Finish the column by copying the first data expression to the remaining rows. Check to make sure your percentiles look like they are correct! Label the fourth column as Rankbased zscores. Excel provides these values with the norm.s.inv function. Use this function to create the values in the fourth column. Copy the first column to the fifth column. The Excel chart wizard works better if the xaxis values are just to the left of the yaxis values. Select the fourth and fifth column. Select the chart wizard and then the scatter plot. The default data values should be good, but you should provide good labels. See the file ``NormQuant.xls’’ for a completed example in Excel....
View
Full Document
 Summer '08
 AndrewB.Nobel
 Column, Normal probability plot, QQ plot, normal quantile plots

Click to edit the document details