Articles liés à Automated Data Analysis Using Excel
Synopsis
Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to minimize user intervention, automate parameter setup, obtain consistency in both analysis and reporting, and save time through automation.
Focusing on the built-in Visual Basic(R) for Applications (VBA) scripting language of Excel(R), the book shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings. It begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use Excel to obtain data from non-native sources, such as databases and third-party calculation tools. After providing the means to access any required information, the book explains how to automate manipulations and calculations on the acquired data sources. Collecting all of the concepts previously discussed in the book, the final chapter demonstrates from beginning to end how to create a cohesive, robust application. With an understanding of this book, readers should be able to construct applications that can import data from a variety of sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.
À propos de l?auteur
Pfizer Global Research and Development, Groton, Connecticut,
Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.
Résultats de recherche pour Automated Data Analysis Using Excel
Image d'archives
Automated Data Analysis Using Excel
Edité par
Chapman And Hall/Crc, 2007
ISBN 10 : 1584888857
ISBN 13 : 9781584888857
Ancien ou d'occasion
Couverture souple
Vendeur : Anybook.com, Lincoln, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Etat : Good. This is an ex-library book and may have the usual library/used-book markings inside.This book has soft covers. In good all round condition. CD included. Please note the Image in this listing is a stock photo and may not match the covers of the actual item,950grams, ISBN:9781584888857. N° de réf. du vendeur 9085446
Quantité disponible : 1 disponible(s)
Image d'archives
Automated Data Analysis Using Excel [With CDROM]
Edité par
CRC Press, 2007
ISBN 10 : 1584888857
ISBN 13 : 9781584888857
Ancien ou d'occasion
Paperback
Vendeur : ThriftBooks-Dallas, Dallas, TX, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.9. N° de réf. du vendeur G1584888857I3N00
Quantité disponible : 1 disponible(s)