Thank you, Rodrigo!!!! You are a great Teammate in the way you leave comments and appreciation. It helps me to keep making more videos for you and the rest of our World Team!!!!
Your excellency, you did not dissapointed me from the (box-and-whisker) plot. (see the comment) thank you so much again. May god bless you and wish you the best in every thing.
Hello Mike, I must say that I got some recognition in my company and all credit goes for that to you. I love your videos and your way of teaching. Whatever I've learn till now, is because of you. I've a small question about the frequency distribution. What if the bin sizes are not fixed, For example, suppose the first bin would be 2 - 3 followed by 3 - 5, 5 -50 and > 50. Currently I'm putting this information in different sheet and pulling the data with the help of vlookup. Kindly advise.
Great videos!! They have been a tremendous help! Question: When saying 0 up to 50 doesn't that mean 50 or less? Everything up to 50 (49.9999999999... but NOT including 50).
great video! I have a question? pivot table is so convient to get a chart or table. but since the data i am dealing with is stochastic(every time i run, the data is different) i found that pivot table doesn't change automatically. how can i fix it? or when dealing with stochastic data, we can only use traditional way? thanks so much!!
Hey please do a video on this or guide me here. I NEED TO HAVE DATA ANALYSIS ADD IN first to do this. Suppose you measure the number of minutes it takes an employee to complete a task, where the maximum allowed time is 5 minutes, and each time is rounded to the nearest minute. Data from 130 employees is summarized below. Construct a frequency bar chart and a pie chart from this data. How long did it take most employees to complete the task? time: 1, 2, 3, 4, 5 frequency: 15, 30, 45,25, 20
I want to refer to the percentage cell in this way, ="This had a percentage of "&C5 but the formatting does not remain as a percentage, it turns it into a decimal. Any ideas how I can keep the format as percentage when referring to the cell? Many thanks
Best teacher I ever had, Mike I will never get tired of thanking you and acknowledging how talented you are.
Thank you, Rodrigo!!!! You are a great Teammate in the way you leave comments and appreciation. It helps me to keep making more videos for you and the rest of our World Team!!!!
Excel file at link below video - statistics 2010 - Week 2
No video download
I am glad that you like it!
You will have to create a second set of data and add it to the chart "Change Source Data" button.
Your excellency, you did not dissapointed me from the (box-and-whisker) plot. (see the comment) thank you so much again. May god bless you and wish you the best in every thing.
You are welcome!!
@jahshappybus , you are welcome!
Hello Mike, I must say that I got some recognition in my company and all credit goes for that to you. I love your videos and your way of teaching. Whatever I've learn till now, is because of you.
I've a small question about the frequency distribution. What if the bin sizes are not fixed, For example, suppose the first bin would be 2 - 3 followed by 3 - 5, 5 -50 and > 50. Currently I'm putting this information in different sheet and pulling the data with the help of vlookup. Kindly advise.
Try:
="This had a percentage of "&TEXT(C5,"0.00%")
This has all been really helpful. Thank you!!!!
the way you apply formulas ... u r brain ghost ! :)
thank you for educating us :)
random sound effects! lol
Some excellent info in here. Much appreciated for sharing!
Great videos!! They have been a tremendous help! Question: When saying 0 up to 50 doesn't that mean 50 or less? Everything up to 50 (49.9999999999... but NOT including 50).
Hi ! I love your videos ! , i had a question , for pareto chart for 2007 excel how i do the % Total value
Excelente !!!!!
great video! I have a question? pivot table is so convient to get a chart or table. but since the data i am dealing with is stochastic(every time i run, the data is different) i found that pivot table doesn't change automatically. how can i fix it? or when dealing with stochastic data, we can only use traditional way? thanks so much!!
thanks, that works great :D
Hi, Nice video, can we have cumulative frequency in excel 2007 pivot chart
Hey please do a video on this or guide me here. I NEED TO HAVE DATA ANALYSIS ADD IN first to do this. Suppose you measure the number of minutes it takes an employee to complete a task, where the maximum allowed time is 5 minutes, and each time is rounded to the nearest minute. Data from 130 employees is summarized below. Construct a frequency bar chart and a pie chart from this data. How long did it take most employees to complete the task?
time: 1, 2, 3, 4, 5
frequency: 15, 30, 45,25, 20
I want to refer to the percentage cell in this way,
="This had a percentage of "&C5
but the formatting does not remain as a percentage, it turns it into a decimal. Any ideas how I can keep the format as percentage when referring to the cell?
Many thanks
nice
neat
how do I download this :(