CH 1 – Mean & Median (Three X & Y’s)
Essentials of Modern Business Statistics with Microsoft® Excel®
Anderson, Sweeney, Williams, Camm, and Cochran
07th Edition
Given three x and y’s… find the mean and median.
Given three x and y’s… find the mean and median.
Develop a predictive model to assist marketing efforts by examining the relationship between home values and landscaping expenditures using data provided in the file Landscape. What does the scatter plot suggest about the relationship between the variables? Calculate the estimated regression equation using the least squares method and use it to predict landscaping expenditures for homes of varying values.
Given the relative frequency and total return for four stocks… find the weighted average total return.
Given three x and y’s … find the sample variance and sample standard deviations
Given the probability individual purchasing product, the probability individual recalls seeing the advertisement, and the probability of both… find the probability B or S, purchase given recall seeing.
Given you flip coin 5 times… how many ways to get heads.
Given the group of people… find out how many ways to pick a president, secretary, and treasurer.
Given the percent of arrivals that are Southwest and US Airways and the percent on-time… find the probability a Southwest flight will arrive on time.
Given the percent of autos covered by insurance… solve the probability questions asking for an expected number, variance, probability of all, etc.
Given how long a carryout order takes and the exponential distribution… find the probability the carryout order will be ready in the time asked for.