开始使用免费开始使用

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 Sheets 中的误差与不确定性

查看课程

练习说明

  • 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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习