For the Excel file Travel Expenses, use a PivotTable to find the average and standard deviation of
Question:
For the Excel file Travel Expenses, use a PivotTable to find the average and standard deviation of expenses for each sales rep.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 73% (15 reviews)
Travel Expenses Date Sales Rep Expenses 322014 Crawford 22125 362014 Crawford 8022 372014 Crawford 2...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business Communication questions
-
Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart.
-
For the Excel file Closing Stock Prices, a. Apply both column and line sparklines to visualize the trends in the prices for each of the four stocks in the file. b. Compute the daily change in the Dow...
-
For the Excel file Credit Risk Data, compute the correlation between age and months employed, age and combined checking and savings account balance, and the number of months as a customer and amount...
-
Compare the ACA passed in 2010 with the Massachusetts health plan adopted in 2006 (use the Internet to obtain more details than we have provided in this chapter). Be sure to note the similarities and...
-
Distinguish between food infection and food poisoning and give an example of each.
-
Delacroix Co. had 800 units of inventory at the beginning of March 2010. Other information about that beginning Work in Process Inventory is as follows: Direct labor costs were extremely high during...
-
Draw a conceptual model of hypothesized relationships for the Samouels customer database. Identify the hypotheses and indicate whether they are directional or nondirectional.
-
Austin Landers is the accountant for Sun Coast, a manufacturer of outdoor furniture that is sold through specialty stores and internet companies. Annually, Landers is responsible for reviewing the...
-
A company provided the following direct materials cost information. Compute the direct materials quantity variance. Standard costs assigned: Direct materials standard cost (405,000 units @...
-
12 Mitchell's Specialties sells high-end furniture (dressers, chairs, sofas, and tables). The company has been in business for several years. Based on its experience, management projects next year's...
-
Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. Also, find the average sales by source (Web or e mail). Do you think this information could be...
-
In the Excel file Facebook Survey, find the average and median hours online/ week and number of friends in the sample using the appropriate Excel functions. Compute the midrange and compare all...
-
What does the term compounding mean?
-
How do emergent properties within teams, such as synergy and collective intelligence, manifest and influence team performance, and what factors contribute to their development and sustenance?
-
Think about your workplace, organization, or industry; if you are not currently working, think about previous employment or a job that you are aiming for. The broader your perspective, the more...
-
Choose any global organization that successfully undertook a strategic transformation to adapt to changing market dynamics and sustain its competitive advantage. Examine the company's challenges,...
-
In examining C&C Sports through the lens of a SWOT analysis, several key factors come to light. The strengths of the company are evident in its established brand reputation and a loyal customer base...
-
A perfectly insulated container initially contains 0.2 kg of ice at -15 C. Now we add water at 30 C, but only the minimum amount needed to barely melt all the ice. Find the net entropy change of the...
-
Try to identify at least one practical problem that may arise when using SVA calculations to reward managers.
-
Coastal Refining Company operates a refinery with a distillation capacity of 12,000 barrels per day. As a new member of Coastal's management team, you have been given the task of developing a...
-
An option is: (a) the right to buy an asset at a future point in time (b) the obligation to buy an asset at a future point in time (c) a swap (d) a derivative product that is traded only in the USA
-
A small assembly line for the assembly of power steering pumps needs to be balanced. Exhibit 8.11 is the precedence diagram for problems #8 and #9. The cycle time is determined to be 1.5 minutes. How...
-
For the assembly line described in Problem 8, how would the line be balanced by choosing the assignable task having the shortest task time first? Exhibit 8.11 is the precedence diagram for problems...
-
For the assembly line described in Problem 8, how would the line be balanced by choosing the assignable task having the shortest task time first? Exhibit 8.11 is the precedence diagram for problems...
-
Mediocre Company has sales of $120,000, fixed expenses of $24,000, and a net income of $12,000. If sales rose 10%, the new net income would be: Question 18 options: $16,800 $36,000 $13,200 $15,600
-
1. Why might managers of small restaurants decide not to adopt the standard work hour approach to controlling labour cost? (minimum 150 words )
-
Which statement is true regarding the U.S. GAAP impairment test for limited life intangibles? A. U.S. GAAP impairment is likely to be greater than IFRS impairment. B. The impairment test for limited...
Study smarter with the SolutionInn App