Question: fa) Filter the data to focus on unemployed Canadians. Using the sample data, construct a relative frequency distribution of unemployed Canadians by province. b) Create

 \fa) Filter the data to focus on unemployed Canadians. Using thesample data, construct a relative frequency distribution of unemployed Canadians by province.

\fa) 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 labels 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 formal statistical test to compare the distributions. At the 5% signicance level, should we reject or not reject the claim that the distribution of unemployed Canadians by province is the same as the distribution of Canadian population by province? (Hint: Apply the x2 test of goodness of fit.) Are there any provinces that seem to have a higher than expected number of unemployed workers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!