150k views
0 votes
Harold has been working as a real estate agent. he has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. in one of harold’s columns there are too many numbers after the decimal place. harold does not need this level of detail. it is distracting from the data and he really only needs two numbers after the decimal. how could harold make the data appear cleaner in the most efficient way?

User Eswar
by
7.2k points

1 Answer

1 vote
The main thought is that Harold should round off all his data to the nearest hundredths place so that all would have 2 decimal places. The most efficient way would be to use software tools like MS Excel. This is very useful especially in collating and analyzing data because it has different features like inputting formula to the cells, data fitting, different types of graph, iteration, and linear regression.

For reducing all decimal places to 2 numbers only, highlight all of the data, then place your cursor as shown in the picture encircle in red. This feature automatically rounds off your data in one click per decimal place. I've given examples of lengthy numbers shown in the left side. Just click the 'decrease decimal' button until it reaches to just two numbers, as shown on the right side. Using this MS Excel feature, it will save time for Harold.
Harold has been working as a real estate agent. he has a lot of housing data to report-example-1
User Lubin
by
7.1k points