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 Rank-based z-scores. 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 x-axis values are just to the left of the y-axis 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