Excel在統(tǒng)計中的應用

第1章  Excel中文版基礎(chǔ)                  
   1.1  Excel中文版概述                  
     1.1.1  啟動Excel                  
     1.1.2  Excel的屏幕介紹                  
     1.1.3  Excel的信息表示結(jié)構(gòu)                  
     1.1.4  對工作簿文件的操作                  
   1.2  工作表格的編排                  
     1.2.1  輸入數(shù)據(jù)                  
     1.2.2  整行. 整列. 整張工作表和區(qū)域的選中                  
     1.2.3  單元格. 行. 列的插入與刪除                  
     1.2.4  數(shù)據(jù)的移動和復制                  
     1.2.5  數(shù)據(jù)的刪除與替換                  
     1.2.6  數(shù)據(jù)的自動計算與排序                  
   1.3  公式的使用                  
     1.3.1  運算符                  
     1.3.2  輸入公式                  
     1.3.3  公式的顯示                  
     1.3.4  公式的命名                  
     1.3.5  在公式中使用單元格引用                  
   1.4  Excel幫助                  
     1.4.1  認識【幫助】菜單和Office助手                  
     1.4.2  獲得幫助                  
     1.4.3  選擇Office助手選項                  
 第2章  Excel的基本統(tǒng)計功能                  
   2.1  使用函數(shù)的簡要說明                  
   2.2  常用函數(shù)                  
     2.2.1  Sum 函數(shù)                  
     2.2.2  AVERAGE函數(shù)                  
     2.2.3  Max函數(shù)                  
     2.2.4  Count函數(shù)                  
     2.2.5  Median函數(shù)                  
     2.2.6  Mode （）函數(shù)——眾數(shù)                  
   2.3  Excel中平均數(shù)的計算                  
     2.3.1  調(diào)和平均數(shù)HARMEAN （）                  
     2.3.2  幾何平均數(shù)GEOMEAN （）                  
   2.4  標志變異指標的計算                  
     2.4.1  四分位數(shù)QUARTILE （）函數(shù)                  
     2.4.2  百分位數(shù)                  
     2.4.3  平均差                  
     2.4.4  標準差                  
 第3章  統(tǒng)計分布繪圖                  
   3.1  直方圖HISTOGAM的繪制                  
   3.2  概率分布與累計分布圖                  
     3.2.1  概率分布圖                  
     3.2.2  累計分布圖形繪制                  
   3.3  正態(tài)分布圖形繪制                  
   3.4  指數(shù)分布圖形繪制                  
 第4章  圖形的使用與數(shù)據(jù)地圖                  
   4.1  圖形的使用                  
     4.1.1  創(chuàng)建圖形對象                  
     4.1.2  編輯圖形對象                  
     4.1.3  使用藝術(shù)字                  
     4.1.4  格式化對象                  
     4.1.5  插入圖片                  
   4.2  數(shù)據(jù)地圖                  
     4.2.1  創(chuàng)建地圖                  
     4.2.2  地圖工具欄的使用                  
     4.2.3  點擊鼠標右鍵                  
     4.2.4  添加及刪除數(shù)據(jù)                  
     4.2.5  標題及副標題                  
     4.2.6  添加地圖標志                  
     4.2.7  修改格式屬性                  
     4.2.8  將地圖插入其他程序                  
 第5章  圖表的繪制                  
   5.1  建立統(tǒng)計圖的步驟                  
   5.2  選中圖表類型                  
 第6章  數(shù)據(jù)庫管理與數(shù)據(jù)庫統(tǒng)計函數(shù)                  
   6.1  記錄的抽取和數(shù)列數(shù)據(jù)的產(chǎn)生                  
     6.1.1  數(shù)據(jù)庫記錄的錄入                  
     6.1.2  數(shù)據(jù)庫記錄的抽取                  
     6.1.3  數(shù)列數(shù)據(jù)的產(chǎn)生                  
   6.2  數(shù)據(jù)排序與合并計算                  
     6.2.1  按列排序                  
     6.2.2  按行排序                  
     6.2.3  數(shù)據(jù)合并計算                  
   6.3  數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.1  DAVERAGE數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.2  DCOUNT. DCOUNTA數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.3  DGET數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.4  DMAX. DMIN數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.5  DPRODUCT數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.6  DSTDEV. DSTDEVP. DVAR. DVARP數(shù)據(jù)庫統(tǒng)計函數(shù)                  
     6.3.7  DSUM數(shù)據(jù)庫統(tǒng)計函數(shù)                  
   6.4  透視分析                  
     6.4.1  建立數(shù)據(jù)透視表                  
     6.4.2  在數(shù)據(jù)透視表中添加或刪除字段                  
     6.4.3  更新數(shù)據(jù)透視表                  
 第7章  Excel在相關(guān)分析中的應用                  
   7.1  簡單相關(guān)分析                  
     7.1.1  總體相關(guān)系數(shù)                  
     7.1.2  樣本相關(guān)系數(shù)                  
     7.1.3  相關(guān)系數(shù)r的顯著性檢驗與總體相關(guān)系數(shù)ρ的置信區(qū)間                  
   7.2  多元相關(guān)分析                  
     7.2.1  多元相關(guān)系數(shù)                  
     7.2.2  偏相關(guān)系數(shù)                  
   7.3  等級相關(guān)系數(shù)                  
     7.3.1  等級相關(guān)系數(shù)                  
     7.3.2  等級相關(guān)的檢驗                  
 第8章  Excel在假設檢驗中的應用                  
   8.1  Excel所提供的可用于假設檢驗的函數(shù)與分析工具                  
     8.1.1  分布逆函數(shù)                  
     8.1.2  可求概率值的檢驗函數(shù)                  
     8.1.3  分析工具類                  
   8.2  成對觀測值t檢驗                  
     8.2.1  適用場合                  
     8.2.2  實例應用                  
   8.3  方差相等的兩樣本的t檢驗                  
     8.3.1  適用范圍                  
     8.3.2  實例應用                  
   8.4  方差不等的兩樣本的t檢驗                  
     8.4.1  適用場合                  
     8.4.2  實例應用                  
   8.5  兩平均值差的z檢驗                  
     8.5.1  適用范圍                  
     8.5.2  實例應用                  
   8.6  兩樣本方差相等的Ｆ檢驗                  
     8.6.1  適用場合                  
     8.6.2  實例應用                  
 第9章  Excel在方差分析中的應用                  
   9.1  單因素方差分析                  
   9.2  雙因素有重復試驗的方差分析                  
   9.3  雙因素無重復試驗的方差分析                  
 第10章  Excel在非參數(shù)統(tǒng)計中的應用（一）                  
   10.1  非參數(shù)統(tǒng)計方法概述                  
   10.2  兩獨立樣本的中位數(shù)檢驗                  
     10.2.1  中位數(shù)檢驗簡介                  
     10.2.2  中位數(shù)檢驗舉例                  
   10.3  兩獨立樣本秩和檢驗法                  
     10.3.1  兩獨立樣本秩和檢驗                  
     10.3.2  秩和檢驗舉例應用                  
     10.3.3  如何在Excel上完成秩和計算                  
     10.3.4  近似正態(tài)法                  
   10.4  正負號檢驗法                  
     10.4.1  單一樣本的情況                  
     10.4.2  配對樣本的情況                  
     10.4.3  Excel應用舉例                  
 第11章  Excel在非參數(shù)統(tǒng)計中的應用（二）                  
   11.1  Wilcoxon符號秩檢驗法                  
     11.1.1  符號秩檢驗法                  
     11.1.2  Excel上的符號秩檢驗                  
     11.1.3  正態(tài)近似法                  
   11.2  k個樣本的卡方檢驗                  
     11.2.1  χ2檢驗簡介                  
     11.2.2  卡方檢驗舉例                  
   11.3  k個獨立樣本的中位數(shù)檢驗                  
     11.3.1  k個獨立樣本的中位數(shù)檢驗簡                  
     11.3.2  中位數(shù)檢驗舉例                  
     11.3.3  檢驗步驟小結(jié)                  
   11.4  Friedman檢驗——雙因素方差分析                  
     11.4.1  Friedman檢驗                  
     11.4.2  Friedman檢驗的應用例子                  
     11.4.3  小結(jié)