Automated Data Analysis Using Excel (Chapman & Hall/CRC Data Mining and Knowledge Discovery Series)

✍ Scribed by Brian D. Bissett

Publisher: Chapman and Hall/CRC
Tongue: English
Leaves: 592
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries to retrieve data from databases for analysis. Operations such as fully automated linear and non-linear curve fitting, linear and non-linear mapping, charting, plotting, sorting, and filtering of data have been updated to leverage the newest Excel VBA object models. The text provides examples on automated data analysis and the preparation of custom reports suitable for legal archiving and dissemination.

Functionality Demonstrated in This Edition Includes:

Find and extract information raw data files

Format data in color (conditional formatting)

Perform non-linear and linear regressions on data

Create custom functions for specific applications

Generate datasets for regressions and functions

Create custom reports for regulatory agencies

Leverage email to send generated reports

Return data to Excel using ADO, DAO, and SQL queries

Create database files for processed data

Create tables, records, and fields in databases

Add data to databases in fields or records

Leverage external computational engines

Call functions in MATLAB® and Origin® from Excel

📜 SIMILAR VOLUMES

Automated Data Analysis Using Excel (Cha

📁 Automated Data Analysis Using Excel (Chapman & Hall/CRC Data Mining and Knowledge Discovery Series)

✍ Brian D. Bissett 📂 Library 📅 2020 🏛 Chapman and Hall/CRC 🌐 English

<p>This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using A

Data Mining Using SAS Applications (Chap

📁 Data Mining Using SAS Applications (Chapman & Hall CRC Data Mining and Knowledge Discovery Series)

✍ George Fernandez 📂 Library 📅 2002 🏛 Chapman and Hall\/CRC 🌐 English

Most books on data mining focus on principles and furnish few instructions on how to carry out a data mining project. Data Mining Using SAS Applications not only introduces the key concepts but also enables readers to understand and successfully apply data mining methods using powerful yet user-frie

Temporal Data Mining (Chapman & Hall CRC

📁 Temporal Data Mining (Chapman & Hall CRC Data Mining and Knowledge Discovery Series)

✍ Theophano Mitsa 📂 Library 📅 2010 🏛 Chapman & Hall \/ CRC 🌐 English

Temporal data mining deals with the harvesting of useful information from temporal data. New initiatives in health care and business organizations have increased the importance of temporal information in data today. From basic data mining concepts to state-of-the-art advances, Temporal Data Minin

Biological Data Mining (Chapman & Hall C

📁 Biological Data Mining (Chapman & Hall Crc Data Mining and Knowledge Discovery Series)

✍ Jake Y. Chen, Stefano Lonardi 📂 Library 📅 2009 🏛 Chapman and Hall/CRC 🌐 English

Like a data-guzzling turbo engine, advanced data mining has been powering post-genome biological studies for two decades. Reflecting this growth, Biological Data Mining presents comprehensive data mining concepts, theories, and applications in current biological and medical research. Each chapter is

Geographic Data Mining and Knowledge Dis

📁 Geographic Data Mining and Knowledge Discovery, Second Edition (Chapman & Hall CRC Data Mining and Knowledge Discovery Series)

✍ Harvey J. Miller, Jiawei Han 📂 Library 📅 2009 🏛 CRC Press 🌐 English

The Definitive Volume on Cutting-Edge Exploratory Analysis of Massive Spatial and Spatiotemporal Databases Since the publication of the first edition of Geographic Data Mining and Knowledge Discovery, new techniques for geographic data warehousing (GDW), spatial data mining, and geovisualization (G

Knowledge-Guided Machine Learning: Accel

📁 Knowledge-Guided Machine Learning: Accelerating Discovery Using Scientific Knowledge and Data (Chapman & Hall/CRC Data Mining and Knowledge Discovery Series)

✍ Anuj Karpatne (editor), Ramakrishnan Kannan (editor), Vipin Kumar (editor) 📂 Library 📅 2022 🏛 Chapman and Hall/CRC 🌐 English

<p><span>Given their tremendous success in commercial applications, machine learning (ML) models are increasingly being considered as alternatives to science-based models in many disciplines. Yet, these "black-box" ML models have found limited success due to their inability to work well in the prese