Cargando…
Excel data analysis for dummies /
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover t...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Hoboken N.J. :
Wiley,
Ã2014.
Ã2014 |
| Edición: | 2nd ed. |
| Colección: | --For dummies.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn877772392 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 140419s2014 nju o 001 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d N$T |d TEFOD |d E7B |d YDXCP |d AU@ |d DEBSZ |d MMI |d B24X7 |d COO |d OCLCQ |d OCLCF |d TEFOD |d UMI |d TEFOD |d OCLCQ |d DEBBG |d RECBK |d OCLCQ |d COCUF |d CNNOR |d MOR |d CCO |d PIFAG |d ZCU |d LIV |d MERUC |d OCLCQ |d K6U |d OCLCQ |d OCLCO |d U3W |d BUF |d REB |d UUM |d STF |d HCO |d CEF |d NRAMU |d CRU |d ICG |d VTS |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d WYU |d UAB |d DKC |d OCLCQ |d C6I |d AUD |d UKAHL |d INARC |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 015 | |a GBB433518 |2 bnb | ||
| 016 | 7 | |a 016658120 |2 Uk | |
| 019 | |a 880917440 |a 904358224 |a 918899069 |a 961620366 |a 962636476 |a 966353677 |a 1107459078 |a 1200292349 | ||
| 020 | |a 9781118898109 |q (electronic bk.) | ||
| 020 | |a 1118898109 |q (electronic bk.) | ||
| 020 | |a 9781118898086 |q (electronic bk.) | ||
| 020 | |a 1118898087 |q (electronic bk.) | ||
| 020 | |a 1118898095 | ||
| 020 | |a 9781118898093 | ||
| 020 | |z 9781118898093 |q (pbk.) | ||
| 029 | 1 | |a AU@ |b 000052923035 | |
| 029 | 1 | |a AU@ |b 000053690290 | |
| 029 | 1 | |a AU@ |b 000054348569 | |
| 029 | 1 | |a DEBBG |b BV043020122 | |
| 029 | 1 | |a DEBBG |b BV043608911 | |
| 029 | 1 | |a DEBSZ |b 405716753 | |
| 029 | 1 | |a DEBSZ |b 455696896 | |
| 029 | 1 | |a GBVCP |b 88284654X | |
| 035 | |a (OCoLC)877772392 |z (OCoLC)880917440 |z (OCoLC)904358224 |z (OCoLC)918899069 |z (OCoLC)961620366 |z (OCoLC)962636476 |z (OCoLC)966353677 |z (OCoLC)1107459078 |z (OCoLC)1200292349 | ||
| 037 | |a 6CBC35E6-9B21-461A-99CB-D5CABC38E908 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a HF5548.4.M523 .N384 2014eb | |
| 072 | 7 | |a COM |x 054000 |2 bisacsh | |
| 072 | 7 | |a USHC |2 bicssc | |
| 072 | 7 | |a 635 |2 bisacsh | |
| 072 | 7 | |a COM054000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.54 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Nelson, Stephen L., |d 1959- | |
| 245 | 1 | 0 | |a Excel data analysis for dummies / |c Stephen L. Nelson. |
| 250 | |a 2nd ed. | ||
| 260 | |a Hoboken N.J. : |b Wiley, |c Ã2014. | ||
| 264 | 4 | |c Ã2014 | |
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a --For dummies | |
| 500 | |a Includes index. | ||
| 520 | |a Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the book walks you through the steps that lead to superior data analysis. | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a Setting Up a Solver Worksheet. | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Electronic spreadsheets. | |
| 650 | 6 | |a Tableurs. | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Spreadsheets. |2 bisacsh | |
| 650 | 7 | |a Anwendungs-Software. |2 bisacsh | |
| 650 | 7 | |a Spreadsheets. |2 bisacsh | |
| 650 | 7 | |a Electronic spreadsheets |2 fast | |
| 758 | |i has work: |a Excel data analysis for dummies (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGxHr6hxGjVxPjBwkfphVC |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Nelson, Stephen L. |t Excel Data Analysis For Dummies. |b 2nd ed. |d Hoboken : Wiley, 2014 |z 9781118898109 |
| 830 | 0 | |a --For dummies. | |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1676117 |z Texto completo |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781118898086/?ar |z Texto completo |
| 891 | |a .o11700531 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26345169 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26345170 | ||
| 938 | |a Books 24x7 |b B247 |n bks00063545 | ||
| 938 | |a ebrary |b EBRY |n ebr10861210 | ||
| 938 | |a EBSCOhost |b EBSC |n 760952 | ||
| 938 | |a Internet Archive |b INAR |n exceldataanalysi0000nels_u5o2 | ||
| 938 | |a Recorded Books, LLC |b RECE |n rbeEB00437150 | ||
| 938 | |a YBP Library Services |b YANK |n 11777051 | ||
| 938 | |a YBP Library Services |b YANK |n 12673577 | ||
| 994 | |a 92 |b IZTAP | ||