Business Data Analysis Using Excel
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 centre 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.
What people are saying - Write a review
We haven't found any reviews in the usual places.
1 Introduction to Excel
2 Understanding data
3 Data handling
4 Charting data
5 Elementary modelling 1
6 Elementary modelling 2
7 Collating and categorizing data
8 Data descriptioncentral tendency
A1 cell advertising expenditure amount annual compound annuity annum argument arithmetic mean attempt Exercise average axis calculated chart class intervals Clearly coefficient of variation column compounded annually compounding periods compute confirm Consequently contain copy correlation coefficient cost current file data range data set debt decimal places defined deposit Descriptive Statistics discount rate entry equal annual example Excel filtered formula frequency distribution future value graph gross income illustration indicated interest is compounded interest rate linear Load lookup measure median Menu bar mouse Notice number of observations number of occupants obtained online resource centre options percentage Pivot Table present value quartile raw data regression repayments results should resemble shown in Workbook Solution sheet Solution to Exercise squared deviations standard deviation statistics suppose syntax Table taxable income terminal value total number variable variance VLOOKUP function worksheet zero