Home Page Icon
Home Page
Table of Contents for
Advancing into Analytics
Close
Advancing into Analytics
by
Advancing into Analytics
Preface
Learning Objective
Prerequisites
Technical Requirements
Technological Requirements
How I Got Here
“Excel Bad, Coding Good”
The Instructional Benefits of Excel
Book Overview
End-of-Chapter Exercises
This Is Not a Laundry List
Don’t Panic
Conventions Used in This Book
Using Code Examples
O’Reilly Online Learning
How to Contact Us
Acknowledgments
I. Foundations of Analytics in Excel
2. Foundations of Probability
Probability and Randomness
Probability and Sample Space
Probability and Experiments
Unconditional and Conditional Probability
Probability Distributions
Discrete Probability Distributions
Continuous Probability Distributions
Conclusion
Exercises
3. Foundations of Inferential Statistics
The Framework of Statistical Inference
Collect a Representative Sample
State the Hypotheses
Formulate an Analysis Plan
Analyze the Data
Make a Decision
It’s Your World…the Data’s Only Living in It
Conclusion
Exercises
4. Correlation and Regression
“Correlation Does Not Imply Causation”
Introducing Correlation
From Correlation to Regression
Linear Regression in Excel
Rethinking Our Results: Spurious Relationships
Conclusion
Advancing into Programming
Exercises
5. The Data Analytics Stack
Statistics Versus Data Analytics Versus Data Science
Statistics
Data Analytics
Business Analytics
Data Science
Machine Learning
Distinct, but Not Exclusive
The Importance of the Data Analytics Stack
Spreadsheets
Databases
Business Intelligence Platforms
Data Programming Languages
Conclusion
What’s Next
Exercises
II. From Excel to R
6. First Steps with R for Excel Users
Downloading R
Getting Started with RStudio
Packages in R
Upgrading R, RStudio, and R Packages
Conclusion
Exercises
7. Data Structures in R
Vectors
Indexing and Subsetting Vectors
From Excel Tables to R Data Frames
Importing Data in R
Exploring a Data Frame
Indexing and Subsetting Data Frames
Writing Data Frames
Conclusion
Exercises
8. Data Manipulation and Visualization in R
Data Manipulation with dplyr
Column-Wise Operations
Row-Wise Operations
Aggregating and Joining Data
dplyr and the Power of the Pipe (%>%)
Reshaping Data with tidyr
Data Visualization with ggplot2
Conclusion
Exercises
9. Capstone: R for Data Analytics
Exploratory Data Analysis
Hypothesis Testing
Independent Samples t-test
Linear Regression
Train/Test Split and Validation
Conclusion
Exercises
III. From Excel to Python
10. First Steps with Python for Excel Users
Downloading Python
Getting Started with Jupyter
Modules in Python
Upgrading Python, Anaconda, and Python packages
Conclusion
Exercises
11. Data Structures in Python
NumPy arrays
Indexing and Subsetting NumPy Arrays
Introducing Pandas DataFrames
Importing Data in Python
Exploring a DataFrame
Indexing and Subsetting DataFrames
Writing DataFrames
Conclusion
Exercises
12. Data Manipulation and Visualization in Python
Column-Wise Operations
Row-Wise Operations
Aggregating and Joining Data
Reshaping Data
Data Visualization
Conclusion
Exercises
13. Capstone: Python for Data Analytics
Exploratory Data Analysis
Hypothesis Testing
Independent Samples T-test
Linear Regression
Train/Test Split and Validation
Conclusion
Exercises
14. Conclusion and Next Steps
Further Slices of the Stack
Research Design and Business Experiments
Further Statistical Methods
Data Science and Machine Learning
Version Control
Ethics
Go Forth and Data How You Please
Parting Words
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Advancing into Analytics
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset