Data Analytics Problem Set, computer science homework help

User Generated

xownpxfba99

Business Finance

Description

Data Analytics Problem Set

Purpose of Assignment

The purpose of this assignment is to provide students opportunities to reinforce the fundamental topics in data analytics. Through this assignment, students will learn how to read information from bar charts, pie charts, line charts, and frequency distributions. Students will also use Microsoft Excel's pivot table functionality to create frequency distributions, bar charts, and pie charts. The assignment also includes evaluating basic descriptive statistics using Microsoft Excel®.

Assignment Steps

Resources: Data Analytics Problem Set Excel® Template, Excel® 2016 Essential Training

Save the Data Analytics Problem Set Excel® Template to your computer.

Read the instructions on the first tab.

Complete the twelve exercises located in the template and record your answers in the highlighted spaces.

Unformatted Attachment Preview

Instructions: Week 4 Individual Assignment Total Number of Questions - 12 Total Points: 7 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 appropria back and partial credit (if appropriate). 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 comple 2. How many students completed the projec 3. What percent of students completed the p ny students took 4 days to complete the assignment? ny students completed the project in 3 days or less? rcent of students completed the project in 3 days or less? State the answer as a percentage with one digit after decimal. 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 volum 2. What percent of the yearly sales were the 3. What was the percent of increase in sales rcent of the yearly sales were the sales for October–December? State the answer as a percentage with one digit after decimal. as the percent of increase in sales from the first to the second quarter? State the answer as a percentage with one digit after decimal. git after decimal. 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 g 2. What speed gave the lowest ga 3. At what speed did the first not Which car showed this decrease? 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 first noticeable decrease in gasoline mileage occur? Choose one 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’ Amount of increase 2. What is the percent of increase in Dale’s salary from 2 Percentage of increase 3. Calculate the amount and percent of increase in Dale’ Amount of increase 4. If the cost-of-living increase was 10% from 2011 to 20 salary for this period of time kept pace with inflation. Hint: For part 4, follow the steps below: Step 1: Find the amount of salary increase from 2011 to Step 2: Find the percentage increase from 2011 to 2016 Step 3: If the percentage increase from Step 2 is greater 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 2016 Step 3: Did the salary keep pace with inflation? nd percent of increase in Dale’s salary from 2014 to 2015. Percentage of increase State the answer as a percentage with one digit after decima increase in Dale’s salary from 2012 to 2013? State the answer as a percentage with one digit after decimal. nd percent of increase in Dale’s salary from 2016 to 2017. Percentage of increase State the answer as a percentage with one digit after decima ease was 10% from 2011 to 2016, determine if Dale’s me kept pace with inflation. of salary increase from 2011 to 2016. ge increase from 2011 to 2016. increase from Step 2 is greater than 10% cost-of-living increase, then th inflation, otherwise no. increase from 2011 to 2016 State the answer as a percentage with no decimal. (Choose one) with one digit after decimal. with one digit after decimal. The pie chart below shows the family budget. Refer to the chart and answer the following questions. 1. What is the total take-home pay? 2. What percent of the total take-home pay 3. What percent of the take-home pay is allo 4. What percent of take-home pay is spent fo 5. What percent of take-home pay is spent fo savings, and miscellaneous funds are combin Total of education, savings, and miscellaneou Percentage of take-home pay spent on this c rcent of the total take-home pay is allocated for transportation? State the answer as a percentage with one digit after decimal. rcent of the take-home pay is allocated for food? State the answer as a percentage with one digit after decimal. rcent of take-home pay is spent for education? State the answer as a percentage with one digit after decimal. rcent of take-home pay is spent for education when education, d miscellaneous funds are combined to be used for education? e of take-home pay spent on this combined total State the answer as a percentage with one digit after decimal. with one digit after decimal. 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 sa 2. What two expenditures are expected to in 3. What two expenditures are expected to d 4. What expenditure was greatest both years penditure is expected to be the same next year as this year? The Canmark Research Center Airport Customer Satisfaction Survey uses an online questionnaire to provide airlines and airpo customer satisfaction ratings for all aspects of the customers’ flight experience (airportsurvey website, July 2012). After comp flight, customers receive an e-mail asking them to go to the website and rate a variety of factors, including the reservation pr the check-in process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, on-time a and so on. A five-point 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 rating question, “Please rate the airline based on your overall experience with this flight.” The sample ratings are shown below. Rating Excellent Excellent Very Good Good Excellent Excellent Good Very Good Excellent Excellent Good Very Good Very Good Very Good Very Good Very Good Excellent Fair Excellent Very Good Very Good Excellent Very Good Very Good Excellent Excellent Very Good Excellent Excellent Poor Very Good Excellent Very Good Very Good Excellent Very Good Excellent Excellent Credit: Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2017). Statistics f 1. Use the pivot table feature in Microsoft Excel and create a frequency distribution with two column 2. Use Excel to create a bar chart (or a pivot bar chart) 3. Use Excel to create a pie chart (or a pivot pie chart) 4. Interpret information from the charts and the frequency distribution. Very Good Very Good Very Good Excellent Good Very Good Poor Excellent Very Good Excellent Very Good Very Good & Cochran, J. J. (2017). Statistics for business & economics 13e. Boston: Cengage Learning. The data below shows the total sales per day of the week by four salespersons. Use Microsoft Excel to construct a line chart (graph)showing total sales by the days of the week for Happy's Gift Shoppe. Mon Tue Wed Thu Fri Sat Sales $233,94 $352,55 $355,16 $542,18 $369,01 $611,77 Which day of the week constituted highest sales? Use Excel to find the mean, median, and mode of the scores given below. 92 68 72 83 72 95 88 76 72 89 89 96 74 72 Mean Median Mode After your MBA, you are employed as a business analyst for a company that makes household products, which are sold by part-time salespersons who work during their spare time. The company has four salespersons employed. Let us denote these salespersons by A, B, C, and D. The sales records (in dollars) for the past 6 weeks for these four salespersons are shown in the table below. Week 1 2 3 4 5 6 A 1774 1808 1890 1932 1855 1726 B 2205 1507 2352 1939 2052 1630 C 1330 1295 1502 1104 1189 1441 D 1402 1665 1530 1826 1703 1498 Your supervisor has asked you to prepare a brief analysis comparing the sales volumes and the consistency of sales of these four salespersons. Use the mean sales for each salesperson to compare the sales volumes, and then choose an appropriate statistical measure to compare the consistency of sales. Week 1 2 3 4 5 6 A 1774 1808 1890 1932 1855 1726 B 2205 1507 2352 1939 2052 1630 C 1330 1295 1502 1104 1189 1441 D 1402 1665 1530 1826 1703 1498 Mean Median MIN MAX Range Std Dev Variance Case Adapted from Introductory Statistics, 8e, Mann old products, ds (in dollars) the consistency e sales volumes, The data below shows personal income for Quarters 2014: II - 2015: III in millions of dollars, seasonally adjusted at annual rate. Quarter II, 2014 Quarter III, 2014 Quarter IV, 2014 Quarter I, 2015 Quarter II, 2015 Quarter III, 2015 $14.603.925 $14.784.309 $14.925.215 $15.056.970 $15.254.088 $15.449.647 After plotting the line graph, answer the following questions: 1. Is the graph exhibiting an increasing, decreasing, or fluctuating trend? Choose one 2. Which month showed the highest personal income? Construct a pie chart (circle graph) showing the distribution of market share using the data below. The data represents the percent dollar market of comics and magazine sales for September (Rounded to the nearest whole percent). Publisher Marvel Comics DC Comics Image Comics Dark Horse Comics Dreamweave Productions All others Market Share 35% 32% 5% 4% 4% 20% After plotting the pie chart, answer the following questions. 1. What percent of market share is held by the largest three compa 2. What was Image Comics' sales for September if the total market 3. If the total market had $80,000,000 in comics and magazine sales
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello! I attached the complete work, please let me know if there's any further question. :D

Instructions:
Week 4 Individual Assignment
Total Number of Questions - 12
Total Points: 7

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 appropria

back and partial credit (if appropriate).

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 comple

2. How many students completed the projec

3. What percent of students completed the p

ny students took 4 days to complete the assignment?

5

ny students completed the project in 3 days or less?

35

rcent of students completed the project in 3 days or less?
70.0%
State the answer as a percentage with one digit after decimal.

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 v
2. What percent of the yearly sales were

3. What was the percent of increase in sa

April-June

rcent of the yearly sales were the sales for October–December?
17.6% State the answer as a percentage with one digit after decimal.

as the percent of increase in sales from the first to the second quarter?
50.0%
State the answer as a percentage with one digit after decimal.

after decimal.

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 g

2. What speed gave the lowest ga

3. At what speed did the first not
Which car showed this decrease?

1. What speed gave the highest gasoline mileage for both types of automobiles?
40mph
2. What speed gave the lowest gasoline mileage for both types of automobiles?
70mph
3. At what speed did the first noticeable decrease in gasoline mileage occur?
Which car showed this decrease? Full-size
Choose one

25mph

The line chart below shows Dale Crosby's Salary History.
Refer to this chart and answer the questions.

1. Calculate the amount and perce...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags