In this world of looking at faces, both the scientific research chart in the paper and the PPT reported to the teacher should take into account both face value and talent.
For example, the following friend wants to cry first because the painting is too ugly!
Scientific research and drawing are so important, it is natural to choose the weapon (drawing tool) at hand!
At present, the common scientific research drawing software is as follows:
These three tools can complete very professional and beautiful drawings, and 1 and 3 are all in use.
The above tools are very good and powerful, but the high learning cost leads to low cost performance.
So, is there any software as flexible and powerful as Sun's golden hoop?
EXCEL is not specially designed for scientific research drawing, and its drawing function is not very powerful.
However, the learning cost of EXCEL is low (not equal to none), and the interactive interface is super friendly. If it is skillfully used, it can definitely cope with most data visualization work.
Let's take the histogram as an example to see what effect EXCEL can achieve.
When you have many factors and different levels of data, you can use power pivot and Slicer.
You can quickly check the changing trend between different experimental conditions.
Core technology of scientific research surveying and mapping:
Now, let's experience the charm of Excel and this plug-in.
In the above figure, the pivot table groups the data of different conditions and genes and calculates the average value of each group. Similarly, we can also calculate the standard deviation and so on! The qPCR automatic calculation program I wrote before relies heavily on this function.
The following is a demonstration of the whole statistical process:
The magic time is always short, and the introduction of Excel and scientific research drawing plug-ins is drawing to a close. In addition to icon style setting and high-quality icon export, this plug-in also has intimate statistical functions such as variance analysis and linear regression. For the vast number of scientific researchers, it is simply a fragrant cake!
Make good use of Excel and its surroundings, and constantly explore new functions, whether in scientific research or office field, you can have different experiences!
2020-07-05
Sean