- From www.coursera.org
Mastering Data Analysis in Excel
You can't access an archived course
- Self-paced
- Free Access
- Fee-based Certificate
- 6 Sequences
- Introductive Level
Course details
Syllabus
- Week 1 - About This Course
This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which appli... - Week 1 - Excel Essentials for Beginners
In this module, will explore the essential Excel skills to address typical business situations you may encounter in the future. The Excel vocabulary and functions taught throughout this module make it possible for you to understand the additional explanatory E... - Week 2 - Binary Classification
Separating collections into two categories, such as “buy this stock, don’t but that stock” or “target this customer with a special offer, but not that one” is the ultimate goal of most business data-analysis projects. There is a specialized vocabulary of measu... - Week 3 - Information Measures
In this module, you will learn how to calculate and apply the vitally useful uncertainty metric known as “entropy.” In contrast to the more familiar “probability” that represents the uncertainty that a single outcome will occur, “entropy” quantifies the aggreg... - Week 4 - Linear Regression
The Linear Correlation measure is a much richer metric for evaluating associations than is commonly realized. You can use it to quantify how much a linear model reduces uncertainty. When used to forecast future outcomes, it can be converted into a “point esti... - Week 5 - Additional Skills for Model Building
This module gives you additional valuable concepts and skills related to building high-quality models. As you know, a “model” is a description of a process applied to available data (inputs) that produces an estimate of a future and as yet unknown outcome as ... - Week 6 - Final Course Project
The final course project is a comprehensive assessment covering all of the course material, and consists of four quizzes and a peer review assignment. For quiz one and quiz two, there are learning points that explain components of the quiz. These learning po...
Prerequisite
Instructors
Jana Schaich Borg
Assistant Research Professor
Social Science Research Institute
Daniel Egger
Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke University
Editor
L'université Duke est une université de recherche privée nord-américaine, située à Durham (Caroline du Nord). L'université est nommée d'après la dynastie Duke.
Bien que l'université ne fût officiellement fondée qu'en 1924 (ses racines remontent jusqu'en 1838). Fréquemment appelée la « Harvard du Sud », Duke est l'université la plus sélective du Sud des États-Unis.
L'université est membre de l'Association des universités américaines, une association qui, depuis 1900, regroupe les universités de recherches d'élite d'Amérique du Nord.
Platform
Coursera - это цифровая компания, предлагающая массовые открытые онлайн-курсы, основанные учителями компьютеров Эндрю Нгом и Стэнфордским университетом Дафни Коллер, расположенные в Маунтин-Вью, штат Калифорния.
Coursera работает с ведущими университетами и организациями, чтобы сделать некоторые из своих курсов доступными в Интернете, и предлагает курсы по многим предметам, включая: физику, инженерию, гуманитарные науки, медицину, биологию, социальные науки, математику, бизнес, информатику, цифровой маркетинг, науку о данных и другие предметы.