Please tell me what Excel commands you used to solve. Thanks 3. Make in Excel th

Question

Please tell me what Excel commands you used to solve. Thanks 3. Make in Excel three tables size 50 × 100, 250 × 100, 1000 × 100 with Bernoulli distributed random numbers for p(1) = 1/5: Use the generated tables for calculating new column as the average of the first 100 columns. Random numbers in this column will have distribution close to the Normal distribution. Find population probability distrib- ution functions, means, variances and standard deviations and compare its with sample frequency distribution functions, averages, sample estimation of variances and standard deviations for each table. Draw the graphs. Estimate mean and variance for the random variables in the obtained samples using 90% confidence intervals. For estimation of the variance use estimated mean obtained from the sample, and population mean = Recalculate the tables 10 times and determine how many times the population mean and 2 don't belong to the obtained confident intervals for the both cases of estimations. (5 points) 1/5, compare the obtained confidence intervals.

Explanation / Answer

step 1: Use =INT(RAND()*1/(1-0.028)) to generate one bernoulli random number

step 2: create 3 tables(just select the cell and drag the formula to make the tables)

step 3: use =SUM(,) function to create a new column with sum of 100 columns

step 4: use MEAN() =STDEV() functions on each of the tables and compare the values.

..............................

REPEAT steps 1 to 4 ...10 times ....and capture means to calculate confidence intervals

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---