Видео

I have a bug, as my sheet only clears the first line and the code doesn't make it to the second clear line, and it doesn't print the MsgBox to the screen. Any suggestions on what I need to do?

SUPERB. very clear and complete too.

Rare video which explains partial R square calculation👍👍 great work

Thank you so much :*

Although the recording equipment needs to be upgraded, I love the idea of recording the book club. There would be a lot of value in a book club that discussed all the books featured on EconTalk too.

I came across this and it was extremely helpful. Thanks very much.

Life Saver!!!! GREAT instructions!!! Easy to follow!!

You are an absolute lifesaver. THANK YOU!

Thanks a lot! The video is really helpful

You are a life saver

Just a little note on this video, for the IF function you put in a greater than sign for .001 but you say less than so its a little confusing

Thank you. This is the best tutorial on histograms on Excel and so well presented.

Thank you!!!

have a calculation that I would like to put into excel if not in the vba form then make it do the calculation on the spread sheet once I have sent the day to the sheet the calculation is for determining the productivity rate of a excavator it looks like this: 3600s / hr x 3 cy x.85 divided by 20.S' / cycle X 50min/60min X 1/(1+35) the answer is 283.bcy/hr but I dont know how to write it in excel or vba

This is awesome. Is there a code to add a safety so it can’t be deleted by accident? For example, it won’t clear until you click on the “ok” in the msg box.

Yes, there will be an update soon.

Thank you

Very hard to see this considering its only a quarter of the screen

My Clear Form button is also clearing the Conditional Formatting in some of the cells. Some cells I have highlighted when they're blank and once data is entered in the cell the highlighting goes away. When I hit my Clear Form button the data in the cells clears as it should but many of the cells don't go back to being highlighted. If i click in those cells and hit Delete then the cell highlights again, so it's acting as though there's still data in the cell after I hit the Clear Form button. Why do only some cells do this? I've tried reformatting the cells, clearing and re-entering the Conditional Formatting, clearing and re-entering the code for the Form Clear button, and even to the point where I've cleared all formatting from those cells, recreated the cell and added the Conditional Formatting, but the same thing happens to the same cells over and over, no matter what I do. Any thoughts on why this is happening?

Thank you so much! This was extremely helpful regarding my Stats class :)

Here is a link to the data: faculty.sfasu.edu/phelpsrt/youtubefiles/Percent_Polygons_DAToolPak.xlsx

Here is a link to the file: faculty.sfasu.edu/phelpsrt/youtubefiles/hypothetical_grade_book_formulas.xlsx

Here is the link to the file: faculty.sfasu.edu/phelpsrt/youtubefiles/hypothetical_grade_book.xlsx

Here is the link to the file: faculty.sfasu.edu/phelpsrt/youtubefiles/hypothetical_grade_book_pivot.xlsx

Here is the link to the file: faculty.sfasu.edu/phelpsrt/youtubefiles/movie_contingency.xlsx

It is actually called a percentage polygon. "Percentage polynomial" was an error.

Here is the link for the data: faculty.sfasu.edu/phelpsrt/youtubefiles/hypothetical_grade_book_pivot.xlsx

hello. how do we reset selected radio buttons in a box (excel)? thank you so much

Thank You...

Thank you - great tutorial! Appreciate it

Sir, can you please tell me where I can learn about excel VB and macros online for free.

Ok... How about sharing the data-file? So that we can work in parallel...

This video has been really helpful, thank you for uploading

thank you worked like a charm, it is usefull if the code is in the descriptio or in a Comment. so here you go Private Sub NameOfYourButton_Click() Sheets("NameOfSheet").Range("A1:A1").Value = "" MsgBox "form cleared" End Sub

Thank you for your video. I have a question. You calculated the partial r-square by (SSR_full - SSR_without)/SSE_without. But the formula for a general r-square is SSR/SST(total sum of squares). Do you know why the denominator SSE is used instead of SST?

Even in HD, the video resolution is too low to read much of the font for some of the functions; that or the text is too small. . The screen on my laptop is pretty sizable; when the video is only partly filling the screen, the text is too small, and when it's full screen, the resolution at times is too low. . Still very helpful overall though.

It was exactly what I was looking for, thanks

Thank you, you made it very easy to understand this process and I was able to complete my homework in a breeze

At 5:44 , what are you putting into the custom formatting? [0.000....