課程信息

401,695 次近期查看

學生職業成果

23%

完成這些課程後已開始新的職業生涯

21%

通過此課程獲得實實在在的工作福利
可分享的證書
完成後獲得證書
100% 在線
立即開始,按照自己的計劃學習。
可靈活調整截止日期
根據您的日程表重置截止日期。
完成時間大約為21 小時
英語(English)
字幕:英語(English)

您將獲得的技能

Binary ClassificationData AnalysisMicrosoft ExcelLinear Regression

學生職業成果

23%

完成這些課程後已開始新的職業生涯

21%

通過此課程獲得實實在在的工作福利
可分享的證書
完成後獲得證書
100% 在線
立即開始,按照自己的計劃學習。
可靈活調整截止日期
根據您的日程表重置截止日期。
完成時間大約為21 小時
英語(English)
字幕:英語(English)

提供方

杜克大学 徽標

杜克大学

教學大綱 - 您將從這門課程中學到什麼

內容評分Thumbs Up94%(37,880 個評分)Info
1

1

完成時間為 1 小時

About This Course

完成時間為 1 小時
2 個視頻 (總計 11 分鐘), 2 個閱讀材料
2 個視頻
Introduction to Mastering Data Analysis in Excel6分鐘
2 個閱讀材料
Specialization Overview10分鐘
Course Overview10分鐘
完成時間為 2 小時

Excel Essentials for Beginners

完成時間為 2 小時
8 個視頻 (總計 52 分鐘), 1 個閱讀材料, 2 個測驗
8 個視頻
Basic Excel Vocabulary; Intro to Charting7分鐘
Arithmetic in Excel2分鐘
Functions on Individual Cells3分鐘
Functions on a Set of Numbers10分鐘
Functions on Ordered Pairs of Data8分鐘
Sorting Data in Excel5分鐘
Introduction to the Solver Plug-in8分鐘
1 個閱讀材料
Tips for Success10分鐘
2 個練習
Excel Essentials Practice30分鐘
Excel Essentials30分鐘
2

2

完成時間為 2 小時

Binary Classification

完成時間為 2 小時
6 個視頻 (總計 46 分鐘), 1 個閱讀材料, 2 個測驗
6 個視頻
Bombers and Seagulls: Confusion Matrix8分鐘
Costs Determine Optimal Threshold4分鐘
Calculating Positive and Negative Predictive Values5分鐘
How to Calculate the Area Under the ROC Curve11分鐘
Binary Classification with More than One Input Variable7分鐘
1 個閱讀材料
Tips for Success10分鐘
2 個練習
Binary Classification (practice)30分鐘
Binary Classification (graded)45分鐘
3

3

完成時間為 2 小時

Information Measures

完成時間為 2 小時
7 個視頻 (總計 42 分鐘), 1 個閱讀材料, 2 個測驗
7 個視頻
Probability and Entropy7分鐘
Entropy of a Guessing Game7分鐘
Dependence and Mutual Information3分鐘
The Monty Hall Problem8分鐘
Learning from One Coin Toss, Part 15分鐘
Learning From One Coin Toss, Part 28分鐘
1 個閱讀材料
Tips for Success10分鐘
2 個練習
Using the Information Gain Calculator Spreadsheet (practice)30分鐘
Information Measures (graded)45分鐘
4

4

完成時間為 3 小時

Linear Regression

完成時間為 3 小時
11 個視頻 (總計 73 分鐘), 1 個閱讀材料, 3 個測驗
11 個視頻
Introduction to Standardization4分鐘
Standard Normal Probability Distribution in Excel7分鐘
Calculating Probabilities from Z-scores4分鐘
Central Limit Theorem3分鐘
Algebra with Gaussians6分鐘
Markowitz Portfolio Optimization12分鐘
Standardizing x and y Coordinates for Linear Regression6分鐘
Standardization Simplifies Linear Regression9分鐘
Modeling Error in Linear Regression10分鐘
Information Gain from Linear Regression5分鐘
1 個閱讀材料
Tips for Success10分鐘
3 個練習
The Gaussian (practice)30分鐘
Regression Models and PIG (practice)45分鐘
Parametric Models for Regression (graded)45分鐘

審閱

來自使用 EXCEL 分析数据的熱門評論

查看所有評論

關於 从 Excel 到 MySQL:商业分析技术 專項課程

Formulate data questions, explore and visualize large datasets, and inform strategic decisions. In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process. The Capstone Project focuses on optimizing revenues from residential property, and Airbnb, our Capstone’s official Sponsor, provided input on the project design. Airbnb is the world’s largest marketplace connecting property-owner hosts with travelers to facilitate short-term rental transactions. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion....
从 Excel 到 MySQL:商业分析技术

常見問題

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

  • No. Completion of a Coursera course does not earn you academic credit from Duke; therefore, Duke is not able to provide you with a university transcript. However, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

還有其他問題嗎?請訪問 學生幫助中心