Ways in which MS Excel, as a tool for interpreting data can be used by a manager of an organization.
We will write a custom Essay on Microsoft Excel in Modern Business Statistics specifically for you
301 certified writers online
MS Excel as a tool for interpreting data can be useful to an organization manager in many ways. First, it can be very useful in organizing data in a tabular format (Gupta, 2005, p. 60). The various tools and functions of MS Excel would allow a manager to create graphs and charts as well as make various calculations easily. The application also allows the sorting of data, which is often an important step in interpreting data. MS Excel also makes it easier to summarize data in terms of frequency, average, totals, and mode by using its in-built functions. These statistical items are often useful in discerning relationships in data sets.
A pivot table is a powerful tool in MS Excel that would allow a manager to quickly summarize data. It allows one to sort, total, and count data from the original dataset and display the summary in a different table known as the pivot table (Anderson, Sweeney, & Williams, 2008, p. 34). A pivot table also makes it easy to cross-tabulate data.
Through MS Excel, a manager is also able to work with a large amount of data. Data in different MS Excel sheets or workbooks can be linked and used to discern relationships. Therefore, the manager is not limited to the amount of data to work on.
Examples of in which research results would be communicated to other members of the company, and explanation of how the research would be communicated as well as technology that would be used to demonstrate the results and analysis.
Examples in which research results would be communicated to other members of the company include communicating employees’ productivity or performance to the board, reporting market status and trends to marketing executives, and announcing the company’s stock status to shareholders.
The research would be communicated through summarized and diagrammatic formats such as graphs and charts, and tables. For instance, market status and trends information would require the use of graphs to show patterns. Comparison graphs could also be used to show the status of the company in the market. Also, a summary of stock data in terms of averages, totals, mode, and frequencies could be useful to communicate stock information. Short descriptions could also be used to communicate the research results
MS PowerPoint would be used to present the results and analysis, however, these results an analysis would be demonstrated through graphs and charts, and tables. Graphs and charts such as scatter graphs, area graphs, line graphs, column charts, bar charts, and pie charts would be used in the demonstration. The table would also be used for listing information as opposed to providing long descriptions, while pivot tables would be used to provide a summary of data (Dalgleish, 2006, p.5).
The potential legal and ethical issues that could arise if the information gained in this survey was used to create an ideal profile of characteristics that the company looked for when hiring employees.
Several potential legal and ethical issues could arise out of using the survey information in creating profile characteristics. One potential legal and the ethical issue would involve not informing the employees of the real purpose of the survey. It is ethical to inform a respondent of the purpose of a survey in which he or she is providing data. In other words, a respondent should know how the data he or she has provided should be used. It is also would raise ethical and sometimes legal issues if a company used information that was provided free in a commercial setup.
Anderson, D.R., Sweeney, D. J., & Williams, T. A. (2008). Essentials of modern business statistics. Florida: Cengage Learning.
Dalgleish, D. (2006). Excel pivot tables recipe book: a problem-solution approach. New jersy: Apress.
Gupta, V. (2005). Comdex hardware and networking course kit. New York: Dreamtech Press.