Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about how to create X-Y Linear Data Scatter Charts from X-Y data in Excel using Excel Charts and the Microsoft Artificial Intelligence Data Analyze Button.
Topics:
1. (00:00) Introduction
2. (00:34) First X-Y Scatter Data Set: Hours Studied X and Test Scores Y
3. (00:55) Relationship can be revealed with raw data evidence
4. (01:24) Positive or Direct Relationship
5. (01:50) Three Typical Relationships in Linear X-Y Data; Positive, Negative or No Relationship
6. (02:33) Requirements for X-Y Scatter Chart
7. (04:35) Plot Data with a Positive Relationship: Hours Studied vs. Test Score. Learn the Manual Method with Excel Charts.
8. (06:32) Add Trendline with Equation and R^2
9. (07:39) Plot Data with a Positive Relationship: # Ads vs. Sales. Microsoft Artificial Intelligence (AI) Data Analyze Data button Method.
10. (09:32) Plot Data with a Negative Relationship: Class Absences vs. Class Final Grade. Analyze Data button Method.
11. (10:41) Plot Data with a No Relationship: Customer Age vs. Amount Spent. Analyze Data button Method.
12. (11:40) Conclusion
13. (12:18) Closing and Video Links