Essentials Of Statistics For Business & Economics
Essentials Of Statistics For Business & Economics
9th Edition
ISBN: 9780357045435
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
bartleby

Videos

Textbook Question
Chapter 13, Problem 2CP

COMPENSATION FOR SALES PROFESSIONALS

Suppose that a local chapter of sales professionals in the greater San Francisco area conducted a survey of its membership to study the relationship, if any, between the years of experience and salary for individuals employed in inside and outside sales positions. On the survey, respondents were asked to specify one of three levels of years of experience: low (1–10 years), medium (11–20 years), and high (21 or more years). A portion of the data obtained follow. The complete data set, consisting of 120 observations, is contained in the file named SalesSalary.

Chapter 13, Problem 2CP, CASE PROBLEM 2: COMPENSATION FOR SALES PROFESSIONALS
Suppose that a local chapter of sales

Managerial Report

  1. 1. Use descriptive statistics to summarize the data.
  2. 2. Develop a 95% confidence interval estimate of the mean annual salary for all salespersons, regardless of years of experience and type of position.
  3. 3. Develop a 95% confidence interval estimate of the mean salary for inside salespersons.
  4. 4. Develop a 95% confidence interval estimate of the mean salary for outside salespersons.
  5. 5. Use analysis of variance to test for any significant differences due to position. Use a .05 level of significance, and for now, ignore the effect of years of experience.
  6. 6. Use analysis of variance to test for any significant differences due to years of experience. Use a .05 level of significance, and for now, ignore the effect of position.
  7. 7. At the .05 level of significance test for any significant differences due to position, years of experience, and interaction.

1.

Expert Solution
Check Mark
To determine

Use descriptive statistics to summarize the data.

Explanation of Solution

Calculation:

The data represents the survey results obtained to study the relationship between the years of experience and salary for individuals employed in inside and outside sales positions. The respondents were asked to specify one of the three levels of years of experience: low, medium and high.

Descriptive statistics for the salary of individuals who employed inside sales position are shown below:

Software Procedure:

Step by step procedure to obtain the descriptive statistics using EXCEL:

  • In a new EXCEL sheet enter 20 salaries of inside sales position persons at the three experience groups (low, high, medium).
  • Go to Data > Data Analysis (in case it is not default, take the Analysis ToolPak from Excel Add Ins) > Descriptive statistics.
  • Enter Input Range as $B$1:$D$21, select Columns in Grouped By, tick on Summary statistics.
  • Click on OK.

Output using EXCEL is given as follows:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  1

Thus, the descriptive statistics for the years of experience and salary for individuals employed in inside sales positions is obtained.

Descriptive statistics for the salary of individuals who employed outside sales position are shown below:

Software Procedure:

Step by step procedure to obtain the descriptive statistics using EXCEL:

  • In a new EXCEL sheet enter 20 salaries of outside sales position persons at the three experience groups (low, high, medium).
  • Go to Data > Data Analysis (in case it is not default, take the Analysis ToolPak from Excel Add Ins) > Descriptive statistics.
  • Enter Input Range as $B$1:$D$21, select Columns in Grouped By, tick on Summary statistics.
  • Click on OK.

Output using EXCEL is given as follows:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  2

Thus, the descriptive statistics for the years of experience and salary for individuals employed in outside sales positions is obtained.

Descriptive statistics for the salary of individuals who employed inside and outside sales position are shown below:

Software Procedure:

Step by step procedure to obtain the descriptive statistics using EXCEL:

  • In a new EXCEL sheet enter 40 salaries of inside and outside sales position persons at the three experience groups (low, high, medium)..
  • Go to Data > Data Analysis (in case it is not default, take the Analysis ToolPak from Excel Add Ins) > Descriptive statistics.
  • Enter Input Range as $B$1:$D$41, select Columns in Grouped By, tick on Summary statistics.
  • Click on OK.

Output using EXCEL is given as follows:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  3

Thus, the descriptive statistics for the years of experience and salary for individuals employed in inside and outside sales positions is obtained.

Descriptive statistics for the salary of individuals who employed in all sales position are shown below:

Software Procedure:

Step by step procedure to obtain the descriptive statistics using EXCEL:

  • In a new EXCEL sheet enter all the 120 salaries in one column and label it as Total salary.
  • Go to Data > Data Analysis (in case it is not default, take the Analysis ToolPak from Excel Add Ins) > Descriptive statistics.
  • Enter Input Range as $B$1:$B$121, select Columns in Grouped By, tick on Summary statistics.
  • Click on OK.

Output using EXCEL is given as follows:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  4

Thus, the descriptive statistics for the years of experience and salary for individuals employed in all sales positions is obtained.

The mean annual salary for sales persons regardless of years of experience and type of position is $64,925.48 and the standard deviation is $10,838.67. The mean salary for ‘Inside’ sales persons is $56,020.52 and the standard deviation is $3589.83. The mean salary for ‘Outside’ sales persons is $73,830.43 and the standard deviation is $7,922.96. The mean salary and standard deviation for ‘Outside’ sales persons is higher comparing with the mean salary for ‘Inside’ sales persons.

The mean salary for sales persons who have ‘Low’ years of experience is $59,819.63 and the standard deviation is $6,005.06.

The mean salary for sales persons who have ‘Medium’ years of experience is $68,618.13 and the standard deviation is $13,621.38.

The mean salary for sales persons who have ‘High’ years of experience is $66,338.68 and the standard deviation is $9,699.51.

The mean salary and standard deviation for sales persons who have ‘Medium’ years of experience is higher compared with the mean salary for sales persons who have ‘Low’ years of experience and ‘High’ years of experience.

2.

Expert Solution
Check Mark
To determine

Develop a 95% confidence interval estimate of the mean annual salary for all sales persons regardless of years of experience and type of position.

Answer to Problem 2CP

The 95% confidence interval estimate of the mean annual salary for all sales persons regardless of years of experience and type of position is (62,966.41, 66,884.55).

Explanation of Solution

Calculation:

Here, 120 observations is considered as the sample and the population standard deviation is not known. Hence, t-test can be used for finding confidence intervals for testing population means.

The level of significance is 0.05.

Hence,

tα2=t0.052=t0.0252

The 95% confidence interval for the mean annual salary for all sales persons regardless of years of experience and type of position is, x¯t0.025,119(sn)<μ<x¯+t0.025,119(sn).

From part (a), substitute, x¯=$64,925.48,s=10,838.67,n=120 in the above formula.

64,925.48t0.025,119(10,838.67120)<μ<64,925.48+t0.025,119(10,838.67120)

Critical value:

Software procedure:

Step-by-step procedure to obtain t0.025,119 using the EXCEL:

  • Open an EXCEL sheet.
  • Enter the formula in cell A1 as “=T.INV(0.025,119)”.
  • Click on Enter.

Output using EXCEL software is given below:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  5

The value t0.025,119=1.9801.

The 95% confidence interval for the mean is,

64,925.48t0.025,119(10,838.67120)<μ<64,925.48+t0.025,119(10,838.67120)64,925.481.980(10,838.67120)<μ<64,925.48+1.980(10,838.67120)64,925.481,959.07<μ<64,925.48+1,959.0762,966.41<μ<66,884.55

Thus, the 95% confidence interval estimate of the mean annual salary for all sales persons regardless of years of experience and type of position is (62,966.41, 66,884.55).

3.

Expert Solution
Check Mark
To determine

Develop a 95% confidence interval estimate of the mean salary for inside sales persons.

Answer to Problem 2CP

The 95% confidence interval estimate of the mean salary for inside sales persons is (56,947.87, 55,093.17).

Explanation of Solution

Calculation:

From part (a), the mean salary for the inside sales based on low, medium and high is given below:

x¯low=55,031.35x¯medium=55607.75x¯high=57,422.45

The overall mean salary for inside sales person is provided below:

x¯=x¯low+x¯medium+x¯high3=55,031.35+55,607.75+57,422.453=168,061.55556,020.52

Standard deviation:

Software Procedure:

Step by step procedure to obtain the standard deviation using EXCEL:

  • Open an EXCEL sheet.
  • Enter the data.
  • In a cell A1, enter the formula, “=STDEV(F1:H20)”.
  • Click Enter.

Output using EXCEL software is given below:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  6

substitute x¯=$56020.52,s=3,589.83,n=60 in the above formula.

56,020.52t0.025,59(3,589.8360)<μ<56,020.52+t0.025,59(3,589.8360)

Critical value:

Software procedure:

Step-by-step procedure to obtain t0.025,119 using the EXCEL:

  • Open an EXCEL sheet.
  • Enter the formula in cell A1 as “=T.INV(0.025,119)”.
  • Click on Enter.

Output using EXCEL software is given below:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  7

The value t0.025,59=2.001.

The 95% confidence interval for the mean is,

56,020.52t0.025,59(3,589.8360)<μ<56,020.52+t0.025,59(3,589.8360)56,020.522.001(3,589.8360)<μ<56,020.52+2.001(3,589.8360)56,020.52927.35<μ<56,020.52927.3556947.87<μ<55093.17.

Thus, the 95% confidence interval estimate of the mean salary for inside sales persons is (56,947.87, 55,093.17).

4.

Expert Solution
Check Mark
To determine

Develop a 95% confidence interval estimate of the mean salary for outside sales persons.

Answer to Problem 2CP

The 95% confidence interval estimate of the mean salary for outside sales persons is (75,877.15, 71,783.71).

Explanation of Solution

Calculation:

The 95% confidence interval for the mean salary for outside sales persons is, x¯t0.025,59(sn)<μ<x¯+t0.025,59(sn).

The mean and standard deviation for salary of outside sales persons are x¯=$73,830.43,s=7,922.96.

Here, n=60.

73,830.43t0.025,59(3,589.8360)<μ<56,020.52+t0.025,59(3,589.8360)

The 95% confidence interval for the mean is,

73,830.43t0.025,59(3,589.8360)<μ<56,020.52+t0.025,59(3,589.8360)73,830.432.001(3,589.8360)<μ<56,020.52+2.001(3,589.8360)73,830.432,046.72<μ<73,830.432,046.7275,877.15<μ<71,783.71.

Thus, the 95% confidence interval estimate of the mean salary for inside sales persons is (56947.87, 55093.17).

5.

Expert Solution
Check Mark
To determine

Check whether there are any significant differences due to position at α=0.05 level of significance by ignoring the effect of years of experience.

Answer to Problem 2CP

There is sufficient evidence to conclude that there is significant difference in the mean of positions at α=0.05 level of significance.

Explanation of Solution

Calculation:

State the hypotheses:

Null hypothesis:

H0:μ1=μ2

Alternative hypothesis:

Ha: Not all the population means are equal.

The level of significance is 0.05.

One-way ANOVA:

Software procedure:

Step-by-step procedure to obtain the one-way Anova using the EXCEL:

  • Open new EXCEL worksheet.
  • Enter the data values in the cell.
  • On Data tab in Analysis group, click Data Analysis.
  • Select Anova: Single factor.
  • Click Ok.
  • Click in the Input Range box, select the range $A$1: $B$61.
  • Select Labels and Enter Alpha as 0.05.
  • Click in the Output range, select $G$1.
  • Click OK.

Output using the EXCEL software is given below:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  8

From the EXCEL output, the F-ratio is 251.54 and the p-value is 0.000.

Decision:

If p-valueα, reject the null hypothesis H0.

If p-value>α, fail to reject the null hypothesis H0.

Conclusion:

Here, the p-value is less than the level of significance.

That is, p-value(=0.000)<α(=0.05).

Therefore, the null hypothesis is rejected.

There is sufficient evidence to conclude that there is significant difference in the mean of positions at α=0.05 level of significance.

6.

Expert Solution
Check Mark
To determine

Check whether there are any significant differences due to years of experience at α=0.05 level of significance by ignoring the effect of position.

Answer to Problem 2CP

There is sufficient evidence to conclude that there is significant difference in the mean of years of experience at α=0.05 level of significance.

Explanation of Solution

Calculation:

State the hypotheses:

Null hypothesis:

H0:μ1=μ2=μ3

Alternative hypothesis:

Ha: Not all the population means are equal.

The level of significance is 0.05.

One-way ANOVA:

Software procedure:

Step-by-step procedure to obtain the one-way ANOVA using the EXCEL:

  • Open new EXCEL worksheet.
  • Enter the data values in the cell.
  • On Data tab in Analysis group, click Data Analysis.
  • Select Anova: Single factor.
  • Click Ok.
  • Click in the Input Range box, select the range $B$1: $D$41.
  • Select Labels and Enter Alpha as 0.05.
  • Click in the Output range, select $G$1.
  • Click OK.

Output using the MINITAB software is given below:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  9

From the MINITAB output, the F-ratio is 7.93 and the p-value is 0.001.

Conclusion:

Here, the p-value is less than the level of significance.

That is, p-value(=0.001)<α(=0.05).

Therefore, the null hypothesis is rejected.

There is sufficient evidence to conclude that there is significant difference in the mean of years of experience at α=0.05 level of significance.

7.

Expert Solution
Check Mark
To determine

Test for any significant differences due to position, years of experience and interaction at α=0.05 level of significance.

Answer to Problem 2CP

The main effect of factor A (Position) is significant.

The main effect of factor B (Experience) is significant.

The interaction is significant.

Explanation of Solution

Calculation:

Factor A is Position (Inside, Outside). Factor B is Experience (Low, Medium, High).

The testing of hypotheses is as follows:

State the hypotheses:

Main effect of factor A:

Null hypothesis:

H0: There is no significant difference in the means of “Position”.

Alternative hypothesis:

Ha: There is significant difference in the means of “Position”.

Main effect of factor B:

Null hypothesis:

H0: There is no significant difference in the means of “Experience”.

Alternative hypothesis:

Ha: There is significant difference in the means of “Experience”.

Interaction:

Null hypothesis:

H0: There is no interaction between the Factor A (Position) and Factor B (Experience).

Alternative hypothesis:

Ha: There is an interaction between the Factor A (Position) and Factor B (Experience).

Software procedure:

Step-by-step procedure to obtain the factorial experiment using the EXCEL:

  • Open new EXCEL worksheet.
  • Enter the data values in the cell.
  • On Data tab in Analysis group, click Data Analysis.
  • Select Anova: Two-Factor With Replication.
  • Click Ok.
  • Click in the Input Range box, select the range $A$1: $E$11.
  • Click in the Rows per sample, Enter 2.
  • Select Labels and Enter Alpha as 0.05.
  • Click in the Output range, select $G$1.
  • Click OK.

Output obtained by EXCEL procedure is as follows:

Essentials Of Statistics For Business & Economics, Chapter 13, Problem 2CP , additional homework tip  10

For Factor A (Position), the F-test statistic is 751.36 and the p-value is 0.000.

For Factor B (Experience), the F-test statistic is 65.86 and the p-value is 0.000.

For interaction, the F-test statistic is 53.38 and the p-value is 0.000.

Decision:

If p-valueα, reject the null hypothesis H0.

If p-value>α, fail to reject the null hypothesis H0.

Conclusion:

Factor A:

Here, the p-value is less than the level of significance.

That is, p-value(=0.000)<α(=0.05).

Therefore, the null hypothesis is rejected.

That is, the main effect of factor A (Position) is significant.

Factor B:

Here, the p-value is less than the level of significance.

That is, p-value(=0.000)<α(=0.05).

Therefore, the null hypothesis is rejected.

That is, the main effect of factor B (Experience) is significant.

Interaction:

Here, the p-value is less than the level of significance.

That is, p-value(=0.000)<α(=0.05).

Therefore, the null hypothesis is rejected.

Thus, the interaction is significant.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 13 Solutions

Essentials Of Statistics For Business & Economics

Ch. 13.2 - Paint-Drying Robots. How long it takes paint to...Ch. 13.2 - Restaurant Satisfaction. The Consumer Reports...Ch. 13.3 - The following data are from a completely...Ch. 13.3 - The following data are from a completely...Ch. 13.3 - Testing Chemical Processes. To test whether the...Ch. 13.3 - Confidence Intervals for Different Processes....Ch. 13.3 - Marketing Ethics. In the digital age of marketing,...Ch. 13.3 - Machine Breakdowns. To test for any significant...Ch. 13.3 - Testing Time to Breakdown Between All Pairs of...Ch. 13.3 - Minor league Baseball Attendance. The...Ch. 13.4 - Consider the experimental results for the...Ch. 13.4 - Prob. 22ECh. 13.4 - An experiment has been conducted for four...Ch. 13.4 - Auto Tune-Ups. An automobile dealer conducted a...Ch. 13.4 - Airfares on Travel Websites. Are there differences...Ch. 13.4 - SAT Performance. The Scholastic Aptitude Test...Ch. 13.4 - Consumer Preferences. In 2018, consumer goods...Ch. 13.5 - A factorial experiment involving two levels of...Ch. 13.5 - The calculations for a factorial experiment...Ch. 13.5 - Mobile App Website Design. Based on a 2018 study,...Ch. 13.5 - Amusement Park Queues. An amusement park studied...Ch. 13.5 - Auto Fuel Efficiency. As part of a study designed...Ch. 13.5 - Tax Research. A study reported in The Accounting...Ch. 13 - Paper Towel Absorption. In a completely randomized...Ch. 13 - Job Satisfaction. A study reported in the Journal...Ch. 13 - Prob. 36SECh. 13 - College Attendance Rates. The following data show...Ch. 13 - Assembly Methods. Three different assembly methods...Ch. 13 - Job Automation. A Pew Research study conducted in...Ch. 13 - Fuel Efficiency of Gasoline Brands. A research...Ch. 13 - Late-Night Talk Show Viewership. Jimmy Kimmel...Ch. 13 - Golf Club Design. A major manufacturer of golf...Ch. 13 - Language Translation. A factorial experiment was...Ch. 13 - Defective Parts. A manufacturing company designed...Ch. 13 - CASE PROBLEM 1: WENTWORTH MEDICAL CENTER As part...Ch. 13 - CASE PROBLEM 2: COMPENSATION FOR SALES...Ch. 13 - TOURISTOPIA TRAVEL TourisTopia Travel (Triple T)...
Knowledge Booster
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
  • Glencoe Algebra 1, Student Edition, 9780079039897...
    Algebra
    ISBN:9780079039897
    Author:Carter
    Publisher:McGraw Hill
    Functions and Change: A Modeling Approach to Coll...
    Algebra
    ISBN:9781337111348
    Author:Bruce Crauder, Benny Evans, Alan Noell
    Publisher:Cengage Learning
    Linear Algebra: A Modern Introduction
    Algebra
    ISBN:9781285463247
    Author:David Poole
    Publisher:Cengage Learning
  • Glencoe Algebra 1, Student Edition, 9780079039897...
    Algebra
    ISBN:9780079039897
    Author:Carter
    Publisher:McGraw Hill
    Functions and Change: A Modeling Approach to Coll...
    Algebra
    ISBN:9781337111348
    Author:Bruce Crauder, Benny Evans, Alan Noell
    Publisher:Cengage Learning
    Linear Algebra: A Modern Introduction
    Algebra
    ISBN:9781285463247
    Author:David Poole
    Publisher:Cengage Learning
    what is Research Design, Research Design Types, and Research Design Methods; Author: Educational Hub;https://www.youtube.com/watch?v=LpmGSioXxdo;License: Standard YouTube License, CC-BY