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.
林建潮. 灰色预测模型在Excel中的实现及运用[J]. 中国医院统计, 2021, 28(3): 286-288.
Lin Jianchao. Realization and application of gray model in Excel . journal1, 2021, 28(3): 286-288.