A Novel Approach of Quantitative Data Analysis using Microsoft Excel
Keywords:
Excel, Data Analysis, Pivot tables, spreadsheet.Abstract
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.
References
- 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.
- 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
- 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.
- Haworth, L., Zender, C. and Burlew, M. (2009), Output Delivery System (ODS): The Basics and Beyond, SAS Institute, Inc., Cary, NC.
- 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.
- Vyverman, K. (2000), Using Dynamic Data Exchange to pour SAS data into Microsoft Excel, Proceedings of the Eighteenth SAS European Users Group International Conference.
- 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.
- Gebhart, E. (2007a), ODS and Office integration, Proceedings of the 2007 SAS Global Forum, paper 227-2007.
- DelGobbo, V. (2007), Creating multi-sheet Excel workbooks the easy way with SAS, Proceedings of the 2007 SAS Global Forum, paper 229-2007
- 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.
- 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.
- Gebhart, E. (2007b), ODS Markup, tagsets, and styles! Taming ODS styles and tagsets, Proceedings of the 2007 SAS Global Forum, paper 225-2007
- 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.
- 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.
- 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
Downloads
Published
Issue
Section
License
Copyright (c) IJSRCSEIT
This work is licensed under a Creative Commons Attribution 4.0 International License.