
ãµã€ã¯ã«ã¿ã€ã ãæž¬ããšãã®æ³šæç¹ââçŸå Žã§ã®æž¬ãæ¹
ã¹ããããŠã©ãããçæã«äœæ¥ã1åæž¬ã£ãŠãããµã€ã¯ã«ã¿ã€ã ã¯58ç§ããšã¡ã¢ãããããã§ä»ã®å®åãã€ããã æ°ã«ãªã£ãŠããŸãã
ã§ããçŸå Žã®äœæ¥æéã¯æ¯åã°ãã€ããŸãã
⪠ããŸããŸéãã£ã1åãããããªã
âª äœæ¥è
ããèŠãããŠããããããšããã€ãããæ¥ãã ãããããªã
⪠éšåã®åããããã§ãæ°ç§å€ãã£ããããããªã
1åã ãã®æž¬å®ã¯ããµã€ã³ãã1忝ã£ãŠããã®ãµã€ã³ãã¯3ãåºãããšèšããããªãã®ã§ãããã®æ°åãåºæºã«æ¹åãããšã广ã®èšç®ãŸã§å šéšãããŠããŸããŸãã
ãã®èšäºã§ã¯ããµã€ã¯ã«ã¿ã€ã ãæ£ããæž¬ãããã®5ã€ã®æ³šæç¹ãšã枬ã£ãæ°åã®èªã¿æ¹ãæžããŸãã
èãæ¹ïŒãµã€ã¯ã«ã¿ã€ã ã¯ãã°ãã€ãã®ããéãŸãã
ã§ããçç£æè¡ã¯ããµã€ã¯ã«ã¿ã€ã ã1ã€ã®æ°åã§ã¯ãªããã°ãã€ãã®ããéãŸããšããŠèŠãŸãã
èŠãã®ã¯æ¬¡ã®3ã€ã§ãã
⪠ãã€ãã®æéïŒå¹³åã»äžå€®å€ïŒïŒä»ã®å®å
⪠ãã¡ã°ãéããšãïŒããŸãæµãããšãã®æéãæ¹åã®ç®æšã®æãããã«ãªã
⪠é
ããšãã»ã°ãã€ãã®å€§ããïŒäœããèµ·ããŠãããµã€ã³
ç¹ã«å€§äºãªã®ããã°ãã€ãã®å€§ããå·¥çšã§ããã°ãã€ãã倧ãããšããããšã¯ãäœãäžå®å®ãªåå ããããšããããšã§ããå¹³åã ãèŠãŠãããšããã®äžå®å®ããèŠéããŸãã
ãããŠãã°ãã€ããå°ããããããšèªäœããç«æŽŸãªã¿ã¯ãççž®ã«ãªãããšãå°ãªããããŸãããé ãåãæžãã°ãã©ã€ã³å šäœãé ãåã«åŒãããããªããªãããã§ãã
æ£ããæž¬ãããã®5ã€ã®æ³šæç¹
泚æ1ïŒ1ãµã€ã¯ã«ã®ãåºåãããå ã«æ±ºãã
æå€ãšèŠèœãšãããã®ããã©ãããã©ããŸã§ã1ãµã€ã¯ã«ãšãããã§ãã
ããåºåãã®äŸ
ãèµ·ç¹ïŒåã®ã¯ãŒã¯ã眮ããæããæ¬¡ã®éšåã«åãã£ãŠåãåºããç¬é
ãçµç¹ïŒçµã¿çµãã£ãã¯ãŒã¯ã眮ããç¬éåºåããæ¯åãããŸãã ãšã枬ãäººã®æèŠã§1ã2ç§ãããŸãã10ç§ãçž®ããããšããŠãããšãã«ãæž¬ãæ¹ã§2ç§ãããã®ã¯èŽåœçã§ããé³ãåãã§ã誰ãèŠãŠãåãç¬éã«æ±ºãŸãåºåããéžã³ãŸãã
泚æ2ïŒ10ã20åæž¬ã
ä»»ãããæ¥ã®ããã£ããææ¡ãã¯5ã10åã§ãããŸããŸãããã§ããæ¹ååã®åºæºãšããŠæ®ãæ°åã¯ã1å·¥çšããã10ã20åã¯æž¬ããŸãã
åæ°ãå°ãªããšãããŸããŸã®1åã«å¹³åãåŒã£åŒµãããŸããæ¹ååŸãšæ¯ã¹ããšãã«ãæ¬åœã«çž®ãã ã®ããããŸããŸãããèšããªããªããŸãã
泚æ3ïŒããã€ãã®ç¶æ ãã§æž¬ã
枬å®ã®ããã«ç¹å¥ã«æŽããç¶æ ã§ã¯ãªããæ®æ®µã©ããã®äœæ¥ã枬ããŸãã
âª äœæ¥è
ã«ã¯ã枬ãç®çãå
ã«äŒããïŒãããªããè©äŸ¡ããããã§ã¯ãªããå·¥çšãè¯ããããããïŒ
⪠ããã€ãã©ããã§ãé¡ãããŸãããšäŒãã
âª äœæ¥è
ãäœäººãããå·¥çšã¯ã1人ã ãã§ãªãããµã ãå
¥ã人ãããããæž¬ã
枬ãããããšãç¥ããšã人ã¯éããªããã¡ã§ããæ°åæž¬ã£ãŠæ £ããŠããã£ãŠããèšé²ãå§ããã®ã1ã€ã®æã§ãã
泚æ4ïŒå·¥çšããšãèŠçŽ äœæ¥ããšã«åããŠæž¬ã
ã©ã€ã³å šäœã1ã€ã§æž¬ãã®ã§ã¯ãªããå·¥çšããšã«æž¬ããŸããã©ããé ãã®ããèŠã€ããããã§ãã
ããã«1ã€ã®å·¥çšã®äžãããéšåãåãã»ã»ããããã»ç· ããã»çœ®ããã®ãããªèŠçŽ äœæ¥ã«åããŠæž¬ããšãã©ã®åäœã«ã ããããããèŠããŠããŸãã
ã¹ããããŠã©ããã§èŠçŽ ããšã«æž¬ãã®ãé£ãããšãã¯ãã¹ããã§åç»ãæ®ã£ãŠãããšããåçããªããæž¬ãæ¹æ³ããããŸããäœåºŠã§ãèŠçŽããã®ã§ã1äººã§æž¬ããšãã«ã䟿å©ã§ãã
⌠ã¹ããåç»ã§åäœåæââéå ·ãŒãã§å§ããIE
泚æ5ïŒãã€ããšéãåã¯ãçç±ã€ããã§åããŠèšé²ãã
éšåã®åãçŽããèšåã®ãã§ã³åãææåãã§æ¢ãŸã£ãåã¯ããã€ãã®ãµã€ã¯ã«ã¿ã€ã ãšã¯åããŠèšé²ããŸããæ··ãããšãå®åãããããªããªããŸãã
ãã ããæ¶ããŠããŸã£ãŠã¯ãããŸãããããªãé ããããã®ã¡ã¢ãšäžç·ã«æ®ããŠãããšãããèªäœãæ¹åã®ãã¿ã«ãªããŸãã
èšé²ã®äŸïŒ10åæž¬ã£ãããããèªã
ããç· ãã®å·¥çšã10åæž¬ã£ãäŸã§ãã
å 1 2 3 4 5 6 7 8 9 10
ç§ 21 22 23 22 21 29 22 23 22 21
â6åç®ïŒãããèœãšããŠæŸãçŽã
10åãã¹ãŠ å¹³å 22.6ç§ãã°ãã€ãïŒæšæºåå·®ïŒ2.37ç§
6åç®ãé€ã å¹³å 21.9ç§ãã°ãã€ãïŒæšæºåå·®ïŒ0.78ç§ãäžå€®å€ 22ç§6åç®ã®1åã ãã§ãå¹³åã0.7ç§ãã°ãã€ãã¯3åã«ãªã£ãŠããŸãã
ãã®å·¥çšã®å®åã¯ãçŽ22ç§ãã°ãã€ãã¯å°ãããã§ãããããŠãããããèœãšãããšãããããšããå¥ã®åé¡ãèŠã€ãããŸãããèœãšããåãé€ããæ°åã§å®åãèŠãŠãèœãšãåå ã¯å¥ã«å¯ŸçãèããŸãã
ãã€ããšéãå€ããã©ãããé€ããŠãããã®å€æã«è¿·ã£ããããã¡ãã«ç®å®ãæžããŠããŸãã
⌠å€ãå€ã®å€å®æ¹æ³ââååäœç¯å²ãšæ€å®ã®äœ¿ãåãã3Ïã§ã¯èŠã€ãããªãçç±
Excelã§èšé²ããŠãèªåã§éèšãã
枬ã£ãæ°åã¯ãExcelã«èšé²ããŠãèªåã§éèšã§ããããã«ããŠãããŸãã
å å
¥ãããã®
枬å®å 1ã20
åå·¥çšã®ç§æ° 枬ã£ãå€
åè ãã€ããšéã£ãåã®çç±
å¹³å =AVERAGE(ç¯å²)
äžå€®å€ =MEDIAN(ç¯å²)
æå°ã»æå€§ =MIN(ç¯å²)ã=MAX(ç¯å²)
ã°ãã€ã =STDEV.S(ç¯å²)颿°ãå ¥ããŠããã°ãæ°åãæã¡èŸŒãã ãã§å¹³åãã°ãã€ããåºãŸããå·¥çšããšã«å¹³åãšæå€§ãæ£ã°ã©ãã«ãããšãã©ã®å·¥çšãé ããã©ã®å·¥çšãã°ãã€ããŠããããã²ãšç®ã§ããããŸãã
å¹³åãšäžå€®å€ã®äœ¿ãåãã¯ããã¡ãã§æžããŠããŸãã
⌠平åå€ãšäžå€®å€ã®éããšäœ¿ãåãââå€ãå€ã«ã ãŸãããªãããŒã¿ã®èŠæ¹
ãŸãšã
⪠ãµã€ã¯ã«ã¿ã€ã ã¯1åã§æ±ºããªããæ¹ååã®åºæºã¯10ã20åæž¬ã
⪠æåã«ã1ãµã€ã¯ã«ã®åºåãããæ±ºãããåºåããã¶ãããš1ã2ç§ããã
⪠ãã€ãã®ç¶æ
ã§æž¬ããäœæ¥è
ã«ã¯ç®çãå
ã«äŒãã
⪠工çšããšãèŠçŽ äœæ¥ããšã«åããŠæž¬ã
⪠ãã€ããšéãåã¯ãçç±ã€ãã§åããŠèšé²ããïŒæ¶ããªãïŒ
⪠平åã ãã§ãªããã°ãã€ããèŠã
枬ã£ãæ°åãããã£ãããæ¬¡ã¯ãã©ã®å·¥çšãã©ã€ã³å šäœãé ãããŠãããããæ¢ããŸãã
⌠ããã«ããã¯å·¥çšã®èŠã€ãæ¹
ã¿ã¯ãççž®ã®å šäœã®é²ãæ¹ã¯ããã¡ãã®å ¥å£ã®èšäºã«ãŸãšããŠããŸãã
⌠ã¿ã¯ãã¿ã€ã ççž®ãä»»ããããæåã«èŠãããšââç®æšãšçŸç¶ã®å·®ãæ°åã§åºã
ããããŠèªã¿ãã
âŒ æšæºæéã®æ±ãæ¹ââã¬ã€ãã£ã³ã°ãšäœè£ç
⌠段åãæéã®æž¬ãæ¹ââå æ®µåãã»å€æ®µåãã®åé¡ããå§ãã
⌠ã¿ã¯ãã¿ã€ã ãšãµã€ã¯ã«ã¿ã€ã ã®éãââçŸå Žã§æ··ä¹±ããªã䜿ãåãæ¹
çŸå Žæ¹åãããŸãšããŠèŠããæ¹ãž
çŸå Žæ¹åã®èšäºããæž¬ãã»èŠã€ããã»çŽãã®é ã«äžŠã¹ãå°å³ãäœããŸããã
⌠çŸå Žæ¹åã¯äœããå§ããã°ããïŒââæž¬ãã»èŠã€ããã»çŽãã®é ã«äžŠã¹ã56èšäºãä¿åçã
æ¬ã«ãŸãšããŸããïŒKindleïŒ
çµç«å·¥çšã®ãµã€ã¯ã«ã¿ã€ã ã60ç§ãã42ç§ã«çž®ãããŸã§ãã1åã§è¿œããããæ¬ã§ãã第2ç« ããŸã枬ããã§ãã¹ããããŠã©ããã§ã®æž¬ãæ¹ãšèŠçŽ äœæ¥ãžã®åãæ¹ããèšå ¥äŸã€ãã§æ±ã£ãŠããŸãã
⌠çŸå Žã§äœ¿ãIEæ¹åå ¥éââäœæ¥ã®ã ããèŠã€ããŠæéãçž®ãã9ã€ã®ã¹ããã
â» Kindle Unlimited ããå©çšã®æ¹ã¯è¿œå æéãªãã§èªããŸãã
Excelãã³ãã¬ãŒããäœã£ãŠããŸã
ã¹ããããŠã©ããã§æž¬ã£ãæéã®èšé²ãšéèšã«äœ¿ã£ãŠããæžåŒãBOOTHã«çœ®ããŠããŸãããã¯ãã¯äœ¿ã£ãŠããªãã®ã§ãäŒç€Ÿã®PCã§ãåããŸãã
â¶ IEåäœåæãã³ãã¬ãŒãéïŒ9ã·ãŒãïŒÂ¥900
â¶ æšæºäœæ¥çµåãã衚ãã³ãã¬ãŒã Â¥900
ãã®noteã®æ©ãæ¹
èšäºãå¢ããŠããã®ã§ãã©ãããèªãã°ãããã®æ¡å
ãäœããŸããã
é£èŒã·ãªãŒãºã®å
¥å£ãKindleã®æ¢åãExcelãã³ãã¬ãŒãã®äžèЧãããã«ãŸãšããŠããŸãã
⌠ã¯ãããŸããŠãMKM_techã§ãââçç£æè¡20幎ããã®noteã®æ©ãæ¹
ð¬ èšäºã®å 容ã§è³ªåã»çåãããã°ãã³ã¡ã³ãæ¬ãžã©ãããããããã ã質åã¯ãèšäºã«ããŠè©³ãããçãããŠããŸãã