Data Analytics Problem Set
Instructions
Instructions:
Week 4 Individual Assignment
Total Number of Questions – 12
1. You have twelve problems – one on each tab of this Excel file.
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).
Question 1
Fifty 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?
State the answer as a percentage with one digit after decimal.
Question 2
The bar graph below shows the Quarterly Dollar Volume of Batesville Tire Company.
Refer to the bar graph below and answer the questions.
1. Which quarter had the highest dollar volume?
2. What percent of the yearly sales were the sales for October–December?
State the answer as a percentage with one digit after decimal.
3. What was the percent of increase in sales from the ﬁrst to the second quarter?
State the answer as a percentage with one digit after decimal.
Question 3
The line chart below shows data for Automobile Gasoline Mileage Comparisons for
fullsize 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 mileage for both types of automobiles?
3. At what speed did the ﬁrst noticeable decrease in gasoline mileage occur?
Which car showed this decrease?Choose one
Question 4
The line chart below shows Dale Crosby's Salary History.
Refer to this chart and answer the questions.
1. Calculate the amount and percent of increase in Dale’s salary from 2014 to 2015.
Amount of increasePercentage of increaseState the answer as a percentage with one digit after decimal.
2. What is the percent of increase in Dale’s salary from 2012 to 2013?
Percentage of increaseState the answer as a percentage with one digit after decimal.
3. Calculate the amount and percent of increase in Dale’s salary from 2016 to 2017.
Amount of increasePercentage of increaseState the answer as a percentage with one digit after decimal.
4. If the costofliving increase was 10% from 2011 to 2016, determine if Dale’s
salary for this period of time kept pace with inﬂation.
Hint: For part 4, follow the steps below:
Step 1: Find the amount of salary increase from 2011 to 2016.
Step 2: Find the percentage increase from 2011 to 2016.
Step 3: If the percentage increase from Step 2 is greater than 10% costofliving increase, then
Dale's salary kept pace with inflation, otherwise no.
Step 1: Amount of salary increase from 2011 to 2016
Step 2: Percentage increase from 2011 to 2016State the answer as a percentage with no decimal.
Step 3: Did the salary keep pace with inflation?(Choose one)
Question 5
The pie chart below shows the family budget. Refer to the chart and answer the following questions.
1. What is the total takehome pay?
2. What percent of the total takehome pay is allocated for transportation?
State the answer as a percentage with one digit after decimal.
3. What percent of the takehome pay is allocated for food?
State the answer as a percentage with one digit after decimal.
4. What percent of takehome pay is spent for education?
State the answer as a percentage with one digit after decimal.
5. What percent of takehome pay is spent for education when education,
savings, and miscellaneous funds are combined to be used for education?
Total of education, savings, and miscellaneous funds
Percentage of takehome pay spent on this combined totalState the answer as a percentage with one digit after decimal.
Question 6
The bar chart shows the distribution of tax dollars. Refer to the chart and answer the following questions.
1. What expenditure is expected to be the same next year as this year?
2. What two expenditures are expected to increase next year?
3. What two expenditures are expected to decrease next year?
4. What expenditure was greatest both years?
Question 7
The Canmark Research Center Airport Customer Satisfaction Survey uses an online questionnaire to provide airlines and airports with
customer satisfaction ratings for all aspects of the customers’ flight experience (airportsurvey website, July 2012). After completing a
flight, customers receive an email asking them to go to the website and rate a variety of factors, including the reservation process,
the checkin process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, ontime arrival,
and so on. A fivepoint scale, with Excellent, Very Good, Good, Fair, and Poor, is used to record customer ratings. Assume
that passengers on a delta Airlines flight from Myrtle beach, South Carolina, to Atlanta, Georgia, provided the following ratings for the
question, “Please rate the airline based on your overall experience with this flight.”
You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.
Latest completed orders:
#  topic title  discipline  academic level  pages  delivered 

6

Writer's choice

Business

University

2

1 hour 32 min

7

Wise Approach to

Philosophy

College

2

2 hours 19 min

8

1980's and 1990

History

College

3

2 hours 20 min

9

pick the best topic

Finance

School

2

2 hours 27 min

10

finance for leisure

Finance

University

12

2 hours 36 min
