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
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
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.
-
The period is given for a function of the form y = sin bx. Write the function corresponding to the given period. 1/3
-
One electrode in an alkaline battery is zinc, and the other is manganese dioxide. Fill in the blank for the chemical reaction \((a)\) at the zinc electrode: \(\mathrm{Zn}+2 \mathrm{OH}^{-}...
-
Tresh Products uses both special journals and a general journal as described in this chapter. Tresh also posts customers accounts in the accounts receivable subsidiary ledger. The postings for the...
-
Exercise 1 Motion on a Ramp In this exercise you will roll a marble down a ramp and calculate its linear acceleration and velocity. You will then create graphs to illustrate the motion of the marble.
-
Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park, employees do not like to...
-
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...
-
If the objectives of the federal tax system are multi faceted and include raising revenues, providing investment incentives, encouraging certain industries, and meeting desired social objectives, is...
-
What makes for a good billing system? Why is a good billing system important in a family law firm?
-
what are the advantages and disadvantages of mediation and collaborative law in divorce cases?
-
Describe the role of societal values in the development of family law.?
-
Discuss Open Adoption ? Discuss Gay Adoption? Discuss Tribal Adoption?
-
Using Florida's Family Law Practice Manual, explain one situation where an annulment would be granted.?
-
What impact do you think the revocation of the presidential permit on January 20, 2021, had on CanadaU.S. trade relations?
-
When you weigh yourself on good old terra firma (solid ground), your weight is 142 lb. In an elevator your apparent weight is 121 lb. What are the direction and magnitude of the elevator's...
-
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...
-
Find the LCM for each group of expressions. 1.2x-8x+8 and 3x+27x-30 2. 4x+12x+ 9 and 4x2-9 3. 2x2 18 and 2 5x330x+45x
-
StellarCraft, a space equipment manufacturer, produces three types of space components: "Plasma Thrusters," "Navigation Systems," and "Solar Panels." StellarCraft needs to determine the optimal...
-
If 103 people attend a concert and tickets for adults cost $2.25 while tickets for children cost $1.5 and total receipts for the concert was $179.25, how many of each went to the concert? adults...
Study smarter with the SolutionInn App