Which dataset did you choose?
I selected “Unemployment rates” dataset.
Run descriptive statistics in the Analysis Toolpak.
Create and insert at least 2 charts that portray your data, for example bar chart showing the difference between the groups, or line graph showing the relationship between two variables.
Bar chart:
Scatter plot:
What is your null hypothesis about the data?
There is no linear relationship between the unemployment rates of college and high school graduates in 2000 – 2011.
What is your alternative hypothesis?
There is a significant linear relationship between the unemployment rates of college and high school graduates in 2000 – 2011
Choose the appropriate test to run (one-sample z, t-test, ANOVA, linear regression, or chi-square). What test did you run and why is it appropriate for the dataset?
Linear regression is chosen because this test examines the linear relationship between two quantitative variables.
What level of significance will you use to test your hypothesis?
Set the level of significance at 0.05.
Is this test statistically significant? How did you make this determination?
Yes, it is. I have made this determination by looking on the p-value of the College coefficient and on the ANOVA results. The p-value is less than 0.05
What is your statistical conclusion (i.e. are you rejecting or failing to reject the null hypothesis)?
The null hypothesis is rejected.
What is your experimental conclusion (i.e. what are you concluding about your original hypothesis based on the test that you have conducted)?
There is a significant linear relationship between the unemployment rates of college and high school graduates in 2000 – 2011.
