Share via

Excel - PHStat

Anonymous
2020-09-08T08:07:35+00:00

Hi,

I've encountered problems when calculating with the macro "PHStat". When I'm doing a one-sample test for when sigma is known and I put in all the data I get error for the level of significance. The errors look accordingly to the pictures attached.

Please help!

Sincerely,

Martin Hezsö

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-09-11T09:12:56+00:00

    The same problem arises when I'm doing a t test when sigma is unknown and I'm putting in the variables.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-10-01T08:14:55+00:00

    The same problem arises when I'm doing a t test when sigma is unknown and I'm putting in the variables.

    Hi

    I've got a few of my friends who have the same issue.

    Have you managed to figure out why, it works perfectly well on my laptop but not theres.

    Changing from decimals to dots also doesn't help

    Have you uninstalled the program and re-installed it?

    Thanks a tonne!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-09-11T09:11:02+00:00

    Thanks for the reply Jen!

    It doesn't matter if I'm changing the the commas to dots in the data. I have the comma as a separator in the settings. The error keeps popping up in the same matter...

    Any other suggestions?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-09-08T11:42:44+00:00

    Hello Martin! I'm Jen, an independent advisor and a fellow Microsoft user like you. I'd be happy to help you out with this issue.

    Could you please check if your data in column A are formatted as numbers? Try changing the values with dot as decimal separator (example: for A1, make it 7.42) and see if it makes any difference.

    Meanwhile, you might want to check out this video link which discussed about using PHStat to solve a hypothesis test for single sample t-test for the mean.

    https://www.youtube.com/watch?v=Qq7vRipF1x0

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    Hope this helps you.

    If you have any questions, please let me know and I'd be glad to assist you further.

    Thank you and Best Regards!

    Jen :)

    Was this answer helpful?

    0 comments