Step 1: Input the average value and corresponding standard deviation of each group into EXCEL respectively.
Step 2: Right-click to select data series format.
Step 3: Select the error line Y to display positive deviation or other types.
Step 4: Under the error amount, select the user-defined option and select the standard deviation of all data.
Question 2: What does the error line mean? There is no strict definition of error line. You need to see how the author of the picture defines the upper and lower bounds, which may be the standard deviation of the mean, the standard deviation of the whole sample, 1 times, or 1.96 times. In short, they are all some kind of confidence interval, so be careful whose confidence interval it is.
Question 3: What is the significance of error lines in data statistics? How to analyze data with error lines and seek experts' refined explanation! ! Additional error bars: usually used for statistical or scientific data, showing potential errors or uncertainties related to each data mark in the series. The error line can be standard deviation (average deviation) or standard error, which is commonly used.
Look up the meaning of standard deviation and you will know how to analyze it. This is a long, long story.
Question 4: When drawing with excel, it is necessary to draw positive and negative error lines with different lengths, but the general standard deviation can be calculated. How to make positive and negative error lines? Self-creation method, drawing, straight line, draw the required length first, and then move the straight line to the required position.
Question 5: How to adjust the length of the error bar in origin so that the length of the error bar is the same as that measured on the corresponding coordinate axis? Ask for expert guidance! The five-point origin drawing is based on data, and what kind of data can complete what kind of drawing.
The length of the error line is actually the size of the error data. If you want to adjust the length of the error line, you need to modify the size of the error data value. The original data table provides a column of error data, and you only need to fill in the corresponding error data in this column.
The method of setting the error data column is to insert an empty data column after the corresponding Y-axis data column. Then select this newly inserted empty data column (displayed in black after selection), and right-click the selected empty data column. Note: Be sure to right-click the selected data column, and don't point to other places. Click the right mouse button in different places in Origin to pop up different menu contents, so be sure to pay attention! In the pop-up menu, select Set to-gt; Y error, as shown in the figure below:
After setting, you will find that the newly inserted column C(Y) becomes C(yEr? )。 At this time, you can go to C(yEr? ) Fill in the corresponding error data.
Question 6: Help EXCEL chart to add error bars. How to add the error lines of different values in a series? If you select three different values in the Custom box, you can insert them into a series of three different column charts and use WPS excel.
Question 7: Added the wrong line in EXCEL. Now, how about writing a paper? To analyze, how to analyze? 1, and the error line represents the fluctuation range of data.
2. The length of the error line can reflect the accuracy of the data.
3. In fact, the error line is not particularly important and should not be the basis of important analysis.
Question 8: Excel error lines have short horizontal lines, how to delete them? Click the mouse and press DEL or CTRL+X to delete it. If not, please send it to the cloud disk and paste the address, and everyone will help you delete it.
Question 9: excel ladder diagram is positive and negative. How to solve the error line 1? First, open Excel software, enter data (or the average value of a large number of data), click "Insert", select the icon, and build a column chart. 2. Then we need to calculate the error value of the data, which is the variance. In this example, we randomly enter two numbers, 0. 1 and 0.2. Right-click the data series format, select the error line y, click the positive and negative deviation, and then select the user-defined error value. 4. Click the box after Custom, and then select the error value entered in the second step. 5. Then press Enter twice on the computer to get a column chart with error lines.
Question 10: How to analyze the data after entering a good questionnaire? When designing, we should consider the convenience of statistics to facilitate summary. Just use excel.