Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SPC constants
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (2,0.7979,1.128,0.853,1.88,2.659,0,3.267,0,3.267);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (3,0.8862,1.693,0.888,1.023,1.954,0,2.568,0,2.574);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (4,0.9213,2.059,0.88,0.729,1.628,0,2.266,0,2.282);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (5,0.94,2.326,0.864,0.577,1.427,0,2.089,0,2.114);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (6,0.9515,2.534,0.848,0.483,1.287,0.03,1.97,0,2.004);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (7,0.9594,2.704,0.833,0.419,1.182,0.118,1.882,0.076,1.924);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (8,0.965,2.847,0.82,0.373,1.099,0.185,1.815,0.136,1.864);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (9,0.9693,2.97,0.808,0.337,1.032,0.239,1.761,0.184,1.816);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (10,0.9727,3.078,0.797,0.308,0.975,0.284,1.716,0.223,1.777);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (11,0.9754,3.173,0.787,0.285,0.927,0.321,1.679,0.256,1.744);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (12,0.9776,3.258,0.778,0.266,0.886,0.354,1.646,0.283,1.717);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (13,0.9794,3.336,0.77,0.249,0.85,0.382,1.618,0.307,1.693);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (14,0.981,3.407,0.763,0.235,0.817,0.406,1.594,0.328,1.672);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (15,0.9823,3.472,0.756,0.223,0.789,0.428,1.572,0.347,1.653);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (16,0.9835,3.532,0.75,0.212,0.763,0.448,1.552,0.363,1.637);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (17,0.9845,3.588,0.744,0.203,0.739,0.466,1.534,0.378,1.622);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (18,0.9854,3.64,0.739,0.194,0.718,0.482,1.518,0.391,1.608);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (19,0.9862,3.689,0.734,0.187,0.698,0.497,1.503,0.403,1.597);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (20,0.9869,3.735,0.729,0.18,0.68,0.51,1.49,0.415,1.585);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (21,0.9876,3.778,0.724,0.173,0.663,0.523,1.477,0.425,1.575);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (22,0.9882,3.819,0.72,0.167,0.647,0.534,1.466,0.434,1.566);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (23,0.9887,3.858,0.716,0.162,0.633,0.545,1.455,0.443,1.557);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (24,0.9892,3.895,0.712,0.157,0.619,0.555,1.445,0.451,1.548);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (25,0.9896,3.931,0.708,0.153,0.606,0.565,1.435,0.459,1.541);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.