A Novel Approach of Quantitative Data Analysis using Microsoft Excel

Authors(2) :-Boggu Anil Kumar, V Rahamathulla

The point of this short guide is to give a prologue to utilizing Microsoft Excel (in the future: Excel) for quantitative data analysis inside the setting of a business and administration inquire about project. It covers a portion of the key highlights of Excel that are especially helpful while completing an examination project. The guide isn't composed for a particular variant of Excel in spite of the fact that it incorporates screen captures for Excel 2010. The greater part of the usefulness alluded to in the guide is additionally accessible in prior and later forms, in spite of the fact that the UI has changed to some degree. The guide accept that you are as of now acquainted with the nuts and bolts of utilizing Excel (e.g. step by step instructions to make worksheets, enter information, utilize formulae and functions, make outlines (charts), print and work, and so on.). On the off chance that you have never utilized Excel, there are some sensibly evaluated course readings to kick you off. Then again, you may find that Excel preparing or bolster material is accessible in your establishment.

Authors and Affiliations

Boggu Anil Kumar
Department of MCA Sree Vidyanikethan Institute of Management, Sri Venkateswara University, Tirupati, Andhra Pradesh, India
V Rahamathulla
Assistant Professor, Department of MCA, Sree Vidyanikethan Institute of Management, A.Rangampeta, Tirupati, Andhra Pradesh, India

Excel, Data Analysis, Pivot tables, spreadsheet.

  1. Benjamin Jr, William E (2011) The Little Engine That Could: Using LIBNAME Engine Options to Enhance Data Transfers Between SAS and Microsoft Excel Files. Proceedings of SAS Global Forum 2011. 076- 2011.
  2. Vyverman, Koen (2002) Creating Custom Excel Workbooks from Base SAS with Dynamic Data Exchange: A Complete Walkthrough. Proceedings of the Twenty-Seventh Annual SAS Users Group International Conference. 190-27
  3. Choate, P. and Martell, C. (2006), De-mystifying the SAS LIBNAME engine in Microsoft Excel: A practical guide, Proceedings of the Thirty-First SAS Users Group International Conference, paper 024-31.
  4. Haworth, L., Zender, C. and Burlew, M. (2009), Output Delivery System (ODS): The Basics and Beyond, SAS Institute, Inc., Cary, NC.
  5. Roper, C. A. (2000), Intelligently launching Microsoft Excel from SAS, using SCL functions ported to Base SAS, Proceedings of the Twenty-Fifth SAS Users Group International Conference, paper 97-25.
  6. Vyverman, K. (2000), Using Dynamic Data Exchange to pour SAS data into Microsoft Excel, Proceedings of the Eighteenth SAS European Users Group International Conference.
  7. Gebhart, E. (2006), The beginner’s guide to ODS MARKUP: Don’t panic!, Proceedings of the Thirty-First SAS Users Group International Conference, paper 263-31.
  8. Gebhart, E. (2007a), ODS and Office integration, Proceedings of the 2007 SAS Global Forum, paper 227-2007.
  9. DelGobbo, V. (2007), Creating multi-sheet Excel workbooks the easy way with SAS, Proceedings of the 2007 SAS Global Forum, paper 229-2007
  10. Gebhart, E. (2008), The devil is in the details: Styles, tips, and tricks that make your Microsoft Excel output look great!, Proceedings of the 2008 SAS Global Forum, paper 036-2008.
  11. DelGobbo, V. (2006), Creating and importing multi-sheet Excel workbooks the easy way with SAS, Proceedings of the Thirty-First SAS Users Group International Conference, paper 115-31.
  12. Gebhart, E. (2007b), ODS Markup, tagsets, and styles! Taming ODS styles and tagsets, Proceedings of the 2007 SAS Global Forum, paper 225-2007
  13. DelGobbo, V. (2008), Tips and tricks for creating multi-sheet Microsoft Excel workbooks the easy way with SAS, Proceedings of the 2008 SAS Global Forum, paper 192-2008.
  14. Watts, P. (2004), Highlighting inconsistent record entries in Excel: Possible with SAS ODS, optimized in Microsoft DDE, Proceedings of the Seventeenth Northeast SAS Users Group Conference.
  15. DelGobbo, V. (2009), More tips and tricks for creating multi-sheet Microsoft Excel workbooks the easy way with SAS, Proceedings of the 2009 SAS Global Forum, paper 152-2009

Publication Details

Published in : Volume 3 | Issue 4 | March-April 2018
Date of Publication : 2018-04-30
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 13-18
Manuscript Number : CSEIT1833122
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

Boggu Anil Kumar, V Rahamathulla, "A Novel Approach of Quantitative Data Analysis using Microsoft Excel", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 3, Issue 4, pp.13-18, March-April.2018
URL : http://ijsrcseit.com/CSEIT1833122

Follow Us

Contact Us