EBK MODERN BUSINESS STATISTICS WITH MIC
EBK MODERN BUSINESS STATISTICS WITH MIC
5th Edition
ISBN: 9780100475038
Author: williams
Publisher: YUZU
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 12, Problem 1CP

In a study conducted by Zogby International for the Democrat and Chronicle, more than 700 New Yorkers were polled to determine whether the New York state government works. Respondents surveyed were asked questions involving pay cuts for state legislators, restrictions on lobbyists, term limits for legislators, and whether state citizens should be able to put matters directly on the state ballot for a vote. The results regarding several proposed reforms had broad support, crossing all demographic and political lines.

Suppose that a follow-up survey of 100 individuals who live in the western region of New York was conducted. The party affiliation (Democrat, Independent, Republican) of each individual surveyed was recorded, as well as their responses to the following three questions.

  1. 1. Should legislative pay be cut for every day the state budget is late?

    Yes ____ No ____

  2. 2. Should there be more restrictions on lobbyists?

    Yes ____ No ____

  3. 3. Should there be term limits requiring that legislators serve a fixed number of years?

    Yes ____ No ____

The responses were coded using 1 for a Yes response and 2 for a No response. The complete data set is available in the file NYReform.

Managerial Report

  1. 1. Use descriptive statistics to summarize the data from this study. What are your preliminary conclusions about the independence of the response (Yes or No) and party affiliation for each of the three questions in the survey?
  2. 2. With regard to question 1, test for the independence of the response (Yes and No) and party affiliation. Use α = .05.
  3. 3. With regard to question 2, test for the independence of the response (Yes and No) and party affiliation. Use α = .05.
  4. 4. With regard to question 3, test for the independence of the response (Yes and No) and party affiliation. Use α = .05.
  5. 5. Does it appear that there is broad support for change across all political lines? Explain.

1.

Expert Solution
Check Mark
To determine

Find the descriptive statistics to summarize the data from the study.

Explain about the preliminary conclusions about the independence of the response and party affiliation for each of the three questions in the survey.

Explanation of Solution

Calculation:

The given data are related to the survey of 100 individuals, who were asked three questions. The response was coded using “1” for “Yes” response and “2” for “No” response.

The variable ‘Pay Cut?’ represents the response of the question “Should legislative pay be cut for every day the state budget is late?”.

Contingency table:

Software procedure:

Step-by-step software procedure to obtain contingency table using EXCEL software is as follows:

  • Open an EXCEL sheet.
  • Enter the data as Observation in column A, Party in column B, Pay Cut? in column C, Lobbyists? in column D and Term Limits? in column E.
  • Select the all data.
  • Choose Insert > PivotTable.
  • Under Select a table or range in Table/Range enter Data!$A$1:$E$101.
  • Choose New Worksheet.
  • Click OK.
  • In new sheet enter Party as Row Labels.
  • In new sheet enter Pay Cut? as Column Labels.
  • In new sheet enter Observation as Values.
  • Choose Values > Sum of Observation > Value Field Settings.
  • Select Summarize value field by > Count.
  • Click OK.
  • Output using EXCEL software is given below:

EBK MODERN BUSINESS STATISTICS WITH MIC, Chapter 12, Problem 1CP , additional homework tip  1

Now, the percentages of responses for the question “Should legislative pay be cut for every day the state budget is late?” are obtained as follows:

PartyYes (%)No (%)
Democrat2236×100=61.11%1436×100=38.89%
Independent1019×100=52.63%919×100=47.36%
Republican3945×100=86.67%645×100=13.33%

Thus, it can be concluded that since the percentage of Republicans that answered yes is much greater than the percentage of Democrats or Independents that answered yes, the classifications do not appear to be independent.

The variable ‘Lobbyists?’ represents the response of the question “Should there be more restriction on lobbyists?”.

Software procedure:

Step-by-step software procedure to obtain contingency table using EXCEL software is as follows:

  • Open an EXCEL sheet.
  • Enter the data as Observation in column A, Party in column B, Pay Cut? in column C, Lobbyists? in column D and Term Limits? in column E.
  • Select the all data.
  • Choose Insert > PivotTable.
  • Under Select a table or range in Table/Range enter Data!$A$1:$E$101.
  • Choose New Worksheet.
  • Click OK.
  • In new sheet enter Party as Row Labels.
  • In new sheet enter Lobbyists? as Column Labels.
  • In new sheet enter Observation as Values.
  • Choose Values > Sum of Observation > Value Field Settings.
  • Select Summarize value field by > Count.
  • Click OK.
  • Output using EXCEL software is given below:

EBK MODERN BUSINESS STATISTICS WITH MIC, Chapter 12, Problem 1CP , additional homework tip  2

Now, the percentages of responses for the question “Should there be more restriction on lobbyists?” are obtained as follows:

PartyYes (%)No (%)
Democrat2136×100=58.33%1536×100=41.66%
Independent1519×100=78.94%419×100=21.05%
Republican3445×100=75.55%1145×100=24.44%

Thus, it can be concluded that since the percentage of Democrats that answered yes is much less than the percentage of Independents or Republicans that answered yes, the classifications do not appear to be independent.

The variable ‘Term Limits?’ represents the response of the question “Should there be term limits requiring that legislators serve a fixed number of years?”.

Contingency table:

Software procedure:

Step-by-step software procedure to obtain contingency table using EXCEL software is as follows:

  • Open an EXCEL sheet.
  • Enter the data as Observation in column A, Party in column B, Pay Cut? in column C, Lobbyists? in column D and Term Limits? in column E.
  • Select the all data.
  • Choose Insert > PivotTable.
  • Under Select a table or range in Table/Range enter Data!$A$1:$E$101.
  • Choose New Worksheet.
  • Click OK.
  • In new sheet enter Party as Row Labels.
  • In new sheet enter Term Limits?  as Column Labels.
  • In new sheet enter Observation as Values.
  • Choose Values > Sum of Observation > Value Field Settings.
  • Select Summarize value field by > Count.
  • Click OK.
  • Output using EXCEL software is given below:

EBK MODERN BUSINESS STATISTICS WITH MIC, Chapter 12, Problem 1CP , additional homework tip  3

Now, the percentages of responses for the question “Should there be term limits requiring that legislators serve a fixed number of years?” are obtained as follows:

PartyYes (%)No (%)
Democrat1736×100=47.22%1936×100=52.77%
Independent1019×100=52.63%919×100=47.37%
Republican3245×100=71.11%1345×100=28.89%

Thus, it can be concluded that since the percentage of Republicans that answered yes is much higher than the percentage of Democrats or Independents that answered yes, the classifications do not appear to be independent.

2.

Expert Solution
Check Mark
To determine

Perform a test for the independence of the response (Yes or No) and party affiliation with regard to question “Should legislative pay be cut for every day the state budget is late?” at α=0.05 level of significance.

Answer to Problem 1CP

There is a statistically significant relation between the response (Yes or No) and party affiliation.

Explanation of Solution

Calculation:

State the test hypotheses.

Null hypothesis:

 H0:The response (Yes or No) and party affiliation are independent.

That is, there is no statistically significant relation between the response (Yes or No) and party affiliation.

Alternative hypothesis:

 Ha:The response (Yes or No) and party affiliation are not independent.

That is, there is a statistically significant relation between the response (Yes or No) and party affiliation.

The row and column total is tabulated below:

PartyYes (%)No (%)Total
Democrat221436
Independent10919
Republican39645
Total7129100

The formula for expected frequency is given below:

eij=(Row i Total)(Coloumn j Total)Total Sample Size.

The expected frequency for each category is calculated as follows:

PartyYes (%)No (%)
Democrat(36)(71)100=25.56(36)(29)100=10.44
Independent(19)(71)100=13.49(19)(29)100=5.51
Republican(45)(71)100=31.95(45)(29)100=13.05

The formula for chi-square test statistic is given as,

χ2=i=1rj=1c(fijeij)2eij where (i,j)th element denotes the frequency corresponding to (i,j)th cell and r represent the rth row and c represents the cth column.

Therefore, the value of chi-square test statistic is,

χ2=(2225.56)225.56+(1410.44)210.44+(1013.49)213.49+(95.51)25.51+(3931.95)231.95+(613.05)213.0512.6725.56+12.6710.44+12.1813.49+12.185.51+49.7031.95+49.7013.050.49+1.21+0.90+2.21+1.56+3.81=10.18

Thus, the chi-square test statistic is 10.18.

Degrees of freedom:

The degrees of freedom are (r1)(c1) for r row and c columns.

Thus, for 3 rows and 2 columns the degrees of freedom are,

df=(31)(21)=(21)(11)=2

Thus, the degree of freedom is 2.

Level of significance:

The given level of significance is α=0.05.

p-value:

Software procedure:

Step -by-step software procedure to obtain p-value using EXCEL software is as follows:

  • Open an EXCEL sheet and select cell A1.
  • In cell A1 enter the formula =CHISQ.DIST.RT(10.18,2).
  • Press Enter.
  • Output using EXCEL software is given below:

EBK MODERN BUSINESS STATISTICS WITH MIC, Chapter 12, Problem 1CP , additional homework tip  4

From the EXCEL output, the p-value is 0.0062.

Rejection rule:

  • If the p-valueα, then reject the null hypothesis.
  • Otherwise, failed to reject the null hypothesis.

Conclusion:

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

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

Thus, the decision is “reject the null hypothesis”.

Therefore, the data provide sufficient evidence to conclude that the responses and party affiliation are not independent.

Thus, there is a statistically significant relation between the response (Yes or No) and party affiliation.

3.

Expert Solution
Check Mark
To determine

Perform a test for the independence of the response (Yes or No) and party affiliation with regard to question “Should there be more restriction on lobbyists?” at α=0.05 level of significance.

Answer to Problem 1CP

There is no statistically significant relation between the response (Yes or No) and party affiliation.

Explanation of Solution

Calculation:

State the test hypotheses.

Null hypothesis:

 H0:The response (Yes or No) and party affiliation are independent.

That is, there is no statistically significant relation between the response (Yes or No) and party affiliation.

Alternative hypothesis:

 Ha:The response (Yes or No) and party affiliation are not independent.

That is, there is no statistically significant relation between the response (Yes or No) and party affiliation.

The row and column total is tabulated below:

PartyYes (%)No (%)Total
Democrat211536
Independent15419
Republican341145
Total7030100

The formula for expected frequency is given below:

eij=(Row i Total)(Coloumn j Total)Total Sample Size.

The expected frequency for each category is calculated as follows:

PartyYes (%)No (%)
Democrat(36)(70)100=25.20(36)(30)100=10.80
Independent(19)(70)100=13.30(19)(30)100=5.70
Republican(45)(70)100=31.50(45)(30)100=13.50

Therefore, the value of chi-square test statistic is,

χ2=(2125.20)225.20+(1510.80)210.80+(1513.30)213.30+(45.70)25.70+(3431.50)231.50+(1113.50)213.5017.6425.20+17.6410.80+2.8913.30+2.895.70+6.2531.50+6.2513.500.7+1.63+0.22+0.51+0.20+0.46=3.72

Thus, the chi-square test statistic is 3.72.

Degrees of freedom:

The degrees of freedom are (r1)(c1) for r row and c columns.

Thus, for 3 rows and 2 columns the degrees of freedom are,

df=(31)(21)=(21)(11)=2

Thus, the degree of freedom is 2.

Level of significance:

The given level of significance is α=0.05.

p-value:

Software procedure:

Step -by-step software procedure to obtain p-value using EXCEL software is as follows:

  • Open an EXCEL sheet and select cell A1.
  • In cell A1 enter the formula =CHISQ.DIST.RT(3.72,2).
  • Press Enter.
  • Output using EXCEL software is given below:

EBK MODERN BUSINESS STATISTICS WITH MIC, Chapter 12, Problem 1CP , additional homework tip  5

From the EXCEL output, the p-value is 0.1557.

Conclusion:

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

That is, p-value(=0.1557)>α(=0.05)

Thus, the decision is “Do not reject the null hypothesis”.

Therefore, the data do not provide sufficient evidence to conclude that the responses and party affiliation are not independent.

Thus, there is no statistical significant relation between the response (Yes or No) and party affiliation.

4.

Expert Solution
Check Mark
To determine

Perform a test for the independence of the response (Yes or No) and party affiliation with regard to question “Should there be term limits requiring that legislators serve a fixed number of years?” at α=0.05 level of significance.

Answer to Problem 1CP

There is no statistically significant relation between the response (Yes or No) and party affiliation.

Explanation of Solution

Calculation:

State the test hypotheses.

Null hypothesis:

 H0:The response (Yes or No) and party affiliation are independent.

That is, there is no statistical significant relation between the response (Yes or No) and party affiliation.

Alternative hypothesis:

 Ha:The response (Yes or No) and party affiliation are not independent.

That is, there is a statistically significant relation between the response (Yes or No) and party affiliation.

The row and column total is tabulated below:

PartyYes (%)No (%)Total
Democrat171936
Independent10919
Republican321345
Total5941100

The formula for expected frequency is given below:

eij=(Row i Total)(Coloumn j Total)Total Sample Size.

The expected frequency for each category is calculated as follows:

PartyYes (%)No (%)
Democrat(36)(59)100=21.24(36)(41)100=14.76
Independent(19)(59)100=11.21(19)(41)100=7.79
Republican(45)(59)100=26.55(45)(41)100=18.45

Therefore, the value of chi-square test statistic is,

χ2=(1721.24)221.24+(1914.76)214.76+(1011.21)211.21+(97.79)27.79+(3226.55)226.55+(1318.45)218.4519.9821.24+17.9814.76+1.4611.21+1.467.79+29.7026.55+29.7018.450.94+1.22+0.13+0.19+1.12+1.61=5.21

Thus, the chi-square test statistic is 5.21.

Degrees of freedom:

The degrees of freedom are (r1)(c1) for r row and c columns.

Thus, for 3 rows and 2 columns the degrees of freedom are,

df=(31)(21)=(21)(11)=2

Thus, the degree of freedom is 2.

Level of significance:

The given level of significance is α=0.05.

p-value:

Software procedure:

Step -by-step software procedure to obtain p-value using EXCEL software is as follows:

  • Open an EXCEL sheet and select cell A1.
  • In cell A1 enter the formula =CHISQ.DIST.RT(5.21,2).
  • Press Enter.
  • Output using EXCEL software is given below:

EBK MODERN BUSINESS STATISTICS WITH MIC, Chapter 12, Problem 1CP , additional homework tip  6

From the EXCEL output, the p-value is 0.0739.

Conclusion:

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

That is, p-value(=0.0739)>α(=0.05)

Thus, the decision is “Fail to reject the null hypothesis”.

Therefore, the data do not provide sufficient evidence to conclude that the responses and party affiliation are not independent.

Thus, there is no statistically significant relation between the response (Yes or No) and party affiliation.

5.

Expert Solution
Check Mark
To determine

Explain whether it appears that there is broad support for change across all political lines.

Explanation of Solution

The tests conducted in Parts 3 and 4 do not produce significant p-values and imply that there is no dependence between the party affiliation and opinions regarding the restriction for lobbyists and term limits of legislators.

However, the test conducted in Part 2 suggests that there is a significant relationship between one’s party affiliation and their opinion regarding legislative pay cut. The Republicans appear to be much more in favor of legislative pay cut for everyday state budget than the Democrats or the Independents.

Thus, it appears that there is no broad support for change across all political lines, but only across some political lines.

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!
Students have asked these similar questions
In a study conducted by Zogby International for the Democrat and Chronicle, more than 700 New Yorkers were polled to determine whether the New York state government works. Respondents surveyed were asked questions involving pay cuts for state legislators, restrictions on lobbyists, term limits for legislators, and whether state citizens should be able to put matters directly on the state ballot for a vote. The results regarding several proposed reforms had broad support, crossing all demographic and political lines. Suppose that a follow-up survey of 100 individuals who live in the western region of New York was conducted. The party affiliation (Democrat, Independent, Republican) of each individual surveyed was recorded, as well as their responses to the following three questions. Should legislative pay be cut for every day the state budget is late? Yes _________ No _________ Should there be more restrictions on lobbyists? Yes _________ No _________ Should there be term limits…
Bruce had a disagreement with a new federal agency set up to give additional funds for college to individuals with an aptitude for math. After a hearing, the agency determined that Bruce had no aptitude for math and that he would not receive any funding. Bruce, however, was not discouraged. He told his friend Laura, who just graduated from law school, that he would simply appeal the decision to federal court, have the judge do a fresh review, and provide additional information to the judge regarding his math aptitude that the agency did not have. He feels certain that he will win at the federal court level. Assuming the decision by the administrative agency was a factual finding, what should Laura tell Bruce regarding the standard of review the administrative agency will likely apply?That the agency will likely apply a de novo, or new, review.That the agency will likely apply an arbitrary and capricious standard in any review.That the agency will likely apply a substantial evidence…
ClairLinx Wireless, a start-up cell phone company, has divided its market of potential customers into three major groups: single, working; married, working; and retired. ClairLinx surveyed 500 potential customers and asked each, "Of the following, which do you consider to be the most important feature in a cell phone service plan: free nights and weekends, free long distance and roaming, or free calls to customers with the same company?"   Each of the 500 potential customers in the survey was categorized according to the service plan feature she considers most important and the customer group in which she appears. The data are summarized in the contingency table below. In the cells of the table are the respective observed frequencies, and three of the cells also have blanks. Fill in these blanks with the frequencies expected if the two variables, type of potential customer and choice of service plan feature, are independent.   Round the responses to at least two decimal places.  Note:…

Chapter 12 Solutions

EBK MODERN BUSINESS STATISTICS WITH MIC

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
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY