Free

Homework - Case Study Example

Comments (0) Cite this document
Summary
One area where pivot tables would not be appropriate is where there is a single category along with a set of numbers. Simply using the sum function will show…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER94.9% of users find it useful
Homework
Read TextPreview

Extract of sample "Homework"

For this question answer it in one page. When is it appropriate to use pivot tables? Pivot tables can be useful wherever there are large amounts of data that needs to be sorted by category and/or amount. One area where pivot tables would not be appropriate is where there is a single category along with a set of numbers. Simply using the sum function will show the total number in a single category without the need for taking many categories of data and only taking out selected data. One example of a great use of pivot tables would be if a company wanted to see which employee sold the most numbers of products and the particular cities in which they sold them in. A pivot table can then break down the numbers to show the amount sold by each employee. Then, it could even go further and break those numbers down by cities. So you would know which employee made the most number of sales, in which city the most number of sales were made, and which singular employee made the most number of sales in just one city. Data from the pivot table could then be used to allocate funds and estimate future sales based on the data from the pivot table. Comparisons could then be made across previous time periods and a comparison could be made to show the trends of certain employees or locations. Changes could then be made based off this data by either firing an employee or stop selling products in a city that is underperforming.
Make response or comment for 70-80 words for each of them:
1- Because they are amazing tools used to quickly explore and manipulate data from a spreadsheet. A pivot table uses existing data and allows users to sort that data by any field they choose. The user can select which fields they would like to be displayed and whether it should be a column or a row header. That table can then be manipulated by integrating formulas into the table to quickly get inventory counts, cost percentages, sales commissions, regional growth, or anything else you need to determine. Using pivot tables to explore crosstab data is much easier than searching through spreadsheets, pulling out the pertinent data, then creating a new spreadsheet with the data necessary. Pivot tables make analyzing large quantities of data a user-friendly experience. You can actually create a pivot table in as few as 10 mouse clicks!
You are correct in that using a pivot table can significantly reduce the time it takes to analyze data. All it needs is for just a few spaces to be filled in and the pivot table will display all the information you need in a nice and easy format. You might want to mention though that the use of pivot tables is not simply reduced to business-related activities but can also be used in other areas.
2- Pivot tables are a tool used to simplify the process of analyzing data. In Excel, you choose your data range, and when a pivot table is created, each type of data within the range is separated into its own piece. Therefore, you can easily pick and choose which type of data you would like to add to your pivot table to analyze. It is a useful tool for an Excel sheet that contains a large report because it helps you quickly search for a specific amount such as sales by region/employee/product or average profit for a time period. Not only do pivot tables allow you to choose which types of data to include in the table, the values can be shown in different ways such as sum, average, and product or even used to find the maximum in a data set.
This is a good explanation of what a pivot table is, but for someone who does not understand all the technical terms it might be best to use more simple words. Your last comment about sum, average, and data set maximum, although true, these things can also be done through simple Excel functions. You should also state why it is important to know about sales by region/employee/product and what benefit that brings.
3- Pivot tables are appropriate to use when someone needs to summarize or analyze what would otherwise be a cumbersome amount of data. Fields in large tables of information can be filtered to show functions such as sums, maximums, minimums, averages, and counts. Pivot tables are helpful in sorting data by multiple parameters, such as sales by employee and by quarter. They are helpful in finding patterns in data and in answering specific questions about data in tables or lists. They are also appropriate as a more aesthetically pleasing aid to present results of data to management.
All of the points that you have mentioned are pretty standard, but one thing that you have mentioned that others have not done is your comment about presenting data to management. This would be a primary focus of pivot tables because management does not have time to sift through all the data. For them to be able to look at something that tells them what they want to know will greatly assist them in their decision-making process.
4- Pivot tables are beneficial to businesses because of the way they present information. Once the data is compiled, different users can tailor the data to analyze it in different ways. This allows for a more efficient use of data and gives professionals the opportunity to view the information in ways they may not have originally thought. For some uses, pivot tables can be more beneficial at presenting the information that charts, graphs or tables. The feature pivot table with a chart combines these features into a more collective group. Instead of making a variety of graphs, the same information same be used to create a more well-rounded picture of the data and how variables are affected. The amount of information and ways to present it are limitless with the use of pivot tables.
Although the main use of pivot tables is for businesses, they can also be used in other settings, so maybe this is something that you should mention too. Business professionals do like to use pivot tables because of the speed at which information can be presented, but they can have other uses in everyday life. Maybe mention that pivot tables could be used for someone’s personal running schedule so they can make comparisons from the past until now.
5- Pivot tables are an excellent was to summarize data. They are used in either spreadsheets or business intelligence software to enable the user to quickly determine such things as average sales, item counts, and sales by sales person. A user would begin by preparing source data. Once this is done one can create a pivot table and by using the drag and drop feature-- it can be customized to answer any number of questions. Microsoft defines a PivotTable as "an interactive table that automatically extracts, organizes, and summarizes your data." One thing a pivot table is not used for is forecasting. They dont have the ability to support regression lines and trend lines.
While your first sentence is correct, pivot tables can be used in multiple ways, not just to summarize data. Summarizing data can be done by other Excel tool functions. You should explain a little more about source data because someone unfamiliar with data terms may be unsure of what that means. Also, try not to use quotes and instead explain things in your own words because this will show that you understand the concepts. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Homework Case Study Example | Topics and Well Written Essays - 500 words”, n.d.)
Homework Case Study Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/finance-accounting/1603228-homework
(Homework Case Study Example | Topics and Well Written Essays - 500 Words)
Homework Case Study Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/finance-accounting/1603228-homework.
“Homework Case Study Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/finance-accounting/1603228-homework.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Homework

Homework

...?The first part of the video lecture defines and demonstrates the botnet, how the botnet are created and infect the computer systems over the internet. A botnet is a collection of infected computers connected to the internet which are being controlled by the Bot herder and command center. It has been found in the video that a Bot client can easily be developed by a Trojan that installs a bot code on the victim’s PC through a compiled and executable source code that can be written in Microsoft Visual C++. It has been learnt from the video through a practical example to control and command the bots through IRC that can be installed on the private server machine and spreading the bots through e-mail attachment, downloading BitTorrent...
4 Pages(1000 words)Essay

Homework

... A comparison between articles on marijuana use Marijuana has been in use by different persons across the globe for various reasons for a long period. Despite this, there have been various regulations that are imposed on its use, depending on the understanding of the health and economic benefits and hazards associated with its use. In this regard, numerous researches have been undertaken on the topic. This paper seeks to compare two articles; ‘Government Study of Marijuana Sees Medical Benefits by Strolberg, Sheryl and ‘Legalizing of Marijuana Raises Health Concerns’ by Rabin, Roni. ‘Government Study of Marijuana Sees Medical Benefits’ by Strolberg presents a research directed by the government in a bid to understand the effects... A...
3 Pages(750 words)Research Paper

Homework

...The research article “Family Involvement with Childrens Homework: An Intervention in the Middle Grades” by Sandra J Balli, David H Demo and John F Wedman has its purpose stated clearly and succinctly. The study purports to investigate the effects of family involvement in homework at the middle grades. It is sufficiently delimited to involve 74 Caucasian sixth graders and their predominantly middle-class families. The homework assignments of specific Mathematical problems are analyzed, over a period of time. The students are selected from a single school, and the selected classes are handled by the same teacher and the exercises given to them were also the same, to attain uniformity in the...
2 Pages(500 words)Article

Homework

...Homework American Revolution initiated the rebellion against the British colonizers and eventually led to the political and social freedom of the British colonies in the mainland of America. Thesis statement: The wartime experiences of the American Revolution are interconnected with the unification of the people and emergence of civil society, its effects helped the women to gain social status, it helped the slaves to gain confidence and it drastically affected the native population in America. Description and analysis: wartime experiences of the Revolution and the effects on women, slaves, and natives The wartime experiences of the American Revolution are closely related to the direct combat between the revolutionaries... American...
1 Pages(250 words)Essay

Homework

...Homework In the disasters you saw in the photographs, what should the buyer have insisted upon in his/her contract with regard to risk of loss? Explain. Ocean freight has been one of the most utilized modes of shipment throughout the globe as it is cheaper and it can transport any size or weight of goods. Unfortunate for some, this method involves risks such as occurrence of unprecedented disasters, accidents, or malfunctions of these cargo ships. Such cases lead to filing of law suits on the part of the cargo’s insurance companies and on both parties of buyers and sellers. In circumstances such as the ocean disasters reflected in the photographs, the buyer should have included a condition subsequent (Mallor, et al., 2012... In the disasters ...
1 Pages(250 words)Assignment

Homework

...Homework Answers Part One Question Planning for an uncertain situation encompasses a broad process known as contingency planning. This broad process consists of the following components: A plan for incident response A plan for disaster recovery A plan for business continuity These three components account for all-round variables that constitute an uncertain occurrence, thereby informing the planning process for the underlying situation. Question 2 NIST defines a CP process that is made up of seven steps, which include: i. Formulation of a policy statement in relation to contingency planning. ii. Conducting an analysis of business impact. iii. Determination of preventive controls. iv. Development of strategies for...
3 Pages(750 words)Case Study

Homework

... Homework As I search for "security best practices", several internet articles had topics on the information security officer, vendor management, as well as physical security. The paper will discuss security best practices with regards to these three topics mentioned above. It will also comment on papers that other students have written regarding this topic. Information Security Officer The first thing that every security program should do is establish the existence of the Information Security Officer (Putvinski 1). Relying on the size of a person’s security environment, this could be a current worker who has the accessibility to take on further duties or a full-time worker. Apart from the time element, a firm must clearly define...
2 Pages(500 words)Case Study

Homework

...Homework Questions American farmers were faced with various economic and social ills at the turn of the century. Farmers got faced with a banking system that insisted on the gold standard as its monetary system. The railroad system at the time was also deemed as capricious and unfair. The farmers also got faced with rampant land speculation that drove prices for land up. The populist movement referred to the advocacy of the people’s party in 1892 (Roark et al 352). The movement advocated against the industrial society at the time. The movement got based around poor and hard-pressed farmers. The movement called for the formation of a sub treasury, land reform, currency reform, and the empowerment of the common people....
1 Pages(250 words)Coursework

Homework

... Affiliation Cost estimation is an important aspect of project management and determines whether the project is worth undertaking, whether it will be profitable to the company, and if at all the company can afford it (Pinto 2010). It provides the firm with a cost range (“Ball park estimate”) of the total monetary cost of the project. In terms of project schedule and Work breakdown structure, it leads to budgeting for monetary, human and material resources since the management eventually uses these allocations to coordinate the resources to ensure all three are available when needed. Parametric cost estimation works for cost estimation because it is more accurate as compared to analogous cost estimation (Pinto 2010). Considering... Affiliation ...
1 Pages(250 words)Assignment

Homework

...Essential Selling Skills al affiliation Essential Selling Skills When selling in a company, the sales people need to be in order in a manner that the customers are analyzed and their needs match with the company’s products or services. The company I work with deals with short messaging and it deals with networking and short messages sending services. It is assisted with a larger networking company which offers the network to the company through IP gateways. Better Sms Ltd is a company that offers bulk short messages to the customers including short codes and Interactive Video Response services. Marketers and sales managers must ensure that the company’s services are advertised and offered to a larger number of clients... Selling Skills al...
3 Pages(750 words)Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Case Study on topic Homework for FREE!

Contact Us