Question: Use Excel data for problems 1-3 1.The administrator randomly selected 15 students, and randomly assigned them to one of three groups, a powerpoint presentation created
Use Excel data for problems 1-3
1.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. Use excel data analysis at =0.01 to decide which tutorial to use?
PowerPoint AuthorGen ABC
Tutorial Tutorial Tutorial
68 79 75
85 86 83
91 82 78
87 92 86
88 91 81
a. F=0.834 b. F=0.834 >Fcrit 0.692 c. F=0.834 d. F=0.684 e. F=0.684 < Fcrit 6.927 f. F=0.834 > Fcrit 0.388 HINT: For a choice to be correct, each part of the choice must be correct. If two choices seem to be equally correct, choose the choice that does not depend on the sample to sample variation 2.What are the hypotheses? a. H0: all three populations means are equal; H1: at least two population means are different b. H0: at least two populations means are different; H1: all three population means are equal c. H0: AuthoGen is best because it has the highest mean score; H1: All three population means are equal d. H0: all three population means are equal; H1: AuthorGen is best because it has the highest mean score 3.Based on the ANOVA results from questions 1, what is your conclusion? a. reject Ho: AuthoGen Tutorial is best because it has the highest mean score. b. do not reject H0: mean test results are equal, choose the least expensive tutorial c. do not reject H0: mean test results are unequal, AuthorGen Tutorial is the best choice because is has the highest mean score d. reject H0: mean test results are equal, choose the least expensive tutorial. Use excel data for questions 4-7 4.A study was performed whether there was a relationship between the type of animals preferred and the gender of the owner. They data from randomly chosen pet owner who owned who owned either one cat or dog. Use the excel, make a 2x2 pivot table counting by kind of pets and gender of owner, and use for the next 3 questions Gender type female cat male dog male dog male dog female cat female cat female cat female cat male dog female dog female dog male dog male cat male cat female cat female cat female cat female cat female dog male cat male dog male cat male dog male dog female dog male cat female cat male cat female dog female cat female dog male cat male dog male dog male dog male cat female dog female cat male dog female cat female cat male cat female cat male dog female dog male cat female dog male cat male cat male dog A.Count of type Row Labels cat dog grand total Female 15 9 24 Male 12 14 26 grand total 27 23 50 B Count of type Row Labels cat dog grand total male 15 9 24 female 12 14 26 grand total 27 23 50 C Count of type Row Labels cat dog grand total Female 9 15 24 Male 14 12 26 grand total 23 27 50 D Count of type Row Labels cat dog grand total male 9 15 24 female 14 12 26 grand total 23 27 50 5.Perform the chi square test of independence at =0.01 of owner gender and type of type as summarised by the pivot table from problem 4. The chi square statistics is a. 1.34 b. 1.33 c. 1.35 d. 1.32 6.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 https://people.richland.edu/james/lecture/m170/tbl-chi.html a. 5.024 b. 6.635 c. 7.378 d. 9.210 7.You conclude that? a. there is a relationship because the chi square statistic exceeds the critical value 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 exceeds the critical value d. there is a relationship because the chi square the chi statistic is less than the critical value Use Excel data for Questions 8-11 8.A human resource 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. Use Excel data below Days Sick Monday 12 Tuesday 9 Wednesday 11 Thursday 10 Friday 9 Saturday 9 Test H0:Monday=tuesday=Wednesday=Thursday=Friday=Saturday. Use Excel for the next 3 questions. The chi statistics is: a. 0.81 b. 0.83 c. 0.82 d. 0.80 HINT: a preference for a day to take sick leave will be indicated by dependence 9.Continuing, determine the critical value at the significance level of 0.05 using one of a. 11.070 b. 12.592 c. 1.145 d. 1.635 HINT: you can check your results by comparing the results of multiple methods 10.Continuing, find the pvalue using the chi square statistics in a) and one of the Excel function CHISQ.DIST.RT,=CHISQ.DIST, or =CHIDIST(). The pvalue is a. 0.977 b. 0.023 c. 0.936 d. 0.992 HINT: You can check your results by comparing the results of multiple methods 11.Comparing the chi square statistics 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? a. true b. false
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help