Chapter 11 Activity Spring 2024 Things are really bad, now. No one has been able to figure out how to stop the virus from spreading or who might be more affected. You decide to take matters into your own hands and collect some sample data. Mission: You have organized your data from three different samples into a CSV spreadsheet. Now, you have to decide what type of test will be most appropriate for each sample. (Unless otherwise stated, use an alpha of 0.05.) In the first two columns, you have data representing the virus score divided into ethnicity. Use the FIRST TWO columns to answer the following research question. Your question: Is there a difference in mean virus score between the four groups? 1. What type of test will be most appropriate to answer vour question? | 2. Check the assumptions associated with the test. Which of the assumptions are met? Continue with your analysis even if the assumptions are not met. | 3. Report the appropriate test statistic and p-value to answer the research question. i'=0,5earc1 5;&'&%&*0 4. Conduct a test to determine which group(s) differ? 5. Report your results in APA format. In the next two columns, you have data from an experiment. You have recorded data of virus score before and after a proposed treatment. Use the THIRD and FOURTH columns to answer the following research question. Your question: Is the mean virus score lower after treatment? 6. What type of test will be most appropriate to answer your question? 7. Report the appropriate test statistic and p-value for checking the normality of the data. Q Search P W X V7. Report the appropriate test statistic and p-value for checking the normality of the data. Test Statistic: P-value: 8. Report the appropriate test statistic and p-value for answering the research question. Test Statistic: P-value: 9. Report your results in APA format. Q SearchThe last two columns present data displaying the virus score for two groups: those without symptoms and those with symptoms. Use the LAST TWO columns to answer the following Your question: Is there a difference in the mean virus score between the two groups? 10. What type of test will be most appropriate to answer your question? | 11. What are the independent and dependent variables? Independent Dependent Variable: Variable: 12. If applicable, report the p-value and conclusion for a test of the equality of variances. 13. Check the assumptions associated with the test. Which of the assumptions are met? 14. Report the appropriate test statistic and p-value for answering your question. o s .feBOBSAWO 12. If applicable, report the p-value and conclusion for a test of the equality of variances. P-value: Conclusion: 13. Check the assumptions associated with the test. Which of the assumptions are met? 14. Report the appropriate test statistic and p-value for answering your question. Test Statistic: P-value: 15. Report your results in APA format. Q SearchShare File Home Insert Draw P Page Layout Formulas Data Review View Help 2 AutoSum & Cut Calibri * 11 ~ A" A = = ae Wrap Text Genera Normal Bad Good Neutral Calculation AY O LO E Fill [ Copy Linked Cell Note nsert Delete Format Sort & Find & Paste LEE Merge & Center $ ~ % 9 00 20 Conditional Format as Check Cell Explanatory ... Input Clear Filter ~ Select Format Painter Formatting * Table v Styles Cells Editing Clipboard Font Alignment Number A1 X V Race F K L M N P Q R S T U V W X Y Z AA AB AC B D E G H Race Score Before After Symptom: Virus Score 2 White 26 54 39 N 18 3 White 57 56 No 23 4 White 69 0 54 No 13 5 White 41 14 63 No 20 6 White 56 50 42 No 16 7 White 45 67 45 No 11 8 White 45 71 43 No 22 9 White 51 80 47 No 14 10 White 49 27 41 No 16 11 White 60 87 43 No 3 12 White 57 11 53 No 17 13 White 54 47 44 No 13 14 White 72 32 46 No 14 15 White 53 11 56 No 11 16 White 54 23 25 No 15 17 White 48 14 48 No 25 18 White 46 48 36 No 27 19 White 71 56 41 No co 20 White 57 95 28 No 22 21 White 46 34 37 No 27 22 White 62 16 33 No 28 23 White 75 71 47 No 17 24 White 50 53 46 No 10 25 White 42 95 42 No 21 26 White 54 o 45 No 24 27 White 56 68 31 No 28 White 48 57 42 No 16 29 White 72 70 38 No 13 30 White 38 13 53 No 7 31 White 50 47 46 No 19 32 White 63 53 40 No 15 33 White 46 69 56 No 10 34 White 45 66 40 No 20 35 White 45 102 50 No 8 36 White 62 39 43 No 16 37 Black -8 55 42 No 10 38 Black 13 56 46 No 18 11.2 Chapter 11 Activity Data + 100% Ready 3:55 PM Q Search 3/5/2024Share File Home Insert Draw Page Layout Formulas Data Review View Help AutoSum & Cut ab Wrap Text General Normal Bad Good Neutral Calculation IX AY O Calibri 11 ~ A A Fill [A Copy Explanatory ... Input Linked Cell Note Sort & Find & Check Cell t Delete Format Paste Conditional Format as Clear BIU~ ~ SAV CE Merge & Center $ % 9 Filter ~ Select Formatting Table v Format Painter Styles Cells Editing Clipboard Font Alignment Number A1 X V Race G H K M N P Q R S T U V W X Z AA AB AC C D 38 Black 15 56 46 NO 18 39 Black 16 106 47 No 14 40 Black 42 25 47 No 18 41 Black 17 99 46 No 18 42 Black -11 91 55 No 10 43 Black 25 82 51 No 7 44 Black -3 47 34 No 6 45 Black 11 8 48 No 10 46 Black 16 76 38 No 12 47 Black 19 102 31 No 7 48 Black 12 85 40 No 16 49 Black 16 0 19 No 10 50 Black 5 27 48 No 18 51 Black 5 72 53 No 19 52 Black 12 32 52 No 14 53 Black 23 54 51 No 18 54 Black 29 27 53 No 11 55 Black 11 31 45 NO 9 56 Black 24 50 41 No 12 57 Black 12 92 43 No 15 58 Black -2 59 41 No 9 59 Black -1 40 No 16 60 Black 18 53 44 No 13 61 Black -2 48 46 No 18 62 Black 10 116 41 No 16 63 Black -4 6 39 No 18 64 Black 9 81 36 No 16 65 Black 21 63 32 No 11 66 Black 21 28 25 No 17 67 Black 13 79 49 No 19 68 Black 42 91 50 No 10 69 Black 2 92 28 No 20 70 Black 9 26 47 No 14 71 Black 15 108 48 No 27 72 Hispanic 48 92 42 No 22 73 Hispanic 30 77 55 No 19 74 Hispanic 48 0 47 No 13 75 Hispanic 42 63 47 NO 16 11.2 Chapter 11 Activity Data + 100% Ready 3:56 PM Q Search P W X V 3/5/2024 1Share File Home Insert Draw Page Layout Formulas Data Review View Help AutoSum ~ & Cut de Wrap Text General Normal Bad Good Neutral Calculation TIX AY O Calibri 11 ~ A" A Fill [B) Copy Sort & Find & Paste CEE Merge & Center $ % " Conditional Format as Check Cell Explanatory ... Input Linked Cell Note nsert Delete Format BIU~ ~ MAY Clear Filter ~ Select Format Painter Formatting * Table Styles Cells Editing Clipboard Font Alignment Number A1 X V Race S T U V W X Z AA AB AC C H O P Q R D E F G K M N 75 Hispanic 42 47 No 76 Hispanic 44 24 52 No 19 77 Hispanic 47 45 29 No 10 78 Hispanic 31 90 56 No 15 79 Hispanic 41 53 52 No 20 80 Hispanic 40 84 42 No 10 81 Hispanic 41 31 41 No 11 82 Hispanic 41 81 51 Yes 35 83 Hispanic 37 65 33 Yes 22 84 Hispanic 31 4 43 Yes 36 85 Hispanic 43 102 42 Yes 32 86 Hispanic 53 60 45 Yes 50 87 Hispanic 47 49 41 Yes 18 88 Hispanic 50 81 43 Yes 46 89 Hispanic 57 52 46 Yes 54 90 Hispanic 20 46 49 Yes 22 91 Hispanic 35 18 38 Yes 40 92 Hispanic 55 41 Yes 42 93 Hispanic 63 4 57 Yes 60 94 Hispanic 59 30 39 Yes 37 95 Hispanic 56 11 28 Yes 36 96 Hispanic 53 6 35 Yes 35 97 Hispanic 53 70 37 Yes 51 98 Hispanic 45 2 32 Yes 38 99 Hispanic 40 92 41 Yes 11 100 Hispanic 34 62 35 Yes 54 101 Hispanic 71 88 12 Yes 18 102 Hispanic 53 Yes 31 103 Hispanic 47 Yes 59 104 Hispanic 44 Yes 39 105 Hispanic 74 Yes 40 106 Hispanic 61 Yes 50 107 Other 65 Yes 43 108 Other 37 Yes 32 109 Other 42 Yes 20 110 Other 36 Yes 39 111 Other 40 Yes 70 112 Other 40 Yes 68 11.2 Chapter 11 Activity Data + 100% Ready 3:56 PM Q Search W X V 3/5/2024 41Share File Home Insert Draw Page Layout Formulas Data Review View Help AutoSum ~ Normal Bad Good Neutral Calculation TIX AY O & Cut Calibri 11 ~ A" A de Wrap Text General Fill Linked Cell nsert Delete Format Sort & Find & [) Copy Conditional Format as Check Cell Explanatory ... Input Note Clear Paste BIU~ ~MAY CE E Merge & Center $ % " Filter ~ Select Formatting * Table Format Painter Cells Editing Number Styles Clipboard Font Alignment A1 X V Race AB AC M N O P Q R S T U V W X Z AA B C D F F G H K 112 Other 40 Yes bo 113 Other 54 Yes 49 114 Other 48 Yes 37 115 Other 57 Yes 33 116 Other 40 Yes 33 117 Other 55 Yes 49 118 Other 57 Yes 33 119 Other 38 Yes 51 120 Other 48 Yes 29 121 Other 55 Yes 30 122 Other 50 Yes 44 123 Other 48 Yes 37 124 Other 46 Yes 46 125 Other 45 Yes 25 126 Other 49 Yes 27 127 Other 46 Yes 30 128 Other 49 Yes 38 129 Other 42 Yes 44 130 Other 42 Yes 41 131 Other 44 Yes 50 132 Other 69 Yes 29 133 Other 41 Yes 35 134 Other 60 Yes 33 135 Other 52 Yes 43 136 Other 22 Yes 45 137 Other Yes 55 138 Other 63 Yes 33 139 Other 62 Yes 34 140 Other 69 Yes 31 141 Other 60 Yes 29 142 Yes 37 143 Yes 37 144 Yes 41 145 Yes 40 146 Yes 22 147 Yes 56 148 Yes 34 149 Yes 24 11.2 Chapter 11 Activity Data + 100% Ready 3:56 PM Q Search W X V 3/5/2024 41Share Review Help File Home Insert Draw Page Layout Formulas Data View AutoSum ~ Good Neutral Calculation TIX AY O Normal Bad Fill & Cut Calibri 11 ~ A" A de Wrap Text General Note nsert Delete Format Sort & Find & [) Copy Conditional Format as Check Cell Explanatory ... Input Linked Cell Clear Filter ~ Select Paste BIU~ ~ MAY CE E Merge & Center $ % " Formatting * Table Cells Editing Format Painter Styles Number Clipboard Font Alignment A1 X V fc Race AA AB AC N O P Q R S T U V W X Z K M C D F F G H 125 Other 15 Yes 25 126 Other 49 Yes 27 127 Other 46 Yes 30 128 Other 49 Yes 38 129 Other 42 Yes 44 130 Other 42 Yes 41 131 Other 44 Yes 50 132 Other 69 Yes 29 133 Other 41 Yes 35 134 Other 60 Yes 33 135 Other 52 Yes 43 136 Other 22 es 45 137 Other 58 Yes 55 138 Other 63 Yes 33 139 Other 62 Yes 34 140 Other 69 Yes 31 141 Other 60 Yes 29 142 Yes 37 143 Yes 37 144 Yes 41 145 Yes 40 146 Yes 22 147 Yes 56 148 Yes 34 149 Yes 24 150 Yes 35 Yes 41 Yes 41 Yes 25 Yes 29 Yes 26 Yes 32 157 Yes 45 158 Yes 33 159 Yes 13 160 Yes 38 161 Yes 19 162 + 100% 11.2 Chapter 11 Activity Data 3:56 PM Ready W X V 3/5/2024 41 Q Search