Complete data set is test scores and dates of 10 practice exams for about 60,000 students. I want some analysis done on the scores (data are in 60 excel files of 1,000 students each, see sample attached ). A Full list of tests will follow below. I would prefer to have a script built to perform the tests but for short term, I just need someone to run the data analysis and provide the results.
1 - Average score progression for all students on exams 1-5, 1-6, 1-7, 1-8, 1-9, 1-10
2 - Average score on each exam (with total # of scores reported)
3 - Test for significance of any difference in average scores from analysis 1 and analysis 2
4 - Ranking of all tests from most reported scores to fewest reported scores
5 - Ranking of all Bundles from most popular to least popular
6 - Correlation of # of tests taken to Highest score achieved on any test
7 - Use dates to determine most common sequence of exams (e.g. is it 1-2-3 or 1-4-6-7?)
This project is time sensitive so work on parts 1-4 must be done by 3pm PST on Sunday, February 11th 2018.