Channel: ExcelIsFun

Category: Education

Tags: business statistical analysispivottable for discrete probability distributiondata analysisesa 25highline collegeexcel statisticsmike girvinimport data from excel filepower querypivottable reportmicrosoft 365 excelbusn 210load to pivottable reportmike excelisfun girvindiscrete probability distributionstatistical analysischapter 5expected valueexcelisfunexcel statistical analysispivottable cachepivottablestandard deviation

Description: Download Excel File: excelisfun.net/files/Ch05-ESA.xlsm Download data import file: 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