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

Question

Want to see the full answer?

Answer 1

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

See solution

Students have asked these similar questions

Could you please answer this question using excel.Thanks

Questions An insurance company's cumulative incurred claims for the last 5 accident years are given in the following table: Development Year Accident Year 0 2018 1 2 3 4 245 267 274 289 292 2019 255 276 288 294 2020 265 283 292 2021 263 278 2022 271 It can be assumed that claims are fully run off after 4 years. The premiums received for each year are: Accident Year Premium 2018 306 2019 312 2020 318 2021 326 2022 330 You do not need to make any allowance for inflation. 1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method. (b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method. 2. Comment on the differences in the reserves produced by the methods in Part 1.

Calculate the correlation coefficient r, letting Row 1 represent the x-values and Row 2 the y-values. Then calculate it again, letting Row 2 represent the x-values and Row 1 the y-values. What effect does switching the variables have on r? Row 1 Row 2 13 149 25 36 41 60 62 78 S 205 122 195 173 133 197 24 Calculate the correlation coefficient r, letting Row 1 represent the x-values and Row 2 the y-values. r=0.164 (Round to three decimal places as needed.) S 24

Answer 2

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

See solution

Answer 3

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

See solution

Answer 4

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

See solution

Answer 5

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.

Answer 6

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.

Answer 7

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.

Answer 8

Expert Solution & Answer

Answer 9

Expert Solution & Answer

Answer 10

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 11

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...

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.

Concept explainers

Videos

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

Want to see the full answer?

Chapter 4 Solutions