Can you help me put this on excel? I tried several times but I don’t think I’m doing something right.
If we knew the confidence level was 90%, the sample meanwas 3, the sample size was 30 and the population standard deviationwas 1.5, we could use this to find the standard errorof the mean, the z value and the interval half width.
Standard error of the mean = = 0.273861279
Z-value = 1.644853627
Interval half width = Standard error of the mean * …
The expert examines z values and the interval half widths.