Student resources
Excel supplement
The Excel supplement is a tutorial for Microsoft Excel. It was written by Bernard V Liengme specially as a supplement to Quantitative Approaches in Business Studies by Clare Morris.
The table below explains how the units of the tutorial link to the chapters of Quantitative Approaches in Business Studies. The student is advised to read the first two units carefully. The other units may be read in any order.
The units are in Adobe Acrobat format (PDF). The Adobe Acrobat Reader is available FREE from Adobe Systems Incorporated. The workbooks named below are in Excel 97/2000 format. Right-click on any file and choose Save As to save the file to your hard disk.
Tutorial Units Quantitative Approaches in Business Studies Chapters 1 Getting Started with Microsoft Excel 2 Spreadsheets and other computer-based resources 2 Formulas and Functions 2 Spreadsheets and other computer-based resources 3 Solving Equations 1 Tools of the Trade
19 Linear Programming 4 Creating Charts 5 Presenting the Figures 5 Regression Analysis 13 Looking for Connections
14 Spotting the Relationship
15 Multiple Regression 6 Financial Calculations 18 Allowing for Interest 7 Descriptive Statistics
Workbook: STATISTICS16 Summarising the Figures 8 Statistical Distributions
Workbooks: PROBABILITY, NORMALDISTA, NORMALDISTB & NORMALDISTC9 Patterns of Probability 9 Hypothesis Testing
Workbooks: HYPOTHESIS and CHISQUARED10 Estimating from Samples
11 Checking a Theory
Every effort has been made to be accurate but if you believe you have found an error please let the author of the supplement, Bernard Liengme, know. As stated above, the workbooks are in Excel 97/2000 format; files in Excel 5/95 format are available from the author upon request. The author will be pleased to answer questions on Excel but please make them clear and specific.
| Legal and Privacy Terms |
No comments:
Post a Comment