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

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

In Stock
SKU: SONG0367509318
Brand: CRC Press
Regular price$306.30
Quantity
Add to wishlist
Add to compare

Processing time: 1-3 days

US Orders Ships in: 3-5 days

International Orders Ships in: 8-12 days

Return Policy: 15-days return on defective items

Payment Option
Payment Methods

Help

If you have any questions, you are always welcome to contact us. We'll get back to you as soon as possible, withing 24 hours on weekdays.

Customer service

All questions about your order, return and delivery must be sent to our customer service team by e-mail at yourstore@yourdomain.com

Sale & Press

If you are interested in selling our products, need more information about our brand or wish to make a collaboration, please contact us at press@yourdomain.com

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 nonlinear curve fitting, linear and nonlinear 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 filesFormat data in color (conditional formatting)Perform nonlinear and linear regressions on dataCreate custom functions for specific applicationsGenerate datasets for regressions and functionsCreate custom reports for regulatory agenciesLeverage email to send generated reportsReturn data to Excel using ADO, DAO, and SQL queriesCreate database files for processed dataCreate tables, records, and fields in databasesAdd data to databases in fields or recordsLeverage external computational enginesCall functions in MATLAB and Origin from Excel

⚠️ WARNING (California Proposition 65):

This product may contain chemicals known to the State of California to cause cancer, birth defects, or other reproductive harm.

For more information, please visit www.P65Warnings.ca.gov.

Recently Viewed