Plotting Cumulative Density Functions and Chi Squared in Excel (Statistics!)

[whitemountains]

Hello Everyone!

I have just joined this site to get some help. I am hoping that I will be able contributions as well, I would like to help lots of people out!

I am having trouble trying to figure out how to plot a CDF of some empirical data I collected from a study. I also need to do a Chi Square test to prove the data is exponentially distributed. The data table is below:

Trial (Time Spent Reading, seconds)
1 1.88
2 0.54
3 1.9
4 0.15
5 0.02
6 2.81
7 1.5
8 0.53
9 2.62
10 2.67
11 3.53
12 0.53
13 1.8
14 0.79
15 0.21
16 0.8
17 0.26
18 0.63
19 0.36
20 2.03
21 1.42
22 1.28
23 0.82
24 2.16
25 0.05
26 0.04
27 1.49
28 0.66
29 2.03
30 1
31 0.39
32 0.34
33 0.01
34 0.1
35 1.1
36 0.24
37 0.26
38 0.45
39 0.17
40 4.29
41 0.8
42 5.5
43 4.91
44 0.35
45 0.36
46 0.9
47 1.03
48 1.73
49 0.38
50 0.48

If anyone is able to explain how to go about this please feel free to chime in. I appreciate everyone's help.

Best Regards,

WhiteMtns

[MrShorty]

I am not enough of a statistician to teach you how to perform a chi square test. If you need help understanding the basics of a chi square test and distribution, I would first suggest studying the appropriate section in a good intro to stats text.

Once you understand how to perform a chi square test, Excel provides several chi square related functions. See this help file and the related functions at the bottom of the page http://office.microsoft.com/en-us/ma...in=HA102927529