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
- Summer '08
- Column, Normal probability plot, Q-Q plot, normal quantile plots