©
Bags μ σ (from Excel)
Estimates the parameters (via shell_exec and Python)
2024.Jul.03 13:40:47
File to upload (Optional) Uploaded file '.xlsx', such as cargas06.xlsx .
Weight Weight key.
Number Number key (count).
'csv' data Screen data (in 'csv' format, Am or Eu),
ignored (though necessary) if a file is uploaded
Confidence level % Confidence level.
Trials, classes, seed Monte Carlo data.
Show values Show graph coordinates.

From Excel file (uploaded '.xlsx' or inserted '.csv') of the weights of loads of various (unequal) sample sizes, with underlying Gaussian behavior, computes: point estimates of the parameters, μ and σ; and their confidence intervals for a given confidence level.

By Monte Carlo, a histogram is produced leading to the confidence intervals. If 'classes' is given 0, an automatic (Python) number of classes is used. (This may lead to different 'classes' for each graph.)

The default data (with 'seed' = 97531), lead to μ (24.90, 24.91, 24.92) and σ (0.19, 0.465, 0.74), in ~16 s time.

Warning: due to execution on the Internet, run times are limited to ~1 min.

References: Plate: Bags_python

• Google: php exec vs shell_exec vs...

• (Wikipedia) Histogram (Number of bins and width). For 'classes' = 0, auto is used (max. of Sturges and Freedman-Diaconis rules.

• 1873-03-29: Levi-Civita, Tullio (†1941-12-29, 68 yrs.).

 
 
Valid HTML 4.01! IST http://web.tecnico.ulisboa.pt/~mcasquilho/cgi-bin/garage/Q-bags.php
Created: 2021-03-29 — Last modified: 2021-04-01