- De www.coursera.org
Mastering Data Analysis in Excel
You can't access an archived course
- Individualizado
- Acesso livre
- Certificado pago
- 6 sequências
- Introductive Level
Detalhes do curso
Programa de Estudos
- 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...
Pré-requisito
Instrutores
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
A Duke University é uma universidade privada de investigação norte-americana situada em Durham, na Carolina do Norte. A universidade tem o nome da dinastia Duke.
Embora a universidade só tenha sido oficialmente fundada em 1924 (as suas raízes remontam a 1838). Frequentemente referida como a "Harvard do Sul", a Duke é a universidade mais selectiva do Sul dos Estados Unidos.
A universidade é membro da Associação das Universidades Americanas, uma associação que, desde 1900, reúne as universidades de investigação de elite da América do Norte.
Plataforma
A Coursera é uma empresa digital que oferece um curso on-line massivo e aberto, fundado pelos professores de computação Andrew Ng e Daphne Koller Stanford University, localizado em Mountain View, Califórnia.
O Coursera trabalha com as melhores universidades e organizações para disponibilizar alguns dos seus cursos on-line e oferece cursos em várias disciplinas, incluindo: física, engenharia, humanidades, medicina, biologia, ciências sociais, matemática, negócios, ciência da computação, marketing digital, ciência de dados. e outros assuntos.Cours