Analysis of Excel data

In Progress

This will be a fun (and fairly simple) project if, like me, you enjoy ripping data sets apart :)

I have a very simple but very large spreadsheet for which I need to calculate some pretty basic data. I just don't have the time to do it. I reckon it's a few hours work. I am attaching a very limited version of the spreadsheet. The full sheet will be identical in layout but with about 500,000 rows in each worksheet.

As long as you are expert at use of Pivots, data cleaning and basic linear and statistical analysis you should find this easy. There are four worksheets with several hundred thousands of rows (but very simple data)

The data is all about the responses to 4 test types. Each worksheet contains the test id (most tests comprise 30 questions), question id, question type and whether the response was right or wrong.

The number of times a question is answered varies significantly so I also need to know the confidence level and intervals that we could apply to the result for each question, and also to the whole analysis. It would also be useful to know the sample size we should need for each question to obtain 95%/5% and 99%/1% confidence levels/interval.

I want to pull out the following stats:

The difficulty for each question type (based on % of correct answers) ranked and then indexed by decile and then a histogram produced of the results for each of the test types.

I then want to apply the findings to the individual test results to see what the distribution of difficulty of questions is within each test, and then rank the tests according to their "difficulty" and provide an appropriately detailed histogram

I'll know if you are the right person for the job by the quality of questions that you ask from your review of the speadsheet. I have deliberately withheld a couple of items of information that will be needed to complete this task :)

Skills: Mathematics, Statistics

See more: what job for an excel expert, what is ranked data in statistics, test excel expert, stats answers, ranked data statistics, number mathematics, job need mathematics, job for excel expert, indexed data, fun with excel, Find mathematics, find an excel expert, expert excel job, excel test expert, data analysis with excel, data analysis for excel, be expert in excel, ask excel expert, ask excel, statistics job, excel test for job, excel sheet expert, excel expert 2013, statistics task, statistics linear

About the Employer:
( 264 reviews ) Porchfield, United Kingdom

Project ID: #4526082

Awarded to:


This is interesting job. Hope to have a chance to work with you, thanks.

$55 USD in 3 days
(0 Reviews)

31 freelancers are bidding on average $121 for this job


Hi, I would like to do it. Thanks

$147 USD in 3 days
(21 Reviews)

Hi I am interested and I have lot of experience in data analysis tool in MS excel. I know the z test,chi square etc Let start

$105 USD in 3 days
(67 Reviews)

Hi. I think I can do this. See PM with examples of my similar works done. Regards.

$166 USD in 3 days
(29 Reviews)

An experienced Statistician with sound experience in SPSS, Stata, Eviews, R, Excel and have the expertise to complete the project.

$166 USD in 3 days
(14 Reviews)

Please check PM for details.

$150 USD in 7 days
(23 Reviews)

Happy to help you out !!

$105 USD in 3 days
(33 Reviews)

I have done a good number of projects based on excel functions and macros. Please send the remaining information through private message. Thank You.

$140 USD in 2 days
(9 Reviews)

I've spent the last 15 years using Excel for everything and Data Ripper is my middle name...

$144 USD in 7 days
(3 Reviews)

Professional from academic institute can take care

$147 USD in 3 days
(16 Reviews)

I looked through the sample you sent and I should have no problem completing this for you in the next few days. Please check PMB

$122 USD in 4 days
(5 Reviews)

Hi, can start right now. Please see my portfolio sent you in private message.

$66 USD in 6 days
(1 Review)

Hi, I am a research scientist and can very easily do this project for you. My rates are $50.00 and I think I can do this in 3 hours. Please see my video book @ More

$166 USD in 3 days
(1 Review)

Dear Sir. Kindly check PM. thanks - Priyal

$98 USD in 2 days
(5 Reviews)

I have a degree. Please consider me.

$105 USD in 3 days
(1 Review)

I work every day with excel for statistics and big data.

$111 USD in 3 days
(0 Reviews)

I am an expert with data manipulation. I also have a good deal of statistical experience especially with respect to Monte-Carlo techniques.

$177 USD in 15 days
(0 Reviews)

Kindly check your inbox. I am interested.

$111 USD in 2 days
(0 Reviews)

Dear, I would like to finish this job for you! Please, to start as quickly, sent to me the needed Excel files!

$56 USD in 3 days
(0 Reviews)

I am interested in this project.

$200 USD in 3 days
(0 Reviews)

I can easily do this work for you in less than an instant.If you hire me now,I can start immediately.I have positive feedback and 100% completion rate; you can check and trust me.Looking forward to start working with y More

$155 USD in 3 days
(0 Reviews)