Answer a statistics question and generate the right probability calculation in excel
$30-250 USD
Paid on delivery
I have an estimate of the central limit and standard deviation (SD) of a physical phenomenon. The SD is specifically derived from a limited sample of 12 observations.
Using the 'NORMDIST' function in Excel, I have computed a probability of this phenomenon occurring, however it's obvious to me the derived probability is too 'peaked' in many instances. The normal distribution assumes the SD value is the population estimate when it is not.
Now the t-distribution is the obvious candidate (I could be wrong), but I'm not quite sure how to exactly create the same probability calculation as per the NORMDIST.
The 'NORMDIST' function gives the option of adding an 'x', a mean and an SD. The 'TDIST' function does not, it allows for an 'x', and degrees of freedom, which would be 11 in this case (n-1).
I basically want to use my sample derived SD projection, but have it rightfully treated as the sample SD, and I know 'NORMDIST' is not the right function to do that.
The calculation as I have currently is shown as below:
=((NORMDIST(999,-0.91,6.74,TRUE)-NORMDIST(0,-0.91,6.74,TRUE)))
= 44.6%
Now how I can achieve a probability derivation like this but duly considering the SD as a 12 observation sample, using a T-distribution?
This would only take a few minutes for the right person, so I don't expect bids for much more than $30-$40.
Project ID: #7643939
About the project
26 freelancers are bidding on average $77 for this job
Hi I have done 7 courses in biostatistics , probability theory ,machine learning and have tremendous experience in plotting distributions. You can use T distribution or Z distribution . I can do it easily .Please let m More
I am the top ranking freelancer of statistics and mathematics in freelancer.com and excellent in both the subjects. I am M.Sc. in mathematics. I have done a lot of similar jobs before. Please, check employer's feedback More
Hi, I am interested to complete the task. I have been a professional statistical analyst for over eight years. I can solve the problem using Excel with necessary description. Please feel free to contact me direc More
I am an expert in Excel and an experienced MBA Finance as well. I can work on your project and get you the required answer. Jayamala from India Hire Me
I am ready to do the job and can do it nicely with quality work. Please, visit my profile before awarding the project.
Hello, I think there are some functions that can be used for converting Z-normal to and it would be grea tif you can send me your file before awarding, then we can work on it although you provided some descriptions ab More
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready More
As a Post Graduate in Statistics and graduate in mathematics, i have a lot of experience in handling statistical data, especially in Time Series Modelling & Forecasting, Regression analysis,correlation , ANOVA, statist More
Hello. I am an experienced statistics professional and can figure this one out for you. Ya, the issue of n-1 in sd formula has always fascinated / confused me. This will be an interesting one to figure out.
Hello, Expert here, I am a Statistician involved in United Nations Projects in Geneva. I would be very happy to assist you in this project. I am available to discuss now. Hear from you soon, Best regards Fouad
I will help you with full dedication, and I can discuss before award of project. contact me and share details, You can create full milestones and release when I finish the work and submit to you, so that you will be in More
Expert in statistics and mathematics is here to do the job for you. Please, go through the feedback that I received from my employer before awarding the project.
I'm willing to work for you at $10. You can create another project with lower range of price so that I can bid at lower rate. Feel free to inbox me for further discussion.