Skip to Content
Last modified by Mengting Qiu on 2024/09/02 17:23
From version 21.1
edited by Mengting Qiu
on 2024/09/02 16:49
Change comment: Uploaded new attachment "image-20240902164910-12.png", version {1}
To version 23.1
edited by Mengting Qiu
on 2024/09/02 17:12
Change comment: Uploaded new attachment "image-20240902171200-13.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:#4f81bd" %)**Y=(y2-y1)/(x2-x1)* (x-x1) + y1**
54 +(% style="color:blue" %)**Y=(y2-y1)/(x2-x1)* (x-x1) + y1**
55 55  
56 56  
57 57  Calibration Curve Schematic：
... ... @@ -79,26 +79,67 @@
79 79  
80 80  [[image:image-20240902160755-2.png||height="394" width="562"]]
81 81  
82 -* Go to the "Insert" TAB, navigate to the "Chart" menu, and then select the first option in the "Scatter" drop-down list.
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.
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 “Add Trendline” option.
87 +* Right-click on one of the blue dots and select the (% style="color:#4f81bd" %)**"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.
94 94  
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.
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"**(%%).
96 96  
97 -[[image:image-20240902161857-5.png]]
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.
98 98  
97 +Because the ideal data example is used, the R-squared value in this case is 1.
99 99  
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.
101 101  
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 +
102 102  = 3. Case examples =
103 103  
104 104  
image-20240902171200-13.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.ting
Size
... ... @@ -1,0 +1,1 @@
1 +64.5 KB
Content