This page first discusses Excel, then statistics in general near the bottom of the page. Help with Excel This is a simple introduction to some Excel commands which are helpful with the large spreadsheets of medical data on the site. The commands here work in Excel 2010 and Excel 2003.
When you open an excel spreadsheet from the web, it may ask if you want to "enable editing." You'll need to say Yes to make any changes in your copy, or to "find all" entries of a certain type, or filter, or sort. If the spreadsheet was slow to download, click File/Save As a couple times with new names, so you can get back to the original version without downloading again. If you need extra help, many people who work in bookkeeping or finance are good with Excel spreadsheets, or you can search the web. Basics. Most of you already know these:
Undo a Sort or anything: press Ctrl and Z at the same time. You can do this repeatedly to back up to previous versions, sometimes as far as the last time you saved the file Save Frequently, with new names, so you can go back to previous versions if you need to. Calculate an Average or Sum: Suppose you want Average of Column T
Help with Statistics For subscribers, AMA has advice for using statistics with large data files, a checklist, a series discussing medical databases, and an article comparing "odds ratios," probabilities, and "relative risk ratios" (emphasis added):
There are excellent articles on statistical analysis of health data in the British Medical Journal, though it requires a subscription, which you may find at a university or hospital library. |
This site does not provide
legal or medical advice. The site does not recommend doctors, hospitals or anyone. It summarizes information, mostly from Medicare, so you can decide. Dates are assigned arbitrarily to sort the articles. Most articles have been written or updated more recently. Like: Facebook, Twitter, Google+1, Reddit Pages
All
|