Hi,
I have the following values and text, and although I've managed to add the values in my text, I don't know how to show only 2 decimals.
This is my formula:
="The owner can be "&H12*100&"% sure that the population proportion (% of customers excited about the new product) is between "&H18*100&"% and "&H19*100&"%"
These are the values
0.95
0.050
0.025
1.960
0.019
0.037
0.653
0.727
and this is the resulted text:
The owner can be 95% sure that the population proportion (% of customers excited about the new product) is between 65.2993513141917% and 72.7006486858083%
The margin of error is 3.70064868580828
If 100 similar intervals were constructed about 99 intervals could contain the population proportion
Thanks in advance.
Bookmarks