Paul McFedries - Excel Data Analysis For Dummies

10 Chapter 10FIGURE 10-1: A chart with a trend line and some geeky numbers.FIGURE 10-2: An array of best-fit trend values (column F).FIGURE 10-3: A best-fit trend line, extended four periods into the future.FIGURE 10-4: The Series dialog box: your best-fit trend best friend.FIGURE 10-5: An array of forecasted trend values (see the range D14:D17).FIGURE 10-6: A chart with an exponential trend line.FIGURE 10-7: An array of exponential trend values (column C) and forecast value...FIGURE 10-8: A chart with a logarithmic trend line.FIGURE 10-9: A chart with a power trend line.FIGURE 10-10: A chart with a polynomial trend line.FIGURE 10-11: You use the Create Forecast Worksheet dialog box to set up your f...FIGURE 10-12: The new forecast worksheet showing a table and line chart for the...

11 Chapter 11FIGURE 11-1: COUNT returns the tally of the numeric values in a range.FIGURE 11-2: A parts database.FIGURE 11-3: MEDIAN returns the median value of a set of numeric values.FIGURE 11-4: RANK returns the ranking of a value in a set.FIGURE 11-5: LARGE returns the n th largest value in a range or array.FIGURE 11-6: FREQUENCY tells you how many items in a range appear in each bin.FIGURE 11-7: VAR.P returns the variance of data that represents an entire popul...FIGURE 11-8: CORREL calculates the correlation between two sets of values.

12 Chapter 12FIGURE 12-1: Loading the Analysis ToolPak add-in.FIGURE 12-2: The Analysis ToolPak’s tools appear in the Data Analysis dialog bo...FIGURE 12-3: The Descriptive Statistics dialog box, ready to run.FIGURE 12-4: The statistics generated by the Descriptive Statistics tool.FIGURE 12-5: The Moving Average dialog box, good to go.FIGURE 12-6: Some moving averages generated by the Moving Average tool.FIGURE 12-7: A completed version of the Rank and Percentile dialog box.FIGURE 12-8: The product defects with their respective ranks and percentiles.FIGURE 12-9: The parameters change depending on the Distribution value.FIGURE 12-10: Random test scores generated by the Random Number Generation tool...FIGURE 12-11: A worksheet with student grades and a bin range for the distribut...FIGURE 12-12: The Histogram dialog box, all dressed up.FIGURE 12-13: A frequency distribution and histogram for some student grades.

13 Chapter 13FIGURE 13-1: A table of invoice data from which you might select a sample.FIGURE 13-2: The Sampling dialog box, ready to sample.FIGURE 13-3: The sample extracted by the Sampling tool.FIGURE 13-4: Some sample data you can use to perform t-test calculations.FIGURE 13-5: The t-Test: Two-Sample Assuming Equal Variances dialog box.FIGURE 13-6: The results of a t-test.FIGURE 13-7: The z-Test: Two Sample for Means dialog box.FIGURE 13-8: The z-test calculation results.FIGURE 13-9: The completed Regression dialog box.FIGURE 13-10: The regression analysis results.FIGURE 13-11: The completed Correlation dialog box.FIGURE 13-12: The worksheet showing the correlation results for the list price ...FIGURE 13-13: The completed Covariance dialog box.FIGURE 13-14: The worksheet showing the covariance results for the list price a...FIGURE 13-15: The completed Anova: Single Factor dialog box.FIGURE 13-16: The worksheet showing the Anova results for the list price and un...FIGURE 13-17: The completed F-Test Two-Sample for Variances dialog box.FIGURE 13-18: The worksheet showing the F-Test Two-Sample for Variances results...

14 Chapter 14FIGURE 14-1: A standard normal distribution.FIGURE 14-2: A uniform distribution generated by 60,000 dice rolls.FIGURE 14-3: Data sets that are negatively skewed (left) and positively skewed ...FIGURE 14-4: Data sets that have negative kurtosis (left) and positive kurtosis...

15 Chapter 16FIGURE 16-1: Click Tools to see the PivotTable Fields task pane layout options.FIGURE 16-2: You've sold 792 earbuds, but what are the details behind this numb...FIGURE 16-3: The details behind the earbud sales shown in Figure 16-2.FIGURE 16-4: Use the New PivotTable Style dialog box to define your custom styl...FIGURE 16-5: The GETPIVOTDATA function doing its thing.

1 Cover

2 Title Page

3 Copyright

4 Table of Contents

5 Begin Reading

6 Appendix: Glossary of Data Analysis and Excel Terms

7 Index

8 Author Bio

1 iii

2 iv

3 1

4 2

5 3

6 4

7 5

8 6

9 7

10 8

11 9

12 10

13 11

14 12

15 13

16 14

17 15

18 16

19 17

20 18

21 19

22 20

23 21

24 22

25 23

26 24

27 25

28 26

29 27

30 28

31 29

32 31

33 32

34 33

35 34

36 35

37 36

38 37

39 38

40 39

41 40

42 41

43 42

44 43

45 44

46 45

47 46

48 47

49 48

50 49

51 50

52 51

53 52

54 53

55 55

56 56

57 57

58 58

59 59

60 60

61 61

62 62

63 63

64 64

65 65

66 66

67 67

68 68

69 69

70 70

71 71

72 72

73 73

74 74

75 75

76 76

77 77

78 78

79 79

80 80

81 81

82 82

83 83

84 84

85 85

86 86

87 87

88 88

89 89

90 90

91 91

92 92

93 93

94 94

95 95

96 96

97 97

98 99

99 100

100 101

101 102

102 103

103 104

104 105

105 106

106 107

107 108

108 109

109 110

110 111

111 113

112 114

113 115

114 116

115 117

116 118

117 119

118 120

119 121

120 122

121 123

122 124

123 125

124 126

125 127

126 128

127 129

128 130

129 131

130 132

131 133

132 134

133 135

134 137

135 138

136 139

137 140

138 141

139 142

140 143

141 144

142 145

143 146

144 147

145 148

146 149

147 150

148 151

149 152

150 153

151 154

152 155

153 156

154 157

155 158

156 159

157 161

158 162

159 163

160 164

161 165

162 166

163 167

164 168

165 169

166 170

167 171

168 172

169 173

170 174

171 175

172 176

173 177

174 178

175 179

176 181

177 182

178 183

179 184

180 185

181 186

182 187

183 188

184 189

185 190

186 191

187 192

188 193

189 194

190 195

191 196

192 197

193 198

194 199

195 200

196 201

197 203

198 204

199 205

200 206

201 207

202 208

203 209

204 210

205 211

206 212

207 213

208 214

209 215

210 216

211 217

212 218

213 219

214 220

215 221

216 222

217 223

218 224

219 225

220 226

221 227

222 228

223 229

224 230

225 231

226 232

227 233

228 234

229 235

230 236

231 237

232 238

233 239

234 240

235 241

236 242

237 243

238 244

239 245

240 246

241 247

242 248

243 249

244 250

245 251

246 252

247 253

248 254

249 255

250 256

251 257

252 258

253 259

254 260

255 261

256 262

257 263

258 264

259 265

260 266

261 267

262 268

263 269

264 270

265 271

266 272

267 273

268 274

269 275

270 276

271 277

272 279

273 280

274 281

Читать дальше