Question

1 Approved Answer

Posted on Sep 07, 2024

what formula should i put in I8 from SI A 533 - ta les Totale per Cost of Crashes with injury or Jules Fata RA

what formula should i put in I8 image text in transcribed

from SI A 533 - ta les Totale per Cost of Crashes with injury or Jules Fata RA 2.15 55ECS SRS BRO RRRRRRRERA Data Review View Help Draw Calibri BI Page Layout 11 O Home Insert X Cut Oncopy Format Painter Oipboard Formulas A A E A Good Explanator Bad check Cell 22 Normal Conditional Format as Calculation Condtional Formatting Table 25 Wrap Text Merge & Center - % Styles 1 based on the Automobile Association of Amerika and other sources Crashes per Year Per How Many Miles? 100,000,000 Injury Crashes Crashes 361 Fatal Crashes 3.75 Age of Driver Crashes with no injury or fatality Injury Crashes Fatal Crashes All Crashes 4 7 24 2.47 157 Average Miles per licensed Total Mileage per Year Drivers in US Year 7540 4,370,000 32,947,615.000 75404,270.000 2 947615,000 14990 17.520,000 .00 14990 20.150.000 TL 102.638,005 14390 26,810,000L 1513434 1516137,270,000 565.050.4 15101 39.960,000. 695. 5 11820 80.000 119 2020 7545 20.320,000 153.01 2011 7545 9.000.000 H GH2020.000 Jonathan Weiss Write a formula for Total Mileage per Year for a given age group that, when copied down the column across GB- G17, gives the value for each age group. Total Mileage per Year for a given age group is the Average Mileage Per Year times the number of US Licensed Drivers in that age group. 2/14202036 AM Cost of Crashes Crashes with no 2 or fatality 3.231.00 23 Injury Crashes 1515,443.00 24 Far Crashes Bau Normal Check Cell Explanatory... 8 0.00 Conditional Format as Calculation 0 Formatting Table Styles er Crashes per Year Crashes with no injury or fatality Fatal Crashes 18 . 1 Crashes Injury Crashes _._471,809.85 240,517.594---------- 1,502,163.75 1,591,875.91 3,776,406.66 _1.774,258.48 1,908,375.71 996,405.13 461,445.76 294,633.85 Jonathan Weiss Write a formula for Total Mileage per Year for a given age group that, when copied down the column across G8- G17, gives the value for each age group. 11 TL 11 11 1 1 Total Mileage per Year for a given age group is the Average Mileage Per Year times the number of US Licensed Drivers in that age group. 2/13/2020 9:36 AM 11 +-------- Reply... Formatting Format Painter Clipboard Alignment Number 1 Statistics Based on the Automobile Association of America and other sources WN- Crashes All Injury Crashes Fatal Crashes 3.75 2.47 Per How Many Miles? 6 100,000,000 Injury 7 Age of Driver Crashes Crashes 8 16 1432 361 9 18 730197 10 20 572157 1125 526 150 1230 328 92 1340 14 50 315 15 60 241 16 7 0 301 1780432 Average Miles per Licensed Total Mileage per Year Drivers in US Year 7540 4,370,000 32.947,615,0001_ 75404,370,000__-12.947,615,000 32.947,615,000 14990 17,520,000! 262,616,040,000 14990 20,190,000 14990 76,810,000 1,151,343,495,000 15161 37,270,000 565,050,470,000 15161 39,900,000 605,823,560,000 1182034,980,000 413,446, 110,000 1 7545 20,320,000 153,304,240,000 7545 9,040,000 68,202,280,000 All Crashes 471,809.85 240,517.59 1,502,163.75 1,591,875.91 3,776,406.66 1.99 20, 005,000 314 1.25 67 1,908,375.71 9 90.05.13 461, 294,633.85 Cost of Crashes Crashes with no 22 Injury or fatality $3,231.00 23 Injury Crashes $15,443.00 24 Fatal Crashes $25,000.00 Crashes per Year Crashes with no injury or fatality Fatal Crashes hes Injury VW Jonathan Weiss 18 .. Write a formula for Total Mileage per Year for a given age group that, when copied down the column across G8- G17, gives the value for each age group. -- - -- - - Total Mileage per Year for a given age group is the Average Mileage Per Year times the number of US Licensed Drivers in that age group. 2/13/2020 9:36 AM -- - - - - ------ Reply... 1 Statistics Based on the Automobile Association of America and other sources WN Crashe: All Injury Crashes Per How Many Miles? 100,000,000 Injury Crashes Crashes 1432 361 730 197 572157 526 150 328 Age of Driver 16 18 20 25 9 Fatal Crashes 3. 75 2.47 2.15 1.99 1.2 1.12 10 11 12 Average Miles per Licensed Total Mileage per Year Drivers in US Year All Crashes 7 5404,370,000 32,947,615,000 471,809.85 7 5404,370,000_ 32,947,615,000 ---_240,517.59 14990 17,520,000 262,616,040,000! 1,502,163.75 ! 14990 20,190,000 302,638,005,000 1 1,591,875.91 14990 76,810,000 1,151,343,495,000 1 3 ,776,406.66 15161 37,270,000 -565,050,470,000 ___1,774,258.48 15161 39,960,000 605,833,560,000 1,908,375.71 11820 34,980,000 413,446, 110,000 1 9 96,405,13 7545 20,320,000 153,304,240,000 --- 461,445.76 7545 9,040,000 68,202,280,000 294,633.85 315 1.25 241 70 80 301 432 88 67 86 131 Totals 1.04 1.79 3.85 Cost of Crashes Crashes with no 22 injury or fatality $3,231.00 23 Injury Crashes $15,443.00 24 Fatal Crashes $25,000.00