Create a Analyze a Self-Designed Statistical Study

For this assignment you will undertake an analysis based on a self-designed fictitious study that utilizes statistical analyses. You will first develop a fictitious problem to examine. It can be anything. For example, maybe you want to look at whether scores on a standardized college placement test (such as the SAT) are related to the level of income a person makes 10 years after college, or whether those who participate in a Leadership Training program were later rated as better managers compared to those who did not take the training, or whether political affiliation is related to gender. These are just a few examples. Be creative and think about what piques your interest. You might also address a problem that you may want to examine in future research for a thesis or dissertation.

You will use Excel to conduct the analysis. Write an analysis report in which you include the following:

1. Describe your research study.
2. State a hypothesis.
3. List and explain the variables you would collect in this study. There must be a minimum of three (3) variables and two (2) must meet the assumptions for a correlational analysis.
4. Create a fictitious data set that you will analyze. The data should have a minimum of 30 cases, but not more than 50 cases.
5. Conduct a descriptive data analysis that includes the following: a) a measure of central tendency; b) a measure of dispersion and c) at least one graph.
6. Briefly interpret the descriptive data analysis.
7. Conduct the appropriate statistical test that will answer your hypothesis. It must be a statistical test covered in this course such as regression analysis, single t-test, independent t-test, cross-tabulations, Chi-square, or One-Way ANOVA. Explain your justification for using the test based on the type of data and the level of measurement that the data lends to for the statistical analysis.
8. Report and interpret your findings. Use APA style and include a statement about whether you reject or fail to reject the null hypothesis. 
9. Copy and paste your Excel data output to include it as an appendix to your document submission.
10. Remember, the goal of this project is to show what you have learned in the course. Therefore, this project becomes a cumulative learning project where you can demonstrate what you have learned through all the previous assignments, readings and video presentations that you have watched.

Support your paper with a minimum of five (5) scholarly resources. In addition to these specified resources, other appropriate scholarly resources, including older articles, may be included.

Length: 10-12 pages not including title and reference pages, may include spreadsheets