This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 11/18/2011 for the course STOR 155 taught by Professor Andrewb.nobel during the Summer '08 term at UNC.
 Summer '08
 AndrewB.Nobel

Click to edit the document details