ͳ¼Æѧʵѵ±¨¸æ

N5.ÖÐλÊýºÍÖÚÊý£¬ÀûÓù«Ê½£ºM??L??1?1??2i Me?L?2?Sm?1fmi

´ÓÕâÒ»µÀÌâÀ´¿´£¬ÄѵãÖ÷ÒªÔÚÓÚ¼¸ºÎƽ¾ù£¬¼ÓȨƽ¾ù£¬ÖÐλÊý£¬ÖÚÊýµÄ¼ÆË㣬ÌرðÊÇÊý¾ÝΪ·Ö×éÊý¾Ýʱ£¬Òª×¢Òâ·ÖÎöºÍÀí½â£¬²ÅÄܼõÉÙ´íÎó¡£

£¨Èý£©ÀëÉ¢Ö¸±ê 1.¼«²î

R=max-min=9200-4888=4312,´Ë´¦½ÐΪ¼òµ¥¡£

-2.δ·Ö×éÊý¾Ýƽ¾ù²î£¬¹«Ê½Îª£º

?Xn?XÊ×ÏȼÆËã¸Ã×éÊý¾Ýƽ¾ùÖµ£¬Óë¸÷¸ö¾Ý

×ö²îÈ¡¾ø¶ÔÖµÇóºÍÔÙ³ýÒÔ×ܵÄÈËÊý£¬¼ÆËã½ÏΪ¼òµ¥¡£

3.·Ö×éÊý¾Ýƽ¾ù²î£¬¼ÆËã½ÏΪ¸´ÔÓ£¬Ê×ÏȽ«ÏÂͼÖеÄX-ƽ¾ùÖµ¡¢|X-ƽ¾ùÖµ|¡¢|X-ƽ¾ùÖµ|*ƵÊýËã³öÀ´£¬×îºó |X-ƽ¾ùÖµ

?|*f/?fËã³ö¡£

4.·½²îºÍ±ê×¼²î£¬ÀûÓù«Ê½VAR£º¹ÀËãÑù±¾·½²î¡£

nVAR(number1,number2,...)¡£s?2?(x?x)ii?12n?1=

n?x2?(?x)2n2

5.ÀëɢϵÊý

ÓÉÉÏͼ¿ÉËãVs=110.68/1768=0.0626

ͨ¹ýÕâµÀÌâ¿ÉÖª£¬¶Ô¼«²î¡¢·½²î¡¢±ê×¼²î¡¢ÀëɢϵÊýµÈÖ¸±êµÄ·ÖÎöÀ´¶ÔÊý¾Ý·Ö²¼ÀëÉ¢³Ì¶ÈµÄ²â¶È£¬Êý¾Ý±È½Ï¶à¼ÆËãÓеãÀ§ÄÑ£¬µ«¿ÉÒÔͨ¹ý¼ÆËã»ú£¬Ó¦×¢ÒâÑù±¾·½²îºÍ×ÜÌå·½²îÖ®¼ä×ÔÓɶȵIJ»Í¬¡£ £¨ËÄ£©ÃèÊöͳ¼Æ

Ö»ÐèÒª¼ÓÔغêÀûÓÃÊý¾Ý·ÖÎö¹¤¾ß£¬¸÷ÖÖÖ¸±ê¾Í³öÀ´ÁË¡£

£¨Î壩ͼ±íÔËÓÃ

¸ù¾ÝijµØ1990Äê-2008ÄêÈý´ó²úÒµ±ÈÖØÇé×ÊÁÏ£¬ÖÆ×÷Ö±·½Í¼¡¢ÕÛÏßͼ¡¢±ýͼ¡£Ê×ÏÈ°ÑÊý¾ÝÊäÈ빤×÷±íÖУ¬Èçͼ1Ëùʾ¡£

ÀûÓòåÈëͼ±í¹¦ÄÜ£¬Ñ¡ÖÐÊý¾ÝÇøÓò£¬Éú³ÉÕÛÏßͼ¡¢Ö±·½Í¼¡¢±ýͼ¡£

ʵѵ£¨¶þ£© ͳ¼Æ·Ö×é

Ò»¡¢ÊµÑµÄ¿µÄ

ÕÆÎÕExcelÔÚͳ¼Æ×ÊÁÏËѼ¯ºÍÕûÀíÖеÄÓ¦Óá£ÓÃExcel½øÐÐͳ¼Æ·Ö×éºÍ³éÑùÊý¾ÝËѼ¯¡£ÕÆÎÕÀûÓÃExcel½øÐгéÑùµÄ»ù±¾·½·¨£¬ÕÆÎÕƵÊý·Ö²¼±íºÍÖ±·½Í¼Êý¾Ý·ÖÎö»ù±¾¼¼ÇɺͲÙ×÷·½·¨¡£

¶þ¡¢ÊµÑµÄÚÈÝ

£¨Ò»£©£¨³éÑù£©ÀûÓÃÊý¾Ý·ÖÎö¹¤¾ß½øÐÐËæ»ú³éÑù¡£¼ÙÉèÓû¶Ôij¹«Ë¾50Ãû¹¤

È˹¤×ʽøÐе÷²é£¬ÏÖÒª³éÈ¡10¸ö£¬²ÉÓÃËæ»ú³éÑùºÍµÈ¾à³éÑù·½·¨·Ö±ðÈ·¶¨³éÈ¡µÄÔ±¹¤±àºÅ¡£

£¨¶þ£©£¨º¯Êý·¨½øÐÐͳ¼Æ·Ö×éºÍ±àÖÆƵÊý·Ö²¼±í£©ÔÚExcelÖÐÀûÓú¯Êý½øÐÐͳ¼Æ·Ö×éºÍ±àÖÆƵÊý·Ö²¼±í¿ÉÀûÓÃCOUNTIF£¨£©ºÍFREQUENCY£¨£©µÈº¯Êý£¬µ«Òª¸ù¾Ý±äÁ¿ÖµµÄÀàÐͲ»Í¬¶øÑ¡Ôñ²»Í¬µÄº¯Êý¡£µ±·Ö×é±êÖ¾ÊÇÆ·Öʱê־ʱӦʹÓÃCOUNTIF£¨£©º¯Êý£»µ±·Ö×é±êÖ¾ÊÇÊýÁ¿±ê־ʱӦʹÓÃFREQUENCY£¨£©º¯Êý¡£

Èý¡¢ÊµÑµ²½Öè¼°½á¹û·ÖÎö

1.Ê×ÏȽ«Êý¾ÝÊäÈëExcelµ¥Ôª¸ñÖУ¬¹Û²ìÊý¾ÝµÄÀàÐ͸öÊý£¬ÔÚ¹¤×÷±íÖеĿÕÓàλÖÃÁгö¸÷×éÃû³Æ£¬ÈçͼËùʾ¡£

µÚÒ»£¬½«ÉÏÊö×ÊÁÏÊäÈëExcel¹¤×÷±í£»ÔÚµ¥Ôª¸ñD2ÖÐÊäÈë¡°¹¤×÷µ¥Î»ÐÔÖÊ¡±£¬ÔÚE2ÖÐÊäÈ롰ѧÉúÈËÊý¡±£¬ÔÚD3£ºD6ÇøÓòÖÐÒÀ´ÎÊäÈë¹ú¼Ò»ú¹Ø¡¢ÊÂÒµµ¥Î»¡¢ÆóÒµ¡¢×ÔÖ÷´´Òµ£¬±íʾ·Ö×鷽ʽ£¬Í¬Ê±ÕâÒ²¿ÉÒÔ±íʾ·Ö×é×éÏÞ¡£

µÚ¶þ£¬Ñ¡Ôñµ¥Ôª¸ñE3ÖÁE6ÇøÓò£¬ÔÚ¡°²åÈ롱²Ëµ¥Öе¥»÷¡°º¯Êý¡±Ñ¡Ï´ò¿ª¡°Õ³Ìùº¯Êý¡±¶Ô»°¿ò£»ÔÚ¡°º¯Êý·ÖÀࡱÁбíÖÐÑ¡Ôñ¡°³£Óú¯Êý¡± »òÕßÑ¡Ôñ¡°Í³¼Æ¡±Ò²¿ÉÒÔ£¬ÔÚ¡°º¯ÊýÃû¡±ÁбíÖÐÑ¡Ôñ¡°COUNTIF¡±¡£

µÚÈý£¬µ¥»÷¡°È·¶¨¡±°´Å¥£¬Excelµ¯³ö¡°º¯Êý²ÎÊý¡±¶Ô»°¿ò¡£ÔÚÊý¾ÝÇøÓò¡°Range¡±ÖÐÊäÈëµ¥Ôª¸ñB2£ºB31£¬ÔÚÊý¾Ý½ÓÊÜÇø¼äCriteria ÖÐÊäÈëµ¥Ôª¸ñD3£ºD6¡£

µÚËÄ£¬ÓÉÓÚƵÊý·Ö²¼ÊÇÊý×é²Ù×÷£¬ËùÒÔ£¬´Ë´¦²»ÄÜÖ±½Óµ¥»÷¡°È·¶¨¡±°´Å¥£¬¶øÓ¦°´Ctrl +Shift×éºÏ¼ü£¬Í¬Ê±Ç᰻سµ¡±¼ü£¬µÃµ½ÆµÊý·Ö²¼¡£

2.ÔËÓÃͬÑùµÄ·½·¨¿ÉÒÔ½«Ñ§ÉúµÄÓ¢Óï³É¼¨Í³¼Æ³öÀ´¡£ 3.ÀûÓá°Ö±·½Í¼¡±¹¤¾ß½øÐÐͳ¼Æ·Ö×é

Ö±·½Í¼·ÖÎö¹¤¾ßÊÇÒ»¸öÓÃÓÚÈ·¶¨Êý¾ÝµÄƵÊý·Ö²¼¡¢ÀÛ¼ÆƵÊý·Ö²¼£¬²¢Ìṩֱ·½Í¼µÄ·ÖÎöÄ£¿é¡£ËüÔÚ¸ø¶¨¹¤×÷±íÖÐÊý¾Ýµ¥Ôª¸ñÇøÓòºÍ½ÓÊÕÇø¼äµÄÇé¿öÏ£¬¼ÆËãÊý¾ÝµÄƵÊýºÍÀÛ»ýƵÊý

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ì滻Ϊ@)