how to add descriptive statistics to excel

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. Step 1: In cell B9, start typing the formula =AVERAGE() However, in Excel, you have a built-in AVERAGE function that does this task for you.

TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (36+).

How to add descriptive statistics to excel