Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm Download data import file: https://excelisfun.net/files/MonclaireGolf.xlsx
Learn about how to import Excel Data with Power Query and load the table directly to the PivotTable, then build a Discrete Probability Distribution and calculate Expected Value and Standard Deviation.
Topics:
1. (00:00) Introduction
2. (00:31) Importing data into Excel: CSV or Excel file.
3. (01:13) Look at objects in Excel file.
4. (02:00) Look at Gold Data Table and discuss Goals of Project.
5. (02:46) Power Query to Import One Table from Excel Workbook file.
6. (04:22) Import To PivotTable Report (PivotTable Cache) rather than loading the data to the worksheet.
7. (05:28) Use PivotTable to create Discrete Probability Distribution for Golf Data.
8. (07:44) Adding a Variable to Row Area of PivotTable that is in Source Data Set is NOT possible. If that if your goal, switch over to formulas. Video shows Example.
9. (09:28) Calculate Probabilities from Discrete Probability Distribution.
10. (10:23) Calculate Expected Value (Mean) from Discrete Probability Distribution.
11. (10:49) Calculate Variance and Standard from Discrete Probability Distribution.
12. (11:54) Summary of video
13. (12:30) Closing and Video Links

ExcelIsFunMon, March 14, 2022 6:20pm