Tamamlanmış

Simple Spreadsheet Pivot Table

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.

Beceriler: Excel, HTML, Microsoft Access, İstatistik

Daha fazlasını gör: spreadsheet in html, sample pay roll, pay roll format, m format in excel, human scale, html to spreadsheet, html spreadsheet, get to know you survey, get to know survey, statistician, simple excel, Roll up, pivot table excel, pay roll, need statistician, need a statistician, looking for statistician, i need a statistician to work with, human factor, excel to my sql, excel stats, excel PIVOT, excel pivot table, database population, database consult

İşveren Hakkında:
( 81 değerlendirme ) Saratoga Springs, United States

Proje NO: #5557682

Seçilen:

avinav606lx

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. Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(7 Değerlendirme)
3.3

Bu iş için 7 freelancer ortalamada $33 teklif veriyor

ethicalboy

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde72%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(43 Değerlendirme)
5.1
seomaster212

Hi sir i am ready for work kindly check pm. Hi sir kindly let me know in pm for discussion Thanks. Regards seomaster

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(20 Değerlendirme)
4.1
elqueabandona

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 al Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.2
rashidaliansari

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.0
kanishkpanchal

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Aan12

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0