Business Analytics
Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
bartleby

Concept explainers

Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of tw…
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency o…
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow compar…
bartleby

Videos

Question
Book Icon
Chapter 4, Problem 1.50PE
To determine

Find the mean of the amount of travel expenses for each sales representative by using PivotTable.

Find the standard deviation of the amount of travel expenses for each sales representative by using PivotTable.

Expert Solution & Answer
Check Mark

Want to see the full answer?

Check out a sample textbook solution
Blurred answer
Previous
Chapter 4, Problem 1.49PE
Next
Chapter 4, Problem 1.51PE

Chapter 4 Solutions

Business Analytics

Ch. 4 - Explain the science of statistics.Ch. 4 - What is a metric? How does it differ from a...Ch. 4 - Explain the difference between a discrete and a...Ch. 4 - Describe the four types of measurement scales and...Ch. 4 - What is a frequency distribution?Ch. 4 - Explain how to calculate a relative frequency.Ch. 4 - State how to use Excel for constructing frequency...Ch. 4 - State the features and limitations of the Excel...Ch. 4 - What does an ogive display?Ch. 4 - Prob. 2.6CYU
Ch. 4 - Prob. 3.1CYUCh. 4 - Prob. 3.2CYUCh. 4 - Prob. 3.3CYUCh. 4 - What is a cross-tabulation?Ch. 4 - Prob. 4.2CYUCh. 4 - Explain the difference between a population and a...Ch. 4 - List and explain the common measures of location...Ch. 4 - Prob. 5.3CYUCh. 4 - Prob. 5.4CYUCh. 4 - Prob. 5.5CYUCh. 4 - Prob. 5.6CYUCh. 4 - Prob. 5.7CYUCh. 4 - Prob. 5.8CYUCh. 4 - Prob. 6.1CYUCh. 4 - Use Excel to find the mean and variance for the...Ch. 4 - Prob. 7.1CYUCh. 4 - Prob. 7.2CYUCh. 4 - Prob. 8.1CYUCh. 4 - Prob. 8.2CYUCh. 4 - Prob. 9.1CYUCh. 4 - Prob. 9.2CYUCh. 4 - Prob. 9.3CYUCh. 4 - What rules are typically used to identify...Ch. 4 - Prob. 10.2CYUCh. 4 - Summarize statistical tools that are typically...Ch. 4 - Prob. 11.2CYUCh. 4 - What are the principles of statistical thinking?Ch. 4 - Prob. 12.2CYUCh. 4 - Prob. 12.3CYUCh. 4 - A survey handed out to individuals at a major...Ch. 4 - Prob. 1.2PECh. 4 - Identify each of the variables in the Excel file...Ch. 4 - Prob. 1.4PECh. 4 - Prob. 1.5PECh. 4 - Prob. 1.6PECh. 4 - Prob. 1.7PECh. 4 - Prob. 1.8PECh. 4 - Prob. 1.9PECh. 4 - Prob. 1.10PECh. 4 - Prob. 1.11PECh. 4 - Prob. 1.12PECh. 4 - Use a PivotTable to construct a frequency...Ch. 4 - Prob. 1.14PECh. 4 - Prob. 1.15PECh. 4 - Prob. 1.16PECh. 4 - Prob. 1.17PECh. 4 - Prob. 1.18PECh. 4 - Prob. 1.19PECh. 4 - Prob. 1.20PECh. 4 - Use a PivotTable to construct a cross-tabulation...Ch. 4 - Use PivotTables to construct cross-tabulations for...Ch. 4 - Prob. 1.23PECh. 4 - Prob. 1.24PECh. 4 - Prob. 1.25PECh. 4 - Compute the mean, median, midrange, and mode for...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - In the Excel file Facebook Survey, find the range,...Ch. 4 - Prob. 1.30PECh. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Prob. 1.33PECh. 4 - Prob. 1.34PECh. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 1.38PECh. 4 - The Data worksheet in the Excel file Airport...Ch. 4 - Prob. 1.40PECh. 4 - Prob. 1.41PECh. 4 - Prob. 1.42PECh. 4 - Prob. 1.43PECh. 4 - Prob. 1.44PECh. 4 - Prob. 1.45PECh. 4 - Prob. 1.46PECh. 4 - Prob. 1.47PECh. 4 - Prob. 1.48PECh. 4 - Prob. 1.49PECh. 4 - Prob. 1.50PECh. 4 - Prob. 1.51PECh. 4 - Prob. 1.52PECh. 4 - Prob. 1.53PECh. 4 - In the Excel file Debt and Retirement Savings, use...Ch. 4 - Prob. 1.55PECh. 4 - Prob. 1.56PECh. 4 - Prob. 1.57PECh. 4 - Prob. 1.58PECh. 4 - Prob. 1.59PECh. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 1.61PECh. 4 - The Excel file Beverage Sales lists a sample of...Ch. 4 - For the Presidents Inn Guest Database, find the...Ch. 4 - Prob. 1.64PECh. 4 - For the Excel file Credit Risk Data, compute the...Ch. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 1.67PECh. 4 - In the Excel file Weddings, find the mean, median,...Ch. 4 - Use the following approaches to analyze the survey...Ch. 4 - Prob. 1.70PECh. 4 - A producer of computer-aided design software for...Ch. 4 - Prob. 1.72PECh. 4 - Prob. 1.73PECh. 4 - A Midwest pharmaceutical company manufactures...Ch. 4 - Find the mean and variance of a deck of 52 cards,...Ch. 4 - Elizabeth Burke has received several questions...
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
SEE MORE TEXTBOOKS
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License