1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
damaskus [11]
3 years ago
15

How to calculate false discovery rate in excel?

Business
1 answer:
Zielflug [23.3K]3 years ago
3 0
<span>Put the individual p-values in ascending order.Assign ranks to the p-values. For example, the smallest has a rank of 1, the second smallest has a rank of 2.<span>Calculate each individual p-value’s Benjamini-Hochberg critical value, using the formula (i/m)Q, where:<span>i = the individual p-value’s rank,m = total number of tests,Q = the false discovery rate (a percentage, chosen by you).</span></span>Compare your original p-values to the critical B-H from Step 3; find the largest p value that is smaller than the critical value.</span>

As an example, the following list of data shows a partial list of results from 25 tests with their p-values in column 2. The list of p-values was ordered (Step 1) and then ranked (Step 2) in column 3. Column 4 shows the calculation for the critical value with a false discovery rate of 25% (Step 3).



The bolded p-value (for Children) is the highest p-value that is also smaller than the critical value: .042 < .050. <span>All </span>values above it (i.e. those with lower p-values) are highlighted and considered significant, even if those p-values are lower than the critical values. For example, Obesity and Other Health are individually, not significant when you compare the result to the final column (e.g. .039 > .03). However, with the B-H correction, they are considered significant; in other words, you would reject the null hypothesis for those values.

You might be interested in
When a sales manager determines that her staff is not making sufficient progress toward meeting monthly sales quotas and develop
Studentka2010 [4]
When a sales manager determines that her staff is not making sufficient progress toward meeting monthly sales quotas and develops a plan of corrective action, which shows that <span>she is performing the management function of <span>CONTROLLING.
Because, </span></span> her important duty as a controller is to set a goal and performance standards.
7 0
3 years ago
A homeowner sued a plumber for damages resulting from the plumber's allegedly faulty installation of water pipes in her basement
Leona [35]

Answer: The correct answer is YES it is admissible as evidence of the plumber's fault.

Explanation: An Evidence has probative value if it tends to prove an issue. The testimony of the homeowner of the regarding the plumber's response is a party admission. It is admissible as a hearsay exemption under Rule 801(d)(2)(A) which explains that a statement or statemens made by a party in a case cannot be excluded as hearsay when offered against him by the opponent. As such, the statement is a probative evidence.

4 0
3 years ago
Consumer behavior quiz
natima [27]

Answer: Benjamin Franklin did not have cars during his time good sir...

Explanation:

3 0
3 years ago
In order to calculate Debtors Collection Period, should I include non current and current trade receivables?​
ivolga24 [154]
You cause look this up on google
6 0
3 years ago
How does a bond issuer decide on the appropriate coupon rate to set on its bonds?
Novay_Z [31]

Answer

The answer and procedures of the exercise are attached in the following image.

Explanation  

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.  

4 0
3 years ago
Other questions:
  • It costs $1,200 to produce 50 pounds of a chemical and it costs $2,200 to produce 150 pounds. The chemical sells for $15 per pou
    12·2 answers
  • The specific ways in which human resource professionals support an organization's strategy vary according to: their level of inv
    14·1 answer
  • Use the following information for Shafer Company to compute inventory turnover for year 2.
    15·1 answer
  • When Wells Fargo employees fraudulently opened customer accounts in order to meet extremely high sales quotas, rehabilitating th
    15·1 answer
  • Jackson State University is evaluating two options. It can perform online distance learning upgrades now for $275,000 or it can
    9·1 answer
  • Derrick was in an automobile accident while he was going to work. The doctor advised him to stay home for eight months due to hi
    5·1 answer
  • Please subscribe to my mom channel please <br><br>i need 200 subscribe ​
    12·2 answers
  • Reasons for looting<br>​
    13·1 answer
  • What is a tariff?
    14·1 answer
  • If a broker receives a due diligence fee from a buyer under the north carolina standard offer to purchase and contract, when can
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!