2. Use Excel to answer the following question. Be sure to turn in a screenshot of...

Transcribed Image Text:

2. Use Excel to answer the following question. Be sure to turn in a screenshot of your results from Excel (or upload your excel file) in order to receive credit. We want to know if students who ate a healthful breakfast perform differently on a quiz than a group of students who skipped breakfast. Our participants' scores are presented below: Sample 1: ate oatmeal before the quiz: 9, 11, 12, 8, 10, 6, 8, 10, 12 Sample 2: skipped breakfast before the quiz: 8, 5, 6, 7, 8, 10, 11, 6, 5 Use Excel to answer the following questions: a. What is the obtained value of t? b. Can we reject the null hypothesis? c. Create a bar graph comparing the mean of Sample 1 to the mean of Sample 2. Be sure to include either a screenshot of your graph or your excel file when you turn in your work! 2. Use Excel to answer the following question. Be sure to turn in a screenshot of your results from Excel (or upload your excel file) in order to receive credit. We want to know if students who ate a healthful breakfast perform differently on a quiz than a group of students who skipped breakfast. Our participants' scores are presented below: Sample 1: ate oatmeal before the quiz: 9, 11, 12, 8, 10, 6, 8, 10, 12 Sample 2: skipped breakfast before the quiz: 8, 5, 6, 7, 8, 10, 11, 6, 5 Use Excel to answer the following questions: a. What is the obtained value of t? b. Can we reject the null hypothesis? c. Create a bar graph comparing the mean of Sample 1 to the mean of Sample 2. Be sure to include either a screenshot of your graph or your excel file when you turn in your work!

Answer rating: 100% (QA)

at value 0128253926 pvalue 0899546262 You can round off bUsing a significanc... View the full answer