Learning Excel
Data Analysis
Master Excel for Data Science,
Microsoft Excel is an important tool for data analysis. It helps companies accurately assess situations and make better business decisions. This course helps you unlock the power of your organization's data using the data analysis and visualization tools built into Excel. Author Curt Frye starts with the foundational concepts, including basic calculations such as mean, median, and standard deviation, and provides an introduction to the central limit theorem. He then shows how to visualize data, relationships, and future results with Excel's histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. Finally, he reviews the process of calculating Bayesian probabilities in Excel. Each chapter includes practical examples that show how to apply the techniques to real-world business problems.
Contents:
- Introduction
- 1. Foundational Concepts of Data Analysis
- 2. Visualize Data
- 3. Test a Hypothesis
- 4. Utilize Data Distributions
- 5. Measure Covariance and Correlation
- 6. Perform Bayesian Analysis
- Conclusion
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 2h 9m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Curt Frye |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science IT & Networking Business |
| Tags | Data Analysis IT Business Intelligence Microsoft Excel |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Institutional Research Specialist in Data Analysis $42k
Professional-Data Analysis - SQL $63k
Business and Data Analysis $67k
Data Management and Analysis Fellowship - CDC $68k
Data Analyst, Marketing & Analysis $68k
Senior Data Analyst, Marketing & Analysis $77k
Data Scientist (Social Network Analysis) $84k
Analyst, R&D IT and Data Analysis Lead $88k
Data Management and Analysis Tech. $94k
Senior Data Analysis - ITSM Analyst $101k
Senior Data Analysis Engineer u2013 Engineering Data Analysis $149k
Data Architect - Financial Planning and Analysis $156k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 2h 9m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Curt Frye |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science IT & Networking Business |
| Tags | Data Analysis IT Business Intelligence Microsoft Excel |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
