It assumes that there is some kind of relationship (termed as correlation) between two variables. Regression Analysis is a widely used statistical technique to determine a relationship between two or more variables and predict the future (forecasting) based on the model fitted. You’ll get a Standard Deviation value as shown in the screenshot below: Step 3: Use closing parentheses to complete the formula and press Enter key.

It will give me a single value, which represents the standard deviation between the Sales Values. I will use the sales values spread across B2:B7 as a reference to the STDEV.S function. Step 2: Now, use the range of cells you wanted to capture the standard deviation. Step 1: Start typing the formula under cell D10 as =STDEV.S( to initiate the formula for sample standard deviation. Follow the steps below to be able to find the standard deviation. STDEV.P works well when you have an entire population to cover, and STDEV.S is the one that can be used to figure out the Standard Deviation for a sample. We have two functions to achieve the result. It is very easy to calculate Standard Deviation under Excel.

We can find out the Standard Deviation, which gives us a good idea about the spread of the data.

We can also be very interested in knowing the degree to which the data points are deviating from our data. Go to Home tab, under which navigate towards Number group. Follow the step below to achieve the result. We need to change the number formatting for column D to be seen in a percentage format. Select all the necessary sales, including D2 and press Ctrl + D. You can use the keyboard shortcut Ctrl + D to achieve the result. Step 3: Now, Drag down this formula across the rows to see the Margin% we have acquired for different countries through trade. Step 2: Press Enter key to see the Margin% value we have acquired for UAE through our trade. Step 1: In column D, under cell D2, use the formula as C2/B2 (Since C2 has Margin and B2 has Sales value for UAE). The general formula for calculating Margin% is as follows: Does percentage show it all in a nice way, you know? Let’s see how this can be done. Suppose we wanted to capture the Margin % we have acquired through business with each country. You can copy the formulas and paste them to different cells so that you get the formulated results for the other column.Įxample #2 – Margin Percentage for Each Country Well, this is one of the nicest Excel features of all time. Step 4: Copy cell B9 and paste (Ctrl + V) it under cell C9 to get the average value for Margin. Step 3: Close the parentheses to complete the formula and press Enter key to see the output as shown below: Step 2: Use B2:B7 (all sales values) as a reference under the AVERAGE function.

Basic statistical analysis in excel