|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
07-20-2007, 08:55 AM
|
#1 |
|
Member (9 bit)
Join Date: Oct 2003
Location: NorthEastern USA
Posts: 369
|
MS Excel more help
Hi All,
My new question: For example: I have the following data: 70 70 80 50 60 85 How to I calculate the percentage of data that greater than or equal to 70? Thank you in advance for all your help.
__________________
Fair isn't always equal. |
|
|
|
07-24-2007, 10:25 PM
|
#2 |
|
Member (8 bit)
Join Date: May 1999
Location: Houston, TX
Posts: 161
|
Assuming your data is in column A:
First create a column with the following coding in the first row: =IF(A1>=70,1,0) , then copy and paste this to subsequent rows in the column. Then at the bottom of this new column (Column B): =AVERAGE(B1:B6) This will be your percentage greater than or equal to 70. |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Slow Cable Connection | Tokenekie | Networking & Online Security | 5 | 06-13-2007 10:20 AM |
| High Ping, Latency issue | SpectreT6 | Networking & Online Security | 6 | 02-23-2007 07:45 PM |
| Connects, but NO internet -Serious | lani | Networking & Online Security | 41 | 04-26-2005 09:53 AM |
| Acceptable pings. | theyosh | Networking & Online Security | 4 | 01-24-2005 03:44 PM |
Linear Mode
