用Excel編寫公式模板計算醫(yī)學決定水平處的偏倚

用Excel編寫公式模板計算醫(yī)學決定水平處的偏倚,,,,,,

序號,參比試劑,考核試劑,決定水平處偏倚計算：,,,

1,114.7,114.6,Bc=|Yc-Xc|=|a+(b–1)Xc|,,,

2,150.4,147.9,,,,

3,162,163,Bc95%的置信區(qū)間計算：,,,

4,147,148,,,,

5,167.5,163.9,,,,

6,142.8,142.8,,,,

7,167.9,164.9,,,,

8,169.4,166.9,,,,

9,169.2,170.1,,,,

10,168.2,165.4,,,,

11,167.4,165.8,,,,

12,143.1,144.1,醫(yī)學決定水平處的偏倚計算（紅色區(qū)域錄入醫(yī)學決定水平）,,,

13,164.1,160.9,決定水平Xc,45,X平=,139.68

14,168.9,168,Sy.x=,2.3054,（Xi-X平）^2和=,151530.82

15,131.9,135.2,決定水平處偏倚95%置信區(qū)間,,"0.6443(-0.5198,1.8084)",

16,137.9,140.8,可接受的偏倚限值,5.00%,"(-2.2500,2.2500)",

17,147.1,148.7,決定水平處偏倚Bc,0.6443,L（95%下限）=,-0.5198

18,138.9,141.3,,,U（95%上限）=,1.8084

19,159.3,156.9,,,,

20,156.7,159.7,,,,

21,136.1,136.9,,"紅色部分注意：數組公式外面的{},如丟失，則計算錯誤，最好勿動",,

22,131.3,132.8,,,,

23,136.9,140.8,錄入對應產品的決定水平,,,

24,126.1,126.2,,,,

25,134.3,132.4,,,,

26,113.4,116.3,如需增加數據，從中間插入行，然后錄入數據即可，不要加在最后,,,

27,113.2,110.1,,,,

28,162,165.3,,,,

29,133.1,133.5,,,,

30,164.2,168.8,,,,

31,113.8,114.7,,,,

32,114.9,117.8,,,,

33,120.7,122.4,,,,

34,115.3,116.4,,,,

35,122.1,125.6,,,,

36,138.4,142.1,,,,

37,116.8,118.2,,,,

38,117.3,120.5,,,,

39,124.8,121.6,,,,

40,140,144,,,,

41,132.5,136.1,,,,

42,130.3,131.3,,,,

43,127.3,125.7,,,,

44,155.1,156.5,,,,

45,151.7,147.6,,,,

46,166.3,169.3,,,,

47,149.3,153.6,,,,

48,138.2,140.3,,,,

49,141.6,140.1,,,,

50,116.4,116.9,,,,

51,145.4,146,,,,

52,139.7,136.7,,,,

53,145.1,141.7,,,,

54,114.7,115.2,,,,

55,160.5,159.2,,,,

56,166.6,165.2,,,,

57,151,153.4,,,,

58,134.6,132.4,,,,

59,119.3,119.3,,,,

60,123.3,121.9,,,,

61,134.2,136.1,,,,

62,135.3,132.3,,,,

63,129,130.2,,,,

64,132.4,136.1,,,,

65,131.9,128.7,,,,

66,167,167.8,,,,

67,160.2,160.3,,,,

68,145.4,144.3,,,,

69,138.6,141.7,,,,

70,142.9,143.2,,,,

71,66.2,66.5,,,,

72,54.7,55.5,,,,

73,36.8,36.2,,,,

74,82.8,81.1,,,,

75,90.5,89.3,,,,

76,39.2,40.2,,,,

77,27,27.7,,,,

78,66.4,64.6,,,,

79,64.2,62.4,,,,

80,41,41.5,,,,

81,94.8,94.1,,,,

82,34.8,35.7,,,,

83,128.6,125.1,,,,

84,91.1,90.4,,,,

85,153.4,154.1,,,,

86,195.2,193.2,,,,

87,192.8,193.8,,,,

88,147.7,148.4,,,,

89,198.1,197.5,,,,

90,162.8,163.1,,,,

91,192.2,197.3,,,,

92,194.5,188.8,,,,

93,156.8,157.4,,,,

94,176.5,172.1,,,,

95,185.5,187.4,,,,

96,155.5,157.4,,,,

97,177.2,175.7,,,,

98,182.7,184.5,,,,

99,151.1,152.8,,,,

100,158.5,161.4,,,,

101,195,192.6,,,,

102,189.3,188.5,,,,

103,183.7,182.1,,,,

104,151.5,150