在没有VBA的情况下在Excel中进行患者级健康经济建模:一个教程
Rob Blissett1, Will Sullivan2, Inola Subban2
1Maple Health Group, LLC, New York, NY, USA. rob.blissett@maplehealthgroup.com.
PharmacoEconomics
|October 8, 2025
概括
本教程介绍了微软Excel中的灵活的患者级成本效益模型. 它展示了如何在没有Visual Basic for Applications (VBA) 的情况下实现个人级别的离散事件模拟 (DES),用于医疗技术评估 (HTA).
科学领域:
- 卫生经济学和结果研究研究.
- 计算建模计算建模
- 卫生技术评估 卫生技术评估
背景情况:
- 微软Excel中的队列级模型是医疗技术评估 (HTA) 中成本效益分析 (CEA) 的标准.
- 这些模型在捕捉患者异质性方面存在局限性,可能引入偏见.
- 熟悉性和较低的计算负担有助于继续使用队列模型.
研究的目的:
- 为在 Microsoft Excel 中实施个人级别离散事件模拟 (DES) 提供指导.
- 通过使用当代Excel函数演示一种灵活的患者级建模方法.
- 在没有Visual Basic for Applications (VBA) 的情况下实现高级建模.
主要方法:
- 使用当代的微软Excel函数进行计算.
- 实现以前发布的个人级别离散事件模拟 (DES) 模型.
- 避免使用Visual Basic for Applications (VBA) 代码的使用.
主要成果:
- 在原生Excel中展示可行的患者级别离散事件模拟 (DES).
- 在没有VBA的情况下成功实施灵活的成本效益模型.
- 验证当代Excel函数用于先进的健康经济建模.
结论:
- 当代的Excel函数使HTA的灵活,患者级成本效益建模成为可能.
- 这种方法克服了传统队列模型的局限性,而不需要VBA.
- 基于电子表格的个人级别离散事件模拟 (DES) 是HTA的一个可行的替代方案.
相关概念视频
Overview of Microsoft Excel as a Data Analysis Tool
1.4K
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...
1.4K
Performing a Simple Data Analysis using MS-Excel Function
919
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...
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...
919
Microsoft Excel: Regression Analysis
1.5K
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...
To perform regression...
1.5K
Microsoft Excel: Student's t-Test
1.5K
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...
To conduct a t-test in Excel, use the T.TEST function or the "Data...
1.5K
Mathematical Modeling: Problem Solving
253
Mathematical modeling transforms real-world scenarios into mathematical expressions, allowing for structured problem-solving and analysis. This process involves defining the situation, assigning variables to measurable quantities, selecting an appropriate model, and solving the resulting equation. Such models are invaluable in finance, providing precise methods to evaluate investments, loans, and repayment structures.A widely used example is the calculation of fixed monthly payments on a loan,...
253
Microsoft Excel: Median, Quartile range, and Box Plots
3.1K
In Microsoft Excel, calculating the median, interquartile range, and creating box plots can help understand the distribution of your data.
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
3.1K


