Statistics in Excel Tutorial 1.1. Descriptive Statistics using Microsoft Excel
HTML-код
- Опубликовано: 23 сен 2020
- This video tutorial describes how to compute Descriptive Statistics in Excel. Most people underestimate the power and use of microsoft Excel for Statistical analysis. Excel can very quickly generate statistics, percentiles and can do variety of statistical tasks in excel including hypothesis testing and running t-tests as well.
in this video, we compute measures of central tendency, measures of dispersion, measures of location such as percentiles. We generate, mean, median, mode, percentiles, Frequency table and also histogram. Using these methods one can summarize the data quickly.
As someone who struggles with Excel and is very insecure when it comes to data analysis, I can say this video is perfect to understand the basics. Thank you! Also, I love how you embellished the sheet in respect to the people who would hypothetically then read it. The little details make a huge difference. Great video!
Very simple and straight forwards explanations and example. Thank you!
He did that!!!! Loved watching him move throughout excel like a master! I’m taking intermediate business applications and i hope to become this proficient one day! Thanks for the video!
Agreed. I wish the audio was better quality.
I watched this 1 hour to my interview and it was worth it.
Sir add-on was very necessary step thanks for that. Amazing explanation
Hey man, thank you for this wonderful video, it helped me to complete my assignment and I have learned so many things.
Thank you so much! This clear and nice content is more than 1000 videos! I just leant a lot in few minutes. Big up Professor!
very useful presentation! straight to the point! Thanks!
Really great video. Clear and makes me more confident on my data analysis journey. Cheers bro!
I do like your explanation. Very useful and thank you for the share.
Great video very informative and helpful. Thank you
The best video of data analysis In excell
Thanks for a great simple video to understand for my uni assignments
Final year student in Statistics so this would really help when finishing and going for a degree
Excellent presentation !!
Hello there, many thanks for a great video, very well done. I do have a question, what tool do you use to create the video?
This is very useful, thank you so much
Thanks a lot, very educative.
Wonderful explanation 😁
you saved my life!! thank you so much :))
Thank for your teaching.
Thanks for proving these additional videos sir
Thank You very informative
Very useful.
Thank you very much for sharing good information.
Great Job Sir
Great
Thank you Sir. It really helped me very much.
thank you! very helpful
Well presented
Thank you for the sharing and need more , great
Good explanation 🎉
Thank you for teaching and that was fun and challenging
Very good
Thank you so much..
It is very useful 😊
amazing sir.your voice is clerar
Can you share the soft copy of this excel which will be helpful while learning along with the video
nice video, thanks.
How we make range of numbers if we also have negative values in our data how we range them did we range them first then we range posiyive values like
-0.5 to - 2
-2 to -4
0 to 4
4 to 6
if Mean>median, it should be positively skewed. why some cases descriptive analysis table shows negative skewness
Thank u so much
Helpfull Thansk
Good morning, sir. I have problem with descriptive data that is input range contain nun-numeric data. Could you help me fix it, please?
hello, is it okay if there is another percentile equaled to the median? I had a data and after following your steps, I tried the percentile and the 34% to 55% had the same value
Yes....but 50th percentile still be equal to median. Let’s understand this through an example. Imagine if all values are equal, in that case min equals maximum and quartile 1, quartile2, quartile 3 and all percentiles are equal. Mean median, mode also will be equal. If 34th percentile and 55 th percentile are equal it means, the sorted array of observations all values in between those records are same for a variable.
@@CXOLearningAcademy thanks for clarification, thought i did it wrong
Thank you!!!!
Thank you
Thank you very much
Sir, it's informative one. Thanks. Want to know, can we use this for incremental data ?
For incremental or dynamic data it is always better to use business intelligence package like tableau or power BI. If you want excel, then use data/queries and connection and specify the refresh time setting and use named ranges. but Data Analysis tab is essentially a VB macro. So you have to run it again to generate descriptive statistics. percentiles are formulas so they will get refreshed if you have allowed automatic calculations.
Hello. Thank you soo much. My question is to you is that while computing the frequency table should i assume the starting point of lower bin always 0? or this is only for this particular dataset which you have shown? another question is, after getting the Frequency table if i want to delete Histogram, and only want to keep the Frequency table, will that be possible? Also is it possible to calculate Frequency table for more than one column simultaneously or it should always be separate? Please reply.
The starting bin need not be zero. For e.g if numbers are negative, let’s say we want to count companies which have negative profits, then all our upper and lower bins will be negative. If you do not want histogram, you can uncheck the chart output button. Or else delete it later. Deleting histogram will not delete frequency table. If you want to generate counts for more than one column use frequency formulae in excel rather than the data analysis menu.
Thank u so much sir
Sir ,Is there a way I can down the data set which you are using it
where can i get the next video of the same topic descriptive statistics
Execcellent job! How do you interpret the analysis in words using ChatGPT? hank you
Thank you soo much
Please show how to calculate descriptive statistics in continuous series
How to interpret values from summery stats ?
Thanks
What do you do when you get an error that says your input contains non-numerical data even though all your data values are indeed numbers (I checked, made sure the values weren't strings)?
It is likely you are including column header with the data without checking header checkbox in the dialog box. You have to indicate that you have included headers in the data.
You're an amazing teacher. I love how you made everything simple and straight to the point. Great job!
thanks
Very well presentation. How can I find your sample data?
Yes pls
I have option tab but there's no add ins the only content in option tab was "Regional Format Settings" I badly need your help where I could find data analysis my final exam is near and we are required to utilize excel.
Are you using Mac or windows? If you are using windows, then in excel, Click the File tab, click Options, and then click the Add-Ins category and then click on manage. If you are using Mac, you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins. It is also likely you may be using the earlier version of excel. i am using windows and office 365. in case you cannot still find it, you will find help for previous versions at the following link: support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4
@@CXOLearningAcademy hello! I'm using chromebook
Hello Nadine, i checked Microsoft tech support page on the topic. It says Toolpak analysis tool is only available for windows and Mac and is not available for chromebook. The response is from Microsoft tech person. I found it on the following page answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_365hp/analysis-toolpak-in-excel-for-office-365-on/f268fb6f-3de3-4675-99fb-91a474d8c866
The median value for the Decimal Number for 50% is Different as compared to 50 Percentile eg Median=3.695 and 50 percentile is 3.655 is this possible or am i doing wrong? Thanks
If you have sufficient observations both numbers must come equal. Median is 50th percentile. However if observations are small then there is small extrapolation approximation involved. You can use percentile.exc or percentile.inc formula to check. One of these values should match median exactly.
Sir how to make pie chart in that
i have clicked on add ins but the option of analysis is not showing .now what to do?
Click on data tab it has option data analysis
if you have added in successfully, the tab will appear on data. if it is not, check the add in menu again and restart excel.
oh yah!!
Can you provide the dataset?
kolum ech
what does percentile describes?
If 90 percentile of marks is let's say 60, it means 90 percent of all students have scored less than 60 marks and 10 percent of all students have scored more than 60 marks assuming all numbers are unique. If 20th percentile is 30 marks then 80 percent of all students have scored more than 30 marks and 20 percent have scored less than 30 marks. Median is same as 50th percentile or second Quartile. First Quartile is same as 25th percentile. Percentiles are basically measure of location. Others measues of location are Median, Quartiles and deciles. We can use Percentiles to infer about the shape and skewness of data. It can also identify outliers. For e.g all consumers spending above 95 percentile of spend can be called as premium customers. If the 95th percentile of let's say Walmart customer monthly spend is 1000 dollars, it means 5 percent of Walmart customers spent more than or equal to 1000 dollars and 95 percent of all customers spent less than or equal to 1000 dollars.
i have raw data ( related incident cases), and please assists, tq
my mode is not coming what to do pls say
It is possible there is no mode. Remember mode is most frequently occuring value.
How to add Data Analysis???
Go to options and then add on
Hindi mein sikhav
How we make range of numbers if we also have negative values in our data how we range them did we range them first then we range posiyive values like
-0.5 to - 2
-2 to -4
0 to 4
4 to 6
Arrange them in ascending order. -4 to -2 then -2 to 0 and so forth. You have to get the ordering right. Minus 4 is less than minus 2.