Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well with raw data and to make appropriate inferences. Although some statistical techniques for analyzing data and making inferences are sophisticated and require specialized expertise, there are methods that are understandable and applicable by anyone with basic algebra skills and the support of a spreadsheet package. By applying these fundamental methods themselves rather than turning over both the data and the responsibility for analysis and interpretation to an expert, managers will develop a richer understanding and potentially gain better control over their environment. This text is intended to describe these fundamental statistical techniques to managers, data analysts, and students. Statistical analysis of sample data is enhanced by the use of computers. Spreadsheet software is well suited for the methods discussed in this text. Examples in the text apply Microsoft Excel. Readers will have access to the example workbooks and Adobe Flash videos illustrating key steps using Microsoft Excel from the Business Expert Press website.
Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well in the electronic environment with raw data. Although some statistical and financial techniques for analyzing data are sophisticated and require specialized expertise, there are methods that are understandable and applicable by anyone with basic algebra skills and the support of a spreadsheet package. And this book brings these understandable tools to light. This book gives you real insight: • To refresh fundamental mathematical operations that broadly support statistical and financial equations and formulas • To perform business analysis in Excel spreadsheets • To facilitate graphic representations of data • To create mathematical models in spreadsheets
Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well with raw data and to make appropriate inferences. Although some statistical techniques for analyzing data and making inferences are sophisticated and require specialized expertise, there are methods that are understandable and applicable by anyone with basic algebra skills and the support of a spreadsheet package. By applying these fundamental methods themselves rather than turning over both the data and the responsibility for analysis and interpretation to an expert, managers will develop a richer understanding and potentially gain better control over their environment. This text is intended to describe these fundamental statistical techniques to managers, data analysts, and students. Statistical analysis of sample data is enhanced by the use of computers. Spreadsheet software is well suited for the methods discussed in this text. Examples in the text apply Microsoft Excel. Readers will have access to the example workbooks and Adobe Flash videos illustrating key steps using Microsoft Excel from the Business Expert Press website.
Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well in the electronic environment with raw data. Although some statistical and financial techniques for analyzing data are sophisticated and require specialized expertise, there are methods that are understandable and applicable by anyone with basic algebra skills and the support of a spreadsheet package. While specialized software packages may be used in a particular business setting, Microsoft Excel is routinely available on computer desktops. Managers who have been in the field any length of time may not be sufficiently familiar with the capabilities of Excel to make optimal use of its functionalities. Prior to undertaking a program to pursue executive training, managers who are refreshed with basic algebra skills and the capabilities of Excel will be prepared to develop a richer understanding from their more advanced work. The primary foci of this text are (1) to refresh fundamental mathematical operations that broadly support statistical and financial equations and formulas, (2) to introduce work with equations and formulas in Excel spreadsheets, (3) to expand statistical and financial analysis with the programmed Excel functions readily available through the 'Insert Function' toolbar button and the more advanced Data Analysis Toolkit, (4) to facilitate graphic representations of data, and finally (5) to prepare data mounted in differing file formats. This text is a companion to a series of books that addresses the analysis of sample data, time series data, managerial economics, and forecasting techniques. Together these books will equip the manager and the student with a solid understanding of applied data analysis and prepare them to apply the methods themselves.
This will help us customize your experience to showcase the most relevant content to your age group
Please select from below
Login
Not registered?
Sign up
Already registered?
Success – Your message will goes here
We'd love to hear from you!
Thank you for visiting our website. Would you like to provide feedback on how we could improve your experience?
This site does not use any third party cookies with one exception — it uses cookies from Google to deliver its services and to analyze traffic.Learn More.