Skip to Content
Last modified by Mengting Qiu on 2024/09/02 17:23
From version 27.1
edited by Mengting Qiu
on 2024/09/02 17:19
Change comment: There is no comment for this version
To version 24.1
edited by Mengting Qiu
on 2024/09/02 17:14
Change comment: Uploaded new attachment "image-20240902171417-14.png", version {1}

Summary

Details

Page properties
Content
... ... @@ -49,7 +49,7 @@
49 49  When x=8 mA, y=2.5 meters
50 50  
51 51  
52 -**A more general formular:**
52 +A more general formular:
53 53  
54 54  (% style="color:blue" %)**Y=(y2-y1)/(x2-x1)* (x-x1) + y1**
55 55  
... ... @@ -109,20 +109,23 @@
109 109  
110 110  === Step 2: Calculate the line equation and R-squared statistic ===
111 111  
112 -* Write the (% style="color:#4f81bd" %)**Slope formula**(%%) in the formula bar according to the original x and y values statistics table.
112 +* Write the Slope formula in the formula bar according to the original x and y values statistics table.
113 113  
114 114  [[image:image-20240902164104-8.png||height="503" width="492"]]
115 115  
116 -* Write (% style="color:#4f81bd" %)**Intercept formula**(%%) in the formula bar according to the original x and y value statistics table.
117 117  
117 +* Write Intercept formula in the formula bar according to the original x and y value statistics table.
118 +
118 118  [[image:image-20240902164156-9.png||height="525" width="488"]]
119 119  
120 -* Write (% style="color:#4f81bd" %)**CORREL's squared formula**(%%) in the formula bar based on the original x and y statistics table.
121 121  
122 +* Write Correl's squared formula in the formula bar based on the original x and y statistics table.
123 +
122 122  The CORREL function returns "R", so we have to square it to compute "R squared".
123 123  
124 124  [[image:image-20240902164503-11.png||height="523" width="743"]]
125 125  
128 +
126 126  * These values match those shown in the chart.
127 127  
128 128  [[image:image-20240902164910-12.png||height="420" width="897"]]
... ... @@ -131,20 +131,12 @@
131 131  === Step 3: Set up formulas to quickly calculate X and Y values. ===
132 132  
133 133  
134 -* The equation of the best fitting line is "Y-value = SLOPE * x-value + INTERCEPT", so the solution of "y-value" is obtained by multiplying X value and SLOPE, and then INTERCEPT is added.
135 135  
136 -A simple formula table for calculating Y value automatically with input X value is obtained.
137 137  
138 -[[image:image-20240902171627-15.png||height="440" width="754"]]
139 139  
140 140  
141 -* The X value based on the Y value is solved by subtracting INTERCEPT from the Y value and dividing the result by SLOPE: "x-value = (y-value-intercept)/SLOPE".
142 142  
143 -A simple formula table for automatically calculating X value based on the input Y value is obtained.
144 144  
145 -[[image:image-20240902171909-16.png||height="604" width="756"]]
146 -
147 -
148 148  = 3. Case examples =
149 149  
150 150  
image-20240902171627-15.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.ting
Size
... ... @@ -1,1 +1,0 @@
1 -37.9 KB
Content
image-20240902171909-16.png
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.ting
Size
... ... @@ -1,1 +1,0 @@
1 -54.6 KB
Content