2. For our group ice cream project here are the results (download here & ) from our survey put into Excel. Make a bar chart for the "Do you prefer hard ice cream or soft serve ice cream?" question (use the countif function in excel as described in the instructional video). Write up a paragraph explaining in words what your graphs tell you about this data.What gend What age r.What state What is youWhen eating ice cream, what is your favorite con Do you pre How much Do you like How does ice cream taste to you? Female 0-10 NY Vanilla & Ci cup 9 cup soft serve 5 5 Super sweet like it glistens in my mouth 41-50 NY Mint Chocc cake cone 7 waffle cone soft serve 4 delicious Female 1 Yummy Female 21-30 California Chocolate Waffle cont 5 sugar cone soft serve Male 21-30 Texas Chocolate (Waffle con: 15 bowl hard 5 Like ice cream Female 51-60 PA Chocolate bowl 2 cake cone soft serve 5 creamy and sweet Male 41-50 NY Brownie Su other 1 other hard 3 hurts my teeth Male 21-30 CA Butterscotchffle con 0 none of the above hard 4 Sweet and 41-50 Pennsylvaniacky Road Waffle cone hard 3 Creamy Male 2 Cold and sweet Male 31-40 Missouri Trac bowl hard 31-40 PA Chocolate