next up previous contents index
Next: Exercises Up: Using Excel Previous: Computing probabilities less than

Getting z critical values

1. On the menu bar, click on `Insert'. Select `Function'. A new window with a list of functions will appear.
2. From the functions list, select `Statistical'. For function name, select `NORMSINV'.
3. Enter the desired level of significance. Remember to use the area to the left of the critical value ( $1 - \alpha$).
4. Click `OK'.