15,017
edits
Google spreadsheet: Difference between revisions
Jump to navigation
Jump to search
→問卷作答結果的分析
| Line 50: | Line 50: | ||
<td>作答時間</td> | <td>作答時間</td> | ||
<td>牛奶, 巧克力</td> | <td>牛奶, 巧克力</td> | ||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>3</td> | |||
<td>作答時間</td> | |||
<td>香草, 巧克力</td> | |||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
| Line 106: | Line 115: | ||
<td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </div></td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $F$2) = TRUE, 1, 0) </div></td> | ||
<td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $G$2) = TRUE, 1, 0) </div></td> | <td><div style="background-color: yellow"> =IF( REGEXMATCH(B2, $G$2) = TRUE, 1, 0) </div></td> | ||
</tr> | |||
<tr> | |||
<td>3</td> | |||
<td>作答時間</td> | |||
<td>香草, 巧克力</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | </tr> | ||
</table> | </table> | ||
=== 步驟3. 加總分析結果 === | === 步驟3. 加總分析結果 === | ||
最後我們只要把選項名稱那一欄所有分析後的數字加總，例如「香草」D欄，加總(sum)D欄所有的數字，即喜愛香草的數量。 | |||
<table border="1" style=""> | |||
<tr style="background-color: #555555; color: #ffffff;"> | |||
<th></th> | |||
<th>A</th> | |||
<th>B</th> | |||
<th>C</th> | |||
<th>D</th> | |||
<th>E</th> | |||
<th>F</th> | |||
</tr> | |||
<tr> | |||
<td>1</td> | |||
<td>Timestamp</td> | |||
<td>喜愛的冰淇淋口味</td> | |||
<td></td> | |||
<td>香草</td> | |||
<td>牛奶</td> | |||
<td>巧克力</td> | |||
</tr> | |||
<tr> | |||
<td>2</td> | |||
<td>作答時間</td> | |||
<td>牛奶, 巧克力</td> | |||
<td></td> | |||
<td>0</td> | |||
<td>1</td> | |||
<td>1</td> | |||
</tr> | |||
<tr> | |||
<td>3</td> | |||
<td>作答時間</td> | |||
<td>香草, 巧克力</td> | |||
<td></td> | |||
<td>1</td> | |||
<td>0</td> | |||
<td>1</td> | |||
</tr> | |||
<tr> | |||
<td>4</td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
<td></td> | |||
</tr> | |||
<tr> | |||
<td>5</td> | |||
<td></td> | |||
<td></td> | |||
<td>小計</td> | |||
<td><div style="background-color: yellow">1</div></td> | |||
<td><div style="background-color: yellow">1</div></td> | |||
<td><div style="background-color: yellow">2</div></td> | |||
</tr> | |||
</table> | |||
<div style="clear:both"></div> | <div style="clear:both"></div> | ||