Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

[Application of Excel Visual Basic for efficiently complete statistic analysis].

Xu-Hong Hou1, Fu-Jie Shen, Jian-Hua Wang

  • 1Sixth People's Hospital of Shanghai Jiao Tong University, Shanghai 200233, China.

Zhonghua Liu Xing Bing Xue Za Zhi = Zhonghua Liuxingbingxue Zazhi
|May 9, 2006
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Nickel chelating functionalization of graphene composite for metal affinity membrane isolation of lysozyme.

Journal of materials chemistry. B·2020
Same author

In situ growth of β-FeOOH nanorods on graphene oxide with ultra-high relaxivity for in vivo magnetic resonance imaging and cancer therapy.

Journal of materials chemistry. B·2020
Same author

A three-dimensional amylopectin-reduced graphene oxide framework for efficient adsorption and removal of hemoglobin.

Journal of materials chemistry. B·2020
Same author

A novel organic-inorganic hybrid polyoxometalate for the selective adsorption/isolation of β-lactoglobulin.

Journal of materials chemistry. B·2020
Same author

The regulation of hydrophilicity and hydrophobicity of carbon dots via a one-pot approach.

Journal of materials chemistry. B·2020
Same author

Preparation of a cobalt mono-substituted silicotungstic acid doped with aniline for the selective adsorption of ovalbumin.

Journal of materials chemistry. B·2020
Same journal

[Research progress on the impact of the digital information environment on the health of children and adolescents].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2026
Same journal

[Exploration and practice of ideological and political education integration in the "One Core, Two Integrations" curriculum model for epidemiology].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2026
Same journal

[Progress in research of visualization of ideology and politics elements in curriculum and its importance for <i>Epidemiology</i> curriculum].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2026
Same journal

[Operation of WeChat official accounts of <i>Chinese Journal of Epidemiology</i>].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2026
Same journal

[Study on the risk factors of development for mild cognitive impairment to Alzheimer's disease based on the competitive risk joint model].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2026
Same journal

[Mendelian randomization study on related factors for esophageal adenocarcinoma and Barrett's esophagus].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2026
See all related articles

Excel Visual Basic for Application (VBA) efficiently calculates standardized mortality rates (SMRs) from multiple tables. This method enhances statistical analysis of disease data, offering flexibility and improved data handling.

Area of Science:

  • Biostatistics
  • Public Health
  • Epidemiology

Context:

  • Analysis of mortality data requires efficient statistical methods.
  • Traditional methods can be cumbersome for large datasets and multiple tables.
  • Standardized mortality rates (SMRs) are crucial for epidemiological studies.

Purpose:

  • To introduce Excel Visual Basic for Application (VBA) as a tool for efficient statistical analysis.
  • To demonstrate the calculation of standardized mortality rates (SMRs) using Excel VBA.
  • To compare the efficiency of Excel VBA with basic Excel and general databases.

Summary:

  • Mortality data (cancer, cardiovascular diseases) from 1991-2003 in Shanghai Huangpu District was analyzed.
  • Excel VBA was used to calculate male SMRs annually for different cancer classifications, using 2000 Chinese census data.

Related Experiment Videos

  • Results were tabulated, showcasing the capability to process multiple data tables efficiently.

    • Impact:

    • Excel VBA offers greater flexibility in data combination and annotation compared to general databases.
    • Excel VBA surpasses basic Excel in handling multiple tables and interactive data analysis.
    • The study highlights the efficiency and practicality of using Excel VBA for complex statistical analyses in public health research.