╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П

╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П ╨Ч╨╜╨░╤З╨╡╨╜╨╕╨╡

╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П ╨╛╨┐╨╕╤Б╤Л╨▓╨░╨╡╤В, ╨╜╨░╤Б╨║╨╛╨╗╤М╨║╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╤Б╤В╨░╤В╨╕╤Б╤В╨╕╤З╨╡╤Б╨║╨╕╤Е ╨┤╨░╨╜╨╜╤Л╤Е ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤З╨╜╨╛ ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╨╛╨╝╤Г ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤О, ╨┐╤А╨╕ ╨║╨╛╤В╨╛╤А╨╛╨╝ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨┤╨╡╨╗╨╕╤В╤Б╤П ╨┐╨╛╤А╨╛╨▓╨╜╤Г ╤Б ╨║╨░╨╢╨┤╨╛╨╣ ╤Б╤В╨╛╤А╨╛╨╜╤Л. ╨Х╤Б╨╗╨╕ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨╜╨╡ ╤П╨▓╨╗╤П╨╡╤В╤Б╤П ╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤З╨╜╤Л╨╝ ╨╕╨╗╨╕ ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╤Л╨╝, ╨╛╨╜╨╛ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤З╨╜╨╛, ╤В. ╨╡. ╤З╨░╤Б╤В╨╛╤В╨╜╨╛╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤З╨╜╨╛ ╨▓╨╗╨╡╨▓╨╛ ╨╕╨╗╨╕ ╨▓╨┐╤А╨░╨▓╨╛.

╨Ю╨│╨╗╨░╨▓╨╗╨╡╨╜╨╕╨╡

• ╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П ╨Ч╨╜╨░╤З╨╡╨╜╨╕╨╡
  • ╨в╨╕╨┐╤Л ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕
  • ╨д╨╛╤А╨╝╤Г╨╗╨░
  • ╨Я╤А╨╕╨╝╨╡╤А ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕
  • ╨Я╤А╨╡╨╕╨╝╤Г╤Й╨╡╤Б╤В╨▓╨░
  • ╨Э╨╡╨┤╨╛╤Б╤В╨░╤В╨║╨╕
  • ╨Т╨░╨╢╨╜╨╛╤Б╤В╤М
  • ╨Ч╨░╨║╨╗╤О╤З╨╡╨╜╨╕╨╡
  • ╨а╨╡╨║╨╛╨╝╨╡╨╜╨┤╤Г╨╡╨╝╤Л╨╡ ╤Б╤В╨░╤В╤М╨╕

╨в╨╕╨┐╤Л ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕

╨Х╤Б╨╗╨╕ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤З╨╜╨╛, ╨╛╨╜╨╛ ╨╕╨╝╨╡╨╡╤В ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤О 0 ╨╕ ╨╡╨│╨╛ ╤Б╤А╨╡╨┤╨╜╨╡╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ = ╨╝╨╡╨┤╨╕╨░╨╜╨░ = ╨╝╨╛╨┤╨░.

╨Ш╤В╨░╨║, ╨▓ ╨╛╤Б╨╜╨╛╨▓╨╜╨╛╨╝, ╨╡╤Б╤В╤М ╨┤╨▓╨░ ╤В╨╕╨┐╨░:

• ╨Я╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╣: ╨а╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨╕╨╝╨╡╨╡╤В ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Г╤О ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤О╨а╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨╕╨╝╨╡╨╡╤В ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Г╤О ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤О╨а╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╤Б ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨╛╨╣ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╡╨╣ тАФ ╤Н╤В╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡, ╨▓ ╨║╨╛╤В╨╛╤А╨╛╨╝ ╤Б╤А╨╡╨┤╨╜╨╡╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡, ╨╝╨╡╨┤╨╕╨░╨╜╨░ ╨╕ ╨╝╨╛╨┤╨░ ╤П╨▓╨╗╤П╤О╤В╤Б╤П ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╝╨╕, ╨░ ╨╜╨╡ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Л╨╝╨╕ ╨╕╨╗╨╕ ╨╜╤Г╨╗╨╡╨▓╤Л╨╝╨╕. ╨а╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨▒╨╛╨╗╨╡╨╡ ╤Б╨║╨╛╨╜╤Ж╨╡╨╜╤В╤А╨╕╤А╨╛╨▓╨░╨╜╨╛ ╨╜╨░ ╨╛╨┤╨╜╨╛╨╣ ╤Б╤В╨╛╤А╨╛╨╜╨╡ ╤И╨║╨░╨╗╤Л, ╤Б ╨┤╨╗╨╕╨╜╨╜╤Л╨╝ ╤Е╨▓╨╛╤Б╤В╨╛╨╝ ╤Б╨┐╤А╨░╨▓╨░. ╨Я╨╛╨┤╤А╨╛╨▒╨╜╨╡╨╡, ╨║╨╛╨│╨┤╨░ ╨▒╨╛╨╗╤М╤И╨░╤П ╤З╨░╤Б╤В╤М ╤З╨░╤Б╤В╨╛╤В╤Л ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П ╨╜╨░╤Е╨╛╨┤╨╕╤В╤Б╤П ╨╜╨░ ╨┐╤А╨░╨▓╨╛╨╣ ╤Б╤В╨╛╤А╨╛╨╜╨╡ ╨╕ ╨╕╨╝╨╡╨╡╤В ╨▒╨╛╨╗╨╡╨╡ ╨┤╨╗╨╕╨╜╨╜╤Л╨╣ ╨╕ ╤В╨╛╨╗╤Б╤В╤Л╨╣ ╨┐╤А╨░╨▓╤Л╨╣ ╤Е╨▓╨╛╤Б╤В, ╨│╨┤╨╡ ╤Б╤А╨╡╨┤╨╜╨╡╨╡ > ╨╝╨╡╨┤╨╕╨░╨╜╨░ > ╨╝╨╛╨┤╨░ .

• ╨Ю╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Л╨╣: ╨а╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨╕╨╝╨╡╨╡╤В ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Г╤О ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤О, ╨║╨╛╨│╨┤╨░ ╨▒╨╛╨╗╤М╤И╨░╤П ╤З╨░╤Б╤В╤М ╤З╨░╤Б╤В╨╛╤В╤Л ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П ╨╗╨╡╨╢╨╕╤В ╨╜╨░ ╨╗╨╡╨▓╨╛╨╣ ╤Б╤В╨╛╤А╨╛╨╜╨╡ ╨╕ ╨╕╨╝╨╡╨╡╤В ╨▒╨╛╨╗╨╡╨╡ ╨┤╨╗╨╕╨╜╨╜╤Л╨╣ ╨╕ ╤В╨╛╨╗╤Б╤В╤Л╨╣ ╨╗╨╡╨▓╤Л╨╣ ╤Е╨▓╨╛╤Б╤В. ╨У╨┤╨╡ ╤Б╤А╨╡╨┤╨╜╨╡╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П < ╨╝╨╡╨┤╨╕╨░╨╜╨░ < ╨╝╨╛╨┤╨░.

╨д╨╛╤А╨╝╤Г╨╗╨░

╨д╨╛╤А╨╝╤Г╨╗╨░ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨д╨╛╤А╨╝╤Г╨╗╨░ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨д╨╛╤А╨╝╤Г╨╗╨░ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨д╨╛╤А╨╝╤Г╨╗╨░ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨┐╨╛╨╝╨╛╨│╨░╨╡╤В ╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╕╤В╤М ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨▓╨╡╤А╨╛╤П╤В╨╜╨╛╤Б╤В╨╡╨╣ ╨╖╨░╨┤╨░╨╜╨╜╨╛╨│╨╛ ╨╜╨░╨▒╨╛╤А╨░ ╨┐╨╡╤А╨╡╨╝╨╡╨╜╨╜╤Л╤Е. ╨Э╨░ ╨╛╤Б╨╜╨╛╨▓╨░╨╜╨╕╨╕ ╤Б╤В╨░╤В╨╕╤Б╤В╨╕╤З╨╡╤Б╨║╨╛╨╣ ╤Д╨╛╤А╨╝╤Г╨╗╤Л ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П ╨╝╨╛╨╢╨╡╤В ╨▒╤Л╤В╤М ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨╛╨╣, ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╨╛╨╣ ╨╕╨╗╨╕ ╨╜╨╡╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╜╨╛╨╣. ╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П = тИСNi (Xi тАУ X)3 / (N-1) * ╧Г3 ╨┐╨╛╨┤╤А╨╛╨▒╨╜╨╡╨╡ ╨┐╤А╨╡╨┤╤Б╤В╨░╨▓╨╗╨╡╨╜╨╛ ╨╜╨╕╨╢╨╡ тАУ

╨Я╤А╨╕╨╝╨╡╤А ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕

╨з╤В╨╛╨▒╤Л ╨┐╨╛╨╜╤П╤В╤М ╤Н╤В╤Г ╨║╨╛╨╜╤Ж╨╡╨┐╤Ж╨╕╤О ╨▒╨╛╨╗╨╡╨╡ ╨┐╨╛╨┤╤А╨╛╨▒╨╜╨╛, ╨┤╨░╨▓╨░╨╣╤В╨╡ ╤А╨░╤Б╤Б╨╝╨╛╤В╤А╨╕╨╝ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╣ ╨┐╤А╨╕╨╝╨╡╤А:
.free_excel_div{╤Д╨╛╨╜:#d9d9d9;╤А╨░╨╖╨╝╨╡╤А ╤И╤А╨╕╤Д╤В╨░:16px;╤А╨░╨┤╨╕╤Г╤Б ╨│╤А╨░╨╜╨╕╤Ж╤Л:7px;╨┐╨╛╨╖╨╕╤Ж╨╕╤П:╨╛╤В╨╜╨╛╤Б╨╕╤В╨╡╨╗╤М╨╜╨░╤П;margin:30px;padding:25px 25px 25px 45px}.free_excel_div:before{content:»»;╤Д╨╛╨╜:url(╤Ж╨╡╨╜╤В╤А ╤Ж╨╡╨╜╤В╤А ╨▒╨╡╨╖ ╨┐╨╛╨▓╤В╨╛╤А╨░ #207245;╤И╨╕╤А╨╕╨╜╨░:70px;╨▓╤Л╤Б╨╛╤В╨░:70px;╨┐╨╛╨╖╨╕╤Ж╨╕╤П:╨░╨▒╤Б╨╛╨╗╤О╤В╨╜╨░╤П;╨▓╨╡╤А╤Е:50%;margin-top:-35px;╤Б╨╗╨╡╨▓╨░:-35px;╨│╤А╨░╨╜╨╕╤Ж╨░:5px ╤Б╨┐╨╗╨╛╤И╨╜╨░╤П #fff;╨│╤А╨░╨╜╨╕╤Ж╨░-╤А╨░╨┤╨╕╤Г╤Б:50%}

╨Т╤Л ╨╝╨╛╨╢╨╡╤В╨╡ ╤Б╨║╨░╤З╨░╤В╤М ╤Н╤В╨╛╤В ╤И╨░╨▒╨╗╨╛╨╜ Excel ╨┤╨╗╤П ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨╖╨┤╨╡╤Б╤М тАУ ╨и╨░╨▒╨╗╨╛╨╜ Excel ╤Б ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╡╨╣╨Т ╨║╨╛╨╗╨╗╨╡╨┤╨╢╨╡ ╤Г╨┐╤А╨░╨▓╨╗╨╡╨╜╨╕╤П XYZ 30 ╤Б╤В╤Г╨┤╨╡╨╜╤В╨╛╨▓ ╨┐╨╛╤Б╨╗╨╡╨┤╨╜╨╡╨│╨╛ ╨║╤Г╤А╤Б╨░ ╤А╨░╤Б╤Б╨╝╨░╤В╤А╨╕╨▓╨░╤О╤В ╨▓╨╛╨╖╨╝╨╛╨╢╨╜╨╛╤Б╤В╤М ╤В╤А╤Г╨┤╨╛╤Г╤Б╤В╤А╨╛╨╣╤Б╤В╨▓╨░ ╨▓ ╨╕╤Б╤Б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╤Б╨║╤Г╤О ╤Д╨╕╤А╨╝╤Г QPR, ╨╕ ╨╕╤Е ╨▓╨╛╨╖╨╜╨░╨│╤А╨░╨╢╨┤╨╡╨╜╨╕╨╡ ╨╖╨░╨▓╨╕╤Б╨╕╤В ╨╛╤В ╨░╨║╨░╨┤╨╡╨╝╨╕╤З╨╡╤Б╨║╨╛╨╣ ╤Г╤Б╨┐╨╡╨▓╨░╨╡╨╝╨╛╤Б╤В╨╕ ╤Б╤В╤Г╨┤╨╡╨╜╤В╨░ ╨╕ ╨╡╨│╨╛ ╨┐╤А╨╛╤И╨╗╨╛╨│╨╛ ╨╛╨┐╤Л╤В╨░ ╤А╨░╨▒╨╛╤В╤Л. ╨Э╨╕╨╢╨╡ ╨┐╤А╨╕╨▓╨╡╨┤╨╡╨╜╤Л ╨┤╨░╨╜╨╜╤Л╨╡ ╨╛ ╨▓╨╛╨╖╨╜╨░╨│╤А╨░╨╢╨┤╨╡╨╜╨╕╨╕ ╤Б╤В╤Г╨┤╨╡╨╜╤В╨░ ╨▓ ╨╕╤Б╤Б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╤Б╨║╨╛╨╣ ╤Д╨╕╤А╨╝╨╡ PQR.

╨а╨╡╤И╨╡╨╜╨╕╨╡

╨Ш╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╣╤В╨╡ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╡ ╨┤╨░╨╜╨╜╤Л╨╡:

╨а╨░╤Б╤З╨╡╤В ╤Б╤А╨╡╨┤╨╜╨╡╨│╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П

• = (400$*12+500$*8+700$*5+850$*3+1000$*2)/30
• ╨б╤А╨╡╨┤╨╜╨╡╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ = 561,67

╨а╨░╤Б╤З╨╡╤В ╤Б╤В╨░╨╜╨┤╨░╤А╤В╨╜╨╛╨│╨╛ ╨╛╤В╨║╨╗╨╛╨╜╨╡╨╜╨╕╤П

• ╨б╤В╨░╨╜╨┤╨░╤А╤В╨╜╨╛╨╡ ╨╛╤В╨║╨╗╨╛╨╜╨╡╨╜╨╕╨╡ = тИЪ{(╨б╤Г╨╝╨╝╨░ ╨║╨▓╨░╨┤╤А╨░╤В╨░ ╨╛╤В╨║╨╗╨╛╨╜╨╡╨╜╨╕╤П * ╨Ъ╨╛╨╗╨╕╤З╨╡╤Б╤В╨▓╨╛ ╤Б╤В╤Г╨┤╨╡╨╜╤В╨╛╨▓)/N}.
• ╨б╤В╨░╨╜╨┤╨░╤А╤В╨╜╨╛╨╡ ╨╛╤В╨║╨╗╨╛╨╜╨╡╨╜╨╕╨╡ = 189,16

╨а╨░╤Б╤З╨╡╤В ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨╝╨╛╨╢╨╜╨╛ ╨▓╤Л╨┐╨╛╨╗╨╜╨╕╤В╤М ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╝ ╨╛╨▒╤А╨░╨╖╨╛╨╝:

• ╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П: (╤Б╤Г╨╝╨╝╨░ ╨║╤Г╨▒╨░ ╨╛╤В╨║╨╗╨╛╨╜╨╡╨╜╨╕╤П)/(N-1) * ╨║╤Г╨▒ ╤Б╤В╨░╨╜╨┤╨░╤А╤В╨╜╨╛╨│╨╛ ╨╛╤В╨║╨╗╨╛╨╜╨╡╨╜╨╕╤П.
• = (106374650,07) / (29 * 6768161,24)
• = 0,54

╨б╨╗╨╡╨┤╨╛╨▓╨░╤В╨╡╨╗╤М╨╜╨╛, ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ 0,54 ╨│╨╛╨▓╨╛╤А╨╕╤В ╨╜╨░╨╝ ╨╛ ╤В╨╛╨╝, ╤З╤В╨╛ ╨┤╨░╨╜╨╜╤Л╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П ╨╛╤В╨║╨╗╨╛╨╜╤П╤О╤В╤Б╤П ╨╛╤В ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╨╛╨│╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П.

╨Я╤А╨╡╨╕╨╝╤Г╤Й╨╡╤Б╤В╨▓╨░

• ╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П ╨╗╤Г╤З╤И╨╡ ╨┐╨╛╨┤╤Е╨╛╨┤╨╕╤В ╨┤╨╗╤П ╨╕╨╖╨╝╨╡╤А╨╡╨╜╨╕╤П ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╨╕ ╨╕╨╜╨▓╨╡╤Б╤В╨╕╤Ж╨╕╨╣.
• ╨Ш╨╜╨▓╨╡╤Б╤В╨╛╤А ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╤В ╨╡╨│╨╛ ╨┐╤А╨╕ ╨░╨╜╨░╨╗╨╕╨╖╨╡ ╨╜╨░╨▒╨╛╤А╨░ ╨┤╨░╨╜╨╜╤Л╤Е, ╨┐╨╛╤Б╨║╨╛╨╗╤М╨║╤Г ╨╛╨╜ ╤Г╤З╨╕╤В╤Л╨▓╨░╨╡╤В ╤Н╨║╤Б╤В╤А╨╡╨╝╤Г╨╝ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П.
• ╨н╤В╨╛ ╤И╨╕╤А╨╛╨║╨╛ ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╨╡╨╝╤Л╨╣ ╨╕╨╜╤Б╤В╤А╤Г╨╝╨╡╨╜╤В ╨▓ ╤Б╤В╨░╤В╨╕╤Б╤В╨╕╨║╨╡, ╨┐╨╛╤Б╨║╨╛╨╗╤М╨║╤Г ╨╛╨╜ ╨┐╨╛╨╝╨╛╨│╨░╨╡╤В ╨┐╨╛╨╜╤П╤В╤М, ╨╜╨░╤Б╨║╨╛╨╗╤М╨║╨╛ ╨┤╨░╨╜╨╜╤Л╨╡ ╨╛╤В╨╗╨╕╤З╨░╤О╤В╤Б╤П ╨╛╤В ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╨╛╨│╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П.

╨Э╨╡╨┤╨╛╤Б╤В╨░╤В╨║╨╕

• ╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П ╨▓╨░╤А╤М╨╕╤А╤Г╨╡╤В╤Б╤П ╨╛╤В ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╨╛╨╣ ╨┤╨╛ ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨╛╨╣ ╨▒╨╡╤Б╨║╨╛╨╜╨╡╤З╨╜╨╛╤Б╤В╨╕. ╨Ш╨╜╨╛╨│╨┤╨░ ╨╕╨╜╨▓╨╡╤Б╤В╨╛╤А╤Г ╤В╤А╤Г╨┤╨╜╨╛ ╨┐╤А╨╡╨┤╤Б╨║╨░╨╖╨░╤В╤М ╤В╨╡╨╜╨┤╨╡╨╜╤Ж╨╕╤О ╨▓ ╨╜╨░╨▒╨╛╤А╨╡ ╨┤╨░╨╜╨╜╤Л╤Е.
• ╨Р╨╜╨░╨╗╨╕╤В╨╕╨║ ╨┐╤А╨╛╨│╨╜╨╛╨╖╨╕╤А╤Г╨╡╤В ╨▒╤Г╨┤╤Г╤Й╤Г╤О ╨┐╤А╨╛╨╕╨╖╨▓╨╛╨┤╨╕╤В╨╡╨╗╤М╨╜╨╛╤Б╤В╤М ╨░╨║╤В╨╕╨▓╨░, ╨╕╤Б╨┐╨╛╨╗╤М╨╖╤Г╤П ╤Д╨╕╨╜╨░╨╜╤Б╨╛╨▓╤Г╤О ╨╝╨╛╨┤╨╡╨╗╤М, ╨║╨╛╤В╨╛╤А╨░╤П ╨╛╨▒╤Л╤З╨╜╨╛ ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨░╨│╨░╨╡╤В, ╤З╤В╨╛ ╨┤╨░╨╜╨╜╤Л╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╤П╤О╤В╤Б╤П ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╨╛. ╨Э╨╛, ╨╡╤Б╨╗╨╕ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨╕╤Б╨║╨░╨╢╨░╨╡╤В╤Б╤П, ╤Н╤В╨░ ╨╝╨╛╨┤╨╡╨╗╤М ╨╜╨╡ ╨▒╤Г╨┤╨╡╤В ╨╛╤В╤А╨░╨╢╨░╤В╤М ╤Д╨░╨║╤В╨╕╤З╨╡╤Б╨║╨╕╨╣ ╤А╨╡╨╖╤Г╨╗╤М╤В╨░╤В ╨▓ ╤Б╨▓╨╛╨╡╨╝ ╨┐╤А╨╡╨┤╨┐╨╛╨╗╨╛╨╢╨╡╨╜╨╕╨╕.

╨Т╨░╨╢╨╜╨╛╤Б╤В╤М

╨б╤В╨░╤В╨╕╤Б╤В╨╕╨║╨░ ╨╕╨│╤А╨░╨╡╤В ╨▓╨░╨╢╨╜╤Г╤О ╤А╨╛╨╗╤М, ╨║╨╛╨│╨┤╨░ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨╜╨╡ ╤П╨▓╨╗╤П╨╡╤В╤Б╤П ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╤Л╨╝. ╨н╨║╤Б╤В╤А╨╡╨╝╨░╨╗╤М╨╜╤Л╨╡ ╤В╨╛╤З╨║╨╕ ╨┤╨░╨╜╨╜╤Л╤Е ╨▓ ╨╜╨░╨▒╨╛╤А╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨╝╨╛╨│╤Г╤В ╨┐╤А╨╕╨▓╨╡╤Б╤В╨╕ ╨║ ╨┐╨╡╤А╨╡╨║╨╛╤Б╤Г ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П ╨┤╨░╨╜╨╜╤Л╤Е ╨▓╨╗╨╡╨▓╨╛ (╨║╤А╨░╨╣╨╜╨╕╨╡ ╨┤╨░╨╜╨╜╤Л╨╡ ╨▓ ╨╜╨░╨▒╨╛╤А╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨╝╨╡╨╜╤М╤И╨╡, ╤З╤В╨╛ ╨╕╤Б╨║╨░╨╢╨░╨╡╤В ╨╜╨░╨▒╨╛╤А ╨┤╨░╨╜╨╜╤Л╤Е ╨▓ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Г╤О ╤Б╤В╨╛╤А╨╛╨╜╤Г, ╤З╤В╨╛ ╨┐╤А╨╕╨▓╨╛╨┤╨╕╤В ╨║ ╤Б╤А╨╡╨┤╨╜╨╡╨╝╤Г<╤Б╤А╨╡╨┤╨╜╨╡╨╝╤Г<╨╝╨╛╨┤╤Г) ╨╕╨╗╨╕ ╨║ ╨┐╨╡╤А╨╡╨║╨╛╤Б╤Г ╨▓╨┐╤А╨░╨▓╨╛ (╤В.╨╡. , ╤Н╨║╤Б╤В╤А╨╡╨╝╨░╨╗╤М╨╜╤Л╨╡ ╨┤╨░╨╜╨╜╤Л╨╡ ╨▒╨╛╨╗╤М╤И╨╡, ╤Н╤В╨╕ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤З╨╜╤Л╨╡ ╨┤╨░╨╜╨╜╤Л╨╡ ╨╖╨░╨┤╨░╤О╤В╤Б╤П ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╤Л╨╝╨╕, ╤З╤В╨╛ ╨┐╤А╨╕╨▓╨╛╨┤╨╕╤В ╨║ ╤Б╤А╨╡╨┤╨╜╨╡╨╝╤Г> ╤Б╤А╨╡╨┤╨╜╨╡╨╝╤Г> ╨╝╨╛╨┤╨╡). ╨н╤В╨╛ ╨┐╨╛╨╝╨╛╨│╨░╨╡╤В ╨╕╨╜╨▓╨╡╤Б╤В╨╛╤А╤Г ╤Б ╨║╤А╨░╤В╨║╨╛╤Б╤А╨╛╤З╨╜╤Л╨╝ ╨┐╨╡╤А╨╕╨╛╨┤╨╛╨╝ ╨▓╨╗╨░╨┤╨╡╨╜╨╕╤П ╨░╨╜╨░╨╗╨╕╨╖╨╕╤А╨╛╨▓╨░╤В╤М ╨┤╨░╨╜╨╜╤Л╨╡, ╤З╤В╨╛╨▒╤Л ╨╛╨┐╤А╨╡╨┤╨╡╨╗╨╕╤В╤М ╤В╨╡╨╜╨┤╨╡╨╜╤Ж╨╕╤О, ╨┐╨░╨┤╨░╤О╤Й╤Г╤О ╨▓ ╨║╨╛╨╜╤Ж╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П.

╨Ч╨░╨║╨╗╤О╤З╨╡╨╜╨╕╨╡

╨Р╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤П тАФ ╤Н╤В╨╛ ╤В╨╛, ╨╜╨░╤Б╨║╨╛╨╗╤М╨║╨╛ ╨╜╨░╨▒╨╛╤А ╨┤╨░╨╜╨╜╤Л╤Е ╨╛╤В╨║╨╗╨╛╨╜╤П╨╡╤В╤Б╤П ╨╛╤В ╤Б╨▓╨╛╨╡╨│╨╛ ╨╜╨╛╤А╨╝╨░╨╗╤М╨╜╨╛╨│╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П. ╨С╨╛╨╗╤М╤И╨╡╨╡ ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╨╛╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨▓ ╨╜╨░╨▒╨╛╤А╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨╛╨╖╨╜╨░╤З╨░╨╡╤В, ╤З╤В╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨╕╨╝╨╡╨╡╤В ╨╛╤В╤А╨╕╤Ж╨░╤В╨╡╨╗╤М╨╜╤Г╤О ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤О, ╨░ ╨▒╨╛╨╗╤М╤И╨╡╨╡ ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨╛╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╨╡ ╨▓ ╨╜╨░╨▒╨╛╤А╨╡ ╨┤╨░╨╜╨╜╤Л╤Е ╨╛╨╖╨╜╨░╤З╨░╨╡╤В, ╤З╤В╨╛ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨┐╨╛╨╗╨╛╨╢╨╕╤В╨╡╨╗╤М╨╜╨╛╨╡. ╨н╤В╨╛ ╤Е╨╛╤А╨╛╤И╨╕╨╣ ╤Б╤В╨░╤В╨╕╤Б╤В╨╕╤З╨╡╤Б╨║╨╕╨╣ ╨┐╨╛╨║╨░╨╖╨░╤В╨╡╨╗╤М, ╨║╨╛╤В╨╛╤А╤Л╨╣ ╨┐╨╛╨╝╨╛╨│╨░╨╡╤В ╨╕╨╜╨▓╨╡╤Б╤В╨╛╤А╤Г ╨┐╤А╨╛╨│╨╜╨╛╨╖╨╕╤А╨╛╨▓╨░╤В╤М ╨┤╨╛╤Е╨╛╨┤╨╜╨╛╤Б╤В╤М ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╤П.

╨а╨╡╨║╨╛╨╝╨╡╨╜╨┤╤Г╨╡╨╝╤Л╨╡ ╤Б╤В╨░╤В╤М╨╕

╨н╤В╨░ ╤Б╤В╨░╤В╤М╤П ╨▒╤Л╨╗╨░ ╤А╤Г╨║╨╛╨▓╨╛╨┤╤Б╤В╨▓╨╛╨╝ ╨┐╨╛ ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╨╕ ╨╕ ╨╡╨╡ ╨╖╨╜╨░╤З╨╡╨╜╨╕╤О. ╨Ч╨┤╨╡╤Б╤М ╨╝╤Л ╨╛╨▒╤Б╤Г╨┤╨╕╨╝, ╨║╨░╨║ ╤А╨░╤Б╤Б╤З╨╕╤В╨░╤В╤М ╨░╤Б╨╕╨╝╨╝╨╡╤В╤А╨╕╤О, ╨░ ╤В╨░╨║╨╢╨╡ ╨╡╨╡ ╤А╨░╤Б╤З╨╡╤В ╨╕ ╨┐╤А╨╕╨╝╨╡╤А. ╨Ч╨┤╨╡╤Б╤М ╨╝╤Л ╤В╨░╨║╨╢╨╡ ╨╛╨▒╤Б╤Г╨┤╨╕╨╝ ╨╡╨│╨╛ ╨┐╤А╨╡╨╕╨╝╤Г╤Й╨╡╤Б╤В╨▓╨░, ╨╜╨╡╨┤╨╛╤Б╤В╨░╤В╨║╨╕ ╨╕ ╨▓╨░╨╢╨╜╨╛╤Б╤В╤М. ╨Т╤Л ╤В╨░╨║╨╢╨╡ ╨╝╨╛╨╢╨╡╤В╨╡ ╨╛╨╖╨╜╨░╨║╨╛╨╝╨╕╤В╤М╤Б╤П ╤Б╨╛ ╤Б╨╗╨╡╨┤╤Г╤О╤Й╨╕╨╝╨╕ ╤Б╤В╨░╤В╤М╤П╨╝╨╕: тАУ

• ╨Э╨╛╤А╨╝╨░╨╗╤М╨╜╨╛╨╡ ╤А╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨▓ ╤Б╤В╨░╤В╨╕╤Б╤В╨╕╨║╨╡
• ╨а╨╡╨╢╨╕╨╝ ╨▓ Excel
• ╨Т╤Л╤З╨╕╤Б╨╗╨╕╤В╤М ╤Б╤В╨░╨╜╨┤╨░╤А╤В╨╜╤Г╤О ╨╛╤И╨╕╨▒╨║╤Г
• ╨а╨░╤Б╨┐╤А╨╡╨┤╨╡╨╗╨╡╨╜╨╕╨╡ ╨Я╤Г╨░╤Б╤Б╨╛╨╜╨░ Excel