After constructing a boxplot of a series of data, I find that the Median bar is confused with the 1st Quartile bar. I have checked the data and I think there is no error in the database. So is it normal to get such boxplot?
It is not normal for the Median bar to be confused with the 1st Quartile bar in a boxplot. This suggests that there may be an error in the construction of the plot or in the data itself. It's possible that there may be some outliers in the data that are causing the plot to be skewed, or there may be some other issue with the plot configuration. Double-checking the data and the plot settings can help identify any issues that may be causing the problem. Any preprocessing such as data cleaning, outlier removal and scaling should be accounted for before the plot is constructed.
It is not usual, but there is nothing wrong with the data when the median and the 1st or 3rd quartile coincide. No point in trying to prune "outliers" when it's clear that the distribution is inherently odd. Who said they all had to be normal? People don't select doses at random from a normal distribution, they follow the directions on the packet.
It's a problem with boxplots, which show summary statistic, not data.
You should consider plotting the actual data, jittered or stacked, over the boxplot, or even using a raincloud plot, which combines raw data, boxplots and density plots. You can do the latter in jamovi (install the survey module) or JASP.