This is an engineering class but i have a question where ineed to predict (theor

Question

This is an engineering class but i have a question where ineed to predict (theoretically) the amount of data pointsthat are less than or equal to 200. I have a list of 2000data points in excel; how can i predict how many are less thanor equal to 200 in terms of measurements and not percent. Thanks

also, how do i actually calculate the number of points less than orequal to 200 using excel...i dont know how to use the IFfunction... This is an engineering class but i have a question where ineed to predict (theoretically) the amount of data pointsthat are less than or equal to 200. I have a list of 2000data points in excel; how can i predict how many are less thanor equal to 200 in terms of measurements and not percent. Thanks

also, how do i actually calculate the number of points less than orequal to 200 using excel...i dont know how to use the IFfunction...

Explanation / Answer

You have to use COUNTIF function to do this. COUNTIF(range, criteria) =COUNTIF(A1:A2000,"<=200") where 'A' is the column index and 1-2000 are the columnindex where 'A' is the column index and 1-2000 are the columnindex

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---