Excel软件结合Visual Basic编程工具探索MicroRNA-501对肺鳞癌患者生存情况的影响  

Application of Excel and Visual Basic program language in exploring the impact of MicroRNA-501 on the survival of patients with lung squamous cell carcinoma

作　　者：黄致远 江文豪 杨福贵 朱磊 董林 汪令伟 冯明昊 魏亮[2] 王光学[2] 李钦传[1,2] Zhi-Yuan HUANG;Wen-Hao JIANG;Fu-Gui YANG;Lei ZHU;Lin DONG;Ling-Wei WANG;Ming-Hao FENG;Liang WEI;Guang-Xue WANG;Qin-Chuan LI(Department of Cardiothoracic Surgery,East Hospital Affiliated to Tongji University,Shanghai 200120,China;Center for Translational Medicine,East Hospital affiliated to Tongji University,Shanghai 200120,China)

机构地区：[1]同济大学附属东方医院心胸外科,上海200120 [2]同济大学附属东方医院转化医学研究中心,上海200120

出　　处：《医学新知》2020年第5期336-344,共9页New Medicine

基　　金：上海市浦东新区卫生系统重点学科群建设资助(PWZxq2017-13);国家自然科学基金资助项目(81773266);上海市卫生健康委员会资助项目(20194Y0333)。

摘　　要：目的使用Excel软件结合Visual Basic编程工具依据Kaplan-Meier生存分析理论探索肺鳞癌肿瘤组织中MicroRNA-501(miR-501)表达水平对肺鳞癌患者生存时间的影响。方法从Kmplot数据库获取miR-501在不同肺癌患者癌症组织中表达的高低情况数据和对应的生存时间数据,导入Excel表格中。使用Excel软件自带的Visual Basic编程工具设计用户图形界面并编写多个函数进行肺鳞癌患者生存分析。结果肺癌组织中miR-501表达高的肺鳞癌患者生存时间比肺癌组织中miR-501表达低的患者生存时间长。miR-501高表达和低表达的两组患者之间生存曲线的对数秩检验显示,两组生存时间差异具有统计学意义(P<0.05)。结论使用Excel结合Visual Basic语言编程可以较好地分析miR-501表达高低对肺鳞癌患者生存时间的影响,其结果可信可靠。Objective applying Excel software accompany with Visual Basic program tools to explore how does the expression level of miR-501 in tumor tissue affect the survival time of lung squamous cell carcinoma patients.Methods Obtain the data of the survival time of lung Squamous cell carcinoma patients and the expression level of miR-501 in their tumor tissue from Kmplot databases.Import them into Excel software.Draw Graph User Interface and Write program to perform survival analysis of these lung Squamous cell carcinoma patients.Result Lung Squamous cell carcinoma patients who have a higher expression level of miR-501 live longer than ones who have a lower expression level of miR-501.The log-rank test between higher miR-501 group and lower miR-501 group shows difference of survial time between two group was statistically significant(P<0.05).Conclusion Excel with Visual Basic program tools contributes great in survival analysis and log-rank test of survival analysis data of cancer patients.The result is credible.

关 键 词：EXCEL软件 Visual Basic编程工具 MICRORNA miR-501 生存分析法 乘积极限法 对数秩检验 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] R734.2[自动化与计算机技术—计算机科学与技术]