Problem B $(20$ points$)$: You have been assigned to analyze emissions data statistically provided to you in an excel file $($See INSY$3021\_$HW$1\_$Spring$2024-$ Car Data$).$ The tables contain emissions data $($grams of particulate matter emitted per gallon of gasoline burned$)$ from cars driven at high altitudes, normal altitudes, and low altitudes.

You must calculate the mean, standard deviation, and five$-$number summary for different driving conditions. Show all your work $($your spreadsheet must contain cell formulas$).$ If you do not show your work, you may not receive full credit even if the correct answer is given.

Use Excel to analyze the data and answer the following questions:

Can you make inferences or conclusions using the data provided and why?

List an inference or conclusion that you can draw about the different driving conditions. Provide a visual $($graph$)$ to support your answer.

List two concerns that you would have about the data.

$\backslash$table$[[$Particulate matter $($PM$)$ emission $($in glgal$)$ for vehicle at normal altitude$],[3\mathrm{.}50,2\mathrm{.}87,3\mathrm{.}12,3\mathrm{.}25,5\mathrm{.}46,3\mathrm{.}11,3\mathrm{.}12,2\mathrm{.}88,3\mathrm{.}29,2\mathrm{.}94,2\mathrm{.}64,3\mathrm{.}31,4\mathrm{.}48],[3\mathrm{.}48,3\mathrm{.}06,3\mathrm{.}11,4\mathrm{.}15,2\mathrm{.}86,3\mathrm{.}81,3\mathrm{.}47,3\mathrm{.}24,3\mathrm{.}63,4\mathrm{.}14,8\mathrm{.}64,6\mathrm{.}04,4\mathrm{.}48],[4\mathrm{.}98,9\mathrm{.}39,4\mathrm{.}66,13\mathrm{.}00,6\mathrm{.}57,6\mathrm{.}38,2\mathrm{.}87,3\mathrm{.}10,3\mathrm{.}11,2\mathrm{.}61,3\mathrm{.}46,2\mathrm{.}97,2\mathrm{.}90],[3\mathrm{.}40,3\mathrm{.}37,3\mathrm{.}51,3\mathrm{.}14,3\mathrm{.}63,5\mathrm{.}67,2\mathrm{.}55,4\mathrm{.}67,4\mathrm{.}63,5\mathrm{.}03,3\mathrm{.}23,3\mathrm{.}04,3\mathrm{.}63],[5\mathrm{.}12,4\mathrm{.}37,3\mathrm{.}81,4\mathrm{.}68,3\mathrm{.}17,5\mathrm{.}34,5\mathrm{.}79,3\mathrm{.}28,4\mathrm{.}10,8\mathrm{.}55,3\mathrm{.}18,5\mathrm{.}06,2\mathrm{.}48],[2\mathrm{.}25,2\mathrm{.}53,4\mathrm{.}12,5\mathrm{.}47,4\mathrm{.}74,3\mathrm{.}88,7\mathrm{.}94,6\mathrm{.}24,5\mathrm{.}52,5\mathrm{.}59,5\mathrm{.}10,5\mathrm{.}33,6\mathrm{.}58],[8\mathrm{.}73,9\mathrm{.}82,5\mathrm{.}36,7\mathrm{.}12,7\mathrm{.}67,6\mathrm{.}07,6\mathrm{.}01,4\mathrm{.}72,5\mathrm{.}24,7\mathrm{.}79,5\mathrm{.}59,5\mathrm{.}48,4\mathrm{.}96],[7\mathrm{.}30,5\mathrm{.}93,6\mathrm{.}59,4\mathrm{.}96,5\mathrm{.}12,3\mathrm{.}07,7\mathrm{.}30,7\mathrm{.}16,9\mathrm{.}74,7\mathrm{.}41,5\mathrm{.}40,6\mathrm{.}97,13\mathrm{.}23],[11\mathrm{.}30,8\mathrm{.}50,5\mathrm{.}52,7\mathrm{.}45,6\mathrm{.}93,8\mathrm{.}05,7\mathrm{.}82,12\mathrm{.}19,5\mathrm{.}62,4\mathrm{.}67,4\mathrm{.}75,10\mathrm{.}92,11\mathrm{.}93],[8\mathrm{.}96,7\mathrm{.}78,11\mathrm{.}14,12\mathrm{.}63,10\mathrm{.}23,8\mathrm{.}83,7\mathrm{.}60,7\mathrm{.}41,8\mathrm{.}70,7\mathrm{.}93,6\mathrm{.}51,11\mathrm{.}04,9\mathrm{.}71],[9\mathrm{.}21,6\mathrm{.}67,6\mathrm{.}89,6\mathrm{.}49,4\mathrm{.}80,4\mathrm{.}16,4\mathrm{.}97,5\mathrm{.}90,,,,,],[,,,,,,,,,,,,],[\text{'},,,,,,,,,,,,],[$Particulate matter $($PM$)$ emission $($in glgal$)$ for vehicle at high altitude$],[9\mathrm{.}59,8\mathrm{.}28,8\mathrm{.}07,7\mathrm{.}23,7\mathrm{.}54,5\mathrm{.}46,4\mathrm{.}44,5\mathrm{.}01,15\mathrm{.}63,15\mathrm{.}02,25\mathrm{.}38,11\mathrm{.}24,5\mathrm{.}22],[4\mathrm{.}06,6\mathrm{.}04,19\mathrm{.}11,14\mathrm{.}26,21\mathrm{.}91,10\mathrm{.}50,9\mathrm{.}81,9\mathrm{.}18,8\mathrm{.}95,20\mathrm{.}64,9\mathrm{.}10,8\mathrm{.}04,7\mathrm{.}66],[10\mathrm{.}86,6\mathrm{.}40,5\mathrm{.}57,6\mathrm{.}35,5\mathrm{.}84,4\mathrm{.}37,5\mathrm{.}81,7\mathrm{.}32,7\mathrm{.}84,4\mathrm{.}89,6\mathrm{.}68,3\mathrm{.}85,11\mathrm{.}14],[10\mathrm{.}67,11\mathrm{.}52,4\mathrm{.}68,12\mathrm{.}14,11\mathrm{.}20,9\mathrm{.}31,4\mathrm{.}09,8\mathrm{.}32,8\mathrm{.}53,8\mathrm{.}32,4\mathrm{.}01,7\mathrm{.}91,7\mathrm{.}60],[7\mathrm{.}61,3\mathrm{.}50,8\mathrm{.}46,7\mathrm{.}29,7\mathrm{.}64,4\mathrm{.}07,3\mathrm{.}11,5\mathrm{.}32,3\mathrm{.}83,9\mathrm{.}56,,,],[,,,,,,,,,,,,],[$Particulate matter $($PM$)$ emission $($in glgal$)$ for vehicle at lov $($desert$)$ altitude$],[],[2\mathrm{.}87,6\mathrm{.}01,,,,,,,,,,,],[3\mathrm{.}06,4\mathrm{.}30,,,,,,,,,,,],[7\mathrm{.}31,7\mathrm{.}82,,,,,,,,,,,],[3\mathrm{.}73,7\mathrm{.}60,,,,,,,,,,,],[5\mathrm{.}83,5\mathrm{.}50,,,,,,,,,,,]]$