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.
![how to perform statistical analysis in excel 2010 how to perform statistical analysis in excel 2010](https://hakanforss.files.wordpress.com/2012/11/addcolumns_thumb.png)
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:
![how to perform statistical analysis in excel 2010 how to perform statistical analysis in excel 2010](https://www.addintools.com/documents/excel/images/excel-chart-tools-menus-692-520.png)
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
![how to perform statistical analysis in excel 2010 how to perform statistical analysis in excel 2010](https://media.gcflearnfree.org/ctassets/topics/175/whatif_example_dialog.png)
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.