 .  
  


       : ,  , , -,   ,          (  ),          .     ,    ,      ,     .





 

 



  



  ,2021



ISBN978-5-0055-3064-6

     Ridero







     ,    .      Youtube.      .




1.



   .    . 堖       .      -  䠖    .

 ,  30    -  ,   .      .       廠 Big Data,         Data Science   ,      .

      . , ,        .







     .

Ӡ    ,      蠫.     .    , , , , .      .       - , ..






.    



   ,  ,   .

        ,      . ,    .  ,        .   ,  . ,   .

   .

 -         .

     .          ..   .          .          .

    .        .  .

     -.    ,  100,  1000,   1000000.     .       .




 


  ,    ,   ,   .    Microsoft Excel      .   ,   Excel   .    Libre Office Calc.     , ,  렖 Google Sheets.

      .    .   ,       .    .

    ,  .          ,        , ..






.   Excel



     , , .          .      .    ,   ,  ,  .     , ,  .     ,        . ,     ,     .

 .       ,   .       :          ?

   ,      . ,       .    .   20 30?  120?     , .







   ,    .

 Excel.

     .

   ,  ࠖ ꠗ     . -   Scatter Plot, -蠖  . Ӡ  , ..






.    



   ,     .    40, 110.

      . -     ,   .      .  ,     .   .

      .  More Options  .  Display equation on chart   .    , ..






.   



   :       . ,    ,  .     ,    .

Ӡ        蠖  .      :     1,14   123.         .

           .     ?    100.

   ,       .      .

,    :         .     ,       .

      .     蠖    .

      ,    .    ,  ,  .






.   



     ,        .    ,     .







   .        ꠖ    .     ,     - -.    -,   -.

  ,   .        .     .        .       ,  .




 


      ,   .        蠖   .  ,       .      . ,      ,   .     :

;

;

.






.   



     ,    .

     ࠖ       .       : , ,    .

       .   ,   .          .

  ,      .     .

,       .    ,       ,  .

     ,      .     .      () ,  ,  .

     .  ,   , , ,  .   .

           .     ,     ,      .          . , ,    .






.  



    , ..

  -  . ,  ࠖ  ,    . ,  ,      .    ,       .   . ,   . 90     ,   -,   ,      .       ,  - 젖  ()  ( , ).   ,    ,   .

  𻠖    ,  , .   -  . ,    .    .

    ,  ,         .      ?       ?      ?     .

 ,   .   ,    ?    ?  ,   .       .   ,     ,   堖    .

 .  -        .      .         .

  ,       -  - ,   .

   ,    , , .      ,     ,   .     ,  - ,  -  .    ,   .

  -    ,  -.

   .       , .

     .     .    ,   .     .         .





    ,    . ,     -  堖  ,  ,  , Data Science,   Python.

     -⠖ .  : Massive Open Online Courses (MOOC).   ,  - .

       .




2.



   .    , ..






.   



   .

       .   .     ,  , ,  Excel.

  ,           .    Python   R.    ,  Matlab,   ,  .

,       .  ,    Python    .

     ,   .

   ,   Desktop Version.

       ,      .     .

,     .    ࠖ    ,    .    .  ,        .     , ,     /    QR-.

         .   ,     蠖 : File Options Add-ins Excel Add-ins Go Analysis ToolPak, ..






.  



    ࠖ  廠   , ..






.  



 ,     蠖  Libre Office.      c    (Open Source).  ,     MS Windows, Linux MacOS, ..






.  Libre Office



      . ʠ,         .        ,  .   蠖      .         , ,  ,    .

        .    ,   . ,    .      ,    ,      -.       .

 Libre Office      Portable Version, . .    ,   .     ,        .     ,    㠖    .






.  



  Libre Office Calc   MS Excel  .      *.XLSX. ,       .     ,   , ..






.  Libre OfficeCalc



  Python,     .    - , , . Anaconda    , ..






.   Anaconda



 www.anaconda.com (http://www.anaconda.com/)      Individual Edition   .

         Anaconda Navigator.        Jupyter Lab  .    Jupyter Notebook  , . .        ,   .






.  Anaconda Navigator



  Jupyter Lab    .          .       localhost  , ..






.  JupyterLab



      Jupyter Notebook  .     .   ࠖ      .            砖    .



    Anaconda Jupyter Notebook   .  ,       .    ,    Google    ,   Google Chrome.    Jupyter.



   Anaconda.  Jupyter Lab.   .   Hello, World.




 JupyterLAb


 Jupyter Lab.   . Notebook     .   .    .     .    Code  .    Markdown  .       . Markdown    ,        LaTeX.

   #    . ,   Hello, World -    .  , 𻠖   .

   [Shift+Enter].  .    .        .

 ,      Markdown.       Code.

    .    print.  ,     . Python     ( ).       .  蠖   .  .    [Ctrl+Enter].      ,   .

   .     .    .




 Google Colab


       .   Google Colab -,    .  :

https://colab.research.google.com (https://colab.research.google.com/)

 :      Google.      Google.     Gmail.

     , ..






.  Google Colaboratory



-   .  ,     .      Google Drive.        .

      .  *.ipynb  ,     ,  ,  , .    ,   , ,     .         *.py.

  栖    .       ,   [Shift+Enter] [Ctrl+Enter].

       .       ,  :  !

     .     .   ,         ,    Google.       [+Text].      .       #.    ,    ꠖ ,  .             .

  ,    .      .

   ,   .      .

  ,     ,    . ,  Google     蠖      .         . Ѡ ,          CUDA,       Python.    ,    .




3.



  .  -    ,         堖     .   ,        .  ,      - .






.   



     ,  .     ,    .

    , . .   .        .    ()  .     (,      ).      蠫 ().

   ,  ,    .

    .

   ,    ,    ,     .

  ,      .       .     0,5.     .

    . ,   ,    .

    p.      probability.    proba , . ,     -  ,   렖 .   - ,  , , . Ƞ   ,    ,   .

      . Ƞ   :    - , , .






. :  



     .    :   ,     0,5   0,5 .    堖  .  :   , ..

ࠖ   .     ,       .       . ,    . ,    . ,           .      ,      .

   .       .         ,  .    :    .    .      ,         .  10   .  ,   .       ,    .






.  



      .   ,     ,   .       ,  .     ,     .

    ,     軠     .        .       ,    .   ,        ,  ,   .    ,  ,   . ,      ,  .    .    , ,  .  -      .

  ,        . ,    ,     . ࠖ    ,    , .

   , ,   .          Excel   .        , ..






.   



       ,   .      0,522.       .       .     ,      ()     .        .   ,    .    0,5     0.    0,5     1.  ,     ,     .   0,5   .

,        .      .      .         ROUND / .




Excel 


   Excel.

 ꠖ   .

 : 堖  .       .






.   



  .    .      ,  , .        ,     .      .    10 .

    Uniform / .

  01.

 Random seed      .  ,    .     .     1234.

   ⠖ Output range.  ,     ,   .

        .

        .

  ,    .   ROUND,     :    .






.   



,      ,   0,5.  :  0,5.

    .

     .     蠖   .        .   ,  [Ctrl+Down].     ࠖ   .   10001.   .  : [Ctrl+Home].

  .  ,     .   堖   ,  蠖     .     Excel  AVERAGE,  堖 .   :   ,     [Ctrl+Shift+Down].    .   [Enter]  [].

     ,    0,5.   0,5.     .

    ?     .       ,       .   ,    ,  [OK].  ,   -   .     10 .     .

      砖    .

 .       ,   ,    蠖    .      ?        ,   .        ,   .  堖   .     10000.            ,      .   .

     ,   . ,     .   ࠖ          .     , 堖 ⠫, ⠫,    .      .




Excel 


     .    RAND / .     .      ,   :     ,   ,   , ..






.  -



   .

       ,       .      10001,    .  ,      .  堖 .    .

  . Ӡ    :     ,        2:10001.      .     Home Editing Fill Down.      .      , ..






.  



         .






.  



 .  Excel.   .      .   RAND  .    .      . ٸ .       2 10001. ,    .    : Home Editing Fill Down.    .   [Ctrl+Down].    10001,  .

   .   ROUND.  ,     .   A2,   .         ( ),      頖   .      .        .

  ,       0,5.   AVERAGE.

 렖  [CTRL+S]  .       .

 ,        ,        /  .        .       RAND    .

     .   , ,       .       -.

  堖   ,   . Ӡ  .   .

 ,   Excel        .      1.             .

          ,   .  ,      .    .

,       蠖    蠖       RAND, ..






.  



   10000     10.     .        ,  ,    .

       .   .       ,       .    , ,  .     .      .  ,      ,  ,   .   ,      ?      .

        ࠖ       .      .  ,    .     Excel,    ,  , .   Python.




Libre Office Calc 


   .         Libre Office Calc. Calc    .

   堖    .    ,   .






.  



    Sheet Fill Cells Fill Random Number, ..






.    



     , . .   : Distribution Uniform.  Minimum / Maximum:  .    Cell range 2:10001.  ,      Enable custom seed,       .

       ࠖ Enable rounding.     ,  ,     .






.    



       , . .  ,  Excel.       ,   .






.  



  ,       ,  0,5.




Libre Office Calc 


     ,    Excel   RAND, ..






.  



  RAND 2.

     : Sheet Fill Cells Fill Down, ..






.  






.  



 ,      ,     Excel.    .    ,      .     ,  .      RAND, ROUND AVERAGE.

        0,5. Ƞ  . Ƞ       .

     ,        ,      .       0,5,    蠖 -.

    .     ,  ,     .      , ..






.  




JupyterLab


    .  Python     .

         Anaconda / Jupyter Lab   Python.






.  JupyterLab



      numpy    np  .      .  ,        . , numpy   ,    /  .    ,  ,   .     .

      np.

 ࠖ      .    rand   ,   : 10000 1.

        round.

        .    mean.     .

     .        MEAN AVERAGE.    .       젖        .   . ,        help.      .

     ,      .




Google Colab


         Google Colaboratory, ..






.  Google Colab



    Anaconda / Jupyter Lab.      ,   .  ,   . Colab     . Ƞ     .

,   Colab.  ,        .   .

  ,    [Shift+Enter].    ꠖ          : Connect.

 ,        .

  ,          - .     .     ,     .

Ƞ  :       .    : arithmetic mean,    .     ,       .      .

         .

  : Runtime RunAll.

       print.      .      .

 . ,     .         .    ,  .     .

 ࠖ   . 蠖     .    .      .       , ..






.  




4.



  ࠖ . ,  .    .

  ,       .   ,          . ,      .

   , ,  .  堖  ,  .






.   



, 堖      -  .    ࠖ   .       .

         .

    .  ,     .      .

  堖 Probability Distribution. Probability  . Distribution .

 頖       .     ,         .  堖     . -  , -  .

   ,    .






.  



   .    .    ,       .






.   



         ,   .       .






.  



   .      , . . ,         .    . ,      .    .     . ,     .   .

   ,  ,   Python. Ƞ     .       .     .

    .

     .   .

  : 1234.

   .






.     



   ,     .

   Excel.

  .   , ..

  Insert Chart    : Bar Chart Histogram.

Bar Chart    ,          .         . ,   .     10000,   10000.     堫.

Histogram  ,     .     .      ( ), ..






.  ࠖ 



      ໠     Excel.       MS Office.

  ,     .   ,       ,   .       bin.   bin  .     .        .

 ,  堖     . Excel   ,     .      .         .






.   



     .            .     .   ࠖ ࠖ   ,   .

,          .     頖  .  ࠖ  ࠖ .  ,      . ,         .






.   



      ,     .   histo  ,   gram , .

        . ,     .

      .           , ..






.   






.   




. Excel





  .


   .

   ,     (https://www.litres.ru/pages/biblio_book/?art=66324880)  .

      Visa, MasterCard, Maestro,    ,   ,     ,  PayPal, WebMoney, ., QIWI ,       .


