Many friends in the background said that there was more demand for painting, so they sorted it out.
Graphpad
The use of, one is to spread knowledge, the other is to learn from excellent software, so that online drawing is getting better and better.
Graphpad, origin and SigmaPlot
It is three kinds of statistical mapping software commonly used by scientific research leaders. They have their own advantages and disadvantages and often need to be used together.
Today I'm going to introduce you to the basic usage of Graphpad.
The following is the welcome interface of Graphpad.
from
Block 1
It can be seen that GraphpadPrism6 provides users with
Six
Basic statistical chart selection;
Box 2
The following is an explanation of the selected chart. Click Learn More to view the official help document.
Box 3
You can choose a small classification under a certain kind of chart;
Box 4
Provide demonstration data sets for beginners to get started.
The description of the six statistical chart types and the statistical methods used are as follows:
Here, the second ready-made data set provided under grouping is selected for drawing demonstration. Click Create directly after selecting it.
After the previous step, we entered the main interface of graphpad operation.
Block 1
Shown here are our data. Each large group represents three different cell lines (wild type cells, GPP5cellline and GPP7cell line). Each row represents different treatments (serum starvation and normal culture); 5 parallel replicates in each group.
There are missing values in the experimental data, such as A:Y4 in the first row.
Box 2
Chu is a place.
directory tree
After importing data, click the graph to draw, as shown below:
In this interface, you can change the chart type according to your own needs. Beginners should dare.
Chaos point
Try different options yourself, and you will know what each part does. (trying to understand the truth)
The preliminary statistical chart above does not show the statistical analysis results such as the differences between groups, so how to show the differences between groups by adding *?
In the welcome interface, there is an option EnterandPloterrorValues All Readycalculedelsewhere, which means that the statistical analysis results made in other places can be imported from outside. Is it necessary to do calculations elsewhere before painting?
No need! Because you can do statistical analysis directly on Graphpad! ! ! Although the analysis can be done elsewhere first, it is not recommended. Direct operation is more convenient.
First, determine our analysis objectives:
1) Assess whether the differences between cell lines are beyond expectations;
2) Assess whether the difference between treatments exceeds the expected contingency;
3) evaluating whether the differences between treatments are consistent with each cell line;
4) Calculate the 95% confidence interval of the difference between cell lines with different treatments.
So we need to carry out
Two-factor analysis of variance
, click Analyze, select two-way ANOVA from the grouping analysis list, and accept all the default options in the dialog box. The humanization of Graphpad lies in that it will automatically identify the data structure of the current analysis and show users the optimal default analysis options.
After detailed analysis, you need some statistical knowledge. Don't be afraid to try it. You will find that when you click different options, the icon will change accordingly, which is very convenient for users to understand.
1) Part I: Experimental design. It is mentioned at the beginning that this set of data is unpaired, so choose the first one;
2) Part II: Multiple comparison options, that is, horizontal comparison, vertical comparison or oblique comparison;
3) Part III: Select some parameters for statistical analysis.
After the above settings are completed, click OK to display the analysis results in the main operation interface and save them in the results folder under the left directory tree.
1. Introduction to the graphic editing toolbar
1) Part I: Document operation module, similar to office, such as opening, creating, saving, copying and pasting;
2) The second part: data analysis, that is, statistical analysis of the previously demonstrated input data;
3) Part III: Graphic editing, which is the essence of software. You can edit and change graphs, such as graph type, axis, error bar, graph size, color, etc.
4) The fourth part: text editing, which can illustrate lines and add text on the statistical chart;
5) Part V: Graphic output, which can export, print or output the completed drawings to word/PPT.
2. According to the previous statistical analysis results, use the text editing tool to add the marks of differences between groups to the statistical chart.
1)draw: lines with different shapes can be inserted;
2) Writing: editing words, inserting formulas, etc.
3) Double-click any element in the graph to edit the shape, size and thickness of text and lines.
3. Coordinate axis adjustment
Click Change.
The second icon
, still in the picture.
Double-click coordinate axis
, bring up the coordinate adjustment tool;
See the figure for the overall setting of the coordinate axis and the setting of the X axis, and generally do not make too many changes;
This paper focuses on how to set the Y axis and make it
Truncated graph
This is a common problem in statistical charts.
The previous data is not very different and is not suitable for demonstration, so a histogram is generated. The left column value is too large, the right column value is too small, the right column almost disappears, and the picture looks very uncoordinated. Become a
Truncated graph
This problem can be well solved.
1) Click LeftYaxis in the coordinate settings (generally, drawing only generates the left y axis by default);
2) Select two sections at 2)GapsandDirection, that is, break the Y axis into two sections (you can also choose to break the Y axis into three sections according to the actual data);
3) In this section, set parameters (ranges) for the Y axis at the bottom and the top respectively;
4) Then, set the Y-axis digital label at the major scale interval under Regularlyspacedticks;
Length: 50%, half of the upper and lower sections;
Minimum value: the minimum value of the lower segment is 0, and the minimum value of the upper segment is150;
Maximum value: the maximum value of the lower segment 10 and the maximum value of the upper segment 200;
Majorticks: The size of each cell in the lower segment is 2, and the upper segment is 10.
In this way, the middle part of Y axis 10- 150 is cut off, and the whole picture looks much better.
4. Color modification
Click Change.
The last icon
, still in the picture.
Double-click post
, bring up the toolbox for adjusting parameters;
The basic operation of making a statistical chart with graphpad is probably the above content. It is not difficult to master the use of a tool, just try more. What is difficult is the statistical knowledge behind it. How to choose an appropriate statistical analysis method for your own data? When we know which data structures are suitable for different analysis methods, we can analyze the data of different experimental designs appropriately through analogy.
What drawing software is used to draw the coordinate map? First, drawing the coordinate map can be done by CAD.
Second, the method of drawing coordinates with CAD
1. Double click the cad icon to start cad.
2. Make the most basic settings of cad first, as shown below. I usually open the polar axis, set the object capture at the same time, and then open it.
3. Enter a straight command line, or directly enter l, some of which are capitalized. As shown in the following figure 1. Of course, you can also choose the straight line shortcut graph in the upper left corner.
4. Enter the letter L in the command bar in turn, and then enter the coordinates, 0,0; 700,0; 700,500; -700,500, and then press the letter C (close command), and the rectangle is drawn.
How to make a coordinate map 1: How to select three lines of data in excel, including text, when drawing a coordinate map with Excel data.
Then click Insert-Select a line chart in the chart box-Select a line chart with data markers in the triangle below.
Select the abscissa, right-click a point, and then select Format Data Series.
Select the short axis in the pop-up list on the right. That is, a two-coordinate line chart is generated.
At this time, you can also click the plus sign at the top right of the line chart to add the axis title, and finish.
Question 2: How to draw a coordinate map? 1. Execute the command "Draw/Draw Grid/Display Grid on Screen (pay attention to data setting)/OK" to display the drawing grid on the page; 2. Draw the coordinate axis with the arrow on the Drawing toolbar, and hold down the Shift key when drawing to ensure that the drawn line is horizontal and vertical; 3. Draw a scale on the coordinate axis with "straight line" or "ellipse"; 4. Use this box to identify data on the number axis; 6. Use "ellipse" as the coordinate point (hold down the Shift key when drawing), use "straight line" to draw the vertical line leading from the point to the coordinate axis, and use "text box" as the coordinate of the point. 7. Make function graphics with the optional graphics on the drawing toolbar. 1. When the drawing toolbar opens, select Arrow and use it to drag a straight line with an arrow horizontally (its shape and size can be changed in Format Graphics). If you want to drag it directly, please hold down the shift key while dragging. 2. Drag the vertical line with arrow in the same way. 3. Select two rows at the same time, click the "Draw" button on the leftmost side of the drawing toolbar, and use "Align Left" and "Align Bottom" in "Align and Distribute" to adjust their positions respectively. If you think it's the right size, put them together at this time. 4. Drag out a short vertical line with the "straight line" in the picture. If the length, thickness and color are appropriate, copy a few, then select them all and align their bottom "horizontal distribution" with the method just now. At this point, the scale on the abscissa has begun to take shape. Merge them, then select the just merged coordinates and align their bottom ends to adjust their positions. 5. Select "WordArt" in the drawing, mark a number, letter or text with a suitable size and content, copy a few, edit the order, enlarge the display scale, drag the first mark as far as possible to the appropriate position below your first scale (or 0 scale) (to move accurately, hold down the Ctrl key and press the up, down, left and right keys), and drag the last mark. The abscissa or even the label can be used, and the ordinate can also be treated in this way. Finally, if you are satisfied, just select all the contents and combine them! The content of the whole coordinate axis will be freely dragged and resized, and inserted into the position you need. CAD is enough. Enter the serial number and coordinates with notepad. You can see the position of each coordinate by importing CAD. Click the point to view the coordinates of the point. The serial number can be displayed directly on the dot.
Question 3: How to make two vertical graphs with excel tables? In Excel2007, you can do the following:
1. First make a graph with the same axis from two sets of data, that is, only the left longitudinal axis (main axis).
2. Right-click a set of data (rows), set the data series format, and select "Secondary Axis".
Question 4: How to use CAD to draw a coordinate diagram to open Notepad and write the coordinates in this format;
385898 1. 189,6 17709.949
3858929.686,6 17798.773
385892 1. 137,6 178 13.5 18
38589 19.038,6 178 17. 138
385879 1. 18 1,6 17753.282
385879 1.847,6 17749. 154
3858794.678,6 1773 1.603
38588 10.862,6 1763 1.275
385898 1. 189,6 17709.949
Note: Write in English, not Chinese.
Copy, open AutoCAD, enter the command PL or LDD \\> space, and then paste it into the command line.
The last blank line is a space. If there is this space, you can end the action.
Question 5: How to make a coordinate map? You can draw with word or geometric sketchpad.
Question 6: How to make a two-coordinate map 1?
Open an Excel document, such as the data to be analyzed as shown in the figure.
2
Select the analyzed data, and click Insert-Column Chart to select a simple column chart, as shown.
three
In the right-click option, select Format Data Series.
four
In the Format Data Series dialog box that appears, select the series to draw on the secondary axis.
five
In the right-click option, select Select Data.
six
In the Select Data Source dialog box that appears, click Add Series and set the value to 0.
seven
Double-click the series respectively, and open the data series format-Options-Set the overlapping ratio and classification spacing-until the series column chart is separated. The double coordinate diagram is shown in the following figure.
Question 7: How to draw a coordinate map with word? The vertical intersection of the up arrow and the right arrow is the X axis and the Y axis, and the coordinate points can be made by a table with equal width and height. The table can be set with different borders as needed.
Question 8: How to make an excel chart with two vertical coordinates to establish secondary coordinates! 1. Open the data to create a secondary axis, select the data, and then insert it. Select the histogram in the chart ribbon to get a preliminary chart.
2. Select a chart. Under the format of the currently selected chart tool, select the "Growth Rate" series, which is the data we want to put on the secondary axis.
3. After selecting "Growth Rate" series, right-click and select Set Data Series Format to open the setting window.
4. In the sequence options bar that appears, select the secondary axis.
5. In the obtained chart, continue to select the "growth rate" series, and right-click to change the chart format of the series. In the changed chart type, select the combination, then select the second cluster column chart, and then confirm to get the graph we want.
6. Add a title, unit, and change the value of the horizontal axis to the year, and you will get a very standard chart.
Question 9: How to draw the x-y curve in excel to select the data area->; Insert menu-> "chart"->; Select XY scatter chart in chart type->; "sub-chart type", select "smooth line scatter chart of countless data points"->; Click "Finish"
Supplement: You should first enter data in the EXCEL table, then select the data range, and then insert the chart.
Question: How to set the XY axis when excel makes a line chart? Using Sichuan Y scatter plot, you can display the relationship between XY by selecting a smooth line scatter plot in the sub-chart type. Want to show the relationship of XY axis! This is easy to handle: first select the polyline and right-click "Add Trend Line" and "Linearity" in "Type".