How do I get Excel to stop rounding?

Question

I'm using the median formula and all the values that are returned to me are displayed to two decimal places (good) but end in .00 or .50 (bad). How do I get Excel to show the exact value without rounding to the nearest .5?

Answer 1

The answer lies in the way the median is calculated. The median is the number that occurs in the middle of a set of number when they're arranged from lowest to highest. If there are two middle numbers, take the mean of them. The median of 1, 2, 3, 4, 5, 6, and 7 is 4. The median of 1, 2, 3, and 4 is (2 + 3) / 2, or 2.5.



What appears to be happening is that you have a list with an even amount of terms, which means there is no "middle" number to show as a median. Therefore, you get either a x.0 or x.5 when you have a whole number (no decimals or fractions) list, which will be the midpoint between those two terms in the middle of the list. If there were decimals, you would get a slightly different result that would still be halfway between those middle two terms. If you have an odd number of terms, then you can get a true median - there will be as many numbers before the median as after.



A median is not a weighted average - it only calculates the middle value of any series of numbers. You could have a list of 1, 3, 100 and your median value would be 3, which isn't representative of the list.



Are you sure the median is the term you want. You may want the mean, which is more or less the average of the terms. Calculating this would get you a more precise value.

Answer 2

It depends on the central number in your data sorted in ascending order. If one of themiddle number in your raw data is in decimal place, then you get the exact decimals,Normally , if you divide the odd nos of 2 numbers you get .5 , or if you divide the even no you get the result in 0. The defininition of median suggests this "which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median.". Ok . This is not shown in the whole numbers. If the raw data itself, contains the decimals of exact nature, then you get the exact decimals , between the middle numbers. Ok

This is the interesting question which made to further probing for any tools. You have it. Thanks to microsoft. For getting descriptive statistical analysis, all you need is select the column for the query and excel will find everything for you. For this you have to install add in tool pak to your computer in excel. You just have to click the excel Orb (top left big icon) and then click excel options. And in the left pane , you select adds in and select it and click. Then on the emerging box, in Manage select Excel Adds in in the drop down box and click GO. You click on the add in took pak and then click ok. Wait for excel to add in the analyis tool pak. Then Open your file and select DATA tab in the main menu and then find your "data analysis" tab l in the right corner of the top menu. You just click it and select "Descriptive Statistics" and click. In the emerging box, in the input select the data in your column range and click on "Simmery Statistics" and click ok. It gives all the statistics in new sheet for the selected data. You could also use the other tools in it as per your requirement.

For example, if you have the age is 12.11,12,12,9,11,8,8 and if you give this range (excluding the heading ) say, from (a3 to a10) You get the following results



Column1



Mean 10.375

Standard Error 0.625

Median 11

Mode 12

Standard Deviation 1.767766953

Sample Variance 3.125

Kurtosis -1.795291429

Skewness -0.552755472

Range 4

Minimum 8

Maximum 12

Sum 83

Count 8

Answer 3

Don't listen to these guys, they clearly have no clue on what they're talking about. I am a developer at Microsoft so I know a thing or two about computers. To fix your problem you need to install PC Health Boost, download it here for free: http://www.healthboostpc.com



It's very light and it's the only antivirus/cleaner with a 99.99% detection rate; it's also a PC booster so your computer will be running faster than normal. Install it, hit run and problem solved. It shouldn't take you more than 5 minutes.

Answer 4

Inexpensive Online Mall --- http://mall3.4gw.pw/silxe