Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd
Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams' Essentials Of Business Analytics, 2nd
2nd Edition
ISBN: 9781305861794
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 1P

A sales manager is trying to determine appropriate sales performance bonuses for her team this year. The following table contains the data relevant to determining the bonuses, but it is not easy to read and interpret. Reformat the table to improve readability and to help the sales manager make her decisions about bonuses.

Chapter 3, Problem 1P, A sales manager is trying to determine appropriate sales performance bonuses for her team this year.

Expert Solution & Answer
Check Mark
To determine

Provide reformation for the table to improve readability.

Answer to Problem 1P

The table is reformatted as follows:

SalespersonTotal Sales ($)Average Performance Bonus Previous Years ($)Customer AccountsYears with Company
Smith, Michael325,001124,9912414
Yu, Joe13,67824097
Reeves, Bill452,359219,8717521
Hamilton, Joshua87,4247643283
Harper, Derek87,6541,250214
Quinn, Dorothy234,09114,568489
Graves, Lorrie379,40227,98112112
Sun, Yi31,73467371
Thompson, Nicole127,84513,323173

Explanation of Solution

In order to improve readability, the following steps are carried out in the given table:

  • Unnecessary gridlines are deleted.
  • Bold font is removed except for column titles.
  • Text columns are left aligned and numerical columns are right aligned.
  • A comma separator is added to the numerical values that represent the dollar.
  • Unnecessary decimal digits are removed.

Thus, the table is reformatted to improve readability.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Une Entreprise œuvrant dans le domaine du multividéo donne l'opportunité à ses programmeurs-analystes d'évaluer la performance des cadres supérieurs. Voici les résultats obtenues (sur une échelle de 10 à 50) où 50 représentent une excellente performance. 10 programmeurs furent sélectionnés au hazard pour évaluer deux cadres. Un rapport Excel est également fourni. Programmeurs Cadre A Cadre B 1 34 36 2 32 34 3 18 19 33 38 19 21 21 23 7 35 34 8 20 20 9 34 34 10 36 34 Test d'égalité des espérances: observations pairées
A television news channel samples 25 gas stations from its local area and uses the results to estimate the average gas price for the state. What’s wrong with its margin of error?
You’re fed up with keeping Fido locked inside, so you conduct a mail survey to find out people’s opinions on the new dog barking ordinance in a certain city. Of the 10,000 people who receive surveys, 1,000 respond, and only 80 are in favor of it. You calculate the margin of error to be 1.2 percent. Explain why this reported margin of error is misleading.
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License