EngSuite
EngSuite
  • 297
  • 97 928
How to use the QESuite Specification Parameter
00:00 Specification Parameter
01:02 Manual Specification Input
01:33 Cell as Input
01:45 Error 5003.1
01:59 (Nom±Tol) Symmetric 2-Sided
02:31 (Nom+/-Tol) Symmetric 2-Sided
03:03 (Nom+-Tol) Symmetric 2-Sided
03:21 (Nom+UTol/-LTol) Asymmetric 2-Sided
04:24 (LSL--USL) Range Tolerance
05:01 (LSL) Single Sided
06:14 (MIN#) Single Sided
06:40 (USL) Single Sided
07:18 (MAX#) Single Sided
มุมมอง: 172

วีดีโอ

Retry & Cancel MsgBox Buttons - Excel VBA
มุมมอง 1004 หลายเดือนก่อน
In this video we will learn how to create Retry & Cancel button MsgBox in Excel VBA. This opens us up to using MsgBox to interact with the user and give them more control in our automated workbooks. This video was taken from the longer tutorial here: th-cam.com/video/bPbNXM9xHq4/w-d-xo.html More Excel VBA tutorials here: th-cam.com/play/PLJWeb5_BSlfMESJWt0gCFTWrT8x0HwXn1.html Engineering Statis...
Abort, Retry & Ignore MsgBox Buttons - Excel VBA
มุมมอง 594 หลายเดือนก่อน
In this video we will learn how create Abort, Retry & Ignore button MsgBox in Excel VBA. This opens us up to using MsgBox to interact with the user and give them more control in our automated workbooks. This video was taken from the longer tutorial here: th-cam.com/video/bPbNXM9xHq4/w-d-xo.html More Excel VBA tutorials here: th-cam.com/play/PLJWeb5_BSlfMESJWt0gCFTWrT8x0HwXn1.html Engineering St...
Okay & Cancel MsgBox Buttons - Excel VBA
มุมมอง 914 หลายเดือนก่อน
In this video we will learn how create Okay and Cancel button MsgBox in Excel VBA. This opens us up to using MsgBox to interact with the user and give them more control in our automated workbooks. This video was taken from the longer tutorial here: th-cam.com/video/bPbNXM9xHq4/w-d-xo.html More Excel VBA tutorials here: th-cam.com/play/PLJWeb5_BSlfMESJWt0gCFTWrT8x0HwXn1.html Engineering Statisti...
Yes/No MsgBox Buttons - Excel VBA
มุมมอง 1624 หลายเดือนก่อน
In this video we will learn how to a Yes/No input MsgBox in Excel VBA. This opens us up to using MsgBox to interact with the user and give them more control in our automated workbooks. This video was taken from the longer tutorial here: th-cam.com/video/bPbNXM9xHq4/w-d-xo.html More Excel VBA tutorials here: th-cam.com/play/PLJWeb5_BSlfMESJWt0gCFTWrT8x0HwXn1.html Engineering Statistics Videos he...
Get User Input from MsgBox - Excel VBA
มุมมอง 314 หลายเดือนก่อน
In this video we will learn how to get user input from MsgBox in Excel VBA. This opens us up to using MsgBox to interact with the user and give them more control in our automated workbooks. This video was taken from the longer tutorial here: th-cam.com/video/bPbNXM9xHq4/w-d-xo.html More Excel VBA tutorials here: th-cam.com/play/PLJWeb5_BSlfMESJWt0gCFTWrT8x0HwXn1.html Engineering Statistics Vide...
Complete Guide to MsgBox - Excel VBA
มุมมอง 615 หลายเดือนก่อน
In this video we will learn the basics of MsgBox in Excel VBA so that we can include them in our future workbooks. More Excel VBA tutorials here: th-cam.com/play/PLJWeb5_BSlfMESJWt0gCFTWrT8x0HwXn1.html Engineering Statistics Videos here: th-cam.com/play/PLJWeb5_BSlfMmMW-VqJVmHGDwO66lg5Ka.html For support or inquiries please contact our support line: rr.help@engusite.org Excel MsgBox Documentati...
Create Automatic Table Names Using CONCAT()
มุมมอง 305 หลายเดือนก่อน
CONCAT is a criminally underutilized function in Excel because most people don't know it exists. In this video we will learn how to use CONCAT to dynamically name our report. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Count Returning Customers - CountWithDuplicates
มุมมอง 185 หลายเดือนก่อน
Learn how to identify and count returning individuals from customer data in Excel. To do this we will need to create another really useful custom function. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Counting Unique Individuals from Customer Data
มุมมอง 115 หลายเดือนก่อน
Learn how to identify and count unique individuals from customer data in Excel. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Calculating Average Daily Amounts By Month - DaysInMonth
มุมมอง 285 หลายเดือนก่อน
Learn how to calculate average daily amounts by creating a function that returns the amount of days in each month. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Advanced Filtering Methods IfArray - Excel User Defined Functions
มุมมอง 335 หลายเดือนก่อน
Learn how to create advanced filtering options to make your spreadsheets more efficient using a really cool custom function. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Filtering Arrays Using Multiple Conditions
มุมมอง 225 หลายเดือนก่อน
Learn how to Filter and Count your data using multiple conditions. Using custom functions we can create incredible automated reporting spreadsheets. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Getting Categories from a Table using UNIQUE()
มุมมอง 245 หลายเดือนก่อน
Learn how to use UNIQUE() in a practical way to make your automatic reporting easier. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Dropdown Menu in Cells using Data Validation - Excel Tutorials
มุมมอง 515 หลายเดือนก่อน
Learn how to quickly add drop down menus in Excel using the Data Validation feature. This video was taken from the longer tutorial here: th-cam.com/video/aJ9Pvmz9cqE/w-d-xo.html
Automatic Monthly Reporting With Excel VBA - VBA Intermediate Tutorials
มุมมอง 1255 หลายเดือนก่อน
Automatic Monthly Reporting With Excel VBA - VBA Intermediate Tutorials
How to Cancel/Prevent Events Excel VBA
มุมมอง 1736 หลายเดือนก่อน
How to Cancel/Prevent Events Excel VBA
Worksheet Pivot Table Update - Excel VBA
มุมมอง 1406 หลายเดือนก่อน
Worksheet Pivot Table Update - Excel VBA
Worksheet Follow Hyperlink Event Handler - Excel VBA
มุมมอง 1696 หลายเดือนก่อน
Worksheet Follow Hyperlink Event Handler - Excel VBA
Worksheet Selection Change Event Handler - Excel VBA
มุมมอง 2596 หลายเดือนก่อน
Worksheet Selection Change Event Handler - Excel VBA
Cell Change Event - Excel VBA
มุมมอง 927 หลายเดือนก่อน
Cell Change Event - Excel VBA
Worksheet Calculate Event Handler Excel VBA
มุมมอง 3607 หลายเดือนก่อน
Worksheet Calculate Event Handler Excel VBA
Worksheet Before Right Click Event Handler - Excel VBA
มุมมอง 1307 หลายเดือนก่อน
Worksheet Before Right Click Event Handler - Excel VBA
Worksheet Before Double Click Event Handler - Excel VBA
มุมมอง 2627 หลายเดือนก่อน
Worksheet Before Double Click Event Handler - Excel VBA
Worksheet Activate and Deactivate Event Handlers - Excel VBA
มุมมอง 2377 หลายเดือนก่อน
Worksheet Activate and Deactivate Event Handlers - Excel VBA
Complete Guide to Worksheet Events Excel VBA
มุมมอง 1317 หลายเดือนก่อน
Complete Guide to Worksheet Events Excel VBA
Delete Shapes - Excel VBA
มุมมอง 1977 หลายเดือนก่อน
Delete Shapes - Excel VBA
Convert Excel Shapes into Pictures - Excel VBA
มุมมอง 907 หลายเดือนก่อน
Convert Excel Shapes into Pictures - Excel VBA
Rename a New Group of Shapes - Excel VBA
มุมมอง 1917 หลายเดือนก่อน
Rename a New Group of Shapes - Excel VBA
Ungroup Shapes - Excel VBA
มุมมอง 997 หลายเดือนก่อน
Ungroup Shapes - Excel VBA

ความคิดเห็น

  • @robertbennett972
    @robertbennett972 หลายเดือนก่อน

    Listen I can barely see the words in your display.

  • @curiosity_prime
    @curiosity_prime หลายเดือนก่อน

    Concise and direct! Thanks so much for the help

  • @UnwantedHouseGuestXD
    @UnwantedHouseGuestXD หลายเดือนก่อน

    not helpful

  • @utku_bambu
    @utku_bambu 2 หลายเดือนก่อน

    finally someone who shows all the equations behind the process, thank you

  • @sauldejesus1073
    @sauldejesus1073 2 หลายเดือนก่อน

    After watching this video I can conclude that I don't even know how to use Excel!

  • @donaldbiden636
    @donaldbiden636 2 หลายเดือนก่อน

    pls make tutorial on how to make the shape reflections face up

  • @julesmarinas-io4yg
    @julesmarinas-io4yg 2 หลายเดือนก่อน

    My excel don’t have it lol

    • @engsuite3958
      @engsuite3958 2 หลายเดือนก่อน

      Hi Jules, This function is part of our Excel add-in QESuite. Here is a link to our video that shows you how to start the free trial: th-cam.com/video/AtviOYDI3OI/w-d-xo.html If you have any questions getting started please reach out to our support team at rr.help@engsuite.org and someone can assist you. Thank you, EngSuite Support Team rr.help@engsuite.org

  • @LeonardoKasei
    @LeonardoKasei 3 หลายเดือนก่อน

    Thanks for the lesson. Could you, please, help me? I have a variable that formulates the name of a shape by concatenating (origem = "clu" & Worksheets(2).Cells(i, 2) & "." & tsI ) . I would like to use the content of that variable (origem = "clu1.1", for example) to select a Shape I have already created. Is that possible?

  • @TheMcGoblin
    @TheMcGoblin 3 หลายเดือนก่อน

    Hello. tried to install the add in but everytime i try to use it it returns an error showing #Bussy.error, what am i doing wrong?

    • @engsuite3958
      @engsuite3958 3 หลายเดือนก่อน

      Hi, A #Busy error could be caused by a few different issues. Please reach out to our support team (rr.help@engsuite.org) with a screenshot of your formula so that they can take a look at the formula that you used. Thank you!

  • @khushiaggarwal-e8j
    @khushiaggarwal-e8j 3 หลายเดือนก่อน

    Heyy, thank you for this method! Made my life so easier! Could you share the reference for this video? I wanna know how you got the piece function for p values, and why are we using AD*

  • @relevant3329
    @relevant3329 3 หลายเดือนก่อน

    Thanks!

  • @C-AnilM
    @C-AnilM 4 หลายเดือนก่อน

    Why subscriber?? People don't want quality information

  • @ChelseaRedding-b5n
    @ChelseaRedding-b5n 4 หลายเดือนก่อน

    Volume consistency needs work

  • @HeruCool-q9j
    @HeruCool-q9j 4 หลายเดือนก่อน

    how to save shape as picture automatically with vba? without using 3rd party apps or API

  • @choir2008
    @choir2008 4 หลายเดือนก่อน

    For the case in the null hypothesis that the distrubtion is not known, should the funcion in C2 be empitrical distrbution function? The example provided for C2 in the video is that the distribution in Null hypotheis is normal distribution.

  • @choir2008
    @choir2008 4 หลายเดือนก่อน

    For those numbers used to constrol piece-wise function e.g. 1.2937 are they always fixed no matter what our underlying data is?

  • @choir2008
    @choir2008 4 หลายเดือนก่อน

    P value shoud be compared with significant level not crtical value.

  • @falagamer153
    @falagamer153 5 หลายเดือนก่อน

    Muito obrigado por sua ajuda... i am learning a lot... thank you so much for help me to improve myself

    • @engsuite3958
      @engsuite3958 5 หลายเดือนก่อน

      That's great to hear! Were you able to get the function working in Excel?

  • @BNT05
    @BNT05 5 หลายเดือนก่อน

    Thank you for providing this content. You have been quite helpful, and I believe this is not only for me. ●So, did I get correctly that if an A-D value is higher, it corresponds to a lower p-value and hence a higher risk of rejecting Ho that assumes the distribution comes from a specifed distribution (i.e., normal distribution) when the p-value is less than the significance level? ●Is it accurate to argue that the smaller the A-D value, the more likely your distribution is to be normal because the p-value will be larger (above the significance level), allowing Ho to assume that the distribution is from the specified distribution? ● The higher A-D value, the lower p-value and the higher chance of rejecting Ho? ●Otherwise, how should the A-D value be used in respect to the p-value? Thank you in advance.

    • @engsuite3958
      @engsuite3958 5 หลายเดือนก่อน

      Hello, Yes, you are correct that a higher AD value corresponds to a lower p-value and a higher risk of rejecting H0. And yes, the inverse of that would also be true: a smaller AD value corresponds to higher p-value and thus failing to reject the null hypothesis. - IMPORTANT - However, I would not recommend using the AD value to make your conclusions about normality because the p-value calculation also takes the sample size into account. This is one of the main reasons we use the p-value. It standardizes the criteria across sample sizes. Another important reason that we use p-values is because it is directly linked to the risk of Type I Error, this means that by specifying our alpha (generally 0.05) we are actually specifying the acceptable risk of Type I Error at our specific sample size. - CONCLUSION - The p-value is a standardized statistic that allows us to control Type I Error and to ensure that sample size effects are properly controlled. The AD test statistic is still important but should not be used by itself to make conclusions.

    • @BNT05
      @BNT05 5 หลายเดือนก่อน

      @@engsuite3958 Thank you for your insights here. Well noted. Keep up this good work 👏

  • @ABZein
    @ABZein 6 หลายเดือนก่อน

    ❤❤❤❤

  • @Shaunmcdonogh-shaunsurfing
    @Shaunmcdonogh-shaunsurfing 6 หลายเดือนก่อน

    Excellent video

  • @Dergicetea
    @Dergicetea 7 หลายเดือนก่อน

    I really liked so much the approach of this video through the lens of engineering 👏🏼

  • @renieloanes1785
    @renieloanes1785 7 หลายเดือนก่อน

    Thank you for this straight to the point tutorial. This is exactly what I need.

  • @NoNamosss
    @NoNamosss 7 หลายเดือนก่อน

    Isn’t this the Kuiper Test?

    • @engsuite3958
      @engsuite3958 7 หลายเดือนก่อน

      Hi, The Kuiper Test and Kolmogorov-Smirnov Test are both very similar. They both use the maximum discrepancies from the CDF to calculate a test statistic. The difference between the two is that the Kolmogorov-Smirnov Test Statistic is the overall maximum discrepancy MAX(D+, D-) whereas the Kuiper Test Statistic is the sum of the maximum discrepancies above and below the CDF SUM(D+, D-).

  • @sesppsfd3815
    @sesppsfd3815 8 หลายเดือนก่อน

    Cool

  • @Daciouskasoka
    @Daciouskasoka 9 หลายเดือนก่อน

    Very helpful, thank you.

  • @uredevora
    @uredevora 10 หลายเดือนก่อน

    thankyou so much! i am from Indonesia and currently studied statistics in college, this video really helps me out, definitely would recommend you to my friends!

    • @engsuite3958
      @engsuite3958 10 หลายเดือนก่อน

      That is great to hear! If you are interested in Normality testing, especially if you're studying statistics, you should check out this video: th-cam.com/video/WKyAYsqTSCM/w-d-xo.html It might change how you see the AD Test. Thanks, Lucius LaFromboise

  • @hawtpotato90210
    @hawtpotato90210 10 หลายเดือนก่อน

    first

  • @javedahmed8343
    @javedahmed8343 ปีที่แล้ว

    Great

  • @stefanperko
    @stefanperko ปีที่แล้ว

    f(x) does NOT give you the probability of x occurring. That probability would be zero.

    • @BITStudioCode
      @BITStudioCode 2 หลายเดือนก่อน

      Also wondering the same. It is on an interval right?

  • @exploreyourdreamlife
    @exploreyourdreamlife ปีที่แล้ว

    I used to stress about managing normality in excel, but this video provided a fresh perspective. Much respect to the creator for simplifying it! Liked and Subbed!

  • @exploreyourdreamlife
    @exploreyourdreamlife ปีที่แล้ว

    Amazing and straightforward. This Normality test is a dream guide for every expert Liked and Subbed!

  • @neeleshanand6863
    @neeleshanand6863 ปีที่แล้ว

    'QE.CAPABILITYANALYSIS' is always returning #VALUE! error, even though all data is as per the video. Do you have sample excel file from the demo somewheare on the cloud? Can you share the link?