Taking a thematic approach to the use of Excel spreadsheets in introductory business data analysis, this text has been designed to explain the overall nature of what is to be achieved and also instruction in how it is to be done. The learning approach is highly interactive and enables students to develop an understanding of the power of Excel in allowing both analysis of business data sets and in the flexible preparation of graphs, charts and tables for inclusion in reports and essays. The text is supported by an online resource center with self-marking exercises that can be used by instructors for formative and summative assessment, and a series of PowerPoint files containing all of the illustrated worksheets and figures. Features:
Uses software that students are already familiar with to develop quantitative knowledge of Business and Management.Interactive text linked to tasks which are usable within a Virtual Learning Environment.Real data sets and illustrative examples focused on the business environment show how data analysis is applied to the real world.
Content:
Front Matter
• Guide to the Online Resource Center
• Preface
• Table of Contents
1. Introduction to Excel
2. Understanding Data
3. Data Handling
4. Charting Data
5. Elementary Modelling
6. Elementary Modelling
7. Collating and Categorizing Data
8. Data Description - Central Tendency
9. Data Description - Dispersion
10. Data Description - Further Methods
11. Data Description - Association
12. Regression Analysis
13. Financial Arithmetic
14. Investment Appraisal
Index