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
Kendra, Cogley, and Mei share income and loss in a 3:2:1 ratio. The partners have decided to liquidate their partnership. On the
BlackZzzverrR [31]

Answer:

a. Inventory is sold for $600,000.

gain on sale of inventory = $600,000 - $537,200 = $62,800

allocation of gain:

Kendra 1/2 x $62,800 = $31,400

Cogley 1/3 x $62,800 = $20,933

Mei 1/6 x $62,800 = $10,467

Dr Cash 600,000

   Cr Inventory 537,200

   Cr Gain on sale of inventory 62,800

Dr Gain on sale of inventory 62,800

   Cr Kendra, capital 31,400

    Cr Cogley, capital 20,933

    Cr Mei, capital 10,467

Dr Accounts payable 245,500

    Cr Cash 245,500

Dr Kendra, capital 124,400

Dr Cogley, capital 233,433

Dr Mei, capital 177,467

    Cr Cash 535,300

b. Inventory is sold for $500,000.

loss on sale of inventory = $500,000 - $537,200 = -$37,200

allocation of loss:

Kendra 1/2 x $37,200 = $18,600

Cogley 1/3 x $37,200 = $12,400

Mei 1/6 x $37,200 = $6,200

Dr Cash 500,000

Dr Loss on sale of inventory 37,200

   Cr Inventory 537,200

Dr Kendra, capital 18,600

Dr Cogley, capital 12,400

Dr Mei, capital 6,200

    Dr Loss on sale of inventory 37,200

Dr Accounts payable 245,500

    Cr Cash 245,500

Dr Kendra, capital 74,400

Dr Cogley, capital 200,100

Dr Mei, capital 160,800

    Cr Cash 435,300

c. Inventory is sold for $320,000 and any partners with capital deficits pay in the amount of their deficits.

loss on sale of inventory = $320,000 - $537,200 = -$217,200

allocation of loss:

Kendra 1/2 x $217,200 = $108,600

Cogley 1/3 x $217,200 = $72,400

Mei 1/6 x $217,200 = $36,200

Dr Cash 320,000

Dr Loss on sale of inventory 217,200

    Cr Inventory 537,200

Dr Kendra, capital 108,600

Dr Cogley, capital 72,400

Dr Mei, capital 36,200

    Dr Loss on sale of inventory 217,200

Dr Cash 15,600

    Cr Kendra, capital 15,600

Dr Accounts payable 245,500

    Cr Cash 245,500

Dr Cogley, capital 140,100

Dr Mei, capital 130,800

    Cr Cash 270,900

6 0
3 years ago
DJ and Gwen paid $3,200 in qualifying expenses for their son, Nikko, who is a freshman attending the University of Colorado. DJ
navik [9.2K]

Answer:

$1,150

Explanation:

$2,000+[(3,200-2,000) * .25]= $2,300 is their pre-limitation credit

But limited due to AGI as: $2,300 *($180,000 — 170,000/20,000) = $1,150.

4 0
3 years ago
Read 2 more answers
True or false the risk premium is primarily concerned with business risk, financial risk, and inflation risk.
Nikitich [7]
The answer is true .
7 0
4 years ago
Which could argue that a programmer deserves to have his/her work protected by a copyright purely as a result of his/her inalien
Simora [160]

Answer:

What

Explanation:

8 0
3 years ago
________ occurs when an agency, rather than acting in the public interest, becomes too favorable toward the organized interests
Luda [366]

When an agency acts in the interests of corporations it is meant to be regulating, this is called Regulatory capture.

<h3>What is regulatory capture?</h3>

In order to ensure that corporations don't act in ways that threaten the public, regulatory agencies are tasked with moniotirung their moves.

When these agencies stop regulating these companies and instead becomes favorable to them, then the agency has been captured in what is called regulatory capture.

Find out more on regulatory capture at brainly.com/question/16180695.

#SPJ12

7 0
2 years ago
Other questions:
  • Firms HL and LL are identical except for their financial leverage ratios and the interest rates they pay on debt. Each has $10 m
    15·1 answer
  • A business ____ is the way a company operates to generate revenues and remain a viable entity.
    6·1 answer
  • When Yolanda asked her firm's advertising agency to estimate how often consumers saw her firm's IMC message and what percentage
    8·1 answer
  • Increased access to workplace tools and information means work hours may be more
    9·1 answer
  • When a company employs a varied workforce of both men and women, people of many generations, and people from ethnically and raci
    9·2 answers
  • You just invested $1000 in an account that returns 5% per year. After 50 years, when you are old and gray, what will be the valu
    12·2 answers
  • To _____ is to modify or improve upon code.
    6·2 answers
  • Retro Rides, Incorporated, operates two divisions: (1) a Management Division that owns and manages classic automobile rentals in
    5·1 answer
  • The negative feeling that one should have made another purchase, consumption, or disposition decision than one actually did is r
    13·1 answer
  • Accompanying the bank statement was a credit memo for a short-term note collected by the bank for the customer. What entry is re
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!