Excel for Begginers

Journalism student at the Federal University of Juiz de Fora (UFJF). Content Writer at VAVEL UK. Experience in Institutional Communication at the UFJF Communication Department and at the UFJF International Office. Its personal objective is to share knowledge about Creative Organization and Agile Methodology so that people can achieve greater results and productivity in study and work.

Learn about the concept of standard deviation, how it differs from variance, how to apply it in Excel, and other descriptive statistics variables!

What is standard deviation and how to calculate it?

The standard deviation is one of the important measures of dispersion in Statistics, as well as the variance, the mode, the arithmetic mean and the median.It is related to the degree of dispersion of a dataset compared to its arithmetic mean, indicating how homogeneous or heterogeneous this information is.Continue in this article and discover information about this statistical variant and step by step to apply it through the following topics:<ul><li>What is standard deviation?</li><li>How to calculate standard deviation?</li><li>What is the difference between standard deviation and variance?</li><li>What are the other elements of descriptive statistics?</li><li>Learn to use Microsoft Excel!</li></ul>Several times we get lost in so many Excel functions, and we don&#39;t know where to start and what to learn. To help you, we created the <a target="_blank" rel="nofollow" href="https://conteudo.voitto.com.br/ebook-primeiros-passos-no-excel">First Steps eBook in Excel</a> to guide your practice with the tool, as well as how and where to learn about its most complex resources. Learn how to solve everyday problems quickly and efficiently in Excel.By downloading our eBook, you will learn the first steps to create your spreadsheets and use their basic and essential functions.Let&#39;s get started?<a target="_blank" rel="nofollow" href="https://conteudo.pocketbook4you.com/ebook-fist-steps-in-excel"> <Image quality="95" src="https://images.prismic.io/voitto-blog/5ad839f3-56eb-4c5b-a198-380f5e858ce8_Bot%C3%A3o+Banner+Cursos+-+TLSS+%2817%29.png" width="1025" height="205" alt="[EBOOK] Fisrt Steps in Excel" title="[EBOOK] Fisrt Steps in Excel"/></a><h2>What is standard deviation?</h2>Standard deviation is the measure of the dispersion of a data set in relation to its arithmetic mean. It indicates how close or far from it these data are. It can be applied in areas such as biology, finance, physics and laboratory analysis.In statistics, the sample standard deviation is an absolute value related to the deviation of the values ​​of the data set in comparison to the mean.In probability, it is given as the separation of the total number, measuring how the values ​​of this set differ from each other. Thus, it can also be called population standard deviation.<h3>How did standard deviation come about?</h3>The term was first used in 1894 by Karl Pearson, replacing the term “mean error” previously used by Carl Friedrich Gauss.Pearson was an important figure in statistical studies. He was responsible for founding the Department of Applied Statistics at University College London in 1911, making it the first department in the field in the world.In 1918, statistician William Gosset (pseudonym Student) defined the differences between sample standard deviation and population standard deviation after empirical studies.<h2>How to calculate standard deviation?</h2>This is the standard deviation formula: <Image quality="95" width="400" height="189" src="https://images.prismic.io/voitto-blog/f439d77a-ce67-44c4-9d53-a94153da2fd6_image5.png" alt="Standard Deviation" title="Standard Deviation" />On what:<ul><li>S: standard deviation;</li><li>Xi: dataset numbers (using i= 1, 2, 3…);</li><li>X: arithmetic mean;</li><li>n: number of numbers in the data set.</li></ul>The standard deviation is calculated using the square root of this result: the sum of the difference of your variables by the arithmetic mean, divided by the number of variables.Thus, the lower the value found, the more homogeneous and constant this dataset will be. The higher the standard deviation, the more heterogeneous the dataset will be. <Image quality="95" width="450" height="318" src="https://images.prismic.io/voitto-blog/d177590c-a887-4581-88f9-23cca6d235a8_image4.png" alt="Standard Deviation" title="Standard Deviation" />Simplifying these calculations is essential and can be performed in <a target="_blank" rel="noopener" href="https://thinkleansixsigma.com/article/history-of-microsoft">Microsoft </a><a target="_blank" rel="noopener" href="https://thinkleansixsigma.com/article/excel-functions"><a target="_blank" rel="noopener" href="https://thinkleansixsigma.com/article/history-of-microsoft"></a> Excel</a>and Google Sheets.<h2>What is the difference between standard deviation and variance?</h2>Both standard deviation and variance are measures of dispersion used in statistical studies. However, variance and standard deviation are directly related.So, the variance is the difference between the collected data points compared to the arithmetic mean. The standard deviation is an absolute value related to this homogeneity or heterogeneity.Therefore, the variance can be calculated as follows: <Image quality="95" width="276" height="142" src="https://images.prismic.io/voitto-blog/5c9aca8c-4c59-424f-a8ac-02f65b4a79f8_image2.png" alt="Variance" title="Variance" />On what:<ul><li>S: variance;</li><li>Xi: dataset numbers (using i= 1, 2, 3…);</li><li>X: arithmetic mean;</li><li>n: number of numbers in the data set.</li></ul>Hence, the standard deviation is the square root of the variance.<h2>What are the other elements of descriptive statistics?</h2>Descriptive statistics is the initial step of data analysis used to summarize and understand information.The availability of a large amount of data and very efficient computational methods has reinvigorated this area of statistics. It can be used in the application of the <a target="_blank" rel="noopener" href="https://thinkleansixsigma.com/article/six-sigma-belt">Lean Six Sigma methodology</a>.Standard deviation and variance are measures of descriptive statistics. Check out other variables below:<h3>Mean</h3>The mean is nothing more than the sum of all values in the database divided by the total number of elements.There is also the weighted mean, in which each data is assigned and multiplied by a weight. The sum of these elements is then divided by the sum of all weights.<h3>Mode</h3>If we say that a number represents the mode of a database, this number appears the most in that database, the most frequent value.It is worth remembering that if no value is repeated in your database, then we will not have a mode in this case.<h3>Median</h3>The median is the measure of the central positioning of the data. It is the central term for a set of data placed in ascending or descending order.If the number of sorted values is odd, the median is exactly the number located in the middle of the list. If the number of ordered values is even, the median is calculated as the average of the two central values.<h3>Percentiles</h3>Percentiles are measures that divide the sample (in ascending order of data) into 100 equal parts, each with an approximately equal percentage of data.Therefore:<ul><li>the 1st percentile determines the lowest 1% of the data;</li><li>the 50th percentile determines the lowest 50% of the data and is also equal to the median seen previously;</li><li>the 98th percentile determines the lowest 98% of the data.</li></ul>In this way, it can be calculated as follows: <Image quality="95" width="130" height="59" src="https://images.prismic.io/voitto-blog/80995816-837b-4ee9-bc26-79c0522b95c7_image1.png" alt="Percentile" title="Percentile" />In which:<ul><li>K = the position where the percentile will be in the data</li><li>i = the desired percentile number</li><li>n = number of samples.</li></ul><h3>Quartiles</h3>In descriptive statistics, quartiles are values that divide ordered data into four equal parts.Using quartiles, you can quickly assess the dispersion and central tendency of a set of samples, which are important steps in understanding your data.Hence,<ul><li>1st quartile consists of 25% of the data; </li><li>2nd quartile consists of 50% of the data;</li><li>3nd quartile consists of 75% of the data. </li></ul>It can be calculated as follows: <Image quality="95" width="123" height="56" src="https://images.prismic.io/voitto-blog/a71451bd-7567-41f6-b7d9-dd79b45f2772_image6.png" alt="Quartile" title="Quartile" />In which:<ul><li>Q = the position where the quartile will be in the data</li><li>i = the quartile we want to find</li><li>n = number of samples.</li></ul><h3>Amplitude</h3>The amplitude is used to show us how far apart or not the data in the sample being worked on is.To calculate it, simply make the difference between the highest and lowest value.If the range is a high value, it means that your data is distributed within a large range. If not, it shows us that the ranges are small.<h3>Interquartile-Range</h3>The interquartile range was created with the objective of analyzing the degree of dispersion around the data centrality measure.This measure is calculated as the difference between the third quartile and the first quartile.<h2>Learn to use Microsoft Excel!</h2>Are you tired of missing out on incredible career opportunities because you don&#39;t know about the main Excel tools?So you are in the right place! In the<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> Excel for Beginners</a> course, you will learn to work with data in an agile way.In addition, the course is available for FREE, just click on the banner button below and embark on this journey of knowledge!<a target="_blank" rel="nofollow" href="https://thinkleansixsigma.thinkific.com/courses/excel-for-beginners"> <Image quality="95" src="https://images.prismic.io/voitto-blog/45fd4463-eb50-470d-a2e2-1a98155e7fdc_Bot%C3%A3o++Banner+-+Cursos+TLSS+%282%29.png" width="980" height="180" alt="Excel for Beginners" title="Excel for Beginners"/></a>

What is standard deviation and how does it work in descriptive statistics?

Find out what standard deviation is, its relationship to variance, how to apply it, and what its role is in descriptive statistics