Dr. Jerry Burch
Dr. Jerry Burch
  • Видео 101
  • Просмотров 378 180
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.
Multiple Regression
Просмотров 1,1 тыс.2 года назад
Multiple Regression
Predictive Analytics Variance and Standard Deviation
Просмотров 5092 года назад
Predictive Analytics Variance and Standard Deviation
Predictive Analytics Bayes Theorem
Просмотров 4852 года назад
Predictive Analytics Bayes Theorem
Predictive Analytics Probability Concepts
Просмотров 5572 года назад
Predictive Analytics Probability Concepts
Probability using Normal Distribution
Просмотров 4332 года назад
Probability using Normal Distribution
Hypothesis Testing
Просмотров 3192 года назад
Hypothesis Testing
Confidence Interval
Просмотров 3022 года назад
Confidence Interval
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 Z table
Просмотров 2822 года назад
Descriptive Statistics The Z table
Descriptive Statistics The Normal Distribution
Просмотров 9122 года назад
Descriptive Statistics The Normal Distribution
Access Assign 2 Fall 2021
Просмотров 1162 года назад
Access Assign 2 Fall 2021
Access Assignment 1 Step 9
Просмотров 3872 года назад
Access Assignment 1 Step 9
Access Assignment 1 Step 8
Просмотров 2282 года назад
Access Assignment 1 Step 8
Establishing Relationships in Access
Просмотров 512 года назад
Establishing Relationships in Access

Комментарии

  • @HumbertoDaSilvaSantos-pz2nu
    @HumbertoDaSilvaSantos-pz2nu 8 дней назад

    Thank you

  • @louisem.2447
    @louisem.2447 2 месяца назад

    can you show me where to get the pdf? thanks

  • @user-dz5us2tv3q
    @user-dz5us2tv3q 3 месяца назад

    can you send me pdf?

  • @felixoyie936
    @felixoyie936 3 месяца назад

    Great video but how does one find the data mining analysis icon in excel?

  • @kasarfarid8189
    @kasarfarid8189 3 месяца назад

    Can you please share the link or this ppt. The resolution is 480p which is not readable.

  • @pablonutribar8708
    @pablonutribar8708 4 месяца назад

    It does not appear that the data mining tab is possible to use on newer versions of Excel? Kind of useless then..

  • @MichaelReilly-qp8di
    @MichaelReilly-qp8di 4 месяца назад

    Thank you man. saved my night

  • @MichaelReilly-qp8di
    @MichaelReilly-qp8di 4 месяца назад

    your the man jerry!

  • @DDendrite2
    @DDendrite2 4 месяца назад

    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?

  • @moviesflix7082
    @moviesflix7082 4 месяца назад

    No comments?

  • @kendesmarais9018
    @kendesmarais9018 4 месяца назад

    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.

  • @nes9714
    @nes9714 5 месяцев назад

    Where can the add-in for the PCA found in Excel?

  • @Mysteresque
    @Mysteresque 6 месяцев назад

    You are doing great work sir..please care to provide the excel file to follow along please❤❤

  • @mahinaychristine753
    @mahinaychristine753 6 месяцев назад

    What if you don't have yet the given actual value for Jan-21, Feb-21 and Mar-21?

    • @DroppinFactz
      @DroppinFactz 13 дней назад

      Then you use Jan-Sept as data to test against Oct-Dec Sales

  • @geneticsprof
    @geneticsprof 8 месяцев назад

    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.

  • @johnahodgson
    @johnahodgson 8 месяцев назад

    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.

  • @aratirawat11
    @aratirawat11 8 месяцев назад

    Thank you so much sir

  • @dr.strangelove8846
    @dr.strangelove8846 9 месяцев назад

    Dr. Burch how do determine the seed number? What does it mean ?

    • @Iseaaa4322
      @Iseaaa4322 6 месяцев назад

      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.strangelove8846
    @dr.strangelove8846 9 месяцев назад

    Dr. Burch.. This is very helpful. Would you couple of more examples please?

  • @ramlaraya5639
    @ramlaraya5639 9 месяцев назад

    thank you best video

  • @SneakersDD
    @SneakersDD 11 месяцев назад

    Thank you. It's helpful. Could you do more videos on Monte Carlo modeling?

  • @desmoandrew1763
    @desmoandrew1763 Год назад

    thx, this was helpful

  • @andresomar8405
    @andresomar8405 Год назад

    Thanks!

  • @seekingalpha_
    @seekingalpha_ Год назад

    THANKS!!!

  • @riazuddin596
    @riazuddin596 Год назад

    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.?

  • @osamahk4867
    @osamahk4867 Год назад

    Keep going king 🫶

  • @kydkidd
    @kydkidd Год назад

    What is the add-in for the PCA?

  • @falilatbadmus5064
    @falilatbadmus5064 Год назад

    somebody help me please "Posting is only possible with a zero balance; correct document" I am getting this

  • @falilatbadmus5064
    @falilatbadmus5064 Год назад

    i will be acknowledging for this degree

  • @spoon8747
    @spoon8747 Год назад

    Thank youuuuuu because you help me all my homework!!!!

  • @YoutubeChannel-pd2xf
    @YoutubeChannel-pd2xf Год назад

    Thank you!

  • @inakimujika3679
    @inakimujika3679 Год назад

    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

  • @lamhoangmai6310
    @lamhoangmai6310 Год назад

    It's explained well and very helpful.

  • @soorajkumar1137
    @soorajkumar1137 Год назад

    Great stuff!

  • @Hatdogsksk
    @Hatdogsksk Год назад

    Thank you so much!

  • @hansmatthewnierves3168
    @hansmatthewnierves3168 Год назад

    why does this message pop up when I click copy after finding my Quotation? "Ship-to party 26057 not defined for sales area"

  • @ichsanpradana1687
    @ichsanpradana1687 Год назад

    name of tools?

  • @mariecerdan1189
    @mariecerdan1189 Год назад

    Thanks very clear explanation!

  • @AprilWong1978
    @AprilWong1978 Год назад

    Thank you so much, Dr. Burch. You help us do the whole assignment. Greatly appreciated.

  • @AprilWong1978
    @AprilWong1978 Год назад

    Thank you so much. I did share your videos with my classmates. Greatly appreciate your work.

  • @covercouncil2531
    @covercouncil2531 Год назад

    this was very helpful thank you

  • @masontampary3827
    @masontampary3827 Год назад

    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

  • @sabaaslam4766
    @sabaaslam4766 Год назад

    In excel sheet to run multiple regressions, should I use all IV & all control variables as my Independent variable??

  • @prabhusrinivasan676
    @prabhusrinivasan676 Год назад

    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?

    • @dr.strangelove8846
      @dr.strangelove8846 9 месяцев назад

      Let's solve your problem together. Im experiencing something similar

  • @abdullahalamri2787
    @abdullahalamri2787 Год назад

    Thank you

  • @fahad2964
    @fahad2964 Год назад

    Thank you Dr.Jerry that was very helpful

  • @hsfilmproduction
    @hsfilmproduction Год назад

    Is there a pdf of this I can obtain ? Thank You!

  • @kyber10
    @kyber10 2 года назад

    Goated tutorial

  • @PureBasicstuff
    @PureBasicstuff 2 года назад

    I have been trying to do this but in the open items it says no open item added. please help

    • @ponchi123
      @ponchi123 Год назад

      Did you figure it out ? I’m having the same issue.

    • @PureBasicstuff
      @PureBasicstuff Год назад

      @@ponchi123 it is because you have to link the customer with the material/product n then you will have an open item

    • @falilatbadmus5064
      @falilatbadmus5064 Год назад

      @@PureBasicstuff mine is "saying Posting is only possible with a zero balance; correct document "can you help?

  • @sudiproy2738
    @sudiproy2738 2 года назад

    www.apics.org/docs/default-source/scor-p-toolkits/apics-scc-scor-quick-reference-guide.pdf?sfvrsn=