第一:计算函数55982,873,816深圳北京上海广州6.745194E-06平均比值6.75E-066.75E-02100001)营收数据R(来源:年报)单位:万元第1年深圳爱尔(13)北京爱尔(03)上海爱尔(05)广州爱尔(08)2)GDP(来源:宏观经济数据)单位:万元第1年深圳GDP北京GDP上海GDP广州GDP3)R/GDP注:3=1/2第1年平均比值*100004)函数关系100E012.00E-013.00E-014.00E-015.00E-016.00E-017.00E-01f(x)=0.163016323241239ln(x)+0.082R²=0.694739567089299医院成立年份1R/GDP0.082920197.524222.026038.7第二:函数带入X,计算R/GDP5)函数6)预测GDP增速,并计算收入R预测期城市深圳GDP增速02460.00E+001.00E-012.00E-013.00E-014.00E-01f(x)=0.163016323241239ln(x)+0.082R²=0.694739567089299110417.625100.56.430320.032260.5317572.76.432679.934771.4418231.1510739.76.522859.024344.8611878.874768.7合计78709.2医院名称是否体内北京爱尔是上海爱尔是上海爱尔睛亮是广州爱尔是广州黄埔爱尔是深圳爱尔是体内医院收入总计深圳深东爱尔否深圳爱尔(2013)深圳深东爱尔(2018)北京GDP增速北京爱尔(2003)上海GDP增速上海爱尔(2005)上海爱尔睛亮(2016)广州GDP增速广州爱尔(2008)广州黄埔爱尔(2018)体外医院收入总计307866458680154025893001191526373747160,018,207175,028,634194,926,012105,722,400124,940,100140,698,60091,382,135107,482,827124,234,3901.9235311E-053.7965217E-054.4529716E-051.4566449E-052.072193E-052.1329281E-052.0955956E-052.4534152E-053.0160731E-051.8252572E-052.7740433E-053.2006576E-051.83E-012.77E-013.20E-01第2年第3年第4年第2年第3年第4年第2年第3年第4年23241239ln(x)+0.082858312815020870892992340.195882990430.261973803050.308865980862020202120227.37.16.927939.529923.231987.946810121423241239ln(x)+0.0828583128150208708929911786.213197.514657.57319.49242.311043.46.26.05.834260.636316.338422.618981.420440.421947.26.26.05.836927.239142.941413.219749.921321.722944.212748.714676.916568.76.36.15.925878.627457.229077.112964.814087.315245.56779.58480.610038.590330.0101446.6112445.0成立年份2019E2020E200317572.718981.4200518231.119749.9201610739.712748.7200811878.812964.820184768.76779.5201310417.611786.273608.783010.620185100.57319.45100.57319.4718029506433...