How to Plot Relative Risk in Microsoft Excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Plot Relative Risk in Microsoft Excel
Excel features a data plotting feature to help you make graphs. (B2M Productions/Polka Dot/Getty Images)

To plot relative risk, you need two sets of figures from your relative risk data set. This data set includes how the relative risk changes with the covariant, such as length. Using this data, you can plot the relative risk on the y-axis and the covariance on the x-axis. You can use Microsoft Excel to plot this chart after you enter in your data for the relative risk. Excel then creates a graph for you.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Type your covariate data in column A. You can use row 1 as a title row.

  2. 2

    Type your corresponding relative risk data in column B. You can use row 1 as a title row.

  3. 3

    Highlight the cells.

  4. 4

    Click "Insert" then "Line."

  5. 5

    Click anywhere on the chart to activate your chart with the relative risk data plotted.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.