IDEAS home Printed from https://ideas.repec.org/a/eee/jbrese/v63y2010i2p191-206.html
   My bibliography  Save this article

Utilizing and teaching data tools in Excel for exploratory analysis

Author

Listed:
  • Palocsay, Susan W.
  • Markham, Ina S.
  • Markham, Steven E.

Abstract

In this article we offer Excel as an introductory tool to high end business intelligence (BI) and decision support system (DSS) applications. Because it is ubiquitous, Excel can be used by all managers and business students for exploratory data analysis. We provide three key points in this utilization of Microsoft® Excel 2003: (1) manipulating records using Excel as a database, (2) creating PivotTables® and PivotCharts® using Excel for analysis, and (3) importing data using Excel as an automation container. The basic skill set defined by the above three items allows users to begin to use Excel to its full potential in finding information in business data, and it offers a key tool for future research in improving the utilization of information across organizations.

Suggested Citation

  • Palocsay, Susan W. & Markham, Ina S. & Markham, Steven E., 2010. "Utilizing and teaching data tools in Excel for exploratory analysis," Journal of Business Research, Elsevier, vol. 63(2), pages 191-206, February.
    • Handle: RePEc:eee:jbrese:v:63:y:2010:i:2:p:191-206
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0148-2963(09)00064-2
    Download Restriction: Full text for ScienceDirect subscribers only
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Cliff T. Ragsdale, 2001. "Teaching Management Science with Spreadsheets: From Decision Models to Decision Support," INFORMS Transactions on Education, INFORMS, vol. 1(2), pages 68-74, January.
    2. Rau, Devaki, 2006. "Top management team transactive memory, information gathering, and perceptual accuracy," Journal of Business Research, Elsevier, vol. 59(4), pages 416-424, April.
    3. Tihanyi, Laszlo & Thomas, Wayne B., 2005. "Information-processing demands and the multinational enterprise: a comparison of foreign and domestic earnings estimates," Journal of Business Research, Elsevier, vol. 58(3), pages 285-292, March.
    4. Koschat, Martin A., 2005. "A Case for Simple Tables," The American Statistician, American Statistical Association, vol. 59, pages 31-40, February.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Abhijit Sharma, 2015. "Use of Bloomberg Professional in support of finance and economics teaching," Cogent Economics & Finance, Taylor & Francis Journals, vol. 3(1), pages 1115618-111, December.
    2. Roxana POPA STRAINU & Mircea GEORGESCU, 2015. "Support Management Decisions In Small And Medium Companies," Review of Economic and Business Studies, Alexandru Ioan Cuza University, Faculty of Economics and Business Administration, issue 16, pages 167-181, December.
    3. Néstor Rodríguez-Padial & Marta Marín & Rosario Domingo, 2017. "An Approach to Integrating Tactical Decision-Making in Industrial Maintenance Balance Scorecards Using Principal Components Analysis and Machine Learning," Complexity, Hindawi, vol. 2017, pages 1-15, October.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Mauri, Alfredo J. & Lin, Jing & Neiva De Figueiredo, João, 2013. "The influence of strategic patterns of internationalization on the accuracy and bias of earnings forecasts by financial analysts," International Business Review, Elsevier, vol. 22(4), pages 725-735.
    2. Ole‐Kristian Hope & Wayne B. Thomas, 2008. "Managerial Empire Building and Firm Disclosure," Journal of Accounting Research, Wiley Blackwell, vol. 46(3), pages 591-626, June.
    3. Baik, Kibok & Kim, Kyoung Yong & Patel, Pankaj C., 2019. "The internal ecosystem of high performance work system and employee service-providing capability: A contingency approach for servitizing firms," Journal of Business Research, Elsevier, vol. 104(C), pages 402-410.
    4. Christoph Markmann & Alexander Spickermann & Heiko A. von der Gracht & Alexander Brem, 2021. "Improving the question formulation in Delphi‐like surveys: Analysis of the effects of abstract language and amount of information on response behavior," Futures & Foresight Science, John Wiley & Sons, vol. 3(1), March.
    5. Ciaran Heavey & Zeki Simsek, 2015. "Transactive Memory Systems and Firm Performance: An Upper Echelons Perspective," Organization Science, INFORMS, vol. 26(4), pages 941-959, August.
    6. Hsu, Wen-Tsung & Chen, Hsiang-Lan & Cheng, Chia-Yi, 2013. "Internationalization and firm performance of SMEs: The moderating effects of CEO attributes," Journal of World Business, Elsevier, vol. 48(1), pages 1-12.
    7. John F. Wellington & Stephen A. Lewis, 2021. "Getting Beyond the First Result of Solving a Vehicle Routing Problem," INFORMS Transactions on Education, INFORMS, vol. 22(1), pages 9-27, September.
    8. Matolcsy, Zoltan & Wakefield, James, 2017. "Multinational headquarter control of wholly owned foreign subsidiaries," The British Accounting Review, Elsevier, vol. 49(3), pages 275-293.
    9. Aydınlı, Gökhan & Härdle, Wolfgang Karl & Neuwirth, E., 2003. "Computational Statistics with Spreadsheets Towards Efficiency, Reproducibility and Security," SFB 373 Discussion Papers 2003,26, Humboldt University of Berlin, Interdisciplinary Research Project 373: Quantification and Simulation of Economic Processes.
    10. Chiang, Yun-Hwa & Shih, Hsi-An & Hsu, Chu-Chun, 2014. "High commitment work system, transactive memory system, and new product performance," Journal of Business Research, Elsevier, vol. 67(4), pages 631-640.
    11. Winkler, Jens & Kuklinski, Christian Paul Jian-Wei & Moser, Roger, 2015. "Decision making in emerging markets: The Delphi approach's contribution to coping with uncertainty and equivocality," Journal of Business Research, Elsevier, vol. 68(5), pages 1118-1126.
    12. Li, Wanli & Lai, Yin & Wang, Chaohui & Tan, Bowen, 2022. "How do emerging debt market participants recognize firm internationalization?Evidence from effects on credit ratings," Emerging Markets Review, Elsevier, vol. 53(C).
    13. Jocelyn D. Pallauta & Pedro Arteaga & José A. Garzón-Guerrero, 2021. "Secondary School Students’ Construction and Interpretation of Statistical Tables," Mathematics, MDPI, vol. 9(24), pages 1-17, December.
    14. Liao, Jenny & O'Brien, Anne T. & Jimmieson, Nerina L. & Restubog, Simon Lloyd D., 2015. "Predicting transactive memory system in multidisciplinary teams: The interplay between team and professional identities," Journal of Business Research, Elsevier, vol. 68(5), pages 965-977.
    15. Luo, Xueming & Zheng, Qinqin, 2018. "How firm internationalization is recognized by outsiders: The response of financial analysts," Journal of Business Research, Elsevier, vol. 90(C), pages 87-106.
    16. Patrick Regnér & Udo Zander, 2011. "Knowledge and Strategy Creation in Multinational Companies," Management International Review, Springer, vol. 51(6), pages 821-850, December.
    17. Rebecca Piekkari & Phillip C. Nell & Pervez N. Ghauri, 2010. "Regional Management as a System," Management International Review, Springer, vol. 50(4), pages 513-532, August.
    18. Wein-Hong Chen & Yi-Yuan Liu, 2021. "Configurations of home-country experience, leapfrog strategy, and management team composition for acceleration of international expansion: Evidence from Asian multinational enterprises," Asia Pacific Journal of Management, Springer, vol. 38(2), pages 709-733, June.
    19. Efendi, Jap & Park, Jin Dong & Smith, L. Murphy, 2014. "Do XBRL filings enhance informational efficiency? Early evidence from post-earnings announcement drift," Journal of Business Research, Elsevier, vol. 67(6), pages 1099-1105.
    20. Feng, Cong & Patel, Pankaj C. & Sivakumar, K., 2020. "Chief global officers, geographical sales dispersion, and firm performance," Journal of Business Research, Elsevier, vol. 121(C), pages 58-72.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:jbrese:v:63:y:2010:i:2:p:191-206. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/jbusres .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.