The Excel Statistics Cookbook, Second Edition

The Excel Statistics Cookbook, Second Edition
Author: Larry Alton Pace
Publisher: Lulu.com
Total Pages: 65
Release: 2006
Genre: Electronic spreadsheets
ISBN: 9789970041626

Provides step-by-step illustrated instructions for performing the most common statistical procedures in Microsoft Excel. Topics covered: data structures and data lists, descriptive statistics, charts and graphs, one-sample t test, independent samples t test, dependent samples t test, one-way ANOVA, repeated-measures ANOVA, correlation and regression, chi-square tests.

R Graphics Cookbook

R Graphics Cookbook
Author: Winston Chang
Publisher: "O'Reilly Media, Inc."
Total Pages: 414
Release: 2013
Genre: Computers
ISBN: 1449316956

"Practical recipes for visualizing data"--Cover.

The Excel Data and Statistics Cookbook, Third Edition

The Excel Data and Statistics Cookbook, Third Edition
Author: Larry Pace
Publisher: Lulu.com
Total Pages: 207
Release: 2012-11-12
Genre: Computers
ISBN: 0988630001

The Excel Data and Statistics Cookbook,3rd edition, covers all the basic descriptive and inferential statistics taught in an introductory class. Completely updated to illustrate Excel 2013, 2011 (for Mac), and 2010, this book is classroom-tested and instructor-approved.

Python Automation Cookbook

Python Automation Cookbook
Author: Jaime Buelta
Publisher: Packt Publishing Ltd
Total Pages: 527
Release: 2020-05-29
Genre: Computers
ISBN: 1800202598

Get a firm grip on the core processes including browser automation, web scraping, Word, Excel, and GUI automation with Python 3.8 and higher Key FeaturesAutomate integral business processes such as report generation, email marketing, and lead generationExplore automated code testing and Python’s growth in data science and AI automation in three new chaptersUnderstand techniques to extract information and generate appealing graphs, and reports with MatplotlibBook Description In this updated and extended version of Python Automation Cookbook, each chapter now comprises the newest recipes and is revised to align with Python 3.8 and higher. The book includes three new chapters that focus on using Python for test automation, machine learning projects, and for working with messy data. This edition will enable you to develop a sharp understanding of the fundamentals required to automate business processes through real-world tasks, such as developing your first web scraping application, analyzing information to generate spreadsheet reports with graphs, and communicating with automatically generated emails. Once you grasp the basics, you will acquire the practical knowledge to create stunning graphs and charts using Matplotlib, generate rich graphics with relevant information, automate marketing campaigns, build machine learning projects, and execute debugging techniques. By the end of this book, you will be proficient in identifying monotonous tasks and resolving process inefficiencies to produce superior and reliable systems. What you will learnLearn data wrangling with Python and Pandas for your data science and AI projectsAutomate tasks such as text classification, email filtering, and web scraping with PythonUse Matplotlib to generate a variety of stunning graphs, charts, and mapsAutomate a range of report generation tasks, from sending SMS and email campaigns to creating templates, adding images in Word, and even encrypting PDFsMaster web scraping and web crawling of popular file formats and directories with tools like Beautiful SoupBuild cool projects such as a Telegram bot for your marketing campaign, a reader from a news RSS feed, and a machine learning model to classify emails to the correct department based on their contentCreate fire-and-forget automation tasks by writing cron jobs, log files, and regexes with Python scriptingWho this book is for Python Automation Cookbook - Second Edition is for developers, data enthusiasts or anyone who wants to automate monotonous manual tasks related to business processes such as finance, sales, and HR, among others. Working knowledge of Python is all you need to get started with this book.

R Cookbook

R Cookbook
Author: JD Long
Publisher: "O'Reilly Media, Inc."
Total Pages: 600
Release: 2019-06-21
Genre: Computers
ISBN: 1492040630

Perform data analysis with R quickly and efficiently with more than 275 practical recipes in this expanded second edition. The R language provides everything you need to do statistical work, but its structure can be difficult to master. These task-oriented recipes make you productive with R immediately. Solutions range from basic tasks to input and output, general statistics, graphics, and linear regression. Each recipe addresses a specific problem and includes a discussion that explains the solution and provides insight into how it works. If you’re a beginner, R Cookbook will help get you started. If you’re an intermediate user, this book will jog your memory and expand your horizons. You’ll get the job done faster and learn more about R in the process. Create vectors, handle variables, and perform basic functions Simplify data input and output Tackle data structures such as matrices, lists, factors, and data frames Work with probability, probability distributions, and random variables Calculate statistics and confidence intervals and perform statistical tests Create a variety of graphic displays Build statistical models with linear regressions and analysis of variance (ANOVA) Explore advanced statistical techniques, such as finding clusters in your data

Data Analysis Using SQL and Excel

Data Analysis Using SQL and Excel
Author: Gordon S. Linoff
Publisher: John Wiley & Sons
Total Pages: 698
Release: 2010-09-16
Genre: Computers
ISBN: 0470952520

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.

R Cookbook

R Cookbook
Author: Paul Teetor
Publisher: "O'Reilly Media, Inc."
Total Pages: 438
Release: 2011-03-03
Genre: Computers
ISBN: 1449307264

With more than 200 practical recipes, this book helps you perform data analysis with R quickly and efficiently. The R language provides everything you need to do statistical work, but its structure can be difficult to master. This collection of concise, task-oriented recipes makes you productive with R immediately, with solutions ranging from basic tasks to input and output, general statistics, graphics, and linear regression. Each recipe addresses a specific problem, with a discussion that explains the solution and offers insight into how it works. If you’re a beginner, R Cookbook will help get you started. If you’re an experienced data programmer, it will jog your memory and expand your horizons. You’ll get the job done faster and learn more about R in the process. Create vectors, handle variables, and perform other basic functions Input and output data Tackle data structures such as matrices, lists, factors, and data frames Work with probability, probability distributions, and random variables Calculate statistics and confidence intervals, and perform statistical tests Create a variety of graphic displays Build statistical models with linear regressions and analysis of variance (ANOVA) Explore advanced statistical techniques, such as finding clusters in your data "Wonderfully readable, R Cookbook serves not only as a solutions manual of sorts, but as a truly enjoyable way to explore the R language—one practical example at a time."—Jeffrey Ryan, software consultant and R package author

Data Analysis with Excel®

Data Analysis with Excel®
Author: Les Kirkup
Publisher: Cambridge University Press
Total Pages: 468
Release: 2002-03-07
Genre: Computers
ISBN: 9780521797375

An essential introduction to data analysis techniques using spreadsheets, for undergraduate and graduate students.

Pandas 1.x Cookbook

Pandas 1.x Cookbook
Author: Matt Harrison
Publisher: Packt Publishing Ltd
Total Pages: 627
Release: 2020-02-27
Genre: Computers
ISBN: 1839218916

Use the power of pandas to solve most complex scientific computing problems with ease. Revised for pandas 1.x. Key Features This is the first book on pandas 1.x Practical, easy to implement recipes for quick solutions to common problems in data using pandas Master the fundamentals of pandas to quickly begin exploring any dataset Book DescriptionThe pandas library is massive, and it's common for frequent users to be unaware of many of its more impressive features. The official pandas documentation, while thorough, does not contain many useful examples of how to piece together multiple commands as one would do during an actual analysis. This book guides you, as if you were looking over the shoulder of an expert, through situations that you are highly likely to encounter. This new updated and revised edition provides you with unique, idiomatic, and fun recipes for both fundamental and advanced data manipulation tasks with pandas. Some recipes focus on achieving a deeper understanding of basic principles, or comparing and contrasting two similar operations. Other recipes will dive deep into a particular dataset, uncovering new and unexpected insights along the way. Many advanced recipes combine several different features across the pandas library to generate results.What you will learn Master data exploration in pandas through dozens of practice problems Group, aggregate, transform, reshape, and filter data Merge data from different sources through pandas SQL-like operations Create visualizations via pandas hooks to matplotlib and seaborn Use pandas, time series functionality to perform powerful analyses Import, clean, and prepare real-world datasets for machine learning Create workflows for processing big data that doesn’t fit in memory Who this book is for This book is for Python developers, data scientists, engineers, and analysts. Pandas is the ideal tool for manipulating structured data with Python and this book provides ample instruction and examples. Not only does it cover the basics required to be proficient, but it goes into the details of idiomatic pandas.

Excel by Example

Excel by Example
Author: Aubrey Kagan
Publisher: Newnes
Total Pages: 385
Release: 2004-05-19
Genre: Computers
ISBN: 0750677562

The spreadsheet has become a ubiquitous engineering tool, and Microsoft Excel is the standard spreadsheet software package. Over the years, Excel has become such a complex program that most engineers understand and use only a tiny part of its power and features. This book is aimed at electronics engineers and technicians in particular, showing them how to best use Excel's features for computations, circuit modeling, graphing, and data analysis as applied to electronics design. Separate chapters cover lookup tables and file I/O, using macros, graphing, controls, using Analysis Toolpak for statistical analysis, databases, and linking into Excel from other sources, such as data from a serial port. The book is basically an engineering cookbook, with each chapter providing tutorial information along with several Excel "recipes" of interest to electronics engineers. The accompanying CD-ROM features ready-to-run, customizable Excel worksheets derived from the book examples, which will be useful tools to add to any electronics engineer's spreadsheet toolbox. Engineers are looking for any and all means to increase their efficiency and add to their "bag of design tricks." Just about every electronics engineer uses Excel but most feel that the program has many more features to offer, if they only knew what they were! The Excel documentation is voluminous and electronics engineers don't have the time to read it all and sift through looking for those features that are directly applicable to their jobs and figure out how to use them. This book does that task for them-pulls out those features that they need to know about and shows them how to make use of them in specific design examples that they can then tailor to their own design needs. *This is the ONLY book to deal with Excel specifically in the electronics field *Distills voluminous and time-consuming Excel documentation down to nitty-gritty explanations of those features that are directly applicable to the electronics engineer's daily job duties *The accompanying CD-ROM provides ready-to-use, fully-customizable worksheets from the book's examples