StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Use of MS Excel to interpret data in the context of organizational management - Essay Example

Cite this document
Summary
Many large companies use it to guide decision-making processes. It can be used to organize and interpret data in ways that reveal significant data patterns that might not otherwise be evident, thereby directly impacting the quality of decision-making…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.3% of users find it useful
Use of MS Excel to interpret data in the context of organizational management
Read Text Preview

Extract of sample "Use of MS Excel to interpret data in the context of organizational management"

Use of MS Excel to Interpret Data in the Context of Organizational Management Microsoft Excel is a tremendous resource for managers of organizations. Many large companies use it to guide decision-making processes (Michel, 2006). It can be used to organize and interpret data in ways that reveal significant data patterns that might not otherwise be evident, thereby directly impacting the quality of decision-making. Among the useful features of Excel for data interpretation are the graph and chart wizard, data sorting and filtering, and formulae.

These are just a few examples of the robust features that have made Excel a virtually indispensable tool for managers in today's business environment. The graph and chart wizards arguably have the greatest "wow" factor of all of the tools of Microsoft Excel. This feature enables the user to develop graphical representations of numbers that make trends and relationships among data visually obvious. For example, a manager can utilize this feature to make a trend chart that plots increases and decreases and projects future performance of the organization based on the data fed into a spreadsheet.

Also, the feature can be used produce pie and bar charts that clearly delineate percentages of a whole that are represented by pieces of data. The feature also produces scatter charts and Venn diagrams illustrating the fallout of related statistics. Data sorting and filtering is another very useful feature of Excel for managers. This allows the user to quickly sort data by prioritized categories, then by value in order to float the highest priority values to the top of a spreadsheet. Filtering then allows the user to easily zero in on particular data sets within a spreadsheet and hide irrelevant data.

These features enable organizational managers to quickly access the data they need to make better decisions faster. Finally, the use of formulae is turns spreadsheets into automatic calculators. Managers can enter a formula that will automatically compute outcomes as numbers are entered into a spreadsheet. This enables the drawing of quick conclusions as disparate pieces of data become known. For example, a manager who needs to track percent attainment of a goal can input a formula that divides attainment by the goal and formats the designated cell as a percentage.

Then, as each month's revenue is typed in, the percent attainment will show up automatically on the spreadsheet. Legal and Ethical Implications of Profiling Potential Employees There are significant legal and ethical implications associated with using surveys to gather characteristics in order to create an ideal profile of potential employees. Not only might a company overlook candidates who are actually right for the position, but they can also get themselves into trouble. In an environment where cost containment is essential, the prospect of expensive litigation or fines is likely not worth the risk involved with collecting dubious data for hiring decisions.

The most glaring of these issues is the potential to engage in racial, ethnic, religious or other prohibited types of profiling of potential employees. Title VII of the Civil Rights Act of 1964 expressly prohibits employment discrimination based on any of these factors. Not only would it be illegal to make hiring decisions based upon these kinds of considerations, but it would also arguably be unethical. Age is another factor that should be handled delicately under the law. The Age Discrimination in Employment Act expressly protects employees age 40 and older from discrimination.

Therefore, if the survey concluded that ideal candidates for the position should be younger, then this can present a serious legal problem for the organization. Another consideration that may not be legally prohibited, but certainly could have ethical implications, is the potential invasion of privacy that goes along with any kind of data collection and compilation. The survey would invariably ask respondents to provide some personal information about them in order to draw useful conclusions about desirable characteristics.

Such questions could easily cross a fuzzy boundary of inappropriateness. For example, asking lifestyle questions in order to determine characteristics best suited to an employment position could be considered unethical. Works Cited Age Discrimination in Employment Act, 29 U.S.C.A. Sec. 621 (1967). Civil Rights Act, 42 U.S.C.A. Sec. 2000 (1964). Michel, R. (2006, April). Tools invoke return on IT spend. Manufacturing Business Technology, 24(4), 38.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Use of MS Excel to interpret data in the context of organizational Essay”, n.d.)
Retrieved from https://studentshare.org/management/1528547-use-of-ms-excel-to-interpret-data-in-the-context-of-organizational-management
(Use of MS Excel to Interpret Data in the Context of Organizational Essay)
https://studentshare.org/management/1528547-use-of-ms-excel-to-interpret-data-in-the-context-of-organizational-management.
“Use of MS Excel to Interpret Data in the Context of Organizational Essay”, n.d. https://studentshare.org/management/1528547-use-of-ms-excel-to-interpret-data-in-the-context-of-organizational-management.
  • Cited: 0 times

CHECK THESE SAMPLES OF Use of MS Excel to interpret data in the context of organizational management

Communication, Culture, and Diversity on Virtual Team Effectiveness

Sampling The level of analysis adopted in this study is the company or organizational level.... Three of these constructs are organizational variables included in the first research problem: communication, culture and diversity.... Introduction This section elucidates the protocol which will be adopted in the conduct of the study from the collection of data to the analysis and interpretation of findings.... Included in the discussion are sampling design, measures of the constructs pertinent to the study, the data gathering procedure and the estimation method to be applied in data analysis....
6 Pages (1500 words) Essay

Knowledge Management as the Key to Employee-Learning and Productivity: Indian Micro-financial Institutions

The present study examines how effective is knowledge management in an organization to foster innovation and enhance labor productivity within the organization.... The present study also examines the effectiveness of knowledge management system among micro-finance institutions in India.... nbsp;  Organizations across industries and countries have realized that knowledge and its management can be a key differentiator in the highly competitive business world....
8 Pages (2000 words) Research Proposal

Effects of Change on Employees Motivation: A Critical Analysis of the Technology Sector

In the same context, both intrinsic and extrinsic motivation has been separated as both have different types of impacts and benefits offered by organisations.... Comparatively, this sector is more prone to the effects of changes because the frequency of change particularly in the technology sector is the highest than the other sectors, such as banking, insurance, construction and… r the sake of understanding and clarity, the scope of technology, for this paper, will be limited to telecommunication industry and other softwares that influence to the information communication technology. (a) On this topic, previous research has been by Dennis G....
4 Pages (1000 words) Assignment

Employee Engagement On The Scope Of Future Career Growth Of Employees

In the words of Collings & Wood (2009), the most hyped topics in the context of international human resource management are ensuring employee commitment and engagement.... Scholars such as Dyne & Pierce and Konrad (2009) have questioned the authenticity of the organizations in the context of providing the scope of growth for their employee base.... … Most of the firms are trying to measure their employee engagement and relate the same to job satisfaction for identifying the efficacy of their human resource management....
39 Pages (9750 words) Dissertation

CRM & SharePoint Tools in Management

In the paper “CRM & SharePoint Tools in management” the author discusses the need for technology resources.... hellip; The author states that in the light of using a combination of or relying solely on the work of management and Information Technology (IT) there is much to be offered about the operations of both.... For the most part, IT is being established as a necessity of management, but also non-functional without the contributions of management....
7 Pages (1750 words) Research Paper

Time Management

This work "Time management" focuses on the concepts of Endnote software and the Bloomberg database.... Time management was an issue faced by me during the course of learning.... The internal factors mainly include; the core values of the organization, motivation existing amongst the organizational members to adopt CSR, the organizational culture, vigilance, and innovation relating to the sustainability techniques and initiative towards reporting the same to the external stakeholders....
6 Pages (1500 words) Essay

Data Mining and How it Can Be Address

Therefore data warehousing is an aggregation of data that supports data mining, while Data set is a data warehouse subset whereas Database refers to an organized set of data in a given structure.... This is done through the use of algorithms and other statistical techniques.... This is done through the use of algorithms and other statistical techniques.... … The paper "data Mining and How it Can be Address" is a perfect example of an assignment on information technology....
14 Pages (3500 words) Assignment

Geographic Information System and other Spatial Data Handling Technologies

It uses cartographic data in configuring computer hardware software precisely designed for acquiring and maintaining information.... However, all the definitions point towards one particular direction and emphasizing the GIS is a computerized system that integrates the application of computer hardware, software, and the people to apply analytical tools to interpret the spatial data.... nbsp;With increasing global applications of GIS, it is important to begin by understanding the concept relating to the use of this technique....
8 Pages (2000 words) Term 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.
Contact Us