![Dr. Jerry Burch](/img/default-banner.jpg)
- Видео 101
- Просмотров 378 180
Dr. Jerry Burch
Добавлен 19 авг 2020
This channel is designed to provide information and training videos for business and management students and professionals. The primary focus will be on operations management, project management, supply chain management, entrepreneurship, and organizational behavior.
Making a Report in Access
This video shows how to make an Access Report from an Access Query.
Просмотров: 99
Видео
Logistic Regression pruning variables
Просмотров 151Год назад
This video discusses how to use the Excel Add-In Solver to perform logistic regression and then discusses how to remove variables from the prediction model.
Logistic Regression using Solver
Просмотров 2,4 тыс.Год назад
This video shows how to performa a Logistic Regression using Solver and then discusses how to calculate the probability of success using the outputs from Solver. In addition, the video discusses how to interpret the coefficients and whether or not the model is a reasonable model using the confusion matrix.
k means clusters
Просмотров 177Год назад
This video shows you how to perform k-means cluster analysis using Solver and then how to interpret the results and select the proper number of clusters.
Principal Component Analysis with Excel Solver
Просмотров 16 тыс.Год назад
This video shows how to do Principal Component Analysis using Excel Solver.
Project Management Excel Task 4
Просмотров 122Год назад
This video shows you how to track time constraints and make adjustments to your project schedule in Excel.
Creating a Gantt Chart in Excel
Просмотров 191Год назад
This video shows how to create a Gantt Chart in Excel after setting the predecessors, start days and end days associated with t a project. It is associated with Assignment 3 of the Project Management course.
Regression with Control Variables using R
Просмотров 3,8 тыс.Год назад
This video uses the Oregon Health Insurance Experiment data from the Taddy, Hendrix, and Harding Modern Business Analytics textbook to predict the average treatment effect while controlling for a different variable.
Project Management Assignment 2
Просмотров 698Год назад
In this assignment you will be calculating a total cost of labor your your project by creating a table with the associated human resource hourly costs, assigning human resources to each task, and then using a vlookup function to calculate the cost for each task.
Logistic Regression with R
Просмотров 263Год назад
This video uses the spam.csv file to create a logistics regression that could be used to predict whether a email is spam or not spam.
ISM3116 Final Exam
Просмотров 6582 года назад
This video gets you started with the final exam for ISM3116.
Monte Carlo Simulation using Excel
Просмотров 38 тыс.2 года назад
This video shows you how to do a one-variable Monte Carlo Simulation with a normal distribution using Excel and how to use the results.
k nearest neighbors
Просмотров 4032 года назад
This video shows you how to perform a k nearest neighbors cluster analysis using the Solver Excel Add-on.
Unstructured Data Mining using Heirarchical Cluster analysis
Просмотров 3082 года назад
This video shows how to use Heirarchical Cluster Analysis to perform unstructured data mining of data to identify potential clusters that help identify the properties of the data set.
Unstructured Data Mining Using PCA
Просмотров 3592 года назад
This video shows how to use Principal Component Analysis as an unstructured data mining technique to identify underlying relationships in data.
Predictive Analytics Variance and Standard Deviation
Просмотров 5092 года назад
Predictive Analytics Variance and Standard Deviation
Predictive Analytics Probability Concepts
Просмотров 5572 года назад
Predictive Analytics Probability Concepts
Probability using Normal Distribution
Просмотров 4332 года назад
Probability using Normal Distribution
Descriptive Statistics Making sense of the sample
Просмотров 3362 года назад
Descriptive Statistics Making sense of the sample
Descriptive Statistics Calculating probabilities with Z statistics
Просмотров 3022 года назад
Descriptive Statistics Calculating probabilities with Z statistics
Descriptive Statistics The Normal Distribution
Просмотров 9122 года назад
Descriptive Statistics The Normal Distribution
Thank you
can you show me where to get the pdf? thanks
can you send me pdf?
Great video but how does one find the data mining analysis icon in excel?
Can you please share the link or this ppt. The resolution is 480p which is not readable.
It does not appear that the data mining tab is possible to use on newer versions of Excel? Kind of useless then..
Thank you man. saved my night
your the man jerry!
Thank you very much for sharing. I'd like to do this myself on a dataset. Can you confirm you used the Analytic Solver Data Science extension from Frontline Solvers?
No comments?
No comments
@@DeepakYadav-ys7dg yeah No comments
I think you forgot to mention that we need to add in an additional software package such as XLSTAT or something like that. That sure would have saved me a bunch if time trying to figure out why I don’t see the correct tabs.
Where can the add-in for the PCA found in Excel?
You are doing great work sir..please care to provide the excel file to follow along please❤❤
What if you don't have yet the given actual value for Jan-21, Feb-21 and Mar-21?
Then you use Jan-Sept as data to test against Oct-Dec Sales
Hi Dr Burch - Ditto to questioner below. In Microsoft 365 Excel, I can't find 'Data Mining' tab. I used to be able to do PCA in Excel, and crank out component scores & latents. Suggestions, please.
FYI - Note that your calculation on trend shows a 0.0006 slope... but that's a slope PER DAY. A little mental math shows that that equates to a few percent a year.
Thank you so much sir
Dr. Burch how do determine the seed number? What does it mean ?
if I may answer, seed is like the number to randomly generate the data, it can be any number, but if you wish to have the same random data, use the same seed number, I think
Dr. Burch.. This is very helpful. Would you couple of more examples please?
thank you best video
Thank you. It's helpful. Could you do more videos on Monte Carlo modeling?
thx, this was helpful
Thanks!
THANKS!!!
Thank you for sharing these excellent tutorials. Could you please tell me how can I add this Analytic solver and Data mining extension in my excel.?
Keep going king 🫶
What is the add-in for the PCA?
somebody help me please "Posting is only possible with a zero balance; correct document" I am getting this
i will be acknowledging for this degree
Thank youuuuuu because you help me all my homework!!!!
Thank you!
Is there more detail of each part somewhere? Is good to know the general label for example in cost KPI, but it will be more an standard framework if the detail on how to do are public
It's explained well and very helpful.
Great stuff!
Thank you so much!
why does this message pop up when I click copy after finding my Quotation? "Ship-to party 26057 not defined for sales area"
name of tools?
Thanks very clear explanation!
Thank you so much, Dr. Burch. You help us do the whole assignment. Greatly appreciated.
Thank you so much. I did share your videos with my classmates. Greatly appreciate your work.
this was very helpful thank you
Dr. Burch, I'm having trouble understanding how you got the square root of 9,970 as 3,158. I have the square root of 9,970 as roughly 99.85. Can you please comment how you got 3,158? Thank you, Mason
In excel sheet to run multiple regressions, should I use all IV & all control variables as my Independent variable??
Using a mathematical model, I have estimated some system parameters using Kalman filter. Now I have to verify whether the proposed system is robust against uncertainties. I have estimated data and true sensor data. How to do Monte Carlo analysis with the above mentioned information?
Let's solve your problem together. Im experiencing something similar
Thank you
Thank you Dr.Jerry that was very helpful
Is there a pdf of this I can obtain ? Thank You!
Hi. Can I have your email. I have the pdf!
Goated tutorial
I have been trying to do this but in the open items it says no open item added. please help
Did you figure it out ? I’m having the same issue.
@@ponchi123 it is because you have to link the customer with the material/product n then you will have an open item
@@PureBasicstuff mine is "saying Posting is only possible with a zero balance; correct document "can you help?
www.apics.org/docs/default-source/scor-p-toolkits/apics-scc-scor-quick-reference-guide.pdf?sfvrsn=