M2-Unit1-Pivot Tables-Graphs
.pdf
keyboard_arrow_up
School
University of Alabama *
*We aren’t endorsed by this school
Course
490
Subject
Business
Date
Apr 3, 2024
Type
Pages
18
Uploaded by danielw3lch
FI 389 Pivot Table A pivot table is a data summarization tool found in Microsoft Excel. PivotTables, as the name suggests, can be quickly rearrange by changing the orientation of the pivot table fields- to give you a different view of the table. In this tutorial, we will learn how to start with a basic data source and create PivotTable reports that answer common questions about our data. These techniques can be used for just about any type of source data. The following example shows reports you could use to compare your salespeople:
Example 1: Comparing your salespeople Start with source data that contains information about your salespeople. Here is some of the source data records used for the reports in this section. Congratulations, you landed your first job as the Lead Sales Analyst at Nickie’s
Sports Inc. On your first day at work your boss, Sheldon (whose constant demands, it turns out, was the reason the last analysts resigned) approaches you and requests that you generate a report from data he has added to your shared drive. His request is presented in Email 1 below:
Email 1
1.
What is the sum of order amount for each salesperson? 2.
What is the average order amount for each salesperson? 3.
What is the minimum order amount for each salesperson? 4.
What is the maximum order amount for each salesperson? 5.
What is the standard deviation order amount for each salesperson? Answer to Email 1 We can use Pivot Table to solve this problem. To set up your PivotTable: 1.
Click a cell in the source data. 2.
On the Insert
menu, click Pivot Table
3.
Follow the instructions in steps of the wizard.
4. Clicking OK will result in the following: To answer questions (a) through (e) on EMAIL1 we follow the instructions below: EMAIL1 a)
What is the sum of order amount for each salesperson?
We drag the Salesperson field into the Row area, and then drag the Sales field into the Values area.
We then answer question (b) by dragging the sales field into the value area again as shown below Next use the mouse to click any cell on the “Sum of Sales2” column. The
n right click the mouse and see the following output:
Repeat the same process to answer questions (c) through (e) of Email1. Our final output should look like this: Aaah, all in a day’s work. And
the good part is, it’s only
12:20 PM3:03 PM. An early lunch is definitely in order. Chinese? Thai? Chick-
fi… Before you could finish the thought, here comes a popup of a new email from Sheldon.
Email 2 a)
What is the sum of order amount for salespeople in a specific country? b)
What is the average order amount for salespeople in a specific country? c)
What is the minimum order amount for salespeople in a specific country? d)
What is the maximum order amount for salespeople in a specific country? e)
What is the standard deviation order amount for salespeople in a specific country? Answer to Email 2 a)
What are the order amounts for salespeople in a specific country? We drag the Country field and Salesperson field to the Row Label area. We also drag the Sales field to Value area as shown below. Alternatively we can drag the Country field into the Page area. You can then switch between "pages" to view the data for each country. We repeat the same approach in Email 1 for Email2 (b) through (e) to obtain the following final output.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
This data sufficiency problem consists of a question and two statements, labeled (1) and (2), in which certain data are given. You have to decide whether the data given in the statements are sufficient for answering the question. Using the data given in the statements, plus your knowledge of mathematics and everyday facts (such as the number of days in July or the meaning of the word counterclockwise), you must indicate whether:- Statement (1) ALONE is sufficient, but statement (2) alone is not sufficient to answer the question asked.- Statement (2) ALONE is sufficient, but statement (1) alone is not sufficient to answer the question asked.- BOTH statements (1) and (2) TOGETHER are sufficient to answer the question asked, but NEITHER statement ALONE is sufficient to answer the question asked.- EACH statement ALONE is sufficient to answer the question asked.- Statements (1) and (2) TOGETHER are NOT sufficient to answer the question asked, and additional data specific to the problem are…
arrow_forward
Indicate whether the data are time series or cross-sectional.
Number of cars sold by each salesperson in a dealership in October
Choose the correct answer below.
About
A. The data are cross-sectional because the data are measured over time.
B. The data are cross-sectional because the data are taken from situations that vary over time but are measured at a single time instant.
OC. The data are time series because the data are taken from situations that vary over time but are measured at a single time instant.
D. The data are time series because the data are measured over time.
Click to select your answer.
Question Help
arrow_forward
Correct and detailed answer will be Upvoted else downvoted. Thank you!
arrow_forward
Which of the following is the correct sequence in which cost management information is developedand used?a. Business events, data, information, analysis, decisionsb. Business events, data, analysis, information, decisionsc. Business events, information, analysis, knowledge, decisionsd. Business events, data, information, knowledge, decisions
arrow_forward
We can define big data as *
The collection of data from and about
everything internal to the organization.
The collection of data from and about
O everything internal and external to the
organization.
The collection and interpretation of an
organization's internal and external
data to attain its business objectives
besides enhancing customer service.
O None of the mentioned options
arrow_forward
Correct and detailed answer will be Upvoted else downvoted. No plagarism please
arrow_forward
Primarily which among the following reports will you use, to know which constraints are binding and which are not, while using Solver?
a.
Answer Report
b.
Sensitivity Report
c.
None of these
d.
Limits Report
arrow_forward
11. models are generally easier to use and less expensive than dealing with the real life system
a. benefits of models
b. mathematical models
c. schematic models
d. limitations of models
arrow_forward
Over the past few decades, technological advances have led to a dramatic increase in the amount of recorded data. The use of smartphones, RFID tags, electronic sensors, credit cards, and the internet has facilitated the collection of data from phone conversations, emails, business transactions, product and customer tracking, business transactions, and web browsing. Data mining is the process of applying analytical techniques to large quantities of data to find hidden structures, patterns, and relationships among variables. Illustrate some applications of the data mining techniques in business are used in order to gain insight on customers and to uncover patterns to improve business processes
arrow_forward
When is it appropriate to delete an entire row or column, as opposed to deleting data in the row or column?
arrow_forward
True or false?
Select one or more:
а.
Wealth can be measured as a flow over time.
O b. Disposable income measures income after direct taxes, so any consumption out of disposable income is
unaffected by taxation.
Your net worth is equal to your assets (both real and financial) minus
O c.
your
labilities.
O d. An example of gross income in the "bathtub" diagram is a landlord's rental income on a property.
arrow_forward
Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), “E” or “e” (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where “a” and “b” need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not. A survey determines that mint chocolate chip is the favorite ice cream flavor of 6% of consumers. An ice cream shop determines that of 190 customers, 15 customers stated their preference for mint chocolate chip. Find the P-value that would be used to determine if the percentage of customers who prefer mint chocolate chip ice has increased at a 5% level of significance. P-value: Round your answer to four decimal places as necessar
arrow_forward
Paraphrase this one. Analyze and elaborate in 200 words.
Time series analysis is a specific way of analyzing a sequence of data points collected over an interval of time. In time series analysis, analysts record data points at consistent intervals over a set period of time rather than just recording the data points intermittently or randomly. However, this type of analysis is not merely the act of collecting data over time. What sets time series data apart from other data is that the analysis can show how variables change over time? In other words, time is a crucial variable because it shows how the data adjusts over the course of the data points as well as the final results. It provides an additional source of information and a set order of dependencies between the data. Time series analysis typically requires a large number of data points to ensure consistency and reliability. An extensive data set ensures you have a representative sample size and that analysis can cut through noisy…
arrow_forward
Briefly stated, a theory is a set of statements that serves to explain the manner in which certain concepts or variables are related. These statements result both from our present level of knowledge on the topic and from our assumptions about the variables themselves. The theory allows us to deduce logical propositions, or hypotheses, that can be tested in the field or laboratory. In short, a theory is a technique that helps us understand how variables fit together. Their use in research and in management is invaluable (Black & Bright, 2019).
Support why learning organizational behavior and management theory is important to your academic and professional career (s).
arrow_forward
Paraphrase this one. Analyze and elaborate in 120 words.
Predictive analytics involves a statistical approach called regression, which helps us uncover connections between different factors. This technique is valuable for spotting trends within extensive sets of information and figuring out how various inputs relate to each other. It shines brightest when dealing with continuous information that follows an established pattern. Regression frequently comes into play when we want to understand the impact of one or more independent factors on another. For instance, it aids in grasping the effect of raising prices on product sales. This tool holds the key to unraveling hidden insights in data that might otherwise remain unnoticed.
arrow_forward
You are cleaning the data for data modeling. Which of the following is NOT a data preparation step ?
Group of answer choices
Changing the variable type of outcome variable (Defaulted)
Removing variable Index
Replacing any missing value by the mean of that variable
Computing the confusion matrix
arrow_forward
Which of the following statements is true about the budgeting process for the beach cleanup project?
All cleanup tools will be paid for directly by the budget.
Vendor expenses for removing the waste must be in the budget.
The scope document is not referred to during the budgeting process.
Budgeting for effort includes the cost for all cleanup equipment.
arrow_forward
XYZ Co is trying to forecast future customers' needs through the use of
advanced technology and the collection of an updated customers' database.
XYZ Co wants its employees to work extra hard in order achieve this specific
goal. XYZ Co's goal is also
variable
challenging
fixed
impossible
arrow_forward
I need help with everything please.
You do not need to use Solver or solve the problems. Just respond to the problem questions using the outputs provided in the problem. I realize the information isn't complete. There is a picture in the attach image (this is a complete question).
3. Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of clients. A particular portfolio consists of U shares of U.S. Oil and H shares of Huber Steel. The annual return for U.S. Oil is $3 per share and the annual return for Huber Steel is $5 per share. U.S. Oil sells for $25 per share and Huber Steel sells for $50 per share. The portfolio has $80,000 to be invested. The portfolio risk index (0.50 per share of U.S. Oil and 0.25 per share for Huber Steel) has a maximum of 700. In addition, the portfolio is limited to a maximum of 1000 shares of U.S. Oil. The linear programming formulation that will maximize the total annual return of the portfolio is as follows:
Max 3U +…
arrow_forward
1. Construct a 2-by2 contingency table to determine the total number of people who fail the screening test and will be referred for diagnostic testing in the hearing centers.
2. Construct a 2-by-2 contingency table to determine the total number of people who fail the diagnostic test, which represents the target market for hearing aid sales.
arrow_forward
What are the most common file formats supported in BIM (Building Information Modeling) programs?
arrow_forward
What is the advantage of a dot plot over a histogram?
Group of answer choices
1. Preserves the original data in the plot
2. Shows shape of the data in the plot
3. Shows spread of the data in the plot
4. Shows central location of the data
5. Shows priority of categories
arrow_forward
Which of the following statements about what-if analysis is TRUE?
Multiple Choice
Changes in an objective function coefficient will always lead to changes in decision variable values.
Changes to constraint right-hand side values will always lead to changes in decision variable values.
Changes in an objective function coefficient will never lead to changes in decision variable values.
Changes to constraint right-hand side values will never lead to changes in decision variable values.
None of the answer choices is correct.
arrow_forward
1. Business valuation is typically conducted when a company is looking to sell all ora
portion of its operations or looking to merge with or acquire another company.
(True / False)
2. Discounted dividends model is one of the Valuation methods. (True / False)
3. Liquidation Value - is the net cash that a business will pay if its assets were liquidated and
liabilities were paid off today.
4. Financial forecasting is the process of estimating how a business performed in the past.
(True / False)
arrow_forward
1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell.
a. XCountry Train Inc. specializes in trans-American moves for businesses and individuals through the delivery of containers. For every container the company loads on its trans-American rail, the business must pay the rail owners $8,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.10. Harry plans to charge $0.50 per pound to his customers.
The company finds out that to maintain the integrity of its containers, each container could only hold an average of 30,000 pounds. What would the company have to charge customers to make $8,000 in profit on each container?
arrow_forward
Please do not give solution in image format thanku
Susana manages inventory at fashion apparel retailer Orange Republic. In January, Suasana is determining order quantity for swimsuit for coming summer season. Each swimsuit is purchased at $50 and sold at retail price of $105. All the swimsuits that remain unsold at the end of summer, are sold to discount retailer TJ-Minn for $22 at the beginning of fall. The demand for swimsuits during summer is Normally distributed with mean of 200 and standard deviation of 50. If Susana order 250 swimsuits, what is the expected profit from Swimsuits?
arrow_forward
Which of the following statements about appraisal and valuation is FALSE?
O Standards for the appraisal profession are set forth in the Uniform Standards of Professional
Appraisal Practice (USPAP).
O In DCF method, differently assumed holding periods may lead to different valuation
estimates.
O It is customary to validate the DCF valuation using other methods such as the Sales
Comparison approach and the Cost approach.
O If the market value of the developed property is estimated to be higher than the development
cost, the project if financially feasible.
arrow_forward
Integer Linear Programming Problem: Identify decision variable, objective function and constraints MODEL only. Please explain thanks!
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
arrow_forward
Paraphrase this one. Analyze and elaborate in 120 words.
Time series analysis is used for non-stationary data—things that are constantly fluctuating over time or are affected by time. Industries like finance, retail, and economics frequently use time series analysis because currency and sales are always changing. Stock market analysis is an excellent example of time series analysis in action, especially with automated trading algorithms. Likewise, time series analysis is ideal for forecasting weather changes, helping meteorologists predict everything from tomorrow’s weather report to future years of climate change. Examples of time series analysis in action include:
Weather data
Rainfall measurements
Temperature readings
Heart rate monitoring (EKG)
Brain monitoring (EEG)
Quarterly sales
Stock prices
Automated stock trading
Industry forecasts
Interest rates
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Related Questions
- This data sufficiency problem consists of a question and two statements, labeled (1) and (2), in which certain data are given. You have to decide whether the data given in the statements are sufficient for answering the question. Using the data given in the statements, plus your knowledge of mathematics and everyday facts (such as the number of days in July or the meaning of the word counterclockwise), you must indicate whether:- Statement (1) ALONE is sufficient, but statement (2) alone is not sufficient to answer the question asked.- Statement (2) ALONE is sufficient, but statement (1) alone is not sufficient to answer the question asked.- BOTH statements (1) and (2) TOGETHER are sufficient to answer the question asked, but NEITHER statement ALONE is sufficient to answer the question asked.- EACH statement ALONE is sufficient to answer the question asked.- Statements (1) and (2) TOGETHER are NOT sufficient to answer the question asked, and additional data specific to the problem are…arrow_forwardIndicate whether the data are time series or cross-sectional. Number of cars sold by each salesperson in a dealership in October Choose the correct answer below. About A. The data are cross-sectional because the data are measured over time. B. The data are cross-sectional because the data are taken from situations that vary over time but are measured at a single time instant. OC. The data are time series because the data are taken from situations that vary over time but are measured at a single time instant. D. The data are time series because the data are measured over time. Click to select your answer. Question Helparrow_forwardCorrect and detailed answer will be Upvoted else downvoted. Thank you!arrow_forward
- Which of the following is the correct sequence in which cost management information is developedand used?a. Business events, data, information, analysis, decisionsb. Business events, data, analysis, information, decisionsc. Business events, information, analysis, knowledge, decisionsd. Business events, data, information, knowledge, decisionsarrow_forwardWe can define big data as * The collection of data from and about everything internal to the organization. The collection of data from and about O everything internal and external to the organization. The collection and interpretation of an organization's internal and external data to attain its business objectives besides enhancing customer service. O None of the mentioned optionsarrow_forwardCorrect and detailed answer will be Upvoted else downvoted. No plagarism pleasearrow_forward
- Primarily which among the following reports will you use, to know which constraints are binding and which are not, while using Solver? a. Answer Report b. Sensitivity Report c. None of these d. Limits Reportarrow_forward11. models are generally easier to use and less expensive than dealing with the real life system a. benefits of models b. mathematical models c. schematic models d. limitations of modelsarrow_forwardOver the past few decades, technological advances have led to a dramatic increase in the amount of recorded data. The use of smartphones, RFID tags, electronic sensors, credit cards, and the internet has facilitated the collection of data from phone conversations, emails, business transactions, product and customer tracking, business transactions, and web browsing. Data mining is the process of applying analytical techniques to large quantities of data to find hidden structures, patterns, and relationships among variables. Illustrate some applications of the data mining techniques in business are used in order to gain insight on customers and to uncover patterns to improve business processesarrow_forward
- When is it appropriate to delete an entire row or column, as opposed to deleting data in the row or column?arrow_forwardTrue or false? Select one or more: а. Wealth can be measured as a flow over time. O b. Disposable income measures income after direct taxes, so any consumption out of disposable income is unaffected by taxation. Your net worth is equal to your assets (both real and financial) minus O c. your labilities. O d. An example of gross income in the "bathtub" diagram is a landlord's rental income on a property.arrow_forwardAccepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), “E” or “e” (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker. Complex numbers should be in the form (a + bi) where “a” and “b” need to have explicitly stated values. For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not. A survey determines that mint chocolate chip is the favorite ice cream flavor of 6% of consumers. An ice cream shop determines that of 190 customers, 15 customers stated their preference for mint chocolate chip. Find the P-value that would be used to determine if the percentage of customers who prefer mint chocolate chip ice has increased at a 5% level of significance. P-value: Round your answer to four decimal places as necessararrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,