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 Concept Videos

Performing a Simple Data Analysis using MS-Excel Function01:17

Performing a Simple Data Analysis using MS-Excel Function

Microsoft Excel offers a suite of functions and tools ideal for statistical analysis, making it accessible to students and researchers. This article outlines fundamental Excel functions pivotal for data analysis.
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

Microsoft Excel is a cornerstone tool for data analysis and statistical operations, offering a wide array of functionalities to manage, analyze, and visualize data efficiently. Recognized for its versatility, Excel facilitates the performance of basic to complex statistical operations, serving as an indispensable asset for analysts, researchers, and students alike. Excel's significance in data analysis emanates from its spreadsheet environment, where data can be organized in rows and columns,...
Microsoft Excel: Student's t-Test01:25

Microsoft Excel: Student's t-Test

Student's t-test in Microsoft Excel is a statistical method used to compare the means of two groups to determine if they are significantly different from each other. It's commonly used to evaluate hypotheses, such as testing whether a treatment has an effect compared to a control group. Excel provides built-in functions to perform t-tests, making it accessible for users needing to conduct basic statistical analysis.
To conduct a t-test in Excel, use the T.TEST function or the "Data Analysis...
Single Nucleotide Polymorphisms-SNPs01:05

Single Nucleotide Polymorphisms-SNPs

A single nucleotide polymorphism or SNP is a single nucleotide variation at a specific genomic position in a large population. It is the most prevalent type of sequence variation found in the human genome. Point mutations that occur in more than 1% of the population qualify as SNPs. These are present once every 1000 nucleotides on an average in the human genome. Replacement of a purine with another purine (A/G) or a pyrimidine with another pyrimidine (C/T) is known as a transition. In contrast,...
Comparing Copy Number Variations and SNPs02:26

Comparing Copy Number Variations and SNPs

Sequencing of the human genome has opened up several best-kept secrets of the genome. Scientists have identified thousands of genome variations that exist within a population. These variations can be a single nucleotide or a larger chromosomal variation.
Copy number variations or CNVs are the structural variations that cover more than 1kb of DNA sequence. The single nucleotide polymorphism (SNP), on the other hand, is a single nucleotide change or a point mutation that is found in more than 1%...
Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

Regression analysis in Microsoft Excel is a powerful statistical method for examining the relationship between a dependent variable and one or more independent variables. It's used extensively in fields such as economics, biology, and business to predict outcomes, understand relationships, and make data-driven decisions. The most common type is linear regression, which attempts to fit a straight line through the data points to model the relationship between variables.
To perform regression...

You might also read

Related Articles

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

Sort by
Same author

Response to Letter to the Editor: Impact of 1024-Matrix Size on Perforating Artery Visualization in Cerebral CTA Using a 64-Slice CT Scanner.

Journal of medical radiation sciences·2026
Same author

Fatal Injuries Caused by Falling Trees: Correlation Between Postmortem Computed Tomography and Forensic Autopsy Findings in Eight Cases.

International journal of legal medicine·2026
Same author

Verification of the family tree of the Makino family of the Nagaoka domain by DNA analysis.

Anthropological science : journal of the Anthropological Society of Nippon = Jinruigaku zasshi·2026
Same author

A case of CD36 deficiency with multiple white matter lesions.

BMC neurology·2026
Same author

Heat hematoma-like epidural collection mimicking traumatic hematoma in a reheated bathtub death.

Journal of forensic sciences·2026
Same author

Author's reply: Bickerstaff Brainstem Encephalitis with Decorticate-like Posture, Involuntary Movements, Impaired Visual Acuity, and Prolonged Motor Disability.

Internal medicine (Tokyo, Japan)·2026

Related Experiment Video

Updated: Jun 25, 2026

Identification and Classification of Position-specific GABAA Receptor Subunit Missense Variants for Their Role In Hippocampal Pyramidal Neurons
08:04

Identification and Classification of Position-specific GABAA Receptor Subunit Missense Variants for Their Role In Hippocampal Pyramidal Neurons

Published on: June 6, 2025

Development of a spreadsheet for SNPs typing using Microsoft EXCEL.

Masaki Hashiyada1, Yukio Itakura, Shirushi Takahashi

  • 1Division of Forensic Medicine, Department of Public Health and Forensic Medicine, Tohoku University Graduate School of Medicine, 2-1 Seiryo-machi, Sendai, Japan. hashiyad@forensic.med.tohoku.ac.jp

Legal Medicine (Tokyo, Japan)
|March 6, 2009
PubMed
Summary

This study introduces a novel spreadsheet method for analyzing single-nucleotide polymorphisms (SNPs) using template files. This approach efficiently processes 96 SNP loci simultaneously, advancing forensic and biometric applications.

More Related Videos

Demonstration of the Sequence Alignment to Predict Across Species Susceptibility Tool for Rapid Assessment of Protein Conservation
16:02

Demonstration of the Sequence Alignment to Predict Across Species Susceptibility Tool for Rapid Assessment of Protein Conservation

Published on: February 10, 2023

Related Experiment Videos

Last Updated: Jun 25, 2026

Identification and Classification of Position-specific GABAA Receptor Subunit Missense Variants for Their Role In Hippocampal Pyramidal Neurons
08:04

Identification and Classification of Position-specific GABAA Receptor Subunit Missense Variants for Their Role In Hippocampal Pyramidal Neurons

Published on: June 6, 2025

Demonstration of the Sequence Alignment to Predict Across Species Susceptibility Tool for Rapid Assessment of Protein Conservation
16:02

Demonstration of the Sequence Alignment to Predict Across Species Susceptibility Tool for Rapid Assessment of Protein Conservation

Published on: February 10, 2023

Area of Science:

  • Forensic Science
  • Genetics
  • Biotechnology

Background:

  • Single-nucleotide polymorphisms (SNPs) are valuable genetic markers for forensic applications.
  • Current SNP typing methods, like TaqMan assays, require specific controls and have limitations in throughput.
  • High-throughput SNP analysis is crucial for applications such as biometric authentication.

Purpose of the Study:

  • To develop an efficient and cost-effective method for high-throughput SNP analysis.
  • To create a spreadsheet-based tool for analyzing a large number of SNP loci simultaneously.
  • To adapt SNP typing for forensic and biometric applications using novel control strategies.

Main Methods:

  • Utilized TaqMan SNP Genotyping Assays on an ABI PRISM 7500 FAST Real-Time PCR System.
  • Designed a Microsoft EXCEL spreadsheet package incorporating 'template files' for SNP analysis.
  • Employed population data from 120 SNPs and results from 94 unknown samples and negative controls.

Main Results:

  • The developed spreadsheet package enables the analysis of up to 96 SNPs concurrently on a 96-well plate.
  • The 'template file' approach replaces the need for traditional positive and negative controls for each SNP locus.
  • The method facilitates simultaneous analysis of 96 SNPs, significantly increasing throughput compared to standard TaqMan assays.

Conclusions:

  • The novel spreadsheet package offers a streamlined and efficient approach to high-throughput SNP genotyping.
  • This method enhances the feasibility of using SNP analysis for large-scale forensic investigations and biometric identification.
  • The template file system provides a practical alternative for SNP analysis, improving efficiency and potentially reducing costs.