EXCEL FORMULA

Data is believed to be generated by an exponential random variable. A thousand data values are collected. Determine the average in C2 and compile the data into relative frequency bins (see E2:E5) in F2:F5. Using the average as mean, give in G2:G5 the proportions of data expected in each bin for an exponential process. Since the values in column G are proportions, determine in H2:15 the upper and lower bounds of 90% confidence intervals for an average over a sample of size 1000 for Bernoulli random variables of these proportions (i.e. in H2 the lower bound for a 90% confidence interval for an average over a sample of size 1000 of a Bernoulli (G2) random variable, etc.). Then indicate whether the relative frequencies are within these confidence intervals with YES or NO in J2:55. We accept that we do indeed have an exponential random variable if all four relative frequencies lie in their respective confidence intervals. Indicate whether we accept or reject the exponential random variable hypothesis with ACCEPT" or "REJECT" in L2. Illustrate the relationship between the bounds and the relative frequency by plotting columns F:1 against column E in C7-J22 with line plots. B D K G theory rel freq H lower bound upper bound within range? L accept/reject? 1 average 8.5946 E bins [0,5) [5, 10) [10, 15) [15, +00) 0 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 A data 13.6 23.86 10.81 2.52 7.31 11.56 6.15 16.12 1.69 0.37 37.41 6.09 3 0.47 6.64 3.31 5.16 1.81 18.01 22.29 0.58 16.83 6.18 21.76 25.78 3.21 0.58 12.96 15.03 2.28 12.2 0.49 0.51 0.04 34.79 53.41 1.08 3.12 3.8 1.47 1.13 4.72 2.73 4.52 18.74