I need some help on my stat lab assignment. We are using StatCrunch for the data listing... (here is some data)

I know it will take a while to work on it, but I will so appreciate it if someone could help me... thanks :)

4. Using the second dataset, the marketing company wants to answer various questions regarding the relationship between the income groups and cities. (a) Obtain a contingency table (ensure you select Row percent, Column percent, and Percent of total) of household income group by city. Paste the table into your report. (b) Refer to the output in part (a) to answer the following questions: What percentage of all households are in Edmonton and have income between $50,000 and $99,999? What percentage of Edmonton households have income between $50,000 and $99,999? What percentage of the group with income between $50,000 and $99,999 are in Edmonton? (0) Using a = 0.05, is there any evidence that there was a difference in the proportion of households with under $50,000 income between Edmonton and Calgary? Carry out the appropriate two sample proportion test. Paste the output into your report. State the null and alternative hypotheses. Report the value of the appropriate test statistic, the distribution of the test statistic under the null hypothesis, and the Pvalue of the test to answer the question. State your conclusion. ((1) Using a = 0.05, is there any evidence that there was a difference in the proportion of households with under $50,000 income for Edmonton and Calgary? Carry out a chisquare test for homogeneity. Paste the output into your report including the expected values. State the null and alternative hypotheses. Report the value of the appropriate test statistic, the distribution of the test statistic under the null hypothesis, and the Pvalue of the test to answer the question. State your conclusion. (e) What is the relationship between the tests in parts (0) and (d)? More specically, compare the test statistics and the pvalue. (1) Using a = 0.05, carry out an appropriate test to test there was no relationship between the income groups and city. State the null and alternative hypotheses. Paste the output into your report including the expected values. Report the value of the appropriate test statistic, the distribution of the test statistic under the null hypothesis, and the Pvalue of the test to answer the question. State your conclusion. 5. Briey summarize the study. In particular, answer the following questions: Should the marketing company use the distribution of income groups from the 2016 census to relate to the sample data for either city? Does the company notice any difference in the distribution of income groups between Edmonton and Calgary? 153 $50,000 to $99,999 Income Under $50,000 $50,000 to $99,999 Household City 51 Edmonton 102 Calgary Calgary Edmonton Under $50,000 52 Edmonton Under $50,000 103 Calgary $50,000 to $99,999 154 Calgary $50,000 to $99,999 155 Calgary $100,000 and over Edmonton 53 $50,000 to $99,999 Under $50,000 Edmonton $50,000 to $99,999 104 Calgary W N Edmonton $50,000 to $99,999 54 Edmonton $100,000 and over 105 Calgary $100,000 and over 156 Calgary $100,000 and over Under $50,000 Edmonton $100,000 and 55 Edmonton Under $50,000 106 Calgary $100,000 and over 157 Calgary 158 Calgary $50,000 to $99,999 5 107 Under $50,000 Edmonton Under $50,000 56 Edmonton $50,000 to $99,999 Calgary $50,000 to $99,999 108 Calgary $50,000 to $99,999 159 Calgary Under $50,00 Edmonton 00 to $99, 57 Edmonton 160 Calgary $50,000 to $99,999 Edmonton $50,000 to $99,999 58 Edmonton $100,000 and over 109 Calgary Under $50,000 Edmonton $100,000 and over 59 Edmonton $100,000 and over 110 Calgary $50,000 to $99,999 161 Calgary Under $50,000 9 Edmonton $100,000 and over 60 Edmonton Under $50,000 111 Calgary Under $50,00 162 Calgary $100,000 and over 61 Edmonton Under $50,000 112 Calgary $100,000 and over 163 Calgary $100,000 and over 10 Edmonton Under $50,000 62 Edmonton Under $50,000 113 Calgary $100,000 and over 164 Calgary $100,000 and over Edmonton Under $50,000 Under $50,000 114 Calgary $100,000 and over 165 Calgary Under $50,000 12 Edmonton Under $50,000 63 Edmonton Edmonton Under $50,000 64 Edmonton $50,000 to $99,999 115 Calgary Under $50,00 166 Calgary $50,000 to $99,999 13 $50,000 to $99,999 65 Edmonton $50,000 to $99,999 116 Calgary $50,000 to $99,999 167 Calgary Under $50,000 14 Edmonton 15 Edmonton $50,000 to $99,999 66 Edmonton $50,000 to $99,999 117 Calgary Under $50,000 168 Calgary $50,000 to $99,999 Edmonton $50,000 to $99,999 67 Edmonton $100,000 and over 118 Calgary $50,000 to $99,999 169 Calgary $100,000 and over 16 170 Calgary $100,000 and over 17 Edmonton $100,000 and over 38 Edmonton $100,000 and over 119 Calgary $100,000 and over $50,000 to $99,999 18 Edmonton $100,000 and over 69 Edmonton $50,000 to $99,999 120 Calgary $100,000 and over 171 Calgary 19 Edmonton 000 to $9 70 Edmonton $100,000 and over 121 Calgary .000 to $9 172 Calgary Under $50,000 Edmonton $50,000 to $99,999 122 173 Calgary $50,000 to $99,999 20 $100,000 and over 71 Edmonton Calgary Under $50,000 72 Edmonton $100,000 and over 123 Calgary $50,000 to $99,999 174 Calgary $50,000 to $99,999 21 Edmonton $50,000 to $99,999 $50,000 to $99,999 175 Calgary Under $50,000 22 Edmonton $100,000 and over 73 Edmonton $100,000 and over 124 Calgary Edmonton $100,000 and over 74 Edmonton $100,000 and over 125 Calgary Under $50,000 176 Calgary $100,000 and over $100,000 and over 24 Edmonton $100,000 and over 75 Edmonton $50,000 to $99,999 126 Calgary $100,000 and over 177 Calgary $50,000 to $99,999 25 Edmonton $50,000 to $99,999 76 Edmonton $50,000 to $99,999 127 Calgary $100,000 and over 178 Calgary $100,000 and over 26 Edmonton $50,000 to $99,999 77 Edmonton Under $50,000 128 Calgary $50,000 to $99,999 179 Calgary Edmonton Under $50,000 78 Edmonton Under $50,000 129 Calgary $100,000 and over 180 Calgary Under $50,000 27 181 Calgary $50,000 to $99,999 28 Edmonton Under $50,000 79 Edmonton Under $50,000 130 Calgary Under $50,000 29 Edmonton Under $50,000 80 Edmonton Under $50,000 131 Calgary $50,000 to $99,999 182 Calgary Under $50,00 Edmonton Under $50,000 81 Edmonton $50,000 to $99,999 132 Calgary Under $50,000 183 Calgary $50,000 to $99,999 30 31 Edmonton $50,000 to $99,999 82 Edmonton $50,000 to $99,999 133 Calgary $50,000 to $99,999 184 Calgary Under $50,000 Under $50,000 185 Calgary 0 and over 32 Edmonton $50,000 to $99,999 83 Edmonton $100,000 and over 134 Calgary 33 Edmonton $100,000 and over 84 Edmonton $100,000 and over 135 Calgary $100,000 and over 186 Calgary $100,000 and over Edmonton $100,000 and over 85 Edmonton $100,000 and over 136 Calgary $100,000 and over 187 Calgary $50,000 to $99,999 34 86 Edmonton $50,000 to $99,999 137 Calgary $50,000 to $99,999 188 Calgary $100,000 and over 35 Edmonton $ 100,000 and over $50,000 to $99,999 87 Edmonton $50,000 to $99,999 138 Calgary $100,000 and over 189 Calgary $100,000 and over 36 Edmonton 88 $100,000 and over Under $50,000 Edmonton Under $50,00 139 190 $50,000 to $99,999 Edmonton Calgary Calgary 37 89 Edmonton $100,000 and over 140 Calgary Under $50,000 191 Calgary Under $50,000 38 Edmonton Under $50,000 $50,000 to $99,999 Edmonton $100,000 and over 90 Edmonton $50,000 to $99,999 141 Calgary Under $50,000 192 Calgary 40 Edmonton Under $50,00 91 Edmonton $50,000 to $99,999 142 Calgary $50,000 to $99,999 193 Calgary $50,000 to $99,999 41 Edmonton Under $50,000 92 Edmonton $50,000 to $99,999 143 Calgary $50,000 to $99,999 194 Calgary Under $50,000 195 Calgary $100,000 and over 42 Edmonton Under $50,000 93 Edmonton $50,000 to $99,999 144 Calgary Under $50,000 $100,000 and over 196 Calgary $100,000 and over 43 Edmonton r $50,000 94 Edmonton $50,000 to $99,999 145 Calgary 197 $100,000 and over 44 Edmonton $50,000 to $99,999 95 Edmonton $50,000 to $99,999 146 Calgary $100,000 and over Calgary 45 Edmonton $50,000 to $99,999 96 Edmonton $100,000 and over 147 Calgary $100,000 and over 198 Calgary $50,000 to $99,999 148 Calgary $50,000 to $99,999 199 Calgary $50,000 to $99,999 46 Edmonton $100,000 and over 97 Edmonton $100,000 and over 200 $100,000 and over 47 Edmonton $ 100,000 and over BE Edmonton Under $50,000 149 Calgary $50,000 to $99,999 Calgary 48 Edmonton Under $50,00 99 Edmonton Under $50,000 150 Calgary $100,000 and over Under $50,000 49 Edmonton Under $50,000 100 Edmonton $100,000 and over 151 Calgary 50 Edmonton $100,000 and over 101 Calgary Under $50,000 152 Calgary $50,000 to $99,999