 Hi Eileen, this is this homework problem you sent me an email about and it has to do with solving a contingency table and in this case they're asking for relative frequencies or a percentage for a intersection in the table of I think they're looking for employed but not a high school graduate so we've got our count is 8.1 and we want to know what is the percentage and you can do it of course using Excel the long ways but statcrunch makes it very easy let's first of all click on the icon we're going to copy that data into statcrunch and now we've got our our data we've got our row labels employed unemployed not in the labor market and then we've got our column labels not a high school high school some college associates so let's go to stat tables contingency with summary now this is a summary this is raw data this is the summary data so we bring up this dialogue and we need to pick the columns that we're interested in and we're going to pick all four just by clicking on it holding on the shift key and we're going to hit all four of our columns that we're interested in because we want to get the entire contingency table our row labels are in that first column called status we can ignore the column labeling group by and you've got a lot of options here if you're doing the complete contingency table you would pick more of these right now I'm just going to pick two I'm going to pick the percent of total which is what they asked for well let's just do that begin with and I'm going to go ahead and leave the chi square just for the heck of it the hypothesis test pick and we click on compute we got to expand this in order to see all the data I gotta go some more there we go I don't know why it's stretched oh you see why I had that big long title there and we're looking for the percentage that is both employed and not a high school grad and it gives us right there 4.42% and I think if we looked at their answer yeah what did you come up with you got 9.9 I'm not sure how you did that unless you manually calculated these things but anyway that's that's how you get the percentages if they asked you for the expected counts just go back into your options edit and this time let's click on expected count click on compute and we'll get that data come up and it tells you here in this little legend the actual count and the expected count and in that employed not high school the actual count was 8.1 but the expected count was 16.93 that's a big difference and if you look across here we've got quite a few big differences and that will take that tells you why the chi-square hypothesis test is significant which tells you that there is a difference in the actual and the expected so that test is significant and we would reject the null hypothesis but again you can go back and forth we edit this and we can get our row percent I'm gonna really junk it up here and compute and it may look like it's unintelligible but you can actually get all this information there by again looking at the legend we've got the count the row percent the column percent percent of total which is what this question was and the expected count so you've got all the data you need to answer any contingency table problem that you might have hope this helps