Find Jobs
Hire Freelancers

Biostatistics Calculations in Excel

$250-750 AUD

Completed
Posted over 10 years ago

$250-750 AUD

Paid on delivery
I need someone to create a spread that can perform some statistical calculations. The calculations are for quantal bioassays (eg Median lethal dose 50%) where there are different dose levels and the response is binomial (alive/dead). Spearman-Karber method Probit method Reed & Muench (with 95% CI limits) I have attached some work that was done on this previously by another freelancer that never got completely finished. I would like each method to be able to handle up to 10 dose levels (but selectable number), and either constant number of subjects per level or variable. It must compute a 95% CI for each result. There are a few reference papers i can supply on these methods if required (some attached). I want to get a single Excel spreadsheet that i can use to compare run each of these analysis methods on a separate tab. The 3 methods must be able to produce a standard printout which has a neat appearance and shows the data, calculation and result.
Project ID: 5205536

About the project

22 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
This is my first bid, and I want to start making an impression and getting a good reputation, so I am selling my abilities cheaply. I have extensive experience as a biomedical engineer, so this sort of statistical analysis is routine. I have plenty of experience in excel, as well as coding. Thank you for your consideration, P Marathakis
$277 AUD in 2 days
5.0 (2 reviews)
3.0
3.0
22 freelancers are bidding on average $519 AUD for this job
User Avatar
Expert in statistics is here to solve your problem. I am one of the best ranking freelancer in statistics in Freelancer.com.
$500 AUD in 7 days
4.9 (233 reviews)
6.8
6.8
User Avatar
Excel/ VBA expert with great experience here...Lets discuss the project in detail.. I have looked at files and am confident to work on this project.
$400 AUD in 7 days
4.9 (252 reviews)
6.8
6.8
User Avatar
Hi. I think I can do this work for you. Nere some examples of similar works done by me earlier: http://www.freelancer.com/projects/Excel-Financial-Research/stat-econ-work.html http://www.freelancer.com/projects/Visual-Basic-Excel/Financial-Loan-repayment-model.html ... and much more in my profile. Regards
$340 AUD in 14 days
4.9 (169 reviews)
6.8
6.8
User Avatar
It has been a while andrewpadula, If you are comfortable with an R script I could code an automated program that will calculate these values. Let me know, SstatsC
$1,000 AUD in 14 days
5.0 (48 reviews)
6.6
6.6
User Avatar
A proposal has not yet been provided
$333 AUD in 5 days
5.0 (84 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
$736 AUD in 4 days
4.9 (27 reviews)
5.0
5.0
User Avatar
I am a biochemist with a Masters Degree in Biotechnology. I have five years of experience as a microbiologist in baker's yeast production. I have five years of experience in using Excel and statistics for my own tests. Please check my profile and contact me for further information.
$277 AUD in 5 days
4.9 (13 reviews)
5.1
5.1
User Avatar
I am an academic, professional consultant in Statistics and Econometrics and have been publishing research in Health Economics so I am feeling more than confident to bring the desired output/spreadsheet in perfection. I have already completed many such projects in related and other areas like Finance (more advanced calculations needed). Also to inform you a little: As an instructor of Applied Statistics and Econometrics, I am teaching all my courses with any of Stata, Eviews, SPSS, R and Matlab as suitable for the candidates. I deliver advanced contents with real-world cases in Statistical Analysis and Econometric Modelling. Main contents of my courses vary in the areas of Qualitative Data Analysis, Factor Analysis, Principle Component Analysis, Power and Sample Size determination for Survival Studies, Analysis of Open ended surveys and interviews, Multivariate Time Series techniques in VAR/VECM, VARX, SVAR, Multivariate GARCH, ARDL and Bayesian Multivariate Time Series Methods. My courses broadly in the following categories beside the Common Courses in Economics: 1. Advanced Econometrics Modelling using Stata, R, Matlab and Eviews 2. Advanced Financial Econometrics using R and Matlab 3. Advanced Multivariate Statistics using SPSS and Stata 4. Qualitative Data Analysis using R, Stata and SPSS 5. Text, Audio and Survey Analysis using Nvivo
$777 AUD in 7 days
5.0 (4 reviews)
4.0
4.0
User Avatar
Hello , I am a chemical engineering with more than 30 years experience in process analysis and design, statistics and math. I master also Excel and its functions, I have developed many scientific applications based on Excel. I would like to offer my services in order to complete this project. Regards
$500 AUD in 3 days
4.9 (4 reviews)
3.7
3.7
User Avatar
I am a statistician engineer working as a database manager. I master Excel VBA for having work with it there is more than 4 years. I am ready to do this job for you.
$526 AUD in 10 days
5.0 (4 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
$773 AUD in 10 days
3.7 (4 reviews)
4.3
4.3
User Avatar
Hi, I'm graduated a Economics Faculty and Computer Science also. I was very good on Statistics course. I need to actualize my knowledge and I can do this job. Do you have a deadline? Thanks, Liviu
$300 AUD in 10 days
5.0 (1 review)
2.6
2.6
User Avatar
Hello, i am very experienced vb6 / VBA macro coding (12 years) in all Ms. Office Excel/Access/Word/Powerpoint... and will deliver this excellent quality for you!
$320 AUD in 7 days
5.0 (2 reviews)
2.0
2.0
User Avatar
PROPOSAL: 1. Review existing spreadsheet and articles [2hr] 2. Obtain required level of understanding re statistical methods to be used - I have examined the Spearman-Karber method and would need to update myself on the Probit method and Reed & Muench [2hr] 3. Draft layout, calculation and results [2hr] 4. Review and obtain feedback [1hr] 5. Finalise layout [1hr] 6. Build calculations, VBA functions and other controls to make it work [2hr] 7. Test with data and verify results [2hr] 8. Handover and user guidance [2hr] Total hours 14, with general rate of 2 hour progress per day. I have been creating spreadsheets on Excel for the past 17 years and being automating with VBA for the past 3 years. I have been involved with 3 post graduate research projects doing the data analysis (including my degree) and have applied it to market survey as a consultant.
$266 AUD in 7 days
5.0 (1 review)
0.8
0.8
User Avatar
Hello there, Tasks provided will be completed efficiently, accurately and within time. Your data will remain 100% secure. Please provide your timeline and other requisites while offering the project Regards, Akshat Bisht
$333 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Предложение еще не подано
$750 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have been studing excel makros and Visual Basic for many years during my studies at the University. I be able to finish the job in 3-5 days. Feel free to contact me. Pawel
$555 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a graduate of Cell Biology and Genetics. I can do the assignment for you. You must create a milestone first of all before I start. I need all the data and I need to discuss with you. Regards Theresa.
$340 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Andrew, I am a bioinformatics PhD student at University of Cambridge, United Kingdom. As part of my research, I have extensive experience in applying and implementing statistical models to analyse biological data. Although nowadays I mostly use R and Perl for my analyses, my primary software used to be Excel and Visual Basic in my previous lab where I did research for four years. My own field of research is cancer genomics, but I am confident that I will be able to transfer my methods and skills successfully to generate the Excel formulae that you need. I have a Master's degree in biology, but I have also taken almost three years equivalent of undergraduate level courses in statistics and computer science. It is because of my formal training background in both biology and statistics that I believe I will be able to both understand that literature that you provided, as well as implement the statistical methods therein. As tangible evidence of my scientific productivity, I have a number of articles accepted or under consideration in top scientific journals. These journals include Science (Makinen et al. 2011), Nature Genetics, Nature Biotechnology, Cell and two Nature manuscripts. I can provide details on these manuscripts if you are interested. I estimate I need around two weeks to go through the papers and implement the methods, and provisionally another 1-2 weeks review them with you. Looking forward to working with you! Yours Sincerely, Yilong Li
$600 AUD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Bairnsdale, Australia
4.9
13
Payment method verified
Member since Aug 12, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.