Hello!
I have a table of data that I have to show statistical significance for. The data compares the number of minority vs. nonminority persons in a program who were employed vs. unemployed during quarter 2 last year. I have to show that the differences between minority vs. nonminority pairs per row are either significant or not. I am having my work compared against another person who is doing the same work (if we get the same answers, they consider findings to significance testing confirmed, as this is a highstakes report). Their output from SPSS shows significance in some pairs but not others, using a "twosided test of equality for column proportions." The rule is that I must conduct the test using another tool besides SPSS to get that confirmation that our work is right. I attached the original data, the SPSS output I have to match, and a third tab to do this testing in. I don't know how to use R or SAS for this. My questions are:
1) Is this twosided test of equality for column proportions the same thing as a ztest? If not, what IS this test?
2) With this specific dataset, how do I conduct the right test in excel? Or, should I use an online calculator of some sort to do it?
This has become time sensitive, and so any help is genuinely appreciated, thank you!
I have a table of data that I have to show statistical significance for. The data compares the number of minority vs. nonminority persons in a program who were employed vs. unemployed during quarter 2 last year. I have to show that the differences between minority vs. nonminority pairs per row are either significant or not. I am having my work compared against another person who is doing the same work (if we get the same answers, they consider findings to significance testing confirmed, as this is a highstakes report). Their output from SPSS shows significance in some pairs but not others, using a "twosided test of equality for column proportions." The rule is that I must conduct the test using another tool besides SPSS to get that confirmation that our work is right. I attached the original data, the SPSS output I have to match, and a third tab to do this testing in. I don't know how to use R or SAS for this. My questions are:
1) Is this twosided test of equality for column proportions the same thing as a ztest? If not, what IS this test?
2) With this specific dataset, how do I conduct the right test in excel? Or, should I use an online calculator of some sort to do it?
This has become time sensitive, and so any help is genuinely appreciated, thank you!
Attachments

159.1 KB Views: 1

146.8 KB Views: 1

135.9 KB Views: 1