Hello. I am looking for a simple Excel job to be done. I have an 84-question survey (data is pulled from Survey Monday in Excel format). Each question is answered on four point scale (1-4). Those 84 items roll up to four factors. I built an Excel spreadsheet, using a pivot table, to flow the survey responses into the appropriate factors and to compute an average for each factor. Though my Excel skills don't extend very deeply, I did a decent job, proving the concept, if nothing else. I would like someone with strong Excel skills to re-do this. I need to have full confidence in the accuracy of the data, and, frankly, I don't that confidence in myself!
Also, this spreadsheet will eventually be converted into the backend of a website where calculations can be done. But, that will be in the future. I mention this only because I would like what is done to be easily converted later. If you have some HTML/XML/.NET/SQL or whatever else competencies, please let me know. If you would prefer to build something with both Access and Excel, that would be acceptable.
If you are a statistician who can do this work, then I might wish to consult you later as I begin my reliability/validity calculations on the entire sample population.
This will be a simple job for the right person. As the range for this job is only $10-$30, please understand I will be bidding more on promptness, skillset, and feedback than on price.
I will give bidding priority to:
1. Someone who actually reads this and is able to re-state what I am looking for. I will not respond to auto-bids. Of course, if you're auto-bidding, you won't be reading this anyway, so I'm sure to get such bids. If you're a human who takes a moment to read and digest this, you are favored.
2. People with additional stats and HTML skillsets. If you don't have these, but can do this job at an attractive price, do not hesitate to bid
3. Someone with #1 and #2 who can do this soon. It's not an emergency, but I'd like to have this asap.
I pay promptly and will do so upon receipt of a spreadsheet (or Access database) verified to be accurate.
Thank you for reading, and happy bidding.
Hi There,
Thanks for posting the project , I have gone through the project and its looks interesting to me.
As a next step, I would like to discuss more on the survey data format and analysis needed in the pivot. Post that I would be able to start the work.
I am Excel/Access automation professional with 5+ years of experience and can provide you the required quality output here. I am available on-line to discuss more
Thanks,
Abhinav
$30 USD en 1 día
5,0 (7 comentarios)
3,3
3,3
7 freelancers están ofertando un promedio de $33 USD por este trabajo
Hello electric circle. I read what you write, I can provide more descriptive statistics if I have your file, I think in surveys mode play more important role rather than average, also I can provide charts,.., and also correlations to show which questions have an association together, also I can do this using SPSS which is better software for survey analysis and also use NVIVO for qualitative answers (if any), although you may want excel for future use. Also about me:
I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating and finance that helps in this project.
Hello, I have a degree in Business, and use excel every day as part of my job. I have worked with data resulting from surveys as part of my thesis, and I have analyzed and interpreted the resulting information. I am also very neat and tidy. Best regards, Cristian.
Hello,
I have a very strong analytical experience in looking at data in different ways gained through two Master's degrees. The most recent one was in Business Analytics.
I also have three years of experience in doing statistical analysis using excel/access/R/Python.
I can provide you two versions for your survey data analysis. One using Excel only and second version using Excel and Access. If you want to take it to the next level with more data, we can think about using a simple statistical tool to further our analysis.
Please don't hesitate to reach out to me if you have any questions or concerns.
Thanks and Best Regards,
Kanishk
I read the task, and I think it is pretty simple.
Re-state: You have a set of question that have 84 questions in total. Every question in this set have a value, that can move in a range from 1 to 4. You maked a Pivot Table for calculate the mean of the dataset, for every person that take the test.
I can help with this proyect because I have great manage of Excel formulas.
I study Math too, so, I can help with the statistic part.
I have basic knowledge about HTML, but, I manage MS Access Database and Forms.