30MinuteStats
30MinuteStats
  • Видео 40
  • Просмотров 1 233 942
The Mean 3 - Summary Measures of Central Tendency
This tutorial shows how to calculate the mean using a frequency distribution table
Просмотров: 360

Видео

The Mean 1 - Summary Measures of Central Tendency
Просмотров 25611 лет назад
This tutorial shows how to calculate the mean using a simple array of data.
The Mean 2 - Summary Measures of Central Tendency
Просмотров 14911 лет назад
This tutorial shows how to calculate the mean using a frequency distribution table
Quartiles 2
Просмотров 1,6 тыс.11 лет назад
A tutorial showing how to obtain quartile values for a variable using the interpolation method
Quartiles 1
Просмотров 70711 лет назад
A tutorial showing how to obtain quartile values for a variable using cumulative frequencies and a frequency distribution table
Percentiles 2
Просмотров 2,2 тыс.11 лет назад
A tutorial showing how to obtain the value of a variable at different percentiles using an interpolation method
Percentiles 1
Просмотров 5 тыс.11 лет назад
A tutorial showing how to obtain the value of a variable at different percentiles using cumulative frequencies
Cumulative Frequencies 2
Просмотров 60511 лет назад
This tutorial shows how to create cumulative proportions and percentages from frequency distribution tables.
Cumulative Frequencies 1
Просмотров 37911 лет назад
This tutorial shows how to create and interpret cumulative frequency distributions
The Median 2 - Summary Measures of Central Tendency
Просмотров 10311 лет назад
This tutorial shows how to find the median using a frequency distribution table.
The Median 1 - Summary Measures of Central Tendency
Просмотров 11011 лет назад
This tutorial shows how to find the median of an array of data.
The Mode - Summary Measures of Central Tendency
Просмотров 14711 лет назад
This tutorial shows how to find the mode of an array and a frequency distribution.
Descriptive Statistics - Characterizing the Distribution
Просмотров 96811 лет назад
An introduction to descriptive statistics. Using a histogram of a normal distribution, measures of central tendency and dispersion are discussed. Each type of summary measure is related to one dimension of the distribution curve displayed in the histogram.
Histograms - The Shape of A Distribution
Просмотров 2,8 тыс.11 лет назад
A tutorial demonstrating normal and non-normal distributions using histograms and frequency distribution tables
Histograms 1
Просмотров 20111 лет назад
A tutorial showing how to construct a histogram from a frequency distribution
Histograms 2
Просмотров 10511 лет назад
Histograms 2
Calculating Proportions & Percentages 2
Просмотров 99911 лет назад
Calculating Proportions & Percentages 2
Calculating Proportions & Percentages 1
Просмотров 23 тыс.11 лет назад
Calculating Proportions & Percentages 1
Calculating Ratios 2
Просмотров 82111 лет назад
Calculating Ratios 2
Calculating Ratios 1
Просмотров 7 тыс.11 лет назад
Calculating Ratios 1
Statistical Rates 2
Просмотров 7411 лет назад
Statistical Rates 2
Statistical Rates 1
Просмотров 43611 лет назад
Statistical Rates 1
Arrays and Frequency Distributions 1
Просмотров 53811 лет назад
Arrays and Frequency Distributions 1
Arrays and Frequency Distributions 1
Просмотров 3,6 тыс.11 лет назад
Arrays and Frequency Distributions 1
Excel 2010 - RANK.AVG Function
Просмотров 50 тыс.11 лет назад
Excel 2010 - RANK.AVG Function
Excel 2010 - Rank.EQ Function
Просмотров 45 тыс.11 лет назад
Excel 2010 - Rank.EQ Function
Excel 2010 - Slicers for Multiple Pivot Tables
Просмотров 107 тыс.11 лет назад
Excel 2010 - Slicers for Multiple Pivot Tables
Excel 2010 - Conditional Formatting - Formulas
Просмотров 241 тыс.11 лет назад
Excel 2010 - Conditional Formatting - Formulas
Excel 2010 - Conditional Formatting - Data Bars
Просмотров 103 тыс.11 лет назад
Excel 2010 - Conditional Formatting - Data Bars
Excel 2010 - Conditional Formatting - Icons
Просмотров 33 тыс.11 лет назад
Excel 2010 - Conditional Formatting - Icons

Комментарии

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

    thanks a lot

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

    Thank you so much!!!

  • @KIFAConsultant-ri6yj
    @KIFAConsultant-ri6yj Год назад

    Good explanation, Thank you very much

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

    amazing explanation... thanks a lot.. keep going...

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

    .....................................................

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

    Excellent Presentation. Love it .

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

    Interesting alternative to formatting alternate rows, as I only know how to do that using tables.

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

    I want to know how to use three color scale but not color anything below a certain value. Do I use formula option for this instead of number or percentile?

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

    Thanks for this video, if i make school mark sheet than i found 2 condition, 1. marks and 2 Absent how i put the formula for marks and for absent , if mark less than 40 than fail and want to colour red and also if absent than red too

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

    Thanks for your video ! But i have a question that how we can fill that color for entire row following that cell?

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

    THANKS MAN

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

    Thanks alot

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

    Where can I get the table for practice?

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

    Where can I get the sample table to practice?

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

    Thank you very much

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

    god i hate using exccel

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

    Yay. Thank you!

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

    Thanks😊

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

    Thank you man, simple and to the point. All respect 🙌

  • @Aneshram1
    @Aneshram1 3 года назад

    You earned a subscription

  • @bikassingh7469
    @bikassingh7469 3 года назад

    What if I want to rank between 1 to 5

  • @usmaniqbal1836
    @usmaniqbal1836 3 года назад

    Please share this Excel File for practice. Email usmaniqbal102@gmail.com

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 года назад

    Good to see sir.. nice video Sir make office 365 new formulas sir

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 года назад

    Great sir

  • @nonoobott8602
    @nonoobott8602 3 года назад

    Great tutorial. Thanks so much for sharing

  • @rajukumar-uh7pr
    @rajukumar-uh7pr 3 года назад

    There is option of slicer in excel 2010 ???

  • @keivanhamidi
    @keivanhamidi 3 года назад

    dude you're the best

  • @llunaeldas8055
    @llunaeldas8055 4 года назад

    thank you for posting this!

  • @jonchapman621
    @jonchapman621 4 года назад

    Really Appreciated! I did not know that Pivot Table could be that useful. Without this video and another youtube (ruclips.net/video/an_uDBzJNps/видео.html), idk what to do for my marketing presentation.

  • @oshanbandara7241
    @oshanbandara7241 4 года назад

    Very great explanation keep it up .

  • @BASAR360VLOG
    @BASAR360VLOG 4 года назад

    Awasone #BASAR360XL

  • @ameeralameh4894
    @ameeralameh4894 4 года назад

    Ruth from operations is making BANK right now wow

  • @errolwirasinghe
    @errolwirasinghe 4 года назад

    Thanks! Would be awesome if you could provide the table for us to download.

  • @nalcantara9154
    @nalcantara9154 4 года назад

    Extremely helpful, thank you!

  • @diamondstilettos
    @diamondstilettos 4 года назад

    One of the most helpful tutorials I've ever had

  • @jdapaul1351
    @jdapaul1351 4 года назад

    How about Qualitative data and one column only?

  • @RJYL
    @RJYL 4 года назад

    using stick tools would be more simple.

  • @Mick-qq1pi
    @Mick-qq1pi 4 года назад

    Good explanation, easy to follow, thank you.

  • @Hanfahhussain
    @Hanfahhussain 4 года назад

    where can i download this worksheet?

  • @lawrence2467
    @lawrence2467 4 года назад

    Thanks a lot for this nice tutorial!!!

  • @BilalFleifel
    @BilalFleifel 4 года назад

    is there a way to change the databar color based on value? fore example green if above 150K, yellow if below that and red if below 50K

  • @thilinadeshapriya1321
    @thilinadeshapriya1321 4 года назад

    Great explanation,, thanks,,, 👍

  • @KatEyze1015
    @KatEyze1015 5 лет назад

    You went right to the point! Great video!

  • @diptisharma9900
    @diptisharma9900 5 лет назад

    Your video is very clear as per subjet . Thanks a lot.

  • @sonitasim6201
    @sonitasim6201 5 лет назад

    Thank you

  • @54727608
    @54727608 5 лет назад

    Excellent

  • @canyon1899
    @canyon1899 5 лет назад

    This was very helpful. Thank you!

  • @khoirulanam2654
    @khoirulanam2654 5 лет назад

    Thanks you very much. very helpfull

  • @abhishekchakraborty2840
    @abhishekchakraborty2840 5 лет назад

    From these, the color actually changes(shade changes) as the value increases. I need a solid color until the next increment. Like from 20-50, it would be red. It should not change as the value increases. Please help me if possible.

    • @janakaprasad8449
      @janakaprasad8449 5 лет назад

      Select your area and apply conditional formatting few times. (one time one condition. Eg (1)- suppose less than 30 figures should be in red. Then you need to colour higher values. Again select the area and apply another condition. eg (2)- suppose higher than 75 figures should be in green. same as in between also can be applied. (3). ** before going to apply for large set of numbers , try out with set of numbers. understand how figures have to be given , specially in between conditions. Until you clear the conditions, all conditions you applied are in the system) Path for (1)- Select the area ---Conditional Formatting --- Highlight Cells Rules --- less than Path for (2) Select the area ---Conditional Formatting --- Highlight Cells Rules --- higher than Path for (3) Select the area ---Conditional Formatting --- Highlight Cells Rules --- in between

    • @janakaprasad8449
      @janakaprasad8449 5 лет назад

      This is a simple way, There are many

  • @GlassNClouds
    @GlassNClouds 5 лет назад

    If you are ranking the top 10 how do you keep the values 10-1 ? if there is a 4 way tie between first place why did it go to 7 instead of 10 and skip the subsequent numbers?