Home

TDIST equation

%3CLINGO-SUB%20id%3D%22lingo-sub-583579%22%20slang%3D%22en-US%22%3ETDIST%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583579%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20run%20a%20TDIST%20test.%20I%20am%20using%20%3D%20TDIST(E4%2CE3-2%2C2)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE4%20is%202.34.%20E3%20is%2045.%20When%20I%20was%20giving%20the%20formula%2C%20I%20was%20told%20that%20there%20should%20be%20a%20-%20in%20front%20of%20the%20E4%2C%20like%20this%3A%3C%2FP%3E%3CP%3E%3D%20TDIST(-E4%2CE3-2%2C2)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20do%20that%2C%20I%20get%20an%20error.%20Is%20my%20formula%20above%20correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
matbathome
Occasional Visitor

I'm trying to run a TDIST test. I am using = TDIST(E4,E3-2,2)

 

E4 is 2.34. E3 is 45. When I was giving the formula, I was told that there should be a - in front of the E4, like this:

= TDIST(-E4,E3-2,2)

 

When I do that, I get an error. Is my formula above correct?