The question a and b has been answered in the following picture.

Labour force status Unemployed Row Labels .T Count of Province Province Population Proportion Alberta 555 Alberta 555 0.117 British Columbia 384 British Columbia 384 0.136 Manitoba 405 Manitoba 405 0.036 New Brunswick 300 New Brunswick 300 0.021 Newfoundland and Labrador 234 Newfoundland and Labrador 234 0.014 Nova Scotia 255 Nova Scotia 255 0.026 Ontario 1041 Ontario 1041 0.389 Prince Edward Island 158 Price Edward Island 158 0.004 Quebec 597 Quebec 597 0.226 Saskatchewan 291 Saskatchewan 291 0.031 Grand Total 4220 Unemployed Population Proportion 0.45 0.4 0.35 0.3 0.25 Population Proportion 0.2 0.15 0.1 0.05 D Population Proportion Intari Island Albe Quebec Manitob Brunswick Nova Scotia Saskatchewan British Colu Net Newfoundland and Labrador e Edwa Unemployed Canadiansa} Filter the data to focus on unemployed Canadians. Using the sample data. construct a relative frequency distribution of unemployed Canadians by province. b} Create a relative frequency bar graph to visualize and compare the distributions of unemployed Canadians by province to the distribution of Canadian population by province. {Hint: Use your results in part a] and the data in the \"Province Proportions\" sheet to construct a \"Clustered Column\" graph in Excel. Ensure the graph is easy to interpret with clear labeis and a legend.) c) Examine the bar graph in part b] and comment on what you notice when comparing the distributions. Based on your observations. do you believe the distribution of unemployed Canadians by province is different from the distribution of the Canadian population? Explain. d} We will now conduct a fonnai statistical test to compare the distributions. At the 5% signicance level. should we reject or not reject the claim that the distribution of unempioyed Canadians by province is the same as the distribution of Canadian population by province? (Hint: Apply the I2 test of goodness of fit} Are there any provinces that seem to have a higher than expected number of unemployed workers