How to generate des criptive statistics
如何生成描述性統(tǒng)計

1.  Now you might now want to calculate some descriptive statistics for „Value? for Loyalty customers. Go to the top menu, click Tools->Data Analysis.
現(xiàn)在，現(xiàn)在你可能要計算一些描述性統(tǒng)計“值”為忠誠客戶。轉(zhuǎn)到頂部菜單中，單擊“工具” - >“。
 

2.  Select „Descriptive Statistics? then click OK.
選擇“描述統(tǒng)計”，然后單擊“確定”。
 

Now:
現(xiàn)在：

• • Click the white box next to „Input Range?. Then select cell C1 and press Ctrl-Shift-Down to select the entire column
點擊白框旁邊的“輸入范圍”。然后選擇單元格C1，按Ctrl-Shift-下選擇整列
• •Check the box „Labels in first row?
檢查框“標簽的第一行”
http://ukthesis.org/thesis_sample
• • For output range, you can select the cell where you want to output to go. For this example, we want the output to go to K60.
對于輸出范圍，您可以選擇單元格中要輸出去。在這個例子中，我們想輸出到K60。
• •Check the box „Summary Statistics?
檢查“摘要統(tǒng)計”


 
Now Excel will output the descriptive statistics beginning from cell K60:
現(xiàn)在，Excel將開始從細胞K60輸出的描述性統(tǒng)計：