Automated Data Analysis Using Excel
eBook - ePub

Automated Data Analysis Using Excel

Brian D. Bissett

  1. 592 «pägés»
  2. English
  3. «éPÜB (möbïlé fřïéñdly) Ñ ω É»
  4. «Äväïläblé öñ ïÖS & Äñdřöïd Ü ü Ä»
eBook - ePub

Automated Data Analysis Using Excel

Brian D. Bissett

«Böök détäïls ñ»
«Täblé öf çöñtéñts Ð ñ»
«Çïtätïöñs ï»

«Äböüt Thïs Böök ö ñ»

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.

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



Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Automated Data Analysis Using Excel an online PDF/ePUB?
Yes, you can access Automated Data Analysis Using Excel by Brian D. Bissett in PDF and/or ePUB format, as well as other popular books in Economics & Statistics for Business & Economics. We have over one million books available in our catalogue for you to explore.

«Iñföřmätïöñ É»

«Püblïshéř Ñ»
Chapman and Hall/CRC
«Ýéäř»
2020
«ISBÑ»
9781000088496
«Édïtïöñ É»
2
«Sübjéçt л
Economics
«Töpïç»
Statistics for Business & Economics

«Täblé öf çöñtéñts ç é»

    «Çïtätïöñ stylés föř Automated Data Analysis Using Excel ö ř ç ñ»

    APA 6 Citation

    Bissett, B. (2020). Automated Data Analysis Using Excel (2nd ed.). CRC Press. Retrieved from https://www.perlego.com/book/1645867/automated-data-analysis-using-excel-pdf (Original work published 2020)

    Chicago Citation

    Bissett, Brian. (2020) 2020. Automated Data Analysis Using Excel. 2nd ed. CRC Press. https://www.perlego.com/book/1645867/automated-data-analysis-using-excel-pdf.

    Harvard Citation

    Bissett, B. (2020) Automated Data Analysis Using Excel. 2nd edn. CRC Press. Available at: https://www.perlego.com/book/1645867/automated-data-analysis-using-excel-pdf (Accessed: 25 September 2021).

    MLA 7 Citation

    Bissett, Brian. Automated Data Analysis Using Excel. 2nd ed. CRC Press, 2020. Web. 25 Sept. 2021.