Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson
| Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson |
| Autore | Nelson Stephen L. |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
| Descrizione fisica | 1 online resource (363 p.) |
| Disciplina | 005.54 |
| Collana | For Dummies |
| Soggetto topico |
Statistics - Data processing
Statistics - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-118-89810-9 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Title Page; Copyright Page; 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 DealChapter 3: Scrub-a-Dub-Dub: Cleaning Data; Editing 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 |
| Record Nr. | UNINA-9910453567003321 |
Nelson Stephen L.
|
||
| Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson
| Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson |
| Autore | Nelson Stephen L. |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
| Descrizione fisica | 1 online resource (363 p.) |
| Disciplina | 005.54 |
| Collana | For Dummies |
| Soggetto topico |
Statistics - Data processing
Statistics - Computer programs |
| ISBN | 1-118-89810-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Title Page; Copyright Page; 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 DealChapter 3: Scrub-a-Dub-Dub: Cleaning Data; Editing 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 |
| Record Nr. | UNINA-9910790926503321 |
|
Nelson Stephen L.
|
||
| Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson
| Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson |
| Autore | Nelson Stephen L. |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
| Descrizione fisica | 1 online resource (363 p.) |
| Disciplina | 005.54 |
| Collana | For Dummies |
| Soggetto topico |
Statistics - Data processing
Statistics - Computer programs |
| ISBN | 1-118-89810-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Title Page; Copyright Page; 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 DealChapter 3: Scrub-a-Dub-Dub: Cleaning Data; Editing 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 |
| Record Nr. | UNINA-9910809370903321 |
|
Nelson Stephen L.
|
||
| Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||