When I opened the Google Doc of the Excel page at home, it had this "=_xlfn.NORM.INV(RAND(),65,5)" in cell A1. When I deleted the "_xlfn." and the "." in between NORM and INV, it worked fine.
This is what A1 should have in it: =NORMINV(RAND(),65,5)
B1 should look like this: =A1-1.96*5/SQRT(30)
C1 should look like B1 except with a plus.
Of course, this is for a normal distribution, or for a means question. Remember, if you have a proportion, then the function was BININV or BINOMINV, I think.
Again, email or Tweet your questions.
No comments:
Post a Comment