sections

# Statistical Analysis Microsoft Excel 2016

Software related

Statistical Analysis: Microsoft Excel 2016
James Singleton, “ASP.NET Core 2 High Performance – Second Edition”
Mihalis Tsoukalos, “Go Systems Programming: Master Linux and Unix system level programming with Go”
Clif Flynt, Sarath Lakshman, Shantanu Tushar, “Linux Shell Scripting Cookbook – Third Edition”
Jasmin Azemovic, “SQL Server on Linux: Configuring and administering your SQL Server solution on Linux”

Statistical Analysis: Microsoft Excel 2016

Pearson | English | 2018 | ISBN-10: 0789759055 | 576 pages | PDF | 11.81 mb

USE EXCEL’S STATISTICAL TOOLS TO TRANSFORM YOUR DATA INTO KNOWLEDGE
Nationally recognized Excel expert Conrad Carlberg shows you how to use Excel 2016 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples and downloadable workbooks, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes.
You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, Carlberg offers insightful coverage of crucial topics ranging from experimental design to the statistical power of F tests. Updated for Excel 2016, this guide covers both modern consistency functions and legacy compatibility functions.
Becoming an expert with Excel statistics has never been easier! In this book, you’ll find crystal-clear instructions, insider insights, and complete step-by-step guidance.
Master Excel’s most useful descriptive and inferential statistical tools
Understand how values cluster together or disperse, and how variables move or classify jointly
Tell the truth with statistics—and recognize when others don’t
Infer a population’s characteristics from a sample’s frequency distribution
Explore correlation and regression to learn how variables move in tandem
Use Excel consistency functions such as STDEV.S( ) and STDEV.P( )
Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in
Identify skewed distributions using Excel’s new built-in box-and-whisker plots and histograms
Evaluate statistical power and control risk
Explore how randomized block and split plot designs alter the derivation of F-ratios
Use coded multiple regression analysis to perform ANOVA with unbalanced factorial designs
Analyze covariance with ANCOVA, and properly use multiple covariance
Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2016 shortcuts

James Singleton, “ASP.NET Core 2 High Performance – Second Edition”

English | ISBN: 1788399765 | 2017 | PDF/EPUB/MOBI/Code files | 348 pages | 27 MB

Learn how to develop web applications that deploy cross-platform and are optimized for high performance using ASP.NET Core 2
Master high-level web app performance improvement techniques using ASP.NET Core 2.0
Find the right balance between premature optimization and inefficient code
Design workflows that run asynchronously and are resilient to transient performance issues
Who This Book Is For
This book is aimed for readers who can build a web application and have some experience with ASP.NET or some other web application framework (such as Ruby on Rails or Django). They can be people who are happy learning details independently but who struggle to discover the topics that they should be researching. The reader should be interested in improving the performance of their web app and in learning about ASP.NET Core and modern C.
What You Will Learn
Understand ASP.NET Core 2 and how it differs from its predecessor
Address performance issues at the early stages of development
Set up development environments on Windows, Mac, and Linux
Measure, profile and find the most significant problems
Identify the differences between development workstations and production infrastructures, and how these can exacerbate problems
Boost the performance of your application but with an eye to how it affects complexity and maintenance
Explore a few cutting-edge techniques such as advanced hashing and custom transports
In Detail
The ASP.NET Core 2 framework is used to develop high-performance and cross-platform web applications. It is built on .NET Core 2 and includes significantly more framework APIs than version 1.
This book addresses high-level performance improvement techniques. It starts by showing you how to locate and measure problems and then shows you how to solve some of the most common ones. Next, it shows you how to get started with ASP.NET Core 2 on Windows, Mac, Linux, and with Docker containers.
The book illustrates what problems can occur as latency increases when deploying to a cloud infrastructure. It also shows you how to optimize C code and choose the best data structures for the job. It covers new features in C 6 and 7, along with parallel programming and distributed architectures.
By the end of this book, you will be fixing latency issues and optimizing performance problems, but you will also know how this affects the complexity and maintenance of your application. Finally, we will explore a few highly advanced techniques for further optimization.
Style and approach
A step-by-step practical guide filled with real-world use cases and examples

Mihalis Tsoukalos, “Go Systems Programming: Master Linux and Unix system level programming with Go”

English | ISBN: 1787125645 | 2017 | PDF/EPUB/MOBI/Code files | 466 pages | 27 MB

Key Features
Learn how to write system’s level code in Golang, similar to Unix/Linux systems code
Ramp up in Go quickly
Deep dive into Goroutines and Go concurrency to be able to take advantage of Go server-level constructs
Book Description
Go is the new systems programming language for Linux and Unix systems. It is also the language in which some of the most prominent cloud-level systems have been written, such as Docker. Where C programmers used to rule, Go programmers are in demand to write highly optimized systems programming code.
Created by some of the original designers of C and Unix, Go expands the systems programmers toolkit and adds a mature, clear programming language. Traditional system applications become easier to write since pointers are not relevant and garbage collection has taken away the most problematic area for low-level systems code: memory management.
This book opens up the world of high-performance Unix system applications to the beginning Go programmer. It does not get stuck on single systems or even system types, but tries to expand the original teachings from Unix system level programming to all types of servers, the cloud, and the web.
What you will learn
Explore the Go language from the standpoint of a developer conversant with Unix, Linux, and so on
Understand Goroutines, the lightweight threads used for systems and concurrent applications
Learn how to translate Unix and Linux systems code in C to Golang code
How to write fast and lightweight server code
Dive into concurrency with Go
Write low-level networking code

Clif Flynt, Sarath Lakshman, Shantanu Tushar, “Linux Shell Scripting Cookbook – Third Edition”

English | ISBN: 1785881981 | 2017 | EPUB/MOBI/Code files | 552 pages | 5,5 MB

Do amazing things with the shell
Become an expert in creating powerful shell scripts and explore the full possibilities of the shell
Who This Book Is For
If you are a beginner or an intermediate Linux user who wants to master the skill of quickly writing scripts and automate tasks without reading the entire man pages, then this book is for you. You can start writing scripts and one-liners by simply looking at the relevant recipe and its descriptions without any working knowledge of shell scripting or Linux. Intermediate / advanced users, system administrators / developers, and programmers can use this book as a reference when they face problems while coding.
What You Will Learn
Interact with websites via scripts
Write shell scripts to mine and process data from the Web
Automate system backups and other repetitive tasks with crontab
Create, compress, and encrypt archives of your critical data.
Configure and monitor Ethernet and wireless networks
Monitor and log network and system activity
Tune your system for optimal performance
Identify resource hogs and network bottlenecks
Extract audio from video files
Create web photo albums
Use git or fossil to manage revision control and interact with FOSS projects

Jasmin Azemovic, “SQL Server on Linux: Configuring and administering your SQL Server solution on Linux”

English | ISBN: 1788291808 | 2017 | EPUB/MOBI/Code files | 222 pages | 20 MB

Key Features
Design and administer your SQL Server solution on the open source Linux platform
Install, configure, and fine-tune your database application for maximum performance
An easy-to-follow guide teaching you how to implement various SQL Server CTP 2.x offerings on Linux―from installation to administration
Book Description
Microsoft’s launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.
This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables.
By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.
What you will learn
Install and set up SQL Server CTP 2.x on Linux
Create and work with database objects using SQL Server on Linux
Configure and administer SQL Server on Linux-based systems
Create and restore database back-ups
Protect sensitive data using the built-in cryptographic features
Optimize query execution using indexes
Improve query execution time by