ORAC
30th Aug 2004, 20:26
I would be grateful for some help on Excel 2003 macros. I have to produce a report based on a couple of statistical outcomes and would be grateful for some help on macro content and explanation. I need to conduct a hypothetical test at the 5% significance level, followed by a 99% confidence level for the population mean.
I also need to produce an excel worksheet using NORMSINV and CONFIDENCE functions to calculate Zcrit andthe confidence levels for a mean where the population standard deviation is known. I have the manuals, but need help on zeroing in on the right bits of the statistics handbook and on Excel of which I know little...
Any help or advice appreciated.......
I also need to produce an excel worksheet using NORMSINV and CONFIDENCE functions to calculate Zcrit andthe confidence levels for a mean where the population standard deviation is known. I have the manuals, but need help on zeroing in on the right bits of the statistics handbook and on Excel of which I know little...
Any help or advice appreciated.......