canreg5 webinar 5: data analysis...2012/11/13 · canreg5 webinar 5: data analysis morten ervik...
TRANSCRIPT
![Page 1: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/1.jpg)
CanReg5 Webinar 5: Data Analysis
Morten Ervik
International Agency for Research on Cancer,Lyon, France
Lyon, France, 22 October 2012
![Page 2: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/2.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 3: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/3.jpg)
![Page 4: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/4.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 5: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/5.jpg)
Frequencies by year
I A tool to count the cases in the database.I Filter the cases using simple statements
I Boolean logicI Subset of the SQL languageI Filter wizard to help build filters
I Stratify the results:I by any variableI by as many variables you need
I Results can be written to files of standard format for postprocessing in general spreadsheets (Excel, Calc,Numbers), or other tools.
![Page 6: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/6.jpg)
Example: Cases by year
![Page 7: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/7.jpg)
Example: Stomach cancers in 2000 by morphology
![Page 8: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/8.jpg)
Example: Sources in one year
![Page 9: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/9.jpg)
Example: One source over the years
![Page 10: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/10.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 11: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/11.jpg)
Population Dataset Editor
I Lets you add denominators to your databaseI You can store as many as you want:
I By yearI Sub-populations (relevant cases automatically picked from
the database.)
I Support most age group breakdownsI Editor supports copy and paste to and from general
spreadsheets like Excel
![Page 12: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/12.jpg)
Enter details
![Page 13: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/13.jpg)
Enter data
![Page 14: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/14.jpg)
Preview the population pyramid to visually check forerrors
![Page 15: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/15.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 16: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/16.jpg)
Table builder
I Generate “ready to print” tables.I A wide range of different types of tables, for example:
I Incidence tables - rates and number of casesI Age specific incidence curvesI Figures of top 10 cancers by sexI Figures of cases by ageI Population pyramids
I A wide range of output formats:I Scalable formats (PDF, PS, SVG)I Image formats (PNG, etc.)
I Some tables calls transparently R:I Advanced users can write their own R programs that can
be called directly from CanReg5.
![Page 17: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/17.jpg)
Choose table type
![Page 18: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/18.jpg)
Choose period
![Page 19: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/19.jpg)
Choose denominators
![Page 20: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/20.jpg)
Choose file format
![Page 21: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/21.jpg)
Results
![Page 22: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/22.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 23: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/23.jpg)
Export/Report
I Export data for further work in other tools, or provide tocollaborators
I individual casesI only selected variables (or all)I choose to export codes and/or labels/descriptionsI filter cases as you wishI Character separated files compatible with general
spreadsheets, like Excel.
![Page 24: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/24.jpg)
Export/Report
![Page 25: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/25.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 26: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/26.jpg)
Live Demo
![Page 27: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/27.jpg)
Outline
Frequencies by year
Population Dataset Editor
Table Builder
Export/Report
Live Demo
Summary
![Page 28: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/28.jpg)
Summary
I Frequencies by yearI stratified by any variable
I Population Dataset EditorI Table builder
I for “ready to print” tables.I a multitude of file formats for different uses.
I Export/reportI For further analysis in other programs
![Page 29: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/29.jpg)
Summary
I Frequencies by yearI stratified by any variable
I Population Dataset EditorI Table builder
I for “ready to print” tables.I a multitude of file formats for different uses.
I Export/reportI For further analysis in other programs
![Page 30: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/30.jpg)
Summary
I Frequencies by yearI stratified by any variable
I Population Dataset EditorI Table builder
I for “ready to print” tables.I a multitude of file formats for different uses.
I Export/reportI For further analysis in other programs
![Page 31: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/31.jpg)
Summary
I Frequencies by yearI stratified by any variable
I Population Dataset EditorI Table builder
I for “ready to print” tables.I a multitude of file formats for different uses.
I Export/reportI For further analysis in other programs
![Page 32: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/32.jpg)
Future webinars
I Next webinar:I Sometime during the first half of December.
I Theme: Customization, etc.I Please send suggestions to [email protected] to propose
additional topics.
I Slides and videos will be put online at the GICR website;http://gicr.iarc.fr
![Page 33: CanReg5 Webinar 5: Data Analysis...2012/11/13 · CanReg5 Webinar 5: Data Analysis Morten Ervik International Agency for Research on Cancer, Lyon, France Lyon, France, 22 October](https://reader035.vdocuments.us/reader035/viewer/2022071401/60eb89a6184d956cef4237b1/html5/thumbnails/33.jpg)
For Further Information I
Ervik, MortenCanReg5 - the handbook2009-2012Available online at the IACR web page under software
CanReg5 web pagehttp://www.iacr.com.fr/canreg5.htm
@canreg twitter feedhttp://twitter.com/canreg