Re: Calculation of mean/median values in box &whisker plots. [message #617 is a reply to message #613] |
Sun, 25 August 2019 20:13 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) ![Go to next message Go to previous message](/forum/theme/myThemeWithHFCSS/images/down.png) |
nbehrnd
Messages: 215 Registered: June 2019
|
Senior Member |
|
|
Hi Thomas, Hi Tim,
in my observation, all four statistical values provided in the whisker
plot do change by setting manually the cell entry of molecular mass to
the string of "N/A" (without the quotation marks). Processing the data
a twice allows me to retrieve the changes in the whisker plot and its
statistical data, too. Here I share my approach to the task with DW
(Linux version 5.0.0) with the test file alkanes_complete.dwar above:
Reading the file as-such which contains 10 complete entries:
![index.php?t=getfile&id=91&private=0](index.php?t=getfile&id=91&private=0)
Accessing the cell value for methane, "16.0428" is replaced by "=N/A".
As expected, DW will indicate this as a non-valid entry. Of course, no
whisker plot is provided now. But the dot is still present in the plot.
![index.php?t=getfile&id=92&private=0](index.php?t=getfile&id=92&private=0)
Next step, replacing "=N/A" by "N/A". DW accepting this now provides a
Box whisker plot. The dot without associated value is sorted out, the
statistical data are updated.
![index.php?t=getfile&id=93&private=0](index.php?t=getfile&id=93&private=0)
Two additional observations:
If "N/A" is entered for the first time, the line vanishes completely,
hence shortening the list of 10 alkanes to 9 alkanes. This removal
may affect other columns than the column currently worked on, too.
This contradicts the aim to preserve the complete line which only has
no entry for this very cell.
Say, there is a second entry with no value available. Then, a direct
input of "N/A" via DW's edit cell function is possible without danger
to loose the complete line. E.g., direct access to
![index.php?t=getfile&id=94&private=0](index.php?t=getfile&id=94&private=0)
Again for documentation, the file used here is attached below. Maybe
there is a better way -- if so, I'm curious to learn it.
Norwid
-
Attachment: step_0.png
(Size: 7.11KB, Downloaded 843 times)
-
Attachment: step_1.png
(Size: 5.26KB, Downloaded 836 times)
-
Attachment: step_2.png
(Size: 8.80KB, Downloaded 778 times)
-
Attachment: step_3.png
(Size: 9.24KB, Downloaded 833 times)
-
Attachment: test_file.dwar
(Size: 2.85KB, Downloaded 431 times)
|
|
|