Excel data analysis for dummies | WorldCat.org

Additional Physical Form Entry:

Contents at a Glance; Table of Contents; Introduction; About This Book; What You Can Safely Ignore; What You Shouldn't Ignore (Unless You're a Masochist); Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Beyond the Book; Where to Go from Here; Part I: Where's the Beef?; Chapter 1: Introducing Excel Tables; What Is a Table and Why Do I Care?; Building Tables; Analyzing Table Information; Chapter 2: Grabbing Data from External Sources; Getting Data the Export-Import Way; Querying External Databases and Web Page Tables; It's Sometimes a Raw Deal. Chapter 3: Scrub-a-Dub-Dub: Cleaning DataEditing Your Imported Workbook; Cleaning Data with Text Functions; Using Validation to Keep Data Clean; Part II: PivotTables and PivotCharts; Chapter 4: Working with PivotTables; Looking at Data from Many Angles; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Table; Customizing How Pivot Tables Work and Look; Chapter 5: Building PivotTable Formulas; Adding Another Standard Calculation; Creating Custom Calculations; Using Calculated Fields and Items; Retrieving Data from a Pivot Table. Chapter 6: Working with PivotChartsWhy Use a Pivot Chart?; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Chart; Using Chart Commands to Create Pivot Charts; Chapter 7: Customizing PivotCharts; Selecting a Chart Type; Working with Chart Styles; Changing Chart Layout; Changing a Chart's Location; Formatting the Plot Area; Formatting the Chart Area; Formatting 3-D Charts; Part III: Advanced Tools; Chapter 8: Using the Database Functions; Quickly Reviewing Functions; Using the DAVERAGE Function; Using the DCOUNT and DCOUNTA Functions. Using the DGET FunctionUsing the DMAX and DMAX Functions; Using the DPRODUCT Function; Using the DSTDEV and DSTDEVP Functions; Using the DSUM Function; Using the DVAR and DVARP Functions; Chapter 9: Using the Statistics Functions; Counting Items in a Data Set; Means, Modes, and Medians; Finding Values, Ranks, and Percentiles; Standard Deviations and Variances; Normal Distributions; t-distributions; f-distributions; Binomial Distributions; Chi-Square Distributions; Regression Analysis; Correlation; Some Really Esoteric Probability Distributions; Chapter 10: Descriptive Statistics. Using the Descriptive Statistics ToolCreating a Histogram; Ranking by Percentile; Calculating Moving Averages; Exponential Smoothing; Generating Random Numbers; Sampling Data; Chapter 11: Inferential Statistics; Using the t-test Data Analysis Tool; Performing z-test Calculations; Creating a Scatter Plot; Using the Regression Data Analysis Tool; Using the Correlation Analysis Tool; Using the Covariance Analysis Tool; Using the ANOVA Data Analysis Tools; Creating an f-test Analysis; Using Fourier Analysis; Chapter 12: Optimization Modeling with Solver; Understanding Optimization Modeling. Setting Up a Solver Worksheet