Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started