using excel for data analysis about dementia interventions

In the actual application, the world of business has embraced Excel as it is smooth, effective and flexible in the way it can be used. It comes equipped with diverse functionalities such as calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications.

How to carry out data analysis with ExcelĮxcel is basically a spreadsheet that Microsoft developed for the different operating systems such as Windows, macOS, Android and iOS.

It also helps to horizon scan for gaps in evidence synthesis and could help funders and researchers avoid unnecessary duplication of effort. It has proved an invaluable tool in helping to identify potentially relevant trials for Cochrane Reviews. Results: The results from this cross-sectional analysis will be presented in the poster.Ĭonclusions: ALOIS, a study based register, provides us with a simple, yet very effective way to assess the evidence landscape of a particular domain, namely dementia. We will download the results into Excel and perform the following analyses: total number of trials number of trials that were pharmacological in nature and number of trials that were non-pharmacological total number of participants across all trials and then split into non-pharmacological and pharmacological number of trials completed, ongoing or planned trial aims and trials for which there is, as yet, no Cochrane Review. Methods: We will run a search for trials added to the dementia segment in 2014. Objectives: The objective of this study is to perform a cross-sectional analysis on trials added to the Dementia Group's register in 2014 in order to calculate a number of key metrics concerning trial aims, trial status, trial size and trial interventions. ALOIS currently contains over 5000 fully annotated trials in dementia. It links trial reports related to each study together, and each trial is described in a structured way according to structured reporting guidance.

The register provides two main functions. Background: The Cochrane Dementia Group's Specialised Register housed in the Cochrane Register of Studies (CRS) and made available online in ALOIS, named after Alois Alzheimer, is a register of controlled trials in the area of dementia treatment, management and prevention.

Using excel for data analysis about dementia interventions