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

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,23 +109,20 @@
109 109  
110 110  === Step 2: Calculate the line equation and R-squared statistic ===
111 111  
112 -* Write the Slope formula in the formula bar according to the original x and y values statistics table.
112 +* Write the (% style="color:#4f81bd" %)**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.
116 116  
117 -* Write Intercept formula in the formula bar according to the original x and y value statistics table.
118 -
119 119  [[image:image-20240902164156-9.png||height="525" width="488"]]
120 120  
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 -
124 124  The CORREL function returns "R", so we have to square it to compute "R squared".
125 125  
126 126  [[image:image-20240902164503-11.png||height="523" width="743"]]
127 127  
128 -
129 129  * These values match those shown in the chart.
130 130  
131 131  [[image:image-20240902164910-12.png||height="420" width="897"]]
... ... @@ -134,12 +134,20 @@
134 134  === Step 3: Set up formulas to quickly calculate X and Y values. ===
135 135  
136 136  
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.
137 137  
136 +A simple formula table for calculating Y value automatically with input X value is obtained.
138 138  
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".
141 141  
143 +A simple formula table for automatically calculating X value based on the input Y value is obtained.
142 142  
145 +[[image:image-20240902171909-16.png||height="604" width="756"]]
146 +
147 +
143 143  = 3. Case examples =
144 144  
145 145  
image-20240902171627-15.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.ting
Size
... ... @@ -1,0 +1,1 @@
1 +37.9 KB
Content
image-20240902171909-16.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.ting
Size
... ... @@ -1,0 +1,1 @@
1 +54.6 KB
Content