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.
-
You are having lunch at an all-you-can-eat buffet. If you are rational, what should be your marginal utility from the last morsel of food you swallow?
-
For each of the following sets of numbers, calculate a \(95 \%\) confidence interval for the mean \((\sigma\) known); before going through the steps in calculating the confidence interval, the sample...
-
Open a general journal form like the one in Exhibit 2-4, and label it Page 10. After opening the form, record the following transactions in the journal: Dec.14 Purchased equipment for $6,000, paying...
-
Find the zeros of the quadratic function using the square root method. What are the x-intercepts of the graph of the function? 9(x)=(x-4)-9
-
Marcus Enterprise began is 2011 when Damien Marcus invested $8,000 in exchange for capital stock. The following in the work sheet for the company at the end of the first year in business. Prepare an...
-
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...
-
For the following exercises, determine why the function f is discontinuous at a given point a on the graph. State which condition fails. f(x) - = x 27 3 x - 3x -, a = 3
-
How is the financial plan related to the other parts of a firms overall strategic plan?
-
What would be the cost of equity for Firm X at Equity/Capital ratios of 1.0 (no debt) and 0.58 assuming that r RF = 5% and RPM = 4%? Use the Hamada equation to calculate the unlevered beta for Firm X...
-
How does sales stability affect the target capital structure?
-
Dina is a partner in Eastman Technical Group. Dinas dissociation from the partnership will cause a. the automatic termination of the firms legal existence. b. the immediate maturity of all...
-
Would the market-value debt ratio tend to be higher than the book-value debt ratio during a stock market boom or a recession? Explain.
-
Graph the sets of points whose polar coordinates satisfy the equations and inequalitie. r 1
-
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...
-
A consultant advises that a fund pays out $100,000 at the end of 5 years. Provided $12,000 is invested in the fund at the start of each year, beginning immediately and continuing up to and including...
-
Durco Automotive needs a $2 million balance in its contingency fund 3 years from now. The chief financial officer (CFO) wants to know how much to deposit now into Durco's high-yield investment...
-
3. Create a chart for gross margin less R&D and capital costs calculations. a. Calculate gross margin less R&D and capital costs for options A and B. b. Graph total gross margin less R&D and capital...
Study smarter with the SolutionInn App