灰色预测模型在Excel中的实现及运用

doi:10.3969/j.issn.1006-5253.2021.03.021

Abstract
Figure/Table
References (0)
Related Citation (10)

Download: PDF (1302 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS)

Abstract Objective To explore the realization of the gray model GM(1,1) in Excel. Methods Excel was used to compile the GM (1, 1), and the model was validated by the time series of nursing human resource needs. Results With the use of Excel, the GM(1,1) can be quickly and accurately compiled and used for extrapolation prediction. Conclusion The successful realization of gray model in Excel provides methodological reference for forecasting time series data.

Key words： gray model GM(1,1) nursing human resource Excel

Received: 25 January 2021

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Lin Jianchao

Cite this article:

Lin Jianchao. Realization and application of gray model in Excel [J]. journal1, 2021, 28(3): 286-288.

URL:

http://manu58.magtech.com.cn/Jwk_zgyytj/EN/10.3969/j.issn.1006-5253.2021.03.021 OR http://manu58.magtech.com.cn/Jwk_zgyytj/EN/Y2021/V28/I3/286

［1］梁红慧，林新勤，石健．GM(1，1)模型在AIDS发病预测中的应用［J］．中国卫生统计，2012，29(5)：726-727．
［2］林建潮，徐乐，应鉴林，等．灰色模型方法在艾滋病发病率预测中的应用［J］．中国医院统计，2016，23(5)：349-350．
［3］甘仰本．GM(1，1)模型在淋病预测中的应用［J］．中国卫生统计，2014，31(1)：182．
［4］王晓文，熊小庆，施勇，等．灰色序列模型GM(1，1)在江西省流感发病趋势预测中的应用［J］．江西医药，2017，52(7)：702-703．
［5］井淇，高倩倩，蔡伟芹，等．基于新陈代谢GM(1，1)模型的我国卫生总费用预测分析［J］．中国卫生统计，2020，37(3)：431-433．
［6］李红艳，万萍．上海市医院入院人数的灰色预测研究［J］．现代医院管理，2020，18(2)：1-5．
［7］李望晨，张利平，孔雨佳，等．我国妇幼死亡率GM(1，1)与线性回归预测模型研究［J］．中国卫生统计，2010，27(4)：366-368．
［8］林建潮，俞宝法，徐乐，等．灰色模型在区域护理人力资源预测中的应用［J］．中国医院统计，2017，24(3)：164-166．

[1]	Lao Yahong. Study on the application of grey model in the prediction of outpatient volume in a tertiary comprehensive hospital[J]. journal1, 2021, 28(2): 136-138.
[2]	Lin Jianchao. Realization of entropy weight method to determine evaluation index weight in Excel[J]. journal1, 2020, 27(4): 362-364.
[3]	Li Hongbin, Qian Zhijuan, Gu Jianming, Feng Haijuan, Wang Jie.. Using GM (1, 1) to predict the missing values of primary physical development of children in nine suburban areas of China in 2015[J]. journal1, 2020, 27(2): 101-105.
[4]	Du Lianxin, Hou Gang, Fan Lijuan, Liu Junmei, Zhang Yingxia, Ma Jianxin, Ma Zhaoli, Chu Yiwen, Liu Yan. Application of Excel software to the direct report of infectious diseases in a tertiary hospital[J]. journal1, 2019, 26(1): 79-80.
[5]	. [J]. journal1, 2017, 24(4): 293-295.
[6]	. [J]. journal1, 2017, 24(4): 316-317.