開始使用免費開始

Can't start a fire without a spark(line)

So you've made some predictions, you've checked their accuracy, and you see that crashes with multiple vehicles tend to cause the most injuries. This isn't all that suprising. Since you're charged with public safety, your task is to see how to use your resources to make the roads safer without spending all day creating dashboards.

This is a great opportunity to use sparklines to compare data quickly. Just as a reminder, the SPARKLINE() function takes the data (in this case the cell) as the first argument, and sparkline options are enclosed in a set of curly braces ({}), with a comma (,) to separate keys and settings, and with a semi-colon (;) to separate individual options. Thus, your options argument should take the form of the following:

{"option1", option1setting; "option2", option2setting}

本練習屬於課程

Google 試算表中的誤差與不確定性

檢視課程

練習說明

  • In cell I2, add a sparkline that reflects the number of vehicles that crashed in the precinct. - Make sure the chart displays as a "bar" chart. - Set the the limit ("max") as the highest number of vehicles crashed in any precinct.
  • Add sparklines in cells I3:I10 that depict the number of vehicles crashed in that precinct as a proportion of the total from the highest precinct.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習