Modern Business Statistics with Microsoft Excel® | 6th Edition. David R. Anderson/Dennis J. Sweeney/Thomas A. Williams/Jeffrey D. Camm/James J. Cochran. Download Essentials of Health Behavior Includes eBook Access Ebook PDF Download Modern Business Statistics with Microsoft Office Excel w Ebook PDF. Download Full PDF => caite.info Title: Essentials of Modern Business Statistics with Microsoft Excel Author: David R.

Author: | FREDDIE BRODER |

Language: | English, Spanish, Indonesian |

Country: | Belize |

Genre: | Biography |

Pages: | 442 |

Published (Last): | 15.11.2015 |

ISBN: | 420-4-21411-971-6 |

ePub File Size: | 27.86 MB |

PDF File Size: | 18.53 MB |

Distribution: | Free* [*Regsitration Required] |

Downloads: | 43989 |

Uploaded by: | THERSA |

Full file at caite.info -5th-Edition-Anderson-Solutions-Manual Chapter 2 Descriptive Statistics. Full file at caite.info Microsoft-Excel-6th-Edition-Anderson-Solutions-Manual Chapter 2 Descriptive. Essentials of Modern Business Statistics with Microsoft® Excel, 3e David R. Anderson, Dennis J. Sweeney, Thomas A. Williams VP/Editorial Director: Jack W.

These data are categorical. Learn how to construct and interpret cross tabulations, scatter diagrams, side-by-side and stacked bar charts. The combined or aggregated two-year crosstabulation is as follows: Combined 2-Year Batting Outcome A. McDonald's, Subway and 7-Eleven have the highest number of locations.

Full file at https: Tabular and Graphical Displays Learning Objectives 1. Learn how to construct and interpret summarization procedures for qualitative data such as: Learn how to construct and interpret tabular summarization procedures for quantitative data such as: Learn how to construct a dot plot and a histogram as graphical summaries of quantitative data.

Learn how the shape of a data distribution is revealed by a histogram. Learn how to recognize when a data distribution is negatively skewed, symmetric, and positively skewed. Be able to use and interpret the exploratory data analysis technique of a stem-and-leaf display.

Learn how to construct and interpret cross tabulations, scatter diagrams, side-by-side and stacked bar charts. Learn best practices for creating effective graphical displays and for choosing the appropriate type of display. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Class Frequency Percent Frequency A. No Opinion Tabular and Graphical Displays d. These data are categorical. The largest viewing audience is for Wheel of Fortune and the second largest is for Two and a Half Men. Common U.

Tabular and Graphical Displays c. This does not look to be a Delta flight where significant changes are needed to improve the overall customer satisfaction ratings.

It might be insightful for the manager to review explanations from these customers as to how the flight failed to meet expectations. Perhaps, it was an experience with other passengers that Delta could do little to correct or perhaps it was an isolated incident that Delta could take steps to correct in the future. Position Frequency Relative Frequency Pitcher 17 0. Infielders 16 or Where do you live now? Percent changes by living area: Suburb living is steady, but the trend would be that living in the city would decline while living in small towns and rural areas would increase.

Tabular and Graphical Displays e. Compared to ratings of other hotels in the same region, both of these hotels received very favorable ratings. Class Frequency Percent Frequency 6. Tabular and Graphical Displays Waiting Time Frequency Relative Frequency 0—4 4 0. Relative PPG Frequency 0. There is skewness to the right. The largest number of tons is The smallest number of tons is Histogram for 25 Busiest U.

S Ports 12 10 8 Frequency 6 4 2 0 Only five of the 25 ports handle above 75 million tons. Percent Locations Frequency Frequency 10 50 3 15 2 10 1 5 0 0 1 5 2 10 1 5 Total: Tabular and Graphical Displays b. Locations c. The distribution is skewed to the right. McDonald's, Subway and 7-Eleven have the highest number of locations. A class size of 10 results in 10 classes.

A variety of comparisons are possible depending upon when the study is done. Also, note that the top pay has more variability than the median pay. The histogram is skewed to the right. Rotating the stem-and-leaf display counterclockwise onto its side provides a picture of the data that is similar to the histogram in shown in part a.

Although the stem-and-leaf display may appear to offer the same information as a histogram, it has two primary advantages: Most frequent age group: Category A values for x are always associated with category 1 values for y. Category B values for x are usually associated with category 1 values for y. Category C values for x are usually associated with category 2 values for y. Higher values of x are associated with lower values of y and vice versa Average Miles per Hour Make It appears that most of the faster average winning times occur before This could be due to new regulations that take into account driver safety, fan safety, the environmental impact, and fuel consumption during races.

The crosstabulation of condition of the greens by gender is below. So, for the low handicappers, the men show a higher percentage who think the greens are too fast. So, for the higher handicap golfers, the men show a higher percentage who think the greens are too fast. This is an example of Simpson's Paradox. At each handicap level a smaller percentage of the women think the greens are too fast.

But, when the crosstabulations are aggregated, the result is reversed and we find a higher percentage of women who think the greens are too fast. The hidden variable explaining the reversal is handicap level. Fewer people with low handicaps think the greens are too fast, and there are more men with low handicaps than women.

Row percentages are shown below. For example, the percent frequency distribution of the West region is as follows: Northeast Tabular and Graphical Displays Midwest Column percentages are shown below.

Percent Region Frequency Northeast The right margin shows the frequency distribution for the fund type variable and the bottom margin shows the frequency distribution for the brand value.

Higher brand values are associated with the technology brands. The technology brands had the greatest variability.

It might be insightful for the manager to review explanations from these customers as to how the flight failed to meet expectations. Perhaps, it was an experience with other passengers that Delta could do little to correct or perhaps it was an isolated incident that Delta could take steps to correct in the future.

Position Frequency Relative Frequency Pitcher 17 0. Infielders 16 or Where do you live now? Percent changes by living area: Suburb living is steady, but the trend would be that living in the city would decline while living in small towns and rural areas would increase. Tabular and Graphical Displays e. Compared to ratings of other hotels in the same region, both of these hotels received very favorable ratings. Class Frequency Percent Frequency 6. Tabular and Graphical Displays Waiting Time Frequency Relative Frequency 0—4 4 0.

Relative PPG Frequency 0. There is skewness to the right. A class size of 10 results in 10 classes. A variety of comparisons are possible depending upon when the study is done. Percent Locations Frequency Frequency 10 50 3 15 2 10 1 5 0 0 1 5 2 10 1 5 Total: Tabular and Graphical Displays b.

Locations c.

The distribution is skewed to the right. McDonald's, Subway and 7-Eleven have the highest number of locations. The majority of the computer users are in the 3 to 6 hour range.

Usage is somewhat skewed toward the right with 3 users in the 12 to Also, note that the top pay has more variability than the median pay. Most frequent age group: Category A values for x are always associated with category 1 values for y. Category B values for x are usually associated with category 1 values for y. Category C values for x are usually associated with category 2 values for y.

Higher values of x are associated with lower values of y and vice versa Row Percentages: Graduate The first five give the percent frequency distribution of income for each educational level.

The total row provides an overall percent frequency distribution for household income. The second row, labeled H. Graduate, is the percent frequency distribution for households headed by high school graduates.

The fourth row, labeled Bachelor's Degree, is the percent frequency distribution for households headed by bachelor's degree recipients. The percent frequency histogram for high school graduates.

Yes, there is a positive relationship between education level and income. Column Percentages: The first five columns give the percent frequency distributions for each income level.

The percent frequency distribution in the "Total" column gives the overall percent frequency distributions for educational level. From that percent frequency distribution we see that The column percentages show that The row percentages show that These percentages are different because they came from different percent frequency distributions and provide different kinds of information. Compare the "under 25" percent frequency distributions to the "Total" percent frequency distributions.

We see that for this low income level the percentage with lower levels of education is higher than for the overall population and the percentage with higher levels of education is lower than for the overall population. Tabular and Graphical Displays Compare the " or more" percent frequency distribution to "Total" percent frequency distribution.

We see that for this high income level the percentage with lower levels of education is lower than for the overall population and the percentage with higher levels of education is higher than for the overall population. From the comparisons it is clear that there is a positive relationship between household incomes and the education level of the head of the household.

The crosstabulation of condition of the greens by gender is below. So, for the low handicappers, the men show a higher percentage who think the greens are too fast. So, for the higher handicap golfers, the men show a higher percentage who think the greens are too fast. This is an example of Simpson's Paradox. At each handicap level a smaller percentage of the women think the greens are too fast.

But, when the crosstabulations are aggregated, the result is reversed and we find a higher percentage of women who think the greens are too fast. The hidden variable explaining the reversal is handicap level. Fewer people with low handicaps think the greens are too fast, and there are more men with low handicaps than women. Fund Type The right margin shows the frequency distribution for the fund type variable and the bottom margin shows the frequency distribution for the 5 year average return variable.

Higher returns are associated with International Equity funds and lower returns are associated with Fixed Income funds. Higher expense ratios are associated with Domestic Equity funds and lower expense ratios are associated with Fixed Income fund There is some indication that higher 5-year returns are associated with higher net asset values.

Midsize and Compact seem to be more fuel efficient than Large. Higher fuel efficiencies are associated with front wheel drive cars.

Higher fuel efficiencies are associated with cars that use regular gas.

There is a negative relationship between x and y; y decreases as x increases. For midsized cars, lower driving speeds seem to yield higher miles per gallon.

Snowfall inches 80 60 40 20 0 30 40 50 60 70 80 Avg. Low Temp b. Colder average low temperature seems to lead to higher amounts of snowfall.

Two cities have an average snowfall of nearly inches of snowfall: Buffalo, N. Y and Rochester, NY. Both are located near large lakes in New York. The percentage of people with hypertension increases with age.

For ages earlier than 65, the percentage of males with hypertension is higher than that for females. After age 65, the percentage of females with hypertension is higher than that for males. After an increase in age , smartphone ownership decreases as age increases. The percentage of people with no cell phone increases with age.