Results 1 to 7 of 7

Thread: TSHIFT function?

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2022
    Posts
    2

    TSHIFT function?

    Hello

    I am very much new to Visual Basic so apologies if this doesn't make sense...

    I am going through the code within an existing Access database and there is a command called TSHIFT, which apparently is the shifted Studentís t density function but I can't find anything about this and whether it is possible to recreate what this function does using an equivalent DAX function in Excel.

    Would anyone be able to help?

    Many thanks
    Tim

  2. #2
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    37,551

    Re: TSHIFT function?

    It's just math, so it IS possible, but unless you find a built in function that does the same thing, you'd have to do the math yourself. I haven't done a Student's t test since....well, since I was a student, which was a very long time ago. Still, the math behind it is probably available on the internet.
    My usual boring signature: Nothing

  3. #3
    Banned
    Join Date
    Nov 2011
    Posts
    7,803

    Re: TSHIFT function?

    I haven't been able to find a TSHIFT function in Google. Where did you get that from?

  4. #4
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    108,822

    Re: TSHIFT function?

    Quote Originally Posted by Niya View Post
    I haven't been able to find a TSHIFT function in Google. Where did you get that from?
    I thought that it might be VBA but I couldn't find evidence of that. It's probably a custom function in that specific Access application, although I guess we'll see.

  5. #5
    Banned
    Join Date
    Nov 2011
    Posts
    7,803

    Re: TSHIFT function?

    Quote Originally Posted by jmcilhinney View Post
    I thought that it might be VBA but I couldn't find evidence of that. It's probably a custom function in that specific Access application, although I guess we'll see.
    Yea I was thinking the same thing.

  6. #6
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,319

  7. #7

    Thread Starter
    New Member
    Join Date
    Aug 2022
    Posts
    2

    Re: TSHIFT function?

    Quote Originally Posted by jmcilhinney View Post
    I thought that it might be VBA but I couldn't find evidence of that. It's probably a custom function in that specific Access application, although I guess we'll see.
    You are quite right, it is a custom function, I have found the code so will try to recreate in Excel.

    Thanks to everyone for responding.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width