Descriptive Statistics

Coronavirus Info

Extract version of 14 slides : http://bit.ly/33k4CHq

For academic full version of 46 slides, please visit here https://bit.ly/2U9Y9vG and send me request

Statistics Analysis of COVID-19 (Novel Coronavirus)

The number of coronavirus case is increasing very quickly in recent days. Since time zoon difference of countries and delay of report, daily report of WHO cannot catch up really situation, the statistic numbers from WHO, European Centre for Disease Prevention and Control (ECDC),  local authorities and medias may be different.

Date    Cases     Deaths
3/1      1487        36
3/9      14890      532
3/21    141858    7319
Very frightening numbers in Europe. For cumulative cases,  in 8 days and 20 days, the numbers are 10 times and 100 times as many as March 1. Yet deaths number is even more bad, 200 times in 20 days.

À cause de rassemblement pour l'élection municipale et la sortie des gens en profitant de plein soleil au dimanche 15 mars, les nouveaux cas a augementé beaucoup.  Avec confinement à partir du lundi 16 mars, le nombre de cas cumulatifs pour aujourd'hui sera moin de 8 000.

la propagation de coronavirus a accéléré en France à partir du 5 mars. 从3月5日起，法国冠状病毒的传播加速了。

Compare with the peak period in China: average 3649 new cases daily from 31 Jan. to 20 Feb.; average 128 deaths daily from 10 Feb. to 23 Feb. Europe has average 2785 new cases daily in last three days. Italy recorded 168 deaths Tuesday 10 March.

Coronavirus is very active and aggressive in Europe. By 10/3 10:42, ECDC reports 14 890 cases, 532 deaths, with 3 313 new cases on 10 March. 冠状病毒在欧洲非常活跃且具有侵略性。 截止到3月10日10:42时，ECDC报告累计14 890病例，532例死亡，其中3月10日增加3 313例。

As the daily new coronavirus cases drops to 2 digital number in China, Europe will overtake Asia and become the most impacted continent by coronavirus in terms of new infected and existing patients. 中国新病例减到2位数，就新感染和现有患者而言， 欧洲将超越亚洲成为疫情最严重的大陆.

By analyse data of persons infected by coronavirus in Europe and in France, their respective numbers are doubled in every 3 and 2 days. The results reveal and approve that 2 calculate parameters for covid-19 is relatively correct: R0 is 2.2 and median incubation period is 3 days. 通过分析在欧洲和法国被冠状病毒感染的人的数据，他们每三天和两天的数量就会增加一倍。 结果显示并证明了covid-19的2个计算参数是相对正确的：R0为2.2，潜伏期中位数为3天。

En France, le nombre de personnes infectées par coronavirus est doublé dans toures les 48 heures.

In Europe, the number of persons infected by coronavirus is doubled in every 3 days.

I find out an interest thing: recent daily reported of new confirmed COVID-19 cases in China is interval by following a strict regular manner like waterwave, with one day high, the other day must be low. Why & reason? it seems the war between humans and novel coronavirus is actually in a period of stalemate situation, each side does not like to give up, and can not win easily either.
最近中国每天新确诊新冠肺炎病例如水浪般间隔地很有规律，一天高，隔天必定低。为什么？什么原因? 看中国疫情现况, 似乎人类与新型冠状病毒之间的战争正处于僵持胶着状态，双方都不愿意投降放弃，也不能轻易获胜。

3 most impacted countries except China

China Europe Railway

China Europe Railway 中欧班列

中欧班列运营网络

Resouces: www.crct.com

Resource: http://www.crct.com/index.php?m=content&c=index&a=lists&catid=22

Fixed Installment and sum of the geometric progression

Excel's formulas for a loan

To illustrate Excel's most popular financial functions, we consider a loan with monthly payments, an annual interest rate of 6%, a 20-year duration, a present value of $150,000 (amount borrowed) and a future value

为了说明Excel最受欢迎的财务功能，我们假设每月支付贷款，年利率为2.1％，贷款期限20年，贷款总额1 000 000元（借入金额）和未来还款额0。当你修改其它参数时，所求运算值自动变更。

fx en français	VPM	TAUX	NPM	VA	VC
fx in English	PMT	Rate	Nper	Pv	Fv
calculate items	Payment/Month	interest rate/month	duration of months	total amount of loan	balance
1.PMT(VPM)月还贷额	($1 074,65)	0,50%	240	$150 000	0
2.PMT(VPM) 月还贷额	¥-5 106,33	0,175%	240	¥1 000 000	0
3.  Pv    (VA) 贷款总额	¥5 106,33	0,175%	240	¥1 000 000	0
4.   Fv    (VC) 贷款余额	¥-3 106,33	0,175%	240	¥1 000 000	¥595 889
5.Rate(TAUX) 贷款利率	¥-5 206,33	0,192%	240	¥1 000 000	0
6. Nper(NPM) 贷款期限	¥-6 481,24	0,175%	180	¥1 000 000	0

1. 2. Your capacity to get loan 
3. Depends of your monthly payment capacity and duration of loan period 
4. If your financial situation deteriorated… 
5. Interest rate of some banks maybe higher 
6. You chose to pay off a loan earlier 

Ref.: http://www.excel-easy.com/functions/financial-functions.html

Etude de Financement

Traductions de français vers anglais d'une "Etude de Financement" (120 pages) d'un projet.

PROJECT:

AMON SURFACE TRANSPORT

(AMON TRANSPORTS TERRESTRES)

(A.T.T.)

 FINANCING STUDY

INTRODUCTION                                                                                             3

I  -  DESCRIPTION OF THE PROJECT                                                                         4
            A  -  ACTIVITY                                                                               5
            B  -  LOCALIZATION                                                                           8
            C  -  ORGANISATION AND MANAGEMENT                                                           10
II  -  INVESTMENT                                                                                       15
            A  -  COSTS OF STUDY                                                                        16
            B  -  CORPOREAL INVESTMENT                                                                  16
            C  -  CAPITAL OF CIRCULATION                                                                16
III  -  THE SOURCES OF FINANCE                                                                          24
            A  -  FINANCIAL REQUIREMENT                                                                 25
            B  -  RESOURCES                                                                             25
            C  -  PLAN OF FINANCING                                                                     26
IV  -  POTENTIAL  TURNOVER                                                                              28
            A  -  TRANSPORT OF PERSONS                                                                  29
            B  -  TRANSPORT OF CORRESPONDENCE                                                           37
            C  -  TOTAL TURNOVER                                                                        39
V  - FUNCTIONAL CHARGES                                                                                 40
            A  -  FURNITURES AND OPERATIONAL CONSUMPTIONS                                               41
            B  -  EXTERNAL CHARGES AND EXPENSES OF PERSONNEL                                            51
            C  -  OTHER                                                                                 61
VI  -  PREVISIONAL ACCOUNT                                                                              69
            A  -  ACCOUNT OF OPERATION AND RESULTS                                                      71
            B  -  CASHFLOW PLAN                                                                         73
            C  -  PREVISIONAL BALANCE SHEET                                                             75
VII  -  CONCLUSIONS                                                                                     76
            1  -  FINANCIAL IMPACTS                                                                     77
            2  -  ECONOMIC AND SOCIAL IMPACTS                                                           77
APPENDIXS                                                                                               78