Question 1 12 / 12 points UMUC plans to use a new tutorial to teach the students about business ethics. As an experiment, the administrator randomly selected 15 students, and randomly assigned them to one of three groups: a PowerPoint presentation created by the faculty, AuthorGen Presentation created by the faculty, or a well known tutorial by the ABC company. After completing their assigned tutorial, the students are given a Business Ethics test (← Click on link). Use Excel Data Analysis at α = 0.01 to decide which tutorial to use?
Question 2 
8 / 8 points 
What are the Hypotheses?
Question options:
H0: All three population means are equal; H1: At least two population means are different 

H0: At least two population means are different; H1 All three population means are equal 

H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal 

H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score 
Question 3 
8 / 8 points 
Based on the ANOVA results from question 1. What is your conclusion?
Question options:
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score. 

Do not reject H0: Mean test results are equal, choose the least expensive tutorial. 

Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score. 

Reject H0: Mean test results are equal, choose the least expensive tutorial. 
Question 4 
15 / 15 points 
ASPCA studied whether there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from randomly chosen pet owners who owned either one cat or one dog. Open Dogs and Cats (← Click on link), make a 2×2 pivot table counting by kind of pet and gender of owner, and keep Excel file open for the next 3 questions. Your pivot table has the same counts as
Question 5 
10 / 10 points 
Perform the chi square test of independence at α = 0.01 of owner gender and type of pet as summarised by the pivot table from problem 4. The chi square statistic is
Question options:







Question 6 
7 / 7 points 
Continuing with Question 4, the test of independence of kind of pet and owner gender, what is the critical value? You can use the table at
Chi Square Table
Question options:
5.024 

6.635 

7.378 

9.210 
Question 7 
10 / 10 points 
You conclude that
Question options:







Question 8 
8 / 8 points 
A human resources director wants to determine if there is a dependence between day of the week and the number of times employees took sick leave on that day. Open Sick Leave (← Click on link).
Test H0: Monday = Tuesday = Wednesday = Thursday = Friday = Saturday. Keep your Excel file open for the following 3 questions.
The chi square statistic is
Question options:







Question 9 8 / 8 points Continuing, determine the critical value at the significance level of .05 using one of Table Chi Square Table =CHISQ.INV.RT =CHISQ.INV =CHIINV() to find the critical value. The critical value is Question options: 11.070 12.592 1.145 1.635
Question 10 
8 / 8 points 
Continuing, find the pvalue using the chi square statistic in a) and one of the Excel function CHISQ.DIST.RT, =CHISQ.DIST, or =CHIDIST().
The pvalue is
Question options:
0.977 

0.936 

0.023 

0.992 
Question 11 
6 / 6 points 
Comparing the chi square statistic in a) to the critical value in b), or the pvalue in c) to α, is it indicated that employees have a tendency to use Monday as a sick day?
Question options:
True 

False 
Question 1 12 / 12 points UMUC plans to use a new tutorial to teach the students about business ethics. As an experiment, the administrator randomly selected 15 students, and randomly assigned them to one of three groups: a PowerPoint presentation created by the faculty, AuthorGen Presentation created by the faculty, or a well known tutorial by the ABC company. After completing their assigned tutorial, the students are given a Business Ethics test (← Click on link). Use Excel Data Analysis at α = 0.01 to decide which tutorial to use?
Question 2 
8 / 8 points 
What are the Hypotheses?
Question options:
H0: All three population means are equal; H1: At least two population means are different 

H0: At least two population means are different; H1 All three population means are equal 

H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal 

H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score 
Question 3 
8 / 8 points 
Based on the ANOVA results from question 1. What is your conclusion?
Question options:
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score. 

Do not reject H0: Mean test results are equal, choose the least expensive tutorial. 

Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score. 

Reject H0: Mean test results are equal, choose the least expensive tutorial. 
Question 4 
15 / 15 points 
ASPCA studied whether there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from randomly chosen pet owners who owned either one cat or one dog. Open Dogs and Cats (← Click on link), make a 2×2 pivot table counting by kind of pet and gender of owner, and keep Excel file open for the next 3 questions. Your pivot table has the same counts as
Question 5 
10 / 10 points 
Perform the chi square test of independence at α = 0.01 of owner gender and type of pet as summarised by the pivot table from problem 4. The chi square statistic is
Question options:







Question 6 
7 / 7 points 
Continuing with Question 4, the test of independence of kind of pet and owner gender, what is the critical value? You can use the table at
Chi Square Table
Question options:
5.024 

6.635 

7.378 

9.210 
Question 7 
10 / 10 points 
You conclude that
Question options:







Question 8 
8 / 8 points 
A human resources director wants to determine if there is a dependence between day of the week and the number of times employees took sick leave on that day. Open Sick Leave (← Click on link).
Test H0: Monday = Tuesday = Wednesday = Thursday = Friday = Saturday. Keep your Excel file open for the following 3 questions.
The chi square statistic is
Question options:







Question 9 8 / 8 points Continuing, determine the critical value at the significance level of .05 using one of Table Chi Square Table =CHISQ.INV.RT =CHISQ.INV =CHIINV() to find the critical value. The critical value is Question options: 11.070 12.592 1.145 1.635
Question 10 
8 / 8 points 
Continuing, find the pvalue using the chi square statistic in a) and one of the Excel function CHISQ.DIST.RT, =CHISQ.DIST, or =CHIDIST().
The pvalue is
Question options:
0.977 

0.936 

0.023 

0.992 
Question 11 
6 / 6 points 
Comparing the chi square statistic in a) to the critical value in b), or the pvalue in c) to α, is it indicated that employees have a tendency to use Monday as a sick day?
Question options:
True 

False 
Question 1 12 / 12 points UMUC plans to use a new tutorial to teach the students about business ethics. As an experiment, the administrator randomly selected 15 students, and randomly assigned them to one of three groups: a PowerPoint presentation created by the faculty, AuthorGen Presentation created by the faculty, or a well known tutorial by the ABC company. After completing their assigned tutorial, the students are given a Business Ethics test (← Click on link). Use Excel Data Analysis at α = 0.01 to decide which tutorial to use?
Question 2 
8 / 8 points 
What are the Hypotheses?
Question options:
H0: All three population means are equal; H1: At least two population means are different 

H0: At least two population means are different; H1 All three population means are equal 

H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal 

H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score 
Question 3 
8 / 8 points 
Based on the ANOVA results from question 1. What is your conclusion?
Question options:
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score. 

Do not reject H0: Mean test results are equal, choose the least expensive tutorial. 

Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score. 

Reject H0: Mean test results are equal, choose the least expensive tutorial. 
Question 4 
15 / 15 points 
ASPCA studied whether there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from randomly chosen pet owners who owned either one cat or one dog. Open Dogs and Cats (← Click on link), make a 2×2 pivot table counting by kind of pet and gender of owner, and keep Excel file open for the next 3 questions. Your pivot table has the same counts as
Question 5 
10 / 10 points 
Perform the chi square test of independence at α = 0.01 of owner gender and type of pet as summarised by the pivot table from problem 4. The chi square statistic is
Question options:







Question 6 
7 / 7 points 
Continuing with Question 4, the test of independence of kind of pet and owner gender, what is the critical value? You can use the table at
Chi Square Table
Question options:
5.024 

6.635 

7.378 

9.210 
Question 7 
10 / 10 points 
You conclude that
Question options:







Question 8 
8 / 8 points 
A human resources director wants to determine if there is a dependence between day of the week and the number of times employees took sick leave on that day. Open Sick Leave (← Click on link).
Test H0: Monday = Tuesday = Wednesday = Thursday = Friday = Saturday. Keep your Excel file open for the following 3 questions.
The chi square statistic is
Question options:







Question 9 8 / 8 points Continuing, determine the critical value at the significance level of .05 using one of Table Chi Square Table =CHISQ.INV.RT =CHISQ.INV =CHIINV() to find the critical value. The critical value is Question options: 11.070 12.592 1.145 1.635
Question 10 
8 / 8 points 
Continuing, find the pvalue using the chi square statistic in a) and one of the Excel function CHISQ.DIST.RT, =CHISQ.DIST, or =CHIDIST().
The pvalue is
Question options:
0.977 

0.936 

0.023 

0.992 
Question 11 
6 / 6 points 
Comparing the chi square statistic in a) to the critical value in b), or the pvalue in c) to α, is it indicated that employees have a tendency to use Monday as a sick day?
Question options:
True 

False 
Question 1 12 / 12 points UMUC plans to use a new tutorial to teach the students about business ethics. As an experiment, the administrator randomly selected 15 students, and randomly assigned them to one of three groups: a PowerPoint presentation created by the faculty, AuthorGen Presentation created by the faculty, or a well known tutorial by the ABC company. After completing their assigned tutorial, the students are given a Business Ethics test (← Click on link). Use Excel Data Analysis at α = 0.01 to decide which tutorial to use?
Question 1 12 / 12 points UMUC plans to use a new tutorial to teach the students about business ethics. As an experiment, the administrator randomly selected 15 students, and randomly assigned them to one of three groups: a PowerPoint presentation created by the faculty, AuthorGen Presentation created by the faculty, or a well known tutorial by the ABC company. After completing their assigned tutorial, the students are given a Business Ethics test (← Click on link). Use Excel Data Analysis at α = 0.01 to decide which tutorial to use?
Question 2 
8 / 8 points 
Question 2 
8 / 8 points 
Question 2
8 / 8 points
Question 2
8 / 8 points
Question 2
Question 2
Question 2Question 2Question 2
8 / 8 points
8 / 8 points
8 / 8 points
What are the Hypotheses?
What are the Hypotheses?
Question options:
Question options:
H0: All three population means are equal; H1: At least two population means are different 

H0: At least two population means are different; H1 All three population means are equal 

H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal 

H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score 
H0: All three population means are equal; H1: At least two population means are different
H0: At least two population means are different; H1 All three population means are equal
H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal
H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score
H0: All three population means are equal; H1: At least two population means are different
H0: All three population means are equal; H1: At least two population means are different
H0: All three population means are equal; H1: At least two population means are different
H0: All three population means are equal; H1: At least two population means are different
H0: At least two population means are different; H1 All three population means are equal
H0: At least two population means are different; H1 All three population means are equal
H0: At least two population means are different; H1 All three population means are equal
H0: At least two population means are different; H1 All three population means are equal
H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal
H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal
H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal
H0: AuthorGen is best because it has the highest mean score; H1: All three population means are equal
H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score
H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score
H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score
H0: All three population means are equal; H1: AuthorGen is best because it has the highest mean score
Question 3 
8 / 8 points 
Question 3 
8 / 8 points 
Question 3
8 / 8 points
Question 3
8 / 8 points
Question 3
Question 3
Question 3Question 3Question 3
8 / 8 points
8 / 8 points
8 / 8 points
Based on the ANOVA results from question 1. What is your conclusion?
Based on the ANOVA results from question 1. What is your conclusion?
Question options:
Question options:
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score. 

Do not reject H0: Mean test results are equal, choose the least expensive tutorial. 

Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score. 

Reject H0: Mean test results are equal, choose the least expensive tutorial. 
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score.
Do not reject H0: Mean test results are equal, choose the least expensive tutorial.
Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score.
Reject H0: Mean test results are equal, choose the least expensive tutorial.
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score.
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score.
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score.
Reject Ho: AuthorGen Tutorial is best because it has the highest mean score.
Do not reject H0: Mean test results are equal, choose the least expensive tutorial.
Do not reject H0: Mean test results are equal, choose the least expensive tutorial.
Do not reject H0: Mean test results are equal, choose the least expensive tutorial.
Do not reject H0: Mean test results are equal, choose the least expensive tutorial.
Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score.
Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score.
Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score.
Do not reject H0: Mean test results are unequal, AuthorGen Tutorial is the best choice because it has the highest mean score.
Reject H0: Mean test results are equal, choose the least expensive tutorial.
Reject H0: Mean test results are equal, choose the least expensive tutorial.
Reject H0: Mean test results are equal, choose the least expensive tutorial.
Reject H0: Mean test results are equal, choose the least expensive tutorial.
Question 4 
15 / 15 points 
Question 4 
15 / 15 points 
Question 4
15 / 15 points
Question 4
15 / 15 points
Question 4
Question 4
Question 4Question 4Question 4
15 / 15 points
15 / 15 points
15 / 15 points
ASPCA studied whether there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from randomly chosen pet owners who owned either one cat or one dog. Open Dogs and Cats (← Click on link), make a 2×2 pivot table counting by kind of pet and gender of owner, and keep Excel file open for the next 3 questions. Your pivot table has the same counts as
ASPCA studied whether there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from randomly chosen pet owners who owned either one cat or one dog. Open Dogs and Cats (← Click on link), make a 2×2 pivot table counting by kind of pet and gender of owner, and keep Excel file open for the next 3 questions. Your pivot table has the same counts asASPCA studied whether there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from randomly chosen pet owners who owned either one cat or one dog. Open Dogs and Cats (← Click on link), make a 2×2 pivot table counting by kind of pet and gender of owner, and keep Excel file open for the next 3 questions. Your pivot table has the same counts as
Question 5 
10 / 10 points 
Question 5 
10 / 10 points 
Question 5
10 / 10 points
Question 5
10 / 10 points
Question 5
Question 5
Question 5Question 5Question 5
10 / 10 points
10 / 10 points
10 / 10 points
Perform the chi square test of independence at α = 0.01 of owner gender and type of pet as summarised by the pivot table from problem 4. The chi square statistic is
Perform the chi square test of independence at α = 0.01 of owner gender and type of pet as summarised by the pivot table from problem 4. The chi square statistic is
Question options:
Question options:







A) 
1.32 
B) 
1.35 
C) 
1.34 
D) 
1.33 
A) 
1.32 
A) 
1.32 
A) 
1.32 
A)
1.32
A)
1.32
A)
A)
A)
1.32
1.32
1.32
B) 
1.35 
B) 
1.35 
B) 
1.35 
B)
1.35
B)
1.35
B)
B)
B)
1.35
1.35
1.35
C) 
1.34 
C) 
1.34 
C) 
1.34 
C)
1.34
C)
1.34
C)
C)
C)
1.34
1.34
1.34
D) 
1.33 
D) 
1.33 
D) 
1.33 
D)
1.33
D)
1.33
D)
D)
D)
1.33
1.33
1.33
Question 6 
7 / 7 points 
Question 6 
7 / 7 points 
Question 6
7 / 7 points
Question 6
7 / 7 points
Question 6
Question 6
Question 6Question 6Question 6
7 / 7 points
7 / 7 points
7 / 7 points
Continuing with Question 4, the test of independence of kind of pet and owner gender, what is the critical value? You can use the table at
Continuing with Question 4, the test of independence of kind of pet and owner gender, what is the critical value? You can use the table at
Chi Square Table
Chi Square Table
Question options:
Question options:
5.024 

6.635 

7.378 

9.210 
5.024
6.635
7.378
9.210
5.024
5.024
5.024
5.024
6.635
6.635
6.635
6.635
7.378
7.378
7.378
7.378
9.210
9.210
9.210
9.210
Question 7 
10 / 10 points 
Question 7 
10 / 10 points 
Question 7
10 / 10 points
Question 7
10 / 10 points
Question 7
Question 7
Question 7Question 7Question 7
10 / 10 points
10 / 10 points
10 / 10 points
You conclude that
You conclude that
Question options:
Question options:







A) 
There is a relationship because the chi square statistic < 6.635 
B) 
There is no relationship because the chi square statistic is less than the critical value. 
C) 
There is no relationship because the chi square statistic > 6.635. 
D) 
There is a relationship because the chi square statistic exceeds the critical value. 
A) 
There is a relationship because the chi square statistic < 6.635 
A) 
There is a relationship because the chi square statistic < 6.635 
A) 
There is a relationship because the chi square statistic < 6.635 
A)
There is a relationship because the chi square statistic < 6.635
A)
There is a relationship because the chi square statistic < 6.635
A)
A)
A)
There is a relationship because the chi square statistic < 6.635
There is a relationship because the chi square statistic < 6.635
There is a relationship because the chi square statistic < 6.635
B) 
There is no relationship because the chi square statistic is less than the critical value. 
B) 
There is no relationship because the chi square statistic is less than the critical value. 
B) 
There is no relationship because the chi square statistic is less than the critical value. 
B)
There is no relationship because the chi square statistic is less than the critical value.
B)
There is no relationship because the chi square statistic is less than the critical value.
B)
B)
B)
There is no relationship because the chi square statistic is less than the critical value.
There is no relationship because the chi square statistic is less than the critical value.
There is no relationship because the chi square statistic is less than the critical value.
C) 
There is no relationship because the chi square statistic > 6.635. 
C) 
There is no relationship because the chi square statistic > 6.635. 
C) 
There is no relationship because the chi square statistic > 6.635. 
C)
There is no relationship because the chi square statistic > 6.635.
C)
There is no relationship because the chi square statistic > 6.635.
C)
C)
C)
There is no relationship because the chi square statistic > 6.635.
There is no relationship because the chi square statistic > 6.635.
There is no relationship because the chi square statistic > 6.635.
D) 
There is a relationship because the chi square statistic exceeds the critical value. 
D) 
There is a relationship because the chi square statistic exceeds the critical value. 
D) 
There is a relationship because the chi square statistic exceeds the critical value. 
D)
There is a relationship because the chi square statistic exceeds the critical value.
D)
There is a relationship because the chi square statistic exceeds the critical value.
D)
D)
D)
There is a relationship because the chi square statistic exceeds the critical value.
There is a relationship because the chi square statistic exceeds the critical value.
There is a relationship because the chi square statistic exceeds the critical value.
Question 8 
8 / 8 points 
Question 8 
8 / 8 points 
Question 8
8 / 8 points
Question 8
8 / 8 points
Question 8
Question 8
Question 8Question 8Question 8
8 / 8 points
8 / 8 points
8 / 8 points
A human resources director wants to determine if there is a dependence between day of the week and the number of times employees took sick leave on that day. Open Sick Leave (← Click on link).
A human resources director wants to determine if there is a dependence between day of the week and the number of times employees took sick leave on that day. Open Sick Leave (← Click on link).A human resources director wants to determine if there is a dependence between day of the week and the number of times employees took sick leave on that day. Open Sick Leave (← Click on link).
Test H0: Monday = Tuesday = Wednesday = Thursday = Friday = Saturday. Keep your Excel file open for the following 3 questions.
Test H0: Monday = Tuesday = Wednesday = Thursday = Friday = Saturday. Keep your Excel file open for the following 3 questions.
The chi square statistic is
The chi square statistic is
Question options:
Question options:







A) 
.82 
B) 
.83 
C) 
.81 
D) 
.80 
A) 
.82 
A) 
.82 
A) 
.82 
A)
.82
A)
.82
A)
A)
A)
.82
.82
.82
B) 
.83 
B) 
.83 
B) 
.83 
B)
.83
B)
.83
B)
B)
B)
.83
.83
.83
C) 
.81 
C) 
.81 
C) 
.81 
C)
.81
C)
.81
C)
C)
C)
.81
.81
.81
D) 
.80 
D) 
.80 
D) 
.80 
D)
.80
D)
.80
D)
D)
D)
.80
.80
.80
Question 9 8 / 8 points Continuing, determine the critical value at the significance level of .05 using one of Table Chi Square Table =CHISQ.INV.RT =CHISQ.INV =CHIINV() to find the critical value. The critical value is Question options: 11.070 12.592 1.145 1.635
Question 9 8 / 8 points Continuing, determine the critical value at the significance level of .05 using one of Table Chi Square Table =CHISQ.INV.RT =CHISQ.INV =CHIINV() to find the critical value. The critical value is Question options: 11.070 12.592 1.145 1.635
Question 10 
8 / 8 points 
Question 10 
8 / 8 points 
Question 10
8 / 8 points
Question 10
8 / 8 points
Question 10
Question 10
Question 10Question 10Question 10
8 / 8 points
8 / 8 points
8 / 8 points
Continuing, find the pvalue using the chi square statistic in a) and one of the Excel function CHISQ.DIST.RT, =CHISQ.DIST, or =CHIDIST().
Continuing, find the pvalue using the chi square statistic in a) and one of the Excel function CHISQ.DIST.RT, =CHISQ.DIST, or =CHIDIST().
The pvalue is
The pvalue is
Question options:
Question options:
0.977 

0.936 

0.023 

0.992 
0.977
0.936
0.023
0.992
0.977
0.977
0.977
0.977
0.936
0.936
0.936
0.936
0.023
0.023
0.023
0.023
0.992
0.992
0.992
0.992
Question 11 
6 / 6 points 
Question 11 
6 / 6 points 
Question 11
6 / 6 points
Question 11
6 / 6 points
Question 11
Question 11
Question 11Question 11Question 11
6 / 6 points
6 / 6 points
6 / 6 points
Comparing the chi square statistic in a) to the critical value in b), or the pvalue in c) to α, is it indicated that employees have a tendency to use Monday as a sick day?
Comparing the chi square statistic in a) to the critical value in b), or the pvalue in c) to α, is it indicated that employees have a tendency to use Monday as a sick day?
Question options:
Question options:
True 

False 
True
False
True
True
True
True
False
False
False
False