Diff for "FAQ/linebar" - CBU statistics Wiki
location: Diff for "FAQ/linebar"
Differences between revisions 10 and 11
⇤ ← Revision 10 as of 2008-01-08 16:05:27 →
Size: 3052
Editor: PeterWatson
Comment:
← Revision 11 as of 2008-01-08 16:06:53 → ⇥
Size: 3061
Editor: PeterWatson
Comment:
Deletions are marked like this. Additions are marked like this.
Line 12: Line 12:
 1. Highlight the row containing the variable values  1. Highlight the row containing the variable values.
Line 14: Line 14:
 1. Click on the chart wizard icon (identified by a graph of coloured bars) or choose CHART on the INSERT toolbar  1. Click on the chart wizard icon (identified by a graph of coloured bars) or choose CHART on the INSERT toolbar.
Line 16: Line 16:
 1. Under '''CHART TYPE''' choose '''LINE''' and choose '''LINE WITH MARKERS DISPLAYED AT EACH DATA POINT''' under '''CHART SUB-TYPE'''. Click '''NEXT'''  1. Under '''CHART TYPE''' choose '''LINE''' and choose '''LINE WITH MARKERS DISPLAYED AT EACH DATA POINT''' under '''CHART SUB-TYPE'''. Click '''NEXT'''.
Line 20: Line 20:
 1. Click '''ADD'''. ''Control'' should appear in the series window  1. Click '''ADD'''. ''Control'' should appear in the series window.
Line 22: Line 22:
 1. Repeat for ''Patient'' deleting the content of the slot next to ''Name'' and inserting ''Patient'' and deleting the contents of the slot next to ''Value'' and then highlighting the two patient means, 9 and 15. ''Control'' and ''Patient'' should now both be in the series window  1. Repeat for ''Patient'' deleting the content of the slot next to ''Name'' and inserting ''Patient'' and deleting the contents of the slot next to ''Value'' and then highlighting the two patient means, 9 and 15. ''Control'' and ''Patient'' should now both be in the series window.
Line 29: Line 29:
 Click on the tab called '''Y ERROR BARS''' in the resultant '''FORMAT DATA SERIES''' Window  Click on the tab called '''Y ERROR BARS''' in the resultant '''FORMAT DATA SERIES''' Window.
Line 32: Line 32:
 Click on the display named '''BOTH''' and choose '''CUSTOM'''  Click on the display named '''BOTH''' and choose '''CUSTOM'''.
Line 35: Line 35:
 Highlight the standard error row in the spreadsheet. The co-ordinates of the standard error row should appear in the ''''+'''' box in the '''CUSTOM''' section  Highlight the standard error row in the spreadsheet. The co-ordinates of the standard error row should appear in the ''''+'''' box in the '''CUSTOM''' section.
Line 38: Line 38:
 Click on the window adjacent to ''''-'''' and highlight the standard error row. The co-ordinates of the standard error row should appear in the ''''-'''' box  Click on the window adjacent to ''''-'''' and highlight the standard error row. The co-ordinates of the standard error row should appear in the ''''-'''' box.

Adding error bars to line plots of means in EXCEL

Let us assume we have the following input for age (young, old) and clinical group (control, patient) with means and width of confidence interval half width equal to upper limit - mean. Confidence intervals can be obtained e.g. using ANALYZE:DESCRIPTIVE STATISTICS:EXPLORE in SPSS.

Means

CI half width

Group

Young

Old

Young

Old

Control

12

21

0.2

0.1

Patient

9

15

0.3

0.9

  1. Enter the values of the variable to be plotted in one row and the standard errors pertaining to each variable column in another row.
  2. Highlight the row containing the variable values.
  3. Click on the chart wizard icon (identified by a graph of coloured bars) or choose CHART on the INSERT toolbar.

  4. Under CHART TYPE choose LINE and choose LINE WITH MARKERS DISPLAYED AT EACH DATA POINT under CHART SUB-TYPE. Click NEXT.

  5. Delete the contents of the rectangular slot next to 'Name' and type in it Control. Delete the contents of the rectangular slot next to 'Values' and, keeping the cursor in this slot, highlight the two cells in the controls corresponding to the two age means ie 12 and 21.

  6. Click ADD. Control should appear in the series window.

  7. Repeat for Patient deleting the content of the slot next to Name and inserting Patient and deleting the contents of the slot next to Value and then highlighting the two patient means, 9 and 15. Control and Patient should now both be in the series window.

  8. In Category (X) axis labels slot (obtained clicking on the series tab) put ={"Young","Old"}. Make other amendments such as axis titles and Graph title and click on FINISH. The graph should appear in the spreadsheet.

  9. Doubleclick on one of the data points (means) and we can proceed as with the bar chart.

  10. Click on the tab called Y ERROR BARS in the resultant FORMAT DATA SERIES Window.

  11. Click on the display named BOTH and choose CUSTOM.

  12. Highlight the standard error row in the spreadsheet. The co-ordinates of the standard error row should appear in the '+' box in the CUSTOM section.

  13. Click on the window adjacent to '-' and highlight the standard error row. The co-ordinates of the standard error row should appear in the '-' box.

  14. Click OK You should now have a bar chart with error bars. Doubleclicking on the error bars and clicking the PATTERNS tab in the FORMAT ERROR BARS window allows the user to change the style, colour or thickness of the lines forming the error bars.

None: FAQ/linebar (last edited 2014-03-28 14:12:27 by RussellThompson)