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, 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
hospitals or anyone. It
mostly from Medicare, so
you can decide.
Dates are assigned
arbitrarily to sort
the articles. Most
articles have been
written or updated
Like: Facebook, Twitter,