Answer a statistics question and generate the right probability calculation in excel

Closed Posted May 10, 2015 Paid on delivery
Closed 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.

Big Data Sales Data Mining Data Processing Excel Statistics

Project ID: #7643939

About the project

26 proposals Remote project Active Jun 16, 2015

26 freelancers are bidding on average $77 for this job

DataHome

A proposal has not yet been provided

$147 USD in 3 days
(45 Reviews)
8.1
suyashdhoot

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

$35 USD in 3 days
(127 Reviews)
7.0
gitapodder1989

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

$150 USD in 3 days
(142 Reviews)
6.4
ProDataAnalyzer

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

$50 USD in 3 days
(79 Reviews)
6.3
citijayamala

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

$61 USD in 3 days
(68 Reviews)
5.7
DavidSolomon1991

I am ready to do the job and can do it nicely with quality work. Please, visit my profile before awarding the project.

$80 USD in 3 days
(69 Reviews)
5.4
ethicalboy

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

$39 USD in 3 days
(94 Reviews)
5.7
sonarkaushik

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

$45 USD in 2 days
(59 Reviews)
5.9
karanrajput1112

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

$40 USD in 3 days
(47 Reviews)
5.5
whiter12n

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.

$100 USD in 3 days
(8 Reviews)
5.1
aberkanefouad

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

$155 USD in 3 days
(15 Reviews)
5.0
alifarrukh786

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

$60 USD in 3 days
(38 Reviews)
5.1
uttamsaha1981

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.

$60 USD in 3 days
(33 Reviews)
4.5
numberNmatrix

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.

$30 USD in 1 day
(9 Reviews)
4.5
khnh55

A proposal has not yet been provided

$40 USD in 1 day
(5 Reviews)
3.6
biplob36

Hello, I am interested about your project and its really will not take much time as you guessed for the right person. I wish to offer my service for you within your budget of $40. I am a mechanical engineer with 6 More

$40 USD in 1 day
(3 Reviews)
2.8
anacris1

Ph.D. physicist with extensive expertise in scientific computation, mathematical modeling, Monte Carlo and stochastic simulations, quantitative analysis, software design and algorithm development. Past areas of researc More

$150 USD in 3 days
(2 Reviews)
2.6
KaziHadi

A proposal has not yet been provided

$155 USD in 3 days
(4 Reviews)
2.4
freelnat

A proposal has not yet been provided

$155 USD in 1 day
(1 Review)
0.4
hemantjalore

A proposal has not yet been provided

$61 USD in 3 days
(0 Reviews)
0.0