Welcome to visit Zhongnan Medical Journal Press Series journal website!

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

Published on Oct. 16, 2020Total Views: 4013 timesTotal Downloads: 2235 timesDownloadMobile

Author: Zhi-Yuan HUANG 1# Wen-Hao JIANG 1# Fu-Gui YANG 1 Lei ZHU 1 Lin DONG 1 Ling-Wei WANG 1 Ming-Hao FENG 1 Liang WEI 2 Guang-Xue WANG 2* Qin-Chuan LI 1, 2*

Affiliation: 1. Department of Cardiothoracic Surgery, East Hospital Affiliated to Tongji University, Shanghai 200120, China 2. Center for Translational Medicine, East Hospital affiliated to Tongji University, Shanghai 200120, China

Keywords: Excel software Visual Basic program tools MicroRNA miR-501 Survival analysis The product limit method Log-rank test

DOI: 10.12173/j.issn.1004-5511.2020.05.02

Reference: Huang ZY, Jiang WH, Yang FG, Zhu L, Dong L, Wang LW, Feng MH, Wei L, Wang GX, Li QC. 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 [J]. Yixue Xinzhi Zazhi, 2020, 30(5): 336-344. DOI: 10.12173/j.issn.1004-5511.2020.05.02.[Article in Chinese]

  • Abstract
  • Full-text
  • References
Abstract

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.

Full-text
Please download the PDF version to read the full text: download
References

1.Yang Y, Liu L, Zhang Y, et al. MiR-503 targets PI3K p85 and IKK-β and suppresses progression of non-small cell lung cancer[J]. International Journal of Cancer Journal International Du Cancer, 135(7): 1531-1542. DOI: 10.1002/ijc.28799.

2.Bartel DP. MicroRNAs: genomics, biogenesis, mechanism, and function[J]. Cell, 2004, 116(2): 281. DOI: 10.1016/s0092-8674(04)00045-5.

3.Krol J, Loedige I, Filipowicz W. The widespread regulation of microRNA biogenesis, function and decay[J]. Nature Reviews Genetics, 2010, 11(9): 597-610. DOI: 10.1038/nrg2843. 

4.Luo C, Yin D, Zhan H, et al. microRNA-501-3p suppresses metastasis and progression of hepatocellular carcinoma through targeting LIN7A[J]. Cell Death Dis, 2018, 9(5): 535. DOI: 10.1038/s41419-018-0577-y.

5.Zhang Z, Shao L, Wang Y, et al. MicroRNA-501-3p restricts prostate cancer growth through regulating cell cycle-related and expression-elevated protein in tumor/cyclin D1 signaling[J]. Biochemical and Biophysical Research Communications, 2019, 509(3): 746-752. DOI: 10.1016/j.bbrc.2018.12.176. 

6.Wang X, Liu S, Zhou Z, et al. A herpes simplex virus type 2-encoded microRNA promotes tumor cell metastasis by targeting suppressor of cytokine signaling 2 in lung cancer[J]. 2017, 39(5): 1010428317701633. DOI: 10.1177/1010428317701633. 

7.Grooteman MP, van den Dorpel MA, Bots ML, et al. Effect of Online Hemodiafiltration on All-Cause Mortality and Cardiovascular Outcomes[J]. J Am Soc Nephrol, 2012, 23(6): 1087-1096. DOI: 10.1681/ASN.2011121140.

8.Weng Q, Chen M, Li M, et al. Global microarray profiling identified hsa_circ_0064428 as a potential immune-associated prognosis biomarker for hepatocellular carcinoma[J]. J Med Genet, 2019, 56(1): 32-38. DOI: 10.1136/jmedgenet-2018-105440. 

9.Wang M, Chen F, Lu T, et al. Bayesian t-tests for correlations and partial correlations[J]. Journal of Applied Statistics, 2020, 47(10): 1820-1832. DOI: 10.1080/02664763.2019.1695760.

10.Hites RA. Break point analyses of human or environmental temporal trends of POPs[J]. Sci Total Environ, 2019, 664: 518-521. DOI: 10.1016/j.scitotenv.2019.01.353. 

11.Fodor DM, Fodor MM, Stanescu IC, et al. The influence of circadian variation in ischemic stroke onset on the evolution of the severity of the clinical picture and disability[J]. Balneo Res J, 2019, 10(1): 24-27. DOI: 10.12680/balneo.2019.234.

12.Vieira AL, Nespeca MG, Pavini WD, et al. A user-friendly excel spreadsheet for dealing with spectroscopic and chromatographic data[J]. Chemometrics Intell Lab Syst, 2019, 194(6). DOI: 10.12680/balneo.2019.234.

13.Vieira A L, Nespeca M G, Pavini W D, et al. A user-friendly excel spreadsheet for dealing with spectroscopic and chromatographic data[J]. Chemometrics and Intelligent Laboratory Systems, 2019, 194: 103816. DOI: 10.1016/j.chemolab.2019.103816.

14.Hodi FS, O'Day SJ, McDermott DF, et al. Improved Survival with Ipilimumab in Patients with Metastatic Melanoma[J]. N Engl J Med, 2010, 363(8): 711-723. DOI: 10.1056/NEJMoa1003466.

15.Shi M, Mu Y, Zhang H, et al. MicroRNA-200 and microRNA-30 family as prognostic molecular signatures in ovarian cancer: A meta-analysis[J]. Medicine, 2018, 97(32): e11505. DOI: 10.1097/MD.0000000000011505.

16.Wang H, Tan Z, Hu H, et al. microRNA-21 promotes breast cancer proliferation and metastasis by targeting LZTFL1[J]. BMC cancer, 2019, 19(1): 738. DOI: 10.1186/s12885-019-5951-3.

17.Zhou RS, Zhang EX, Sun QF, et al. Integrated analysis of lncRNA-miRNA-mRNA ceRNA network in squamous cell carcinoma of tongue[J]. BMC cancer, 2019, 19(1): 779.  DOI: 10.1186/s12885-019-5983-8. 

18. 郑亮, 吴宏, 钱定广, 等. 上海市高行老年社区人群动脉硬化性心血管疾病患病率的现况调查与危险因素分析[J]. 中国循证心血管医学杂志, 2016, 8(6): 680-682, 690. DOI: 10.3969/j.issn.1674-4055.2016.06.10. [Zheng L, Wu H, Qian DJ, et al. The risk factors analysis and prevalence survey of elderly population with atherosclerotic cardiovascular disease in Gaohang community of Shanghai[J]. Chinese Journal of Evidence-Bases Cardiovascular Medicine, 2016, 8(6) : 680-682, 690.]