- 833
- 1 528 428
Stephanie Powers
Canada
Приєднався 22 вер 2013
Introductory college courses in management and economics taught by Dr. Stephanie Powers in Alberta, Canada.
Dashboard in Power BI
How to create a dashboard in Power BI including the creation of donut plots, line charts, tables, gauges, cards, and sankey diagrams. The datasets used in this video are available at github.com/DrStephPowers/BIA/tree/main/DATA
Переглядів: 50
Відео
Lasso Regression in Python
Переглядів 992 місяці тому
Using Lasso Regression to address overfitting in multiple variable linear regression. Python workbook available here: drstephpowers.github.io/BIA/
Ridge Regression in Python
Переглядів 632 місяці тому
Using ridge regression to address overfitting in a multiple variable regression model. Python workbook available here: drstephpowers.github.io/BIA/
Linear Regression Assumptions
Переглядів 292 місяці тому
Testing the assumptions of linear regression by creating a residual plot and a QQ plot in Python. Python workbook available at: drstephpowers.github.io/BIA/
Linear Regression in Python (smf and sklearn)
Переглядів 1102 місяці тому
How to perform multiple variable linear regression in Python. What variables have an impact on an outcome variable that is a measurement. Python workbook available here: drstephpowers.github.io/BIA/
Poisson Regression in Python (smf and sklearn)
Переглядів 932 місяці тому
Performing multiple variable Poisson Regression in Python. What variables have a significant impact on the counts. Python workbook available here: drstephpowers.github.io/BIA/
Missingness in Data
Переглядів 252 місяці тому
The difference between Missing Completely at Random (MCAR), Missing at Random (MAR), and Missing Not at Random (MNAR).
Logistic Regression in Python (smf and sklearn)
Переглядів 952 місяці тому
How to perform multiple variable logistic regression in Python. What variables have an impact on an outcome variable that is binary (event happens or does not) Python workbook available here: drstephpowers.github.io/BIA/
Association Rule Analysis
Переглядів 613 місяці тому
ARA or market basket analysis considers which products customers buy together. This video shows how to calculate support, confidence, and lift ratios to create association rules. Using the apriori method and Python, you can construct association rules. The Python workbook is available here: drstephpowers.github.io/BIA/
Marketing Analytics
Переглядів 763 місяці тому
A review of the different analytics tools used in marketing analytics. These tools include A/B testing, cluster and classification, regression, forecasting, and more. Each of the tools are covered in more detail in other videos. For the Python code used with each method, please see: drstephpowers.github.io/BIA/
Creating a Dashboard with Streamlit
Переглядів 4143 місяці тому
How to create a dashboard using Streamlit in Python. The code and sample datasets are available at drstephpowers.github.io/BIA/
Sankey Diagrams with Holoview and Plotly
Переглядів 2253 місяці тому
How to create sankey diagrams using holoview and plotly to convey the flow of information. The workbook and sample code are available at drstephpowers.github.io/BIA/
Centre of Gravity Method Using Python
Переглядів 2314 місяці тому
How to use Python to determine the location of your distribution centre based on the amount of inventory and the locations of the companies you are supplying.
Regression: Testing Assumptions
Переглядів 565 місяців тому
This video covers the assumptions of linear regression. Use a residual plot and q-q plot to test the assumptions in Excel (Data Analysis Tool Pak) or Python.
Regression: Standard Error of Estimate
Переглядів 365 місяців тому
Use the standard error of the estimate to create confidence intervals for the mean value of y for a given value of x. Use the standard error of the estimate the sum of squares of x to find the prediction interval for an individual value of y for a given value of x. Use Excel Data Analysis Tool Pak or Python to get the information necessary to build confidence or prediction intervals.
Hypothesis Testing: 2 Sample Proportions Test
Переглядів 455 місяців тому
Hypothesis Testing: 2 Sample Proportions Test
Hypothesis Testing: Two Sample Separate Variance T Test
Переглядів 375 місяців тому
Hypothesis Testing: Two Sample Separate Variance T Test
Hypothesis Testing: One Sample Proportions Test
Переглядів 315 місяців тому
Hypothesis Testing: One Sample Proportions Test
Hypothesis Testing: Two Sample Pooled T Test
Переглядів 295 місяців тому
Hypothesis Testing: Two Sample Pooled T Test
Hypothesis Testing: One Sample T-Test
Переглядів 305 місяців тому
Hypothesis Testing: One Sample T-Test
Hypothesis Testing: One Sample Z Test
Переглядів 525 місяців тому
Hypothesis Testing: One Sample Z Test
good day. you are awwwwwwwsmmmm. but I finally found a video that I could leave comments, just so that I could contact you and ask a question. your economics graph, how to create supply and demand graph in excel. do you know how to do it with apple iMac? some of the techniques on Microsoft excel don't appear to be accessible in excel iMac. please advise. thank you. chris.
If using a Mac you follow the same procedure. Select scatterplot from the Insert tab. Then right click on the chart and choose Select Data. The menu screen looks different but has the same components (series list, x series, y series, and name). Empty the series list on the left (with - sign). Add each component just like in the video.
Wonderful explanation
awesome
that was awsum explanation..
Wonderful explanation ! Thank you