“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How to find the p-value of this data in excel.

Solved by F. H. in 11 mins

Test the hypothesis using the P-value approach. Be sure to verify the requirements of the test.
Upper H 0 : p= 0.46 versus Upper H 1 : p less< 0.46
n equals 150, x equals 63, alpha equals 0.01
Use technology to find the P-value.

Solved by K. L. in 24 mins

i want to automate a timetable excel, time table has many merged fields some, it is difficult to paste every value in database, or excel row by row. I am searcing a last character of value in excel sheet, e.g. (UCA017 P) I am searching a P excel search it , then I want to copy this value, and three values under this value in another sheet in a b c d e column and additonally i want to copy the header and rowid. How to do it by vba or excel please help

Solved by S. F. in 30 mins

want to delete a object which ius starting with LCELW to <managed object)
<managedObject class="LCELW" version="WBTS16" distName="RNC-2/WBTS-2752/MRBTS-1/BTSSCW-1/LCELW-27523" operation="create">
<p name="cellRange">20000</p>
<p name="defaultCarrier">2037</p>
<p name="expirationTime">1</p>
<p name="hspaMapping">None</p>
<p name="maxCarrierPower">46.0</p>
<p name="maxRxLevelDifference">7</p>
<p name="rachCapacity">2</p>

Solved by O. L. in 25 mins

Formula for T is =IF(P2> 0.5, S2, R2). Column P is either 50% or 70%, S is 50% Calc, R is 70% calc. When P is 50% is want S value, but am getting R??

Solved by M. Q. in 12 mins