Use of Spreadsheets for Research Data Collection and Preparation: A Primer.

Abstract:

:Successful research results from the combination of multiple elements, including an appropriate research question, study design, research method, statistical analysis, and interpretation of results. One element of research that is easy to overlook is proper data collection and preparation for analysis. If data collection or preparation is inadequately planned or executed, the data may not be analyzable by a statistician without significant effort spent on data cleaning. Even worse, the data may contain problems that can be resolved only through time-consuming revision or repeat data collection. In this review, we present some practical guidelines and best practices for preparing data that can reduce the work of subsequent analysis.

journal_name

Acad Radiol

journal_title

Academic radiology

authors

Juluru K,Eng J

doi

10.1016/j.acra.2015.08.024

subject

Has Abstract

pub_date

2015-12-01 00:00:00

pages

1592-9

issue

12

eissn

1076-6332

issn

1878-4046

pii

S1076-6332(15)00373-6

journal_volume

22

pub_type

杂志文章,评审
  • Optimization of TI values in inversion-recovery MR sequences for the depiction of fine structures within gray and white matter: separation of globus pallidus interna and externa.

    abstract:RATIONALE AND OBJECTIVES:The authors' purpose was to search the inversion time (TI) values that enable the best differentiation of fine structures in gray matter (gray-gray differentiation). MATERIALS AND METHODS:Seven healthy adult volunteers with no history of neurologic disease or head trauma were recruited and gav...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(03)80789-4

    authors: Nakamura H,Yamada K,Kizu O,Ito H,Nishimura T

    更新日期:2003-01-01 00:00:00

  • MR Diffusion Tractography to Identify and Characterize Microstructural White Matter Tract Changes in Systemic Lupus Erythematosus Patients.

    abstract:PURPOSE:Systemic lupus erythematosus (SLE) is a predominantly female autoimmune disease that can affect the central nervous system. Neuropsychiatric symptoms are found in 25-70% of SLE patients. Using diffusion tensor imaging, various studies have reported changes in white matter integrity in SLE patients with neuropsy...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2016.03.019

    authors: Shastri R,Shah G,Wang P,Cagnoli P,Schmidt-Wilcke T,McCune J,Harris R,Sundgren P

    更新日期:2016-11-01 00:00:00

  • Cause of satisfaction of search effects in contrast studies of the abdomen.

    abstract:RATIONALE AND OBJECTIVES:Extraintestinal abnormalities visible without contrast material on abdominal radiographs are reported less frequently when contrast examinations are performed. Gaze dwell time was used to determine whether this difference is due to failure by observers to scan plain-film regions of contrast stu...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(96)80271-6

    authors: Berbaum KS,Franken EA Jr,Dorfman DD,Miller EM,Krupinski EA,Kreinbring K,Caldwell RT,Lu CH

    更新日期:1996-10-01 00:00:00

  • Computed radiography X-ray exposure trends.

    abstract:RATIONALE AND OBJECTIVES:Computed radiography provides correct optical density on film, independent of the incident radiation exposure, but it can result in under- or overexposure of the imaging plate. In the current study, we evaluated the radiation exposure trends of computed radiography over a 2-year period for port...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(96)80247-9

    authors: Seibert JA,Shelton DK,Moore EH

    更新日期:1996-04-01 00:00:00

  • Evaluation of Simulated Lesions as Surrogates to Clinical Lesions for Thoracic CT Volumetry: The Results of an International Challenge.

    abstract:RATIONALE AND OBJECTIVES:To evaluate a new approach to establish compliance of segmentation tools with the computed tomography volumetry profile of the Quantitative Imaging Biomarker Alliance (QIBA); and determine the statistical exchangeability between real and simulated lesions through an international challenge. MA...

    journal_title:Academic radiology

    pub_type: 杂志文章,多中心研究

    doi:10.1016/j.acra.2018.07.022

    authors: Robins M,Kalpathy-Cramer J,Obuchowski NA,Buckler A,Athelogou M,Jarecha R,Petrick N,Pezeshk A,Sahiner B,Samei E

    更新日期:2019-07-01 00:00:00

  • Liver Imaging Reporting and Data System:: Substantial Discordance Between CT and MR for Imaging Classification of Hepatic Nodules.

    abstract:RATIONALE AND OBJECTIVES:The Liver Imaging Reporting and Data System (LI-RADS) is a newly developed nomogram for standardizing the performance and interpretation of liver imaging. However, it is unclear which imaging technique is optimal to exactly define LI-RADS scale. This study aims to determine the concordance of c...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2015.11.002

    authors: Zhang YD,Zhu FP,Xu X,Wang Q,Wu CJ,Liu XS,Shi HB

    更新日期:2016-03-01 00:00:00

  • Magnetic resonance imaging of mesenchymal stem cells labeled with dual (MR and fluorescence) agents in rat spinal cord injury.

    abstract:RATIONALE AND OBJECTIVES:In vivo tracking cells using gadolinium-based contrast agents have the important advantage of providing a positive contrast on T1-weighted images, which is less likely to be confused with artifacts because of postoperative local signal voids such as metal, hemorrhage, or air. The aim of this st...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2009.03.016

    authors: Shen J,Zhong XM,Duan XH,Cheng LN,Hong GB,Bi XB,Liu Y

    更新日期:2009-09-01 00:00:00

  • Dissecting Costs of CT Study: Application of TDABC (Time-driven Activity-based Costing) in a Tertiary Academic Center.

    abstract:RATIONALE AND OBJECTIVES:The lack of understanding of the real costs (not charge) of delivering healthcare services poses tremendous challenges in the containment of healthcare costs. In this study, we applied an established cost accounting method, the time-driven activity-based costing (TDABC), to assess the costs of ...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2016.11.001

    authors: Anzai Y,Heilbrun ME,Haas D,Boi L,Moshre K,Minoshima S,Kaplan R,Lee VS

    更新日期:2017-02-01 00:00:00

  • 3D Printing of Preoperative Simulation Models of a Splenic Artery Aneurysm: Precision and Accuracy.

    abstract:RATIONALE AND OBJECTIVES:Three-dimensional (3D) printing is attracting increasing attention in the medical field. This study aimed to apply 3D printing to the production of hollow splenic artery aneurysm models for use in the simulation of endovascular treatment, and to evaluate the precision and accuracy of the simula...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2016.12.015

    authors: Takao H,Amemiya S,Shibata E,Ohtomo K

    更新日期:2017-05-01 00:00:00

  • Reproducibility and repeatability of volumetric measurements for olfactory bulb volumetry: which method is appropriate? An update using 3 Tesla MRI.

    abstract:RATIONALE AND OBJECTIVES:The aim of this study was to compare different sequences for olfactory bulb volumetry using 3-T magnetic resonance imaging, evaluating reproducibility, repeatability, and systematic biases. MATERIALS AND METHODS:Twenty-two volunteers underwent 3-T magnetic resonance imaging of the frontal skul...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2011.02.018

    authors: Burmeister HP,Baltzer PA,Möslein C,Bitter T,Gudziol H,Dietzel M,Guntinas-Lichius O,Kaiser WA

    更新日期:2011-07-01 00:00:00

  • Reliability of MR Quantification of Rotator Cuff Muscle Fatty Degeneration Using a 2-point Dixon Technique in Comparison with the Goutallier Classification: Validation Study by Multiple Readers.

    abstract:RATIONALE AND OBJECTIVES:Presurgical assessment of fatty degeneration is important in the management of patients with rotator cuff tears. The Goutallier classification is widely accepted as a qualitative scoring system, although it is highly observer-dependent and has poor reproducibility. The objective of this study w...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2017.03.026

    authors: Horiuchi S,Nozaki T,Tasaki A,Yamakawa A,Kaneko Y,Hara T,Yoshioka H

    更新日期:2017-11-01 00:00:00

  • Preoperative MRI improves prediction of extensive occult axillary lymph node metastases in breast cancer patients with a positive sentinel lymph node biopsy.

    abstract:RATIONALE AND OBJECTIVES:To test the ability of quantitative measures from preoperative dynamic contrast-enhanced magnetic resonance imaging (DCE-MRI) to predict, independently and/or with the Katz pathologic nomogram, which breast cancer patients with a positive sentinel lymph node biopsy will have four or more positi...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2013.10.001

    authors: Loiselle C,Eby PR,Kim JN,Calhoun KE,Allison KH,Gadi VK,Peacock S,Storer BE,Mankoff DA,Partridge SC,Lehman CD

    更新日期:2014-01-01 00:00:00

  • Less Is More: Efficacy of Rapid 3D-T2 SPACE in ED Patients with Acute Atypical Low Back Pain.

    abstract:RATIONALE AND OBJECTIVES:Emergency department (ED) patients with acute low back pain (LBP) may present with ambiguous clinical findings that pose diagnostic challenges to exclude cauda equina syndrome (CES). As a proof of concept, we aimed to determine the efficacy of a rapid lumbar spine (LS) magnetic resonance imagin...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2017.02.011

    authors: Koontz NA,Wiggins RH 3rd,Mills MK,McLaughlin MS,Pigman EC,Anzai Y,Shah LM

    更新日期:2017-08-01 00:00:00

  • Loss of anteroposterior intralobar attenuation gradient of the lung: Correlation with pulmonary function.

    abstract:RATIONALE AND OBJECTIVES:Since the initial description of an intralobar attenuation gradient by Webb et al, it has been suggested that departure from the intralobar attenuation gradient could indicate early lung diseases. However, its significance has not been determined in detail. We aimed to quantify the anteroposter...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2005.10.025

    authors: Nishino M,Roberts DH,Sitek A,Raptopoulos V,Boiselle PM,Hatabu H

    更新日期:2006-05-01 00:00:00

  • Computer-aided detection of clustered microcalcifications in digitized mammograms.

    abstract:RATIONALE AND OBJECTIVES:We investigated a computer-aided detection (CAD) scheme for clustered microcalcifications in digitized mammograms. METHODS:A multistage CAD scheme was developed and tested. To increase sensitivity, the scheme uses a Gaussian band-pass filter and nonlinear threshold. A multistage local minimum ...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(05)80431-3

    authors: Zheng B,Chang YH,Staiger M,Good W,Gur D

    更新日期:1995-08-01 00:00:00

  • Using the Analytic Hierarchy Process for Prioritizing Imaging Tests in Diagnosis of Suspected Appendicitis.

    abstract:RATIONALE AND OBJECTIVES:In clinical guideline or criteria development processes, such as those used in developing American College of Radiology Appropriateness Criteria (ACR AC), experts subjectively evaluate benefits and risks associated with imaging tests and make complex decisions about imaging recommendations. The...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2017.01.001

    authors: Agapova M,Bresnahan BW,Linnau KF,Garrison LP Jr,Higashi M,Kessler L,Devine B

    更新日期:2017-05-01 00:00:00

  • Dual-source CT angiography in aortic stent grafting: An in vitro aorta phantom study of image noise and radiation dose.

    abstract:RATIONALE AND OBJECTIVES:The aim of the study was to investigate the optimal protocols of dual-source computed tomography (CT) angiography in aortic stent grafting in terms of image noise and radiation dose, based on an in vitro phantom study. MATERIALS AND METHODS:A series of helical CT cans were performed on a human...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2010.03.004

    authors: Sun Z,Ng C

    更新日期:2010-07-01 00:00:00

  • Optimizing the Peritumoral Region Size in Radiomics Analysis for Sentinel Lymph Node Status Prediction in Breast Cancer.

    abstract:RATIONALE AND OBJECTIVES:Peritumoral features have been suggested to be useful in improving the prediction performance of radiomic models. The aim of this study is to systematically investigate the prediction performance improvement for sentinel lymph node (SLN) status in breast cancer from peritumoral features in radi...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2020.10.015

    authors: Ding J,Chen S,Serrano Sosa M,Cattell R,Lei L,Sun J,Prasanna P,Liu C,Huang C

    更新日期:2020-11-04 00:00:00

  • Influence of Cardiovascular Risk Factors on the Prevalence of Coronary Atherosclerosis in Patients with Angiographically Normal Coronary Arteries.

    abstract:RATIONALE AND OBJECTIVES:Cardiovascular (CV) disease is predominately influenced by CV risk factors and coronary computed tomography angiography (CTA) is capable of detecting early-stage coronary artery disease. We sought to determine the influence of CV risk factors on the prevalence of nonobstructive atherosclerosis ...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2016.12.005

    authors: Bittner DO,Klinghammer L,Marwan M,Schmid J,Layritz C,Hoffmann U,Achenbach S,Pflederer T

    更新日期:2017-05-01 00:00:00

  • Proteoglycan depletion-induced changes in transverse relaxation maps of cartilage: comparison of T2 and T1rho.

    abstract:RATIONALE AND OBJECTIVES:The authors performed this study to (a) measure changes in T2 relaxation rates, signal-to-noise ratio (SNR), and contrast with sequential depletion of proteoglycan in cartilage; (b) determine whether there is a relationship between the T2 relaxation rate and proteoglycan in cartilage; and (c) c...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(03)80666-9

    authors: Regatte RR,Akella SV,Borthakur A,Kneeland JB,Reddy R

    更新日期:2002-12-01 00:00:00

  • Beyond Correlations, Sensitivities, and Specificities: A Roadmap for Demonstrating Utility of Advanced Imaging in Oncology Treatment and Clinical Trial Design.

    abstract::Despite the widespread belief that advanced imaging should be very helpful in guiding oncology treatment decision and improving efficiency and success rates in treatment clinical trials, its acceptance has been slow. Part of this is likely attributable to gaps in study design and statistical methodology for these imag...

    journal_title:Academic radiology

    pub_type: 杂志文章,评审

    doi:10.1016/j.acra.2017.03.002

    authors: Huang EP,Lin FI,Shankar LK

    更新日期:2017-08-01 00:00:00

  • A review of technical advances in interventional magnetic resonance imaging.

    abstract::Initial research in the development of interventional magnetic resonance (MR) imaging in the late 1980s and early to mid-1990s focused on pulse sequences, devices, and clinical applications. This focus was largely a result of the limited number of areas in which the academic research community leading the development ...

    journal_title:Academic radiology

    pub_type: 杂志文章,评审

    doi:10.1016/j.acra.2005.06.003

    authors: Elgort DR,Duerk JL

    更新日期:2005-09-01 00:00:00

  • A permutation test for comparing ROC curves in multireader studies a multi-reader ROC, permutation test.

    abstract:RATIONALE AND OBJECTIVES:The aim of the study is to develop a permutation test to compare receiver operating characteristic (ROC) curves of two diagnostic modalities in a multireader paired design. MATERIALS AND METHODS:A statistical test for comparing two diagnostic modalities is developed based on all possible excha...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2005.12.012

    authors: Bandos AI,Rockette HE,Gur D

    更新日期:2006-04-01 00:00:00

  • Clinical Decision Support at the Point-of-Order Entry: An Education Simulation Pilot with Medical Students.

    abstract:RATIONALE AND OBJECTIVES:We have been called to reform radiology undergraduate medical education (UME) curricula. Clinically available clinical decision support provides an opportunity to improve education regarding appropriate imaging utilization, patient safety, and cost-effective care. MATERIAL AND METHODS:We creat...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2016.01.020

    authors: Willis MH,Frigini LA,Lin J,Wynne DM,Sepulveda KA

    更新日期:2016-10-01 00:00:00

  • Experimentally induced pulmonary arterial occlusion with detachable balloon in pigs: thin-section CT findings.

    abstract:RATIONALE AND OBJECTIVES:The authors evaluated changes of lung attenuation in pigs, with special attention to the mosaic pattern of low attenuation, at thin-section computed tomography (CT) after obstruction of the proximal pulmonary artery with a detachable balloon. MATERIALS AND METHODS:In seven pigs, nine sites of ...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(98)80241-9

    authors: Kim TK,Im JG,Kim SH,Won HJ,Seo JB,Yeon KM,Han MC

    更新日期:1998-12-01 00:00:00

  • Videomanometry of the pharynx in dysphagic patients with a posterior cricopharyngeal indentation.

    abstract:RATIONALE AND OBJECTIVES:Patients with a posterior indentation in the pharyngoesophageal segment (PES) are generally considered to have an abnormality of the cricopharyngeal muscle (CPM). In this study we determined the actual width of the PES and the pressure circumstances during swallowing within the pharynx and PES ...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(05)80123-0

    authors: Olsson R,Ekberg O

    更新日期:1995-07-01 00:00:00

  • Do telephone call interruptions have an impact on radiology resident diagnostic accuracy?

    abstract:RATIONALE AND OBJECTIVES:The purpose of this study was to measure the effect of distractions, in the form of telephone call interruptions, on radiology resident diagnostic accuracy. MATERIALS AND METHODS:Radiology resident discrepancy reports and reading room telephone logs at an academic tertiary care pediatric hospi...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/j.acra.2014.08.001

    authors: Balint BJ,Steenburg SD,Lin H,Shen C,Steele JL,Gunderman RB

    更新日期:2014-12-01 00:00:00

  • Bootstrap estimation of diagnostic accuracy with patient-clustered data.

    abstract:RATIONALE AND OBJECTIVES:The purpose of this study was to describe a simple bootstrap approach for estimating sensitivity, specificity, and the area under the receiver operating characteristic curve for multisite test outcome data. MATERIALS AND METHODS:The performance of bootstrap estimates was evaluated and compared...

    journal_title:Academic radiology

    pub_type: 杂志文章

    doi:10.1016/s1076-6332(00)80381-5

    authors: Rutter CM

    更新日期:2000-06-01 00:00:00

  • Accuracy of Computed Tomographic Enterography for Obscure Gastrointestinal Bleeding: A Diagnostic Meta-analysis.

    abstract:RATIONALE AND OBJECTIVES:Obscure gastrointestinal bleeding (OGIB) is the bleeding from the gastrointestinal tract without definite source that persists and recurs after a negative endoscopic evaluation. The study aimed to systematically evaluate the diagnostic accuracy of computed tomography enterography on OGIB detect...

    journal_title:Academic radiology

    pub_type: 杂志文章,meta分析,评审

    doi:10.1016/j.acra.2017.09.001

    authors: He B,Yang J,Xiao J,Gu J,Chen F,Wang L,Qian J,Gong S

    更新日期:2018-02-01 00:00:00

  • Diagnostic accuracy of 18F-FDG-PET and PET/CT in the differential diagnosis between malignant and benign pleural lesions: a systematic review and meta-analysis.

    abstract:RATIONALE AND OBJECTIVES:To systematically review and meta-analyze published data about the diagnostic accuracy of fluorine-18-fluorodeoxyglucose ((18)F-FDG) positron emission tomography (PET) and PET/computed tomography (CT) in the differential diagnosis between malignant and benign pleural lesions. METHODS AND MATER...

    journal_title:Academic radiology

    pub_type: 杂志文章,meta分析,评审

    doi:10.1016/j.acra.2013.09.015

    authors: Treglia G,Sadeghi R,Annunziata S,Lococo F,Cafarotti S,Bertagna F,Prior JO,Ceriani L,Giovanella L

    更新日期:2014-01-01 00:00:00