QRB 501 Week 3 Excel Questions Solved

QRB501ExcelTemplateWeek3Questions.xlsx

QRB 501  Week 3 Excel Questions Solved

Don't use plagiarized sources. Get Your Custom Essay on
QRB 501 Week 3 Excel Questions Solved
Just from $13/Page
Order Essay

2

>Instructions

Individual

ssignment

2

Instructions:
Week 3 A
Total Number of Questions –

1
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

days to complete the assignment?

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
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

ollar Volume of

atesville Tire

ompany.

State the answer as a percentage with one digit after decimal.

State the answer as a percentage with one digit after decimal.

The bar graph below shows the Quarterly

D B C
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?
3. What was the percent of increase in sales from the first to the second quarter?

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

.

State the answer as a percentage with one digit after decimal.

Percentage of increase State the answer as a percentage with one digit after decimal.

to 2017.

Amount of increase Percentage of increase State the answer as a percentage with one digit after decimal.
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 201

 5
Amount of increase
Percentage of increase
2. What is the percent of increase in Dale’s salary from 2012 to 2013?
3. Calculate the amount and percent of increase in Dale’s salary from 201

 6
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

State the answer as a percentage with one digit after decimal.

State the answer as a percentage with one digit after decimal.

State the answer as a percentage with one digit after decimal.

State the answer as a percentage 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 is allocated for transportation?
3. What percent of the take-home pay is allocated for food?
4. What percent of take-home pay is spent for education?
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

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

isfaction Survey uses an online questionnaire to provide airlines and airports with

,

, Good,

, and

, is used to record customer ratings. Assume

Excellent
Excellent

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
Very Good
Very Good
Very Good
Excellent
Good
Very Good
Poor
Excellent
Very Good
Excellent
Very Good
Very Good

The Canmark Research Center Airport Customer

Sat
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 Fair Poor
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.
1. Use the pivot table feature in Microsoft Excel and create a frequency distribution with two columns – Rating and Frequency.
Very Good
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.

Question 8

Sat

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
$611.77

Question 9

72

72

89

72

Use Excel to find the mean, median, and mode of the scores given below.
92
68
Mean
72
83
Median
95 Mode
88
76
89
96
74

Question 10

Week A B C D
1

2

3

4

5

6

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

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.
1774 2205 1330 1402
1808 1507 1295 1665
1890 2352 1502 1530
1932 1939 1104 1826
1855 2052 1189 1703
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.
MIN
MAX
Range
Std Dev
Variance
Case Adapted from Introductory Statistics, 8e, Mann

Question 11

Choose one

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
Quarter III, 2015 $15,449,647
2. Which quarter showed the highest personal income?

Question 12

5%

4%

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 3

5%
DC Comics 32% 1. What percent of market share is held by the largest three companies?
Image Comics
Dark Horse Comics 4% 2. What was Image Comics’ sales for September if the total market was $80,000,000?
Dreamweave Productions
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?

What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Premium Quality

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

On-Time Delivery

Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.

24/7 Customer Support

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

image

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

image

Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

Free Features $66FREE

  • Most Qualified Writer $10FREE
  • Plagiarism Scan Report $10FREE
  • Unlimited Revisions $08FREE
  • Paper Formatting $05FREE
  • Cover Page $05FREE
  • Referencing & Bibliography $10FREE
  • Dedicated User Area $08FREE
  • 24/7 Order Tracking $05FREE
  • Periodic Email Alerts $05FREE
image

Our Services

Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.

  • On-time Delivery
  • 24/7 Order Tracking
  • Access to Authentic Sources
Academic Writing

We create perfect papers according to the guidelines.

Professional Editing

We seamlessly edit out errors from your papers.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

image

Delegate Your Challenging Writing Tasks to Experienced Professionals

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

Sign Up Talk to Us

Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

Categories
All samples
Essay (any type)
Essay (any type)
The Value of a Nursing Degree
Undergrad. (yrs 3-4)
Nursing
2
View this sample

It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate
image

Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

Call Us +1 (877) 657-8180 Discuss Order Details Now

See How We Helped 9000+ Students Achieve Success

image

We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

  • Clear elicitation of your requirements.
  • Customized writing as per your needs.

We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

  • Proactive analysis of your writing.
  • Active communication to understand requirements.
image
image

We Handle Your Writing Tasks to Ensure Excellent Grades

We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.

  • Thorough research and analysis for every order.
  • Deliverance of reliable writing service to improve your grades.
Place an Order Start Chat Now
image

Order your essay today and save 30% with the discount code Happy

Order Now