Thank you for the new version. It's true what you say: the not adjusted residual is the square root of the cell Chi square, but still you should export the table to Excel to perform the easy calculations. Actually this is what I used to do before: with your script it's much faster. If you want to check one more possible improvement, note that the script does not show the std residuals when either variable contains missing values. I mean: the table with the frequencies is displayed correctly (e.g. without missing values), but the residuals are not displayed at all. I tried to pre-filter the data table in order to avoid any missing values, but it didn't solve the issue.   ... View more

Got it, thanks. I hope it will be useful for somone else. ... View more

Now it's fine, I will definitely adopt it. Thank you again ... View more

Thank you for your script. Actually there are two formulas for the std res: adjusted and not adjusted. The one you used was the adjusted one (which is fine), but there should be an error in the way pidot# and pdotj# are calculated. Unfortunately I can't really understand the script, hence I can not fix it. I simply added a row with the (slightly simpler) alternative formula, just to check where the problem is - in case you are still interested. ... View more

thank you 😞 ... View more