Distributive and clinical activity measurement using spreadsheet software

M Rubino1

  • 1John Dempsy Hospital, Farmington, CT 06032.

Hospital Pharmacy
|August 1, 1990
PubMed

Related Concept Videos

Statistical Software for Data Analysis and Clinical Trials01:12

Statistical Software for Data Analysis and Clinical Trials

Statistical software is pivotal in data analysis and clinical trials by providing tools to analyze data, draw conclusions, and make predictions. These software packages range from simple data management applications to complex analytical platforms, supporting various statistical tests, models, and simulation techniques. Their significance lies in their ability to handle vast amounts of data with precision and efficiency, enabling researchers to validate hypotheses, identify trends, and make...
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,...
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...
Statistical Analysis System (SAS)01:14

Statistical Analysis System (SAS)

SAS, short for Statistical Analysis System, is a powerful data analysis, management, and visualization tool. Developed by the SAS Institute in the early 1970s, SAS has evolved into a comprehensive software suite used across various industries for statistical analysis, business intelligence, and predictive modeling.
Applications: SAS finds applications in numerous fields, including healthcare for clinical trial analysis, finance for risk assessment, marketing for customer data analysis, and...
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis01:24

Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis

Central tendency refers to the central point or typical value of a dataset. It summarizes the data set with a single value that represents the center of its distribution. The three main measures of central tendency are:
Mean: The arithmetic average of all data points. It is calculated by adding all the values together and dividing by the number of values. The mean is sensitive to extreme values (outliers).
Median: The middle value when the data points are arranged in ascending or descending...
Microsoft Excel: Plotting Mean, SD, and SE01:18

Microsoft Excel: Plotting Mean, SD, and SE

In Microsoft Excel, plotting the mean along with standard deviation (SD) and standard error (SE) helps visualize data variability and reliability. To plot these values, follow these steps:
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...