|
|
libcats.org
Automated Data Analysis Using ExcelBrian D. BissettBecause 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® for Applications (VBA) scripting language of Excel®, 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.
Популярные книги за неделю:
Система упражнений по развитию способностей человека (Практическое пособие)Автор: Петров Аркадий НаумовичКатегория: Путь к себе
Размер книги: 818 Kb
Сотворение мира (3-х томник)Автор: Петров Аркадий НаумовичКатегория: Путь к себе
Размер книги: 817 Kb
Elementary surveying. An introduction to geomaticsАвтор: Ghilani C.D., Автор: Wolf P.R.Категория: P_Physics, PGp_Geophysics
Размер книги: 43.64 Mb
Только что пользователи скачали эти книги:
Б.В.Кацнельсон, А.С.Ларионов, А.М.Калугин. Электровакуумные электронные и газоразрядные приборы (Справочник, 1985)Автор:
Размер книги: 9.54 Mb
Математика XIX века. Геометрия. Теория аналитических функцийАвтор: Колмогоров А.Н. (ред.), Автор: Юшкевич А.Н. (ред.)Категория: Математика
Размер книги: 13.27 Mb
Light: Science and Magic: An Introduction to Photographic LightingАвтор: Fil Hunter, Автор: Paul Fuqua
Размер книги: 5.32 Mb
Reclaiming the native home of hope: community, ecology, and the American WestАвтор: Robert B. Keiter, Автор: University of Utah. Wallace Stegner Center for Land, Автор: Resources, Автор: and the Environment
Размер книги: 390 Kb
Agents of ChangeАвтор: Sanderijn Cels, Автор: Jorrit De Jong, Автор: Frans NautaКатегория: Innovation in Government
Размер книги: 1.43 Mb
|
|
|