Skip to main content

Math Statistics EBK BUSINESS ANALYTICS

To create a Pivot table to find the mean and standard deviation of the amount of travel expenses for each sales representative.

To create a Pivot table to find the mean and standard deviation of the amount of travel expenses for each sales representative.

Solution Summary: The author explains how to create a Pivot table to find the mean and standard deviation of the amount of travel expenses for each sales representative.

EBK BUSINESS ANALYTICS

EBK BUSINESS ANALYTICS

3rd Edition

ISBN: 9780136880844

Author: Evans

Publisher: PEARSON

See similar textbooks

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…

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…

Videos

Question

Definition Definition Measure of central tendency that is the average of a given data set. The mean value is evaluated as the quotient of the sum of all observations by the sample size. The mean, in contrast to a median, is affected by extreme values. Very large or very small values can distract the mean from the center of the data. Arithmetic mean: The most common type of mean is the arithmetic mean. It is evaluated using the formula: μ = 1 N ∑ i = 1 N x i Other types of means are the geometric mean, logarithmic mean, and harmonic mean. Geometric mean: The nth root of the product of n observations from a data set is defined as the geometric mean of the set: G = x 1 x 2 ... x n n Logarithmic mean: The difference of the natural logarithms of the two numbers, divided by the difference between the numbers is the logarithmic mean of the two numbers. The logarithmic mean is used particularly in heat transfer and mass transfer. ln x 2 − ln x 1 x 2 − x 1 Harmonic mean: The inverse of the arithmetic mean of the inverses of all the numbers in a data set is the harmonic mean of the data. 1 1 x 1 + 1 x 2 + ...

Chapter 4, Problem 50PE

To determine

To create a Pivot table to find the mean and standard deviation of the amount of travel expenses for each sales representative.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

Blurred answer

Chapter 4, Problem 49PE

Chapter 4, Problem 51PE

Students have asked these similar questions

answer plz

Income taxes?

how much is the fiems total equity?

Chapter 4 Solutions

EBK BUSINESS ANALYTICS

Ch. 4 - Prob. 1PE Ch. 4 - Classify each of the data elements in the Sales...Ch. 4 - Identify each of the variables in the Excel file...Ch. 4 - Classify each of the variables in the Excel file...Ch. 4 - Use the COUNTIF function to construct a frequency...Ch. 4 - A community health status survey obtained the...Ch. 4 - Construct frequency distributions and histograms...Ch. 4 - Use the Histogram tool to develop a frequency...Ch. 4 - Prob. 12PE Ch. 4 - Use a PivotTable to construct a frequency...

Ch. 4 - Prob. 14PE Ch. 4 - Find the 20thand80th percentiles of home prices in...Ch. 4 - Find the 10thand90th percentiles and the first and...Ch. 4 - Prob. 18PE Ch. 4 - Find the first, second, and third quartiles for...Ch. 4 - Prob. 20PE Ch. 4 - Prob. 21PE Ch. 4 - Find the mean, median, and midrange for the data...Ch. 4 - In the Excel file Facebook Survey, find the mean,...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 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Compute the coefficient of variation for each...Ch. 4 - Find 30 days of stock prices for three companies...Ch. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 39PE Ch. 4 - Prob. 42PE Ch. 4 - Prob. 43PE Ch. 4 - Prob. 44PE Ch. 4 - Prob. 45PE Ch. 4 - In the Excel file Bicycle Inventory, find the...Ch. 4 - Prob. 48PE Ch. 4 - Prob. 49PE Ch. 4 - Prob. 50PE Ch. 4 - Prob. 51PE Ch. 4 - Prob. 52PE Ch. 4 - Prob. 55PE Ch. 4 - Prob. 56PE Ch. 4 - Prob. 57PE Ch. 4 - Prob. 58PE Ch. 4 - Prob. 59PE Ch. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 61PE Ch. 4 - Prob. 62PE Ch. 4 - For the Presidents Inn Guest Database, find the...Ch. 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. 67PE Ch. 4 - Prob. 68PE Ch. 4 - Prob. 70PE Ch. 4 - Prob. 71PE Ch. 4 - Prob. 73PE Ch. 4 - Prob. 74PE Ch. 4 - Prob. 75PE

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.

Similar questions

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Foundations of Business - Standalone book (MindTa...
Marketing
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning

Text book image

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

Text book image

Contemporary Marketing

Marketing

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Cengage Learning

Text book image

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

Text book image

Marketing

ISBN:9780357033753

Author:Pride

Publisher:CENGAGE L

Text book image

Foundations of Business (MindTap Course List)

Marketing

ISBN:9781337386920

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

Text book image

Foundations of Business - Standalone book (MindTa...

Marketing

ISBN:9781285193946

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

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