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

DNA array analysis in a Microsoft Windows environment.

T Conway1, B Kraus, D L Tucker

  • 1Department of Botany and Microbiology, The University of Oklahoma, Norman 73069-0245, USA. tconway@ou.edu

Biotechniques
|January 26, 2002
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

Corrigendum to "User evaluation of clinical simulation-based learning developed by FORCE (Framework for Online Radiographer Clinical Education)"[Radiography 31 (2025)].

Radiography (London, England : 1995)·2025
Same author

Professional challenges faced by student radiographers during COVID-19.

Radiography (London, England : 1995)·2025
Same author

Multi-omics driven genome-scale metabolic modeling improves viral vector yield in HEK293.

Metabolic engineering·2025
Same author

User evaluation of clinical simulation-based learning developed by FORCE (Framework for Online Radiographer Clinical Education).

Radiography (London, England : 1995)·2025
Same author

Ultrasound education across European Federation of Radiographers Societies (EFRS) countries: Similarities and differences.

Radiography (London, England : 1995)·2024
Same author

Achievement of Target Gain Larger than Unity in an Inertial Fusion Experiment.

Physical review letters·2024

This study introduces Visual Basic for Applications macros for Microsoft Excel to analyze DNA microarray gene expression data on Windows computers. These tools enable rapid normalization, statistical analysis, and data processing for smaller labs.

Area of Science:

  • Bioinformatics
  • Computational Biology
  • Molecular Biology

Background:

  • Microsoft Windows computers offer sufficient power for DNA microarray data analysis.
  • Smaller laboratories may prefer Windows over alternative platforms like UNIX for data analysis.
  • Gene expression data analysis requires robust computational and visualization tools.

Purpose of the Study:

  • To develop a series of Visual Basic for Applications (VBA) macros for Microsoft Excel to facilitate rapid and comprehensive DNA microarray gene expression data analysis.
  • To provide a user-friendly, Windows-based solution for analyzing microarray data, particularly for smaller laboratories.
  • To create a workflow for data processing, statistical analysis, and database integration.

Main Methods:

  • Development of four manually executed VBA macros for Microsoft Excel.

Related Experiment Videos

  • Macro 1: Assigns gene names and normalizes hybridization data.
  • Macro 2: Calculates probability values using Student's t-test for replicate analysis.
  • Macro 3: Determines expression ratios and standard deviation of log ratios.
  • Macro 4: Extracts and formats data for Microsoft Access database entry.
  • Description of a Microsoft Access database structure for querying and data export.

    • Main Results:

    • Successful development of VBA macros for automated gene expression data analysis in Excel.
    • Normalization of hybridization data by expressing signal intensity as a percentage of total gene intensity.
    • Statistical analysis of replicate measurements using Student's t-test to determine confidence.
    • Calculation of expression ratios and standard deviation of log ratios with a defined threshold.
    • Creation of a processed dataset compatible with Microsoft Access for multi-experiment queries and third-party software integration.

    Conclusions:

    • The developed Excel macros provide a rapid and comprehensive solution for DNA microarray gene expression data analysis on Windows platforms.
    • These tools are adaptable for various microarray systems, including commercial E. coli membrane arrays.
    • The integrated workflow, from normalization to database entry, enhances data accessibility and analysis capabilities for researchers.
    • The availability of Excel spreadsheets with embedded macros and instructions facilitates adoption by other laboratories.