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.
-
A mechanism has 7 links with all binary pairs except one which is a ternary pair. The number of instantaneous centres of this mechanism are (a) 14 (b) 21 (c) 28 (d) 42.
-
Internal Control for Cash} After comparing cash register tapes with inventory records, the accountant for Good Times Music store is concerned that someone at one of the stores is not recording some...
-
WaterBound uses three processes to manufacture lifts for personal watercraft: forming a lifts parts from galvanized steel, assembling the lift, and testing the completed lift. The lifts are...
-
the appropriate section in the statement of cash flows for reporting the purchase of land
-
Using the factory energy cost data in Exhibit 11.11, find the best moving average and exponential smoothing models. Compare their forecasting ability with the regression model developed in the...
-
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...
-
The curves y = xe -ax are shown in the figure for a = 1, 2, and 3. a. Find the area of the region bounded by y = xe -x and the x-axis on the interval [0, 4]. b. Find the area of the region bounded by...
-
4. A boy with a mass of 65.2kg and maintaining a velocity of 1.1m/s, rides his bike up a hill with an elevation gain of 43 meters. It takes the boy 1.5 minutes to make it up the hill. What was his...
-
Assume you are a portfolio manager for an institutional investment company. Your client asks you to explain what risk factor sensitivity is and what it seeks to measure.
-
For this C++ program can you please complete Time.cpp file using overloaded operators. Below are the screenshots that can you be helpful. So can you please complete the Time.cpp file with the C++...
-
1 9 8 9 C Corporation had gross income of $ 2 5 0 , 0 0 0 , cost of goods sold of $ 8 0 , 0 0 0 . entertainment of $ 2 0 , 0 0 0 , lobbying of $ 5 , 0 0 0 , other expenses of $ 8 8 , 0 0 0 . What is...
-
Suppose the risk-free interest rate is 8%. Having $7 in one year is equivalent to having $___today? (Round to the nearest cent.)
-
If you lift the front wheel of a poorly maintained bicycle off the ground and then start it spinning at 0.72 rev/s, friction in the bearings causes the wheel to stop in just 12 s. If the moment of...
-
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...
-
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...
-
George was recruited to serve as the Chief Human Resources Officer (CHRO) of Epsilon Corporation, a privately-held company in the automotive industry, effective June 1, 2022. Throughout the fiscal...
-
Purchased raw materials on account, $ 8 5 , 0 0 0 . Raw Materials of $ 3 0 , 0 0 0 were requisitioned to the factory. An analysis of the materials requisition slips indicated that $ 6 , 0 0 0 was...
-
Bramble Company is preparing its master budget for 2 0 2 2 . Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Prepare the sales, production, and direct...
Study smarter with the SolutionInn App