Forum Discussion
Why Can't I Get These VERY Basic Calculations
I am taking an Introduction to Statistics course where we use Excel. For some reason, I cannot seem to make my process look like the professor’s. I’ve been struggling with this for three days now...
I wrote: ``the professor is working with exact "p" values, or at least with "p" values that have more than 3 decimal places of precision``.
We cannot know what values the professor uses.
But the following shows some values with 4 decimal places that you can use to duplicate the professor's presentation.
At the very least, that should allow you to proceed with verifying your Excel implementation.
Row 9 shows the actual values that are in row 2, but formatted to display only 3 decimal places.
B10 shows that actual value in B6 up to 15 significant digits, the most that Excel formats.
I hope that helps you understand my explanation of the rounding issue.