Skip to Content
Last modified by Mengting Qiu on 2024/09/02 17:23
From version 22.1
edited by Mengting Qiu
on 2024/09/02 16:52
Change comment: There is no comment for this version
To version 21.1
edited by Mengting Qiu
on 2024/09/02 16:49
Change comment: Uploaded new attachment "image-20240902164910-12.png", version {1}

Summary

Details

Page properties
Content
... ... @@ -51,7 +51,7 @@
51 51  
52 52  A more general formular:
53 53  
54 -(% style="color:blue" %)**Y=(y2-y1)/(x2-x1)* (x-x1) + y1**
54 +(% style="color:#4f81bd" %)**Y=(y2-y1)/(x2-x1)* (x-x1) + y1**
55 55  
56 56  
57 57  Calibration Curve Schematic：
... ... @@ -79,67 +79,26 @@
79 79  
80 80  [[image:image-20240902160755-2.png||height="394" width="562"]]
81 81  
82 -* Go to the "(% style="color:#4f81bd" %)**Insert**(%%)" TAB, navigate to the "(% style="color:#4f81bd" %)**Chart**(%%)" menu, and then select the first option in the "(% style="color:#4f81bd" %)**Scatter**(%%)" drop-down list.
82 +* Go to the "Insert" TAB, navigate to the "Chart" menu, and then select the first option in the "Scatter" drop-down list.
83 83  * A chart will appear with the data points in the two columns.
84 84  
85 85  [[image:image-20240902161202-3.png||height="453" width="824"]]
86 86  
87 -* Right-click on one of the blue dots and select the (% style="color:#4f81bd" %)**"Add Trendline" **(%%)option.
87 +* Right-click on one of the blue dots and select the “Add Trendline” option.
88 88  
89 89  [[image:image-20240902161711-4.png||height="490" width="681"]]
90 90  
91 91  * A straight line will appear on the chart.
92 +On the right side of the screen, the Format Trendline menu will appear. Check the boxes next to “Show formulas on chart” and “Show R-squared values on chart”.
93 +The R-squared value is a statistic that tells you how well the line fits the data. The best R-squared value is 1.000, which means that every data point touches the line.
92 92  
93 -On the right side of the screen, the Format Trendline menu will appear. Check the boxes next to (% style="color:#4f81bd" %)**"Show formulas on chart" **(%%)and (% style="color:#4f81bd" %)**"Show R-squared values on chart"**(%%).
95 +Because the ideal data example is used, the R-squared value in this case is 1. As the difference between the data points and the line increases, the R-squared value decreases, with 0.000 being the lowest possible value.
94 94  
95 -The R-squared value is a statistic that tells you how well the line fits the data. The best R-squared value is **1.000**, which means that every data point touches the line.
97 +[[image:image-20240902161857-5.png]]
96 96  
97 -Because the ideal data example is used, the R-squared value in this case is 1.
98 98  
99 -As the difference between the data points and the line increases, the R-squared value decreases, with **0.000** being the lowest possible value.
100 100  
101 -The equation is of the form (% style="color:blue" %)**"y = kx + b"**(%%),(% style="color:blue" %)** **(%%)where (% style="color:blue" %)**k**(%%) is the slope and (% style="color:blue" %)**b**(%%) is the y-intercept of the line.
102 102  
103 -[[image:image-20240902161857-5.png||height="559" width="1103"]]
104 -
105 -* Calibration is complete. The user can customize the chart by editing the title and adding the axis title.
106 -
107 -[[image:image-20240902163527-7.png||height="349" width="656"]]
108 -
109 -
110 -=== Step 2: Calculate the line equation and R-squared statistic ===
111 -
112 -* Write the Slope formula in the formula bar according to the original x and y values statistics table.
113 -
114 -[[image:image-20240902164104-8.png||height="503" width="492"]]
115 -
116 -
117 -* Write Intercept formula in the formula bar according to the original x and y value statistics table.
118 -
119 -[[image:image-20240902164156-9.png||height="525" width="488"]]
120 -
121 -
122 -* Write Correl's squared formula in the formula bar based on the original x and y statistics table.
123 -
124 -The CORREL function returns "R", so we have to square it to compute "R squared".
125 -
126 -[[image:image-20240902164503-11.png||height="523" width="743"]]
127 -
128 -
129 -* These values match those shown in the chart.
130 -
131 -[[image:image-20240902164910-12.png||height="420" width="897"]]
132 -
133 -
134 -=== Step 3: Set up formulas to quickly calculate X and Y values. ===
135 -
136 -
137 -
138 -
139 -
140 -
141 -
142 -
143 143  = 3. Case examples =
144 144  
145 145