Automated data analysis using excel / (Record no. 79789)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 02039nam a22002057a 4500 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 220728b2020 |||||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781482250138 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.1 BIS-B |
| 100 ## - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Bissett, Brian D. |
| 245 ## - TITLE STATEMENT | |
| Title | Automated data analysis using excel / |
| Statement of responsibility, etc. | Brain D. Bissett |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 2nd ed. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc. | New York |
| Name of publisher, distributor, etc. | CRC Press |
| Date of publication, distribution, etc. | 2020 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 591 p. |
| 365 ## - TRADE PRICE | |
| Price type code | GBP |
| Price amount | 59.90 |
| 500 ## - GENERAL NOTE | |
| General note | 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.<br/><br/>Functionality Demonstrated in This Edition Includes:<br/><br/>* Find and extract information raw data files<br/>* Format data in color (conditional formatting)<br/>* Perform non-linear and linear regressions on data<br/>* Create custom functions for specific applications<br/>* Generate datasets for regressions and functions<br/>* Create custom reports for regulatory agencies<br/>* Leverage email to send generated reports<br/>* Return data to Excel using ADO, DAO, and SQL queries<br/>* Create database files for processed data<br/>* Create tables, records, and fields in databases<br/>* Add data to databases in fields or records<br/>* Leverage external computational engines<br/>* Call functions in MATLAB® and Origin® from Excel |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Computer software--Development |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Decision making--Computer programs |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Microsoft Excel (Computer file) |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Electronic spreadsheets--Computer programs |
| 952 ## - LOCATION AND ITEM INFORMATION (KOHA) | |
| Withdrawn status | |
| Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Collection code | Home library | Current library | Shelving location | Date acquired | Total Checkouts | Full call number | Barcode | Date last seen | Date last checked out | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dewey Decimal Classification | 003-007 | BITS Pilani Hyderabad | BITS Pilani Hyderabad | General Stack (For lending) | 28/07/2022 | 1 | 005.1 BIS-B | 46201 | 13/07/2024 | 21/09/2022 | 28/07/2022 | Books |