Data Analytics Problem Set

Instructions:2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropriate).Week 4 Individual AssignmentFifty business students were given a project to complete. The bar graph below shows the number of days it took the students to complete the assignment.1. How many students took 4 days to complete the assignment? 2. How many students completed the project in 3 days or less? 3. What percent of students completed the project in 3 days or less?Refer to the bar graph below and answer the questions.The bar graph below shows the Quarterly Dollar Volume of Batesville Tire Company.1. Which quarter had the highest dollar volume? 2. What percent of the yearly sales were the sales for October–December? 3. What was the percent of increase in sales from the first to the second quarter?The line chart below shows data for Automobile Gasoline Mileage Comparisons for full-size and compact cars.Refer to the chart and answer the questions.1. What speed gave the highest gasoline mileage for both types of automobiles? 2. What speed gave the lowest gasoline