<br /><br /><p style="text-align: left;"></p>
<p></p><div style="text-align: left;"><br></div><div style="text-align: left;">这本书体系完整，数学相当严密，对于英文不好，读Greene的Econometric <font color="#cc0033">Analysis</font> 很 吃力的同学，先读这本书是个不错的选择。 第一章... <b>...</b> 一本很实用的<font color="#cc0033">excel</font>教材，对于 挖掘<font color="#cc0033">excel</font>的统计功能很有帮助。 作者：<font color="#cc0033">Vijay</font> <font color="#cc0033">Gupta</font>...</div><p></p>
<p><b><font color="#000066"></font></b></p>
<p align="right" style="text-align: left;"><font color="#000066">[此贴子已经被作者于2006-5-10 5:05:24编辑过]</font></p><p align="right" style="text-align: left;"><font color="#000066"><br></font></p><p align="right"><font color="#000066"></font></p><p align="right" style="text-align: left;"><font color="#000066">CONTENTS</font></p><p align="right" style="text-align: left;"><font color="#000066">CHAPTER 1 WRITING FORMULAS 25</font></p><p align="right" style="text-align: left;"><font color="#000066">1.1 The Basics Of Writing Formulae 26</font></p><p align="right" style="text-align: left;"><font color="#000066">1.2 Tool for using this chapter effectively: Viewing the formula instead of the end</font></p><p align="right" style="text-align: left;"><font color="#000066">result 26</font></p><p align="right" style="text-align: left;"><font color="#000066">1.2.a The “A1” vs. the “R1C1“ style of cell references 28</font></p><p align="right" style="text-align: left;"><font color="#000066">1.2.b Writing a simple formula that references cells 29</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3 Types Of References Allowed In A Formula 30</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3.a Referencing cells from another worksheet 30</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3.b Referencing a block of cells 30</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3.c Referencing non–adjacent cells 31</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3.d Referencing entire rows 32</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3.e Referencing entire columns 32</font></p><p align="right" style="text-align: left;"><font color="#000066">1.3.f Referencing corresponding blocks of cells/rows/columns from a set of</font></p><p align="right" style="text-align: left;"><font color="#000066">worksheets 33</font></p><p align="right" style="text-align: left;"><font color="#000066"><br></font></p><p align="right" style="text-align: left;"><font color="#000066"></font></p><p align="right" style="text-align: left;"><font color="#000066">CHAPTER 2 COPYING/CUTTING AND PASTING FORMULAE 35</font></p><p align="right" style="text-align: left;"><font color="#000066">2.1 Copying And Pasting A Formula To Other Cells In The Same Column 36</font></p><p align="right" style="text-align: left;"><font color="#000066">2.2 Copying And Pasting A Formula To Other Cells In The Same Row 37</font></p><p align="right" style="text-align: left;"><font color="#000066">2.3 Copying And Pasting A Formula To Other Cells In A Different Row And Column</font></p><p align="right" style="text-align: left;"><font color="#000066">38</font></p><p align="right" style="text-align: left;"><font color="#000066">2.4 Controlling Cell Reference Behavior When Copying And Pasting Formulae (Use</font></p><p align="right" style="text-align: left;"><font color="#000066">Of The “$” Key) 39</font></p><p align="right" style="text-align: left;"><font color="#000066">2.4.a Using the “$” sign in different permutations and computations in a</font></p><p align="right" style="text-align: left;"><font color="#000066">formula 41</font></p><p align="right" style="text-align: left;"><font color="#000066">2.5 Copying And Pasting Formulas From One Worksheet To Another 42</font></p><p align="right" style="text-align: left;"><font color="#000066">2.6 Pasting One Formula To Many Cells, Columns, Rows 43</font></p><p align="right" style="text-align: left;"><font color="#000066">2.7 Pasting Several Formulas To A Symmetric But Larger Range 43</font></p><p align="right" style="text-align: left;"><font color="#000066">2.8 Defining And Referencing A “Named Range” 43</font></p><p align="right" style="text-align: left;"><font color="#000066">Adding several named ranges in one step 46</font></p><p align="right" style="text-align: left;"><font color="#000066">Using a named range 47</font></p><p align="right" style="text-align: left;"><font color="#000066">2.9 Selecting All Cells With Formulas That Evaluate To A Similar Number Type 48</font></p><p align="right" style="text-align: left;"><font color="#000066">2.10 Special Paste Options 48</font></p><p align="right" style="text-align: left;"><font color="#000066">2.10.a Pasting only the formula (but not the formatting and comments) 48</font></p><p align="right" style="text-align: left;"><font color="#000066">2.10.b Pasting the result of a formula, but not the formula itself 48</font></p><p align="right" style="text-align: left;"><font color="#000066">2.11 Cutting And Pasting Formulae 49</font></p><p align="right" style="text-align: left;"><font color="#000066"></font></p><p align="right" style="text-align: left;"><font color="#000066">.11.a The difference between “copying and pasting” formulas and “cutting and</font></p><p align="right" style="text-align: left;"><font color="#000066">pasting” formulas 49</font></p><p align="right" style="text-align: left;"><font color="#000066">2.12 Creating A Table Of Formulas Using Data/Table 50</font></p><p align="right" style="text-align: left;"><font color="#000066">2.13 Saving Time By Writing, Copying And Pasting Formulas On Several Worksheets</font></p><p align="right" style="text-align: left;"><font color="#000066">Simultaneously 50</font></p><p align="right" style="text-align: left;"><font color="#000066">CHAPTER 3 PASTE SPECIAL 52</font></p><p align="right" style="text-align: left;"><font color="#000066">3.1 Pasting The Result Of A Formula, But Not The Formula 53</font></p><p align="right" style="text-align: left;"><font color="#000066">3.2 Other Selective Pasting Options 56</font></p><p align="right" style="text-align: left;"><font color="#000066">3.2.a Pasting only the formula (but not the formatting and comments) 56</font></p><p align="right" style="text-align: left;"><font color="#000066">3.2.b Pasting only formats 56</font></p><p align="right" style="text-align: left;"><font color="#000066">3.2.c Pasting data validation schemes 57</font></p><p align="right" style="text-align: left;"><font color="#000066">3.2.d Pasting all but the borders 57</font></p><p align="right" style="text-align: left;"><font color="#000066">3.2.e Pasting comments only 57</font></p><p align="right" style="text-align: left;"><font color="#000066">3.3 Performing An Algebraic “Operation” When Pasting One Column/Row/Range On</font></p><p align="right" style="text-align: left;"><font color="#000066">To Another 58</font></p><p align="right" style="text-align: left;"><font color="#000066">3.3.a Multiplying/dividing/subtracting/adding all cells in a range by a number</font></p><p align="right" style="text-align: left;"><font color="#000066">58</font></p><p align="right" style="text-align: left;"><font color="#000066">3.3.b Multiplying/dividing the cell values in cells in several “pasted on”</font></p><p align="right" style="text-align: left;"><font color="#000066">columns with the values of the copied range 59</font></p><p align="right" style="text-align: left;"><font color="#000066">3.4 Switching Rows To Columns 59</font></p><p align="right" style="text-align: left;"><font color="#000066">CHAPTER 4 INSERTING FUNCTIONS 61</font></p><p align="right" style="text-align: left;"><font color="#000066">4.1 Basics 61</font></p><p align="right" style="text-align: left;"><font color="#000066">4.2 A Simple Function 64</font></p><p align="right" style="text-align: left;"><font color="#000066">4.3 Functions That Need Multiple Range References 67</font></p><p align="right" style="text-align: left;"><font color="#000066">4.4 Writing A “Function Within A Function” 69</font></p><p align="right" style="text-align: left;"><font color="#000066">4.5 New Function-Related Features In The XP Version Of Excel 73</font></p><p align="right" style="text-align: left;"><font color="#000066">Searching for a function 73</font></p><p align="right" style="text-align: left;"><font color="#000066">4.5.a Enhanced Formula Bar 73</font></p><p align="right" style="text-align: left;"><font color="#000066">4.5.b Error Checking and Debugging 74</font></p><p align="right" style="text-align: left;"><font color="#000066">CHAPTER 5 TRACING CELL REFERENCES &amp; DEBUGGING FORMULA</font></p><p align="right" style="text-align: left;"><font color="#000066">ERRORS 76</font></p><p align="right" style="text-align: left;"><font color="#000066">5.1 Tracing the cell references used in a formula 76</font></p><p align="right" style="text-align: left;"><font color="#000066">5.2 Tracing the formulas in which a particular cell is referenced 78</font></p><p align="right" style="text-align: left;"><font color="#000066">5.3 The Auditing Toolbar 79</font></p><p align="right" style="text-align: left;"><font color="#000066">5.4 Watch window (only available in the XP version of Excel) 80</font></p><p align="right" style="text-align: left;"><font color="#000066"><br></font></p><p align="right" style="text-align: left;"><font color="#000066"><p align="right" style="text-align: left;">5.5 Error checking and Formula Evaluator (only available in the XP version of Excel)</p><p align="right" style="text-align: left;">81</p><p align="right" style="text-align: left;">5.6 Formula Auditing Mode (only available in the XP version of Excel) 84</p><p align="right" style="text-align: left;">5.7 Cell-specific Error Checking and Debugging 85</p><p align="right" style="text-align: left;">5.8 Error Checking Options 86</p><p align="right" style="text-align: left;">CHAPTER 6 FUNCTIONS FOR BASIC STATISTICS 89</p><p align="right" style="text-align: left;">6.1 “Averaged” Measures Of Central Tendency 90</p><p align="right" style="text-align: left;">6.1.a AVERAGE 90</p><p align="right" style="text-align: left;">6.1.b TRIMMEAN (“Trimmed mean”) 91</p><p align="right" style="text-align: left;">6.1.c HARMEAN (“Harmonic mean”) 92</p><p align="right" style="text-align: left;">6.1.d GEOMEAN (“Geometric mean”) 93</p><p align="right" style="text-align: left;">6.2 Location Measures Of Central Tendency (Mode, Median) 94</p><p align="right" style="text-align: left;">6.2.a MEDIAN 95</p><p align="right" style="text-align: left;">6.2.b MODE 95</p><p align="right" style="text-align: left;">6.3 Other Location Parameters (Maximum, Percentiles, Quartiles, Other) 95</p><p align="right" style="text-align: left;">6.3.a QUARTILE 96</p><p align="right" style="text-align: left;">6.3.b PERCENTILE 96</p><p align="right" style="text-align: left;">6.3.c Maximum, Minimum and “Kth Largest” 97</p><p align="right" style="text-align: left;">MAX (“Maximum value”) 97</p><p align="right" style="text-align: left;">MIN (“Minimum value”) 98</p><p align="right" style="text-align: left;">LARGE 98</p><p align="right" style="text-align: left;">SMALL 99</p><p align="right" style="text-align: left;">6.3.d Rank or relative standing of each cell within the range of a series 99</p><p align="right" style="text-align: left;">PERCENTRANK 99</p><p align="right" style="text-align: left;">RANK 100</p><p align="right" style="text-align: left;">6.4 Measures Of Dispersion (Standard Deviation &amp; Variance) 100</p><p align="right" style="text-align: left;">Sample dispersion: STDEV, VAR 100</p><p align="right" style="text-align: left;">Population dispersion: STDEVP, VARP 101</p><p align="right" style="text-align: left;">6.5 Shape Attributes Of The Density Function (Skewness, Kurtosis) 102</p><p align="right" style="text-align: left;">6.5.a Skewness 102</p><p align="right" style="text-align: left;">6.5.b Kurtosis 104</p><p align="right" style="text-align: left;">6.6 Functions Ending With An “A” Suffix 105</p><p align="right" style="text-align: left;">CHAPTER 7 PROBABILITY DENSITY FUNCTIONS AND CONFIDENCE</p><p align="right" style="text-align: left;">INTERVALS 109</p><p align="right" style="text-align: left;">7.1 Probability Density Functions (PDF), Cumulative Density Functions (CDF), and</p><p align="right" style="text-align: left;">Inverse functions 110</p><p align="right" style="text-align: left;">7.1.a Probability Density Function (PDF) 110</p><p align="right" style="text-align: left;">7.1.b Cumulative Density Function (CDF) 111</p><p align="right" style="text-align: left;">The CDF and Confidence Intervals 112</p><p align="right" style="text-align: left;">7.1.c Inverse mapping functions 114</p><p align="right" style="text-align: left;">Intoduction &amp; Contents</p><p align="right" style="text-align: left;">9</p><p align="right" style="text-align: left;">7.2 Normal Density Function 115</p><p align="right" style="text-align: left;">Symmetry 116</p><p align="right" style="text-align: left;">Convenience of using the Normal Density Function 117</p><p align="right" style="text-align: left;">Are all large-sample series Normally Distributed? 117</p><p align="right" style="text-align: left;">Statistics &amp; Econometrics: Dependence of Methodologies on the assumption</p><p align="right" style="text-align: left;">of Normality 118</p><p align="right" style="text-align: left;">The Standard Normal and its power 119</p><p align="right" style="text-align: left;">7.2.a The Probability Density Function (PDF) and Cumulative Density Function</p><p align="right" style="text-align: left;">(CDF) 119</p><p align="right" style="text-align: left;">7.2.b Inverse function 121</p><p align="right" style="text-align: left;">7.2.c Confidence Intervals 121</p><p align="right" style="text-align: left;">95% Confidence Interval 121</p><p align="right" style="text-align: left;">90% Confidence Interval 122</p><p align="right" style="text-align: left;">7.3 Standard Normal or Z–Density Function 123</p><p align="right" style="text-align: left;">Inverse function 124</p><p align="right" style="text-align: left;">Confidence Intervals 124</p><p align="right" style="text-align: left;">7.4 T–Density Function 125</p><p align="right" style="text-align: left;">Inverse function 126</p><p align="right" style="text-align: left;">Confidence Intervals 126</p><p align="right" style="text-align: left;">7.4.a One–tailed Confidence Intervals 127</p><p align="right" style="text-align: left;">95% Confidence Interval 127</p><p align="right" style="text-align: left;">90% Confidence Interval 127</p><p align="right" style="text-align: left;">7.5 F–Density Function 129</p><p align="right" style="text-align: left;">Inverse function 129</p><p align="right" style="text-align: left;">One–tailed Confidence Intervals 130</p><p align="right" style="text-align: left;">7.6 Chi-Square Density Function 130</p><p align="right" style="text-align: left;">Inverse function 131</p><p align="right" style="text-align: left;">One–tailed Confidence Intervals 131</p><p align="right" style="text-align: left;">7.7 Other Continuous Density Functions: Beta, Gamma, Exponential, Poisson,</p><p align="right" style="text-align: left;">Weibull &amp; Fisher 132</p><p align="right" style="text-align: left;">7.7.a Beta Density Function 132</p><p align="right" style="text-align: left;">Inverse Function 133</p><p align="right" style="text-align: left;">Confidence Intervals 134</p><p align="right" style="text-align: left;">7.7.b Gamma Density Function 134</p><p align="right" style="text-align: left;">Inverse Function 135</p><p align="right" style="text-align: left;">Confidence Intervals 136</p><p align="right" style="text-align: left;">7.7.c Exponential Density Function 136</p><p align="right" style="text-align: left;">7.7.d Fisher Density Function 138</p><p align="right" style="text-align: left;">7.7.e Poisson Density Function 138</p><p align="right" style="text-align: left;">7.7.f Weibull Density Function 138</p><p align="right" style="text-align: left;">7.7.g Discrete probabilities— Binomial, Hypergeometric &amp; Negative Binomial</p><p align="right" style="text-align: left;">139</p><p align="right" style="text-align: left;">Binomial Density Function 139</p><p align="right" style="text-align: left;">Hypergeometric Density Function 139</p><p align="right" style="text-align: left;">Negative Binomial 139</p><p align="right" style="text-align: left;">7.8 List of Density Function 140</p><p align="right" style="text-align: left;">7.9 Some Inverse Function 141</p><p align="right" style="text-align: left;"><br></p><p align="right" style="text-align: left;">...............[More]</p></font></p><p></p><p align="right" style="text-align: left;"><font color="#000066"><br></font></p><p></p><p></p>