i've created a chart using excel and i need it to derive the Z alpha/2 value from the table which i have input into the excel sheet. I want to be able to input the Confidence Interval and automattically have it Divide that number by 2 then divide it by 100 and then look up the closest value in the table. How can this be done, any advice would really help me out, this is for a Business Statistics class, the teacher challanged me to do it and i've been trying to figure it out.
Here is a link to my file so you can get a gist of what i'm trying to do http://www.microwholesale.com/comm/ProblemSolver.zip
Thanks in advance!
Here is a link to my file so you can get a gist of what i'm trying to do http://www.microwholesale.com/comm/ProblemSolver.zip
Thanks in advance!