Find Jobs
Hire Freelancers

Simple Spreadsheet Pivot Table

$10-30 USD

Terminado
Publicado hace alrededor de 10 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 5557682

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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
Avatar del usuario
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.
$72 USD en 3 días
4,4 (43 comentarios)
5,1
5,1
Avatar del usuario
Hi sir i am ready for work kindly check pm. Hi sir kindly let me know in pm for discussion Thanks. Regards seomaster
$50 USD en 5 días
4,7 (20 comentarios)
4,1
4,1
Avatar del usuario
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.
$30 USD en 4 días
4,9 (4 comentarios)
3,2
3,2
Avatar del usuario
A proposal has not yet been provided
$10 USD en 0 día
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
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
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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.
$15 USD en 0 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Saratoga Springs, United States
5,0
81
Forma de pago verificada
Miembro desde jul 18, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.