24 Jul QRB Week 4
Posted at 17:26h
in 2Past Paper
Instructions
| 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 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 first 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 | |
| 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 mileage for both types of automobiles? | |
| 3. At what speed did the first 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 increase | Percentage of increase | State 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 increase | State 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 increase | Percentage of increase | State the answer as a percentage with one digit after decimal. |
| 4. If the cost-of-living increase was 10% from 2011 to 2016, determine if Dale’s | ||
| 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 2016. | ||
| Step 2: Find the percentage increase from 2011 to 2016. | ||
| Step 3: If the percentage increase from Step 2 is greater than 10% cost-of-living 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 2016 | State 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 take-home pay? | |
| 2. What percent of the total take-home pay is allocated for transportation? | |
| State the answer as a percentage with one digit after decimal. | |
| 3. What percent of the take-home pay is allocated for food? | |
| State the answer as a percentage with one digit after decimal. | |
| 4. What percent of take-home pay is spent for education? | |
| State the answer as a percentage with one digit after decimal. | |
| 5. What percent of take-home 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 take-home pay spent on this combined total | State 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 e-mail asking them to go to the website and rate a variety of factors, including the reservation process, | |
| the check-in process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, on-time arrival, | |
| 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 ratings for the | |
| question, “Please rate the airline based on your overall experience with this flight.” The sample ratings are shown below. | |
| Rating | Credit: Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2017). Statistics for business & economics 13e. Boston: Cengage Learning. |
| Excellent | |
| Excellent | 1. Use the pivot table feature in Microsoft Excel and create a frequency distribution with two columns – Rating and Frequency. |
| Very Good | |
| Good | 2. Use Excel to create a bar chart (or a pivot bar chart) |
| Excellent | |
| Excellent | 3. Use Excel to create a pie chart (or a pivot pie chart) |
| Good | |
| Very Good | 4. Interpret information from the charts and the frequency distribution. |
| 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 | |
| Very Good | |
| Very Good | |
| Very Good | |
| Excellent | |
| Good | |
| Very Good | |
| Poor | |
| Excellent | |
| Very Good | |
| Excellent | |
| Very Good | |
| Very Good |
Question 8
| 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. | |
| Sales | Which day of the week constituted highest sales? |
| Mon | $233.94 |
| Tue | $352.55 |
| Wed | $355.16 |
| Thu | $542.18 |
| Fri | $369.01 |
| Sat | $611.77 |
Question 9
| Use Excel to find the mean, median, and mode of the scores given below. | |
| 92 | |
| 68 | Mean |
| 72 | |
| 83 | Median |
| 72 | |
| 95 | Mode |
| 88 | |
| 76 | |
| 72 | |
| 89 | |
| 89 | |
| 96 | |
| 74 | |
| 72 |
Question 10
| 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 | A | B | C | D |
| 1 | 1774 | 2205 | 1330 | 1402 |
| 2 | 1808 | 1507 | 1295 | 1665 |
| 3 | 1890 | 2352 | 1502 | 1530 |
| 4 | 1932 | 1939 | 1104 | 1826 |
| 5 | 1855 | 2052 | 1189 | 1703 |
| 6 | 1726 | 1630 | 1441 | 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 | A | B | C | D |
| 1 | 1774 | 2205 | 1330 | 1402 |
| 2 | 1808 | 1507 | 1295 | 1665 |
| 3 | 1890 | 2352 | 1502 | 1530 |
| 4 | 1932 | 1939 | 1104 | 1826 |
| 5 | 1855 | 2052 | 1189 | 1703 |
| 6 | 1726 | 1630 | 1441 | 1498 |
| Mean | ||||
| Median | ||||
| MIN | ||||
| MAX | ||||
| Range | ||||
| Std Dev | ||||
| Variance | ||||
| Case Adapted from Introductory Statistics, 8e, Mann |
Question 11
| The data below shows personal income for Quarters 2014: II – 2015: III in millions of dollars, seasonally | ||
| adjusted at annual rate. | ||
| Quarter II, 2014 | $14,603,925 | After plotting the line graph, answer the following questions: |
| Quarter III, 2014 | $14,784,309 | |
| Quarter IV, 2014 | $14,925,215 | 1. Is the graph exhibiting an increasing, decreasing, or fluctuating trend? |
| Quarter I, 2015 | $15,056,970 | |
| Quarter II, 2015 | $15,254,088 | Choose one |
| Quarter III, 2015 | $15,449,647 | |
| 2. Which month showed the highest personal income? |
Question 12
| 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 | Market Share | After plotting the pie chart, answer the following questions. |
| Marvel Comics | 35% | |
| DC Comics | 32% | 1. What percent of market share is held by the largest three companies? |
| Image Comics | 5% | |
| Dark Horse Comics | 4% | 2. What was Image Comics’ sales for September if the total market was $80,000,000? |
| Dreamweave Productions | 4% | |
| All others | 20% | 3. If the total market had $80,000,000 in comics and magazine sales for September, what were the sales for Marvel Comics? |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.