Business Statistics Using LOTUS 1-2-3The use of quantitative information in decision making has contributed to the success of businesses in every industry. The proliferation of microcomputers and software tools, such as Lotus 1-2-3, has significantly increased our analytical capabilities. This book treats a wide range of information and tools that provide business professionals with an opportunity and a challenge to increase productivity and effectiveness through quantitative methods. Provides key statistical concepts, including correlation, regression, forecasting, and sampling, for performing business analyses using the powerful (and very popular) Lotus 1-2-3 computer program. The clear exposition makes statistical processes understandable to, and useable by, the non-technical manager. |
Contents
Measures of Central Tendency | 44 |
Measures of Dispersion | 68 |
Random Variables and Probability Distributions | 101 |
Copyright | |
8 other sections not shown
Common terms and phrases
accept the null alternate hypothesis analysis of variance appropriate value average binomial distribution table calculate Chapter Chi-Square Distribution column command confidence interval confidence level confidence limit correlation coefficient COUNT criterion range cross-tab curve customers data points DCOUNT function defects per box degrees of freedom delinquent accounts difference equal example F distribution Formula frequency table infer inferential statistics instance Lotus 1-2-3 database lower limit macro minus normal distribution table null hypothesis number of data number of defects number of orders number of successes number of trials offset outcomes percentage of delinquent population mean population standard deviation population variance probability distribution random sample random variable READY Figure reject the null result sample data sample mean sample size sample standard deviation sample variance service call shown in Figure shows standard normal distribution supplier techniques test statistic TESTING TWO MEANS tion total number two-tailed test VLOOKUP function WILCOXON SIGNED-RANK TEST worksheet