000			03598cam a2200601Ki 4500
001			9781003051886
003			FlBoTFG
005			20220724194206.0
006			m o d
007			cr cnu---unuuu
008			200826t20212020flua ob 000 0 eng d
040			_aOCoLC-P _beng _erda _epn _cOCoLC-P
020			_a9781003051886 _q(electronic bk.)
020			_a100305188X _q(electronic bk.)
020			_a9781000088489 _q(electronic bk. : Mobipocket)
020			_a1000088480 _q(electronic bk. : Mobipocket)
020			_a9781000088472 _q(electronic bk. : PDF)
020			_a1000088472 _q(electronic bk. : PDF)
020			_a9781000088496 _q(electronic bk. : EPUB)
020			_a1000088499 _q(electronic bk. : EPUB)
020			_z9781482250138
020			_z1482250136
035			_a(OCoLC)1190831946
035			_a(OCoLC-P)1190831946
050		4	_aQA76.76.D47
072		7	_aBUS _x061000 _2bisacsh
072		7	_aCOM _x012040 _2bisacsh
072		7	_aCOM _x021030 _2bisacsh
072		7	_aUB _2bicssc
082	0	4	_a005.1 _223
100	1		_aBissett, Brian, _eauthor.
245	1	0	_aAutomated data analysis using Excel / _cBrian Bissett.
250			_aSecond edition.
264		1	_aBoca Raton : _bChapman & Hall/CRC, _c2021.
264		4	_c©2020
300			_a1 online resource : _billustrations (black and white).
336			_atext _btxt _2rdacontent
337			_acomputer _bc _2rdamedia
338			_aonline resource _bcr _2rdacarrier
490	1		_aChapman & Hall/CRC data mining and knowledge discovery series
500			_aPrevious edition: 2007.
520			_aThis 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
588			_aOCLC-licensed vendor bibliographic record.
630	0	0	_aMicrosoft Excel (Computer file)
650		0	_aComputer software _xDevelopment.
650		0	_aDecision making _xComputer programs.
650		7	_aBUSINESS & ECONOMICS / Statistics _2bisacsh
650		7	_aCOMPUTERS / Computer Graphics / Game Programming & Design _2bisacsh
650		7	_aCOMPUTERS / Database Management / Data Mining _2bisacsh
856	4	0	_3Read Online _uhttps://www.taylorfrancis.com/books/9781003051886
856	4	2	_3OCLC metadata license agreement _uhttp://www.oclc.org/content/dam/oclc/forms/terms/vbrl-201703.pdf
942			_2lcc _cEBK
999			_c14766 _d14766