pexels-kulbir-11079217
pexels-kulbir-11079217
pexels-kulbir-11079217
Module 4 Excel Exercise – t-test, and ANOVA Part I: If you have not already done
Home » Social work  »  Module 4 Excel Exercise – t-test, and ANOVA Part I: If you have not already done
Module 4 Excel Exercise – t-test, and ANOVA Part I: If you have not already done
Module 4 Excel Exercise – t-test, and ANOVA Part I: If you have not already done so, watch the following tutorials: Running a t-test in Excel Running ANOVA in Excel Download the two spreadsheets named t-test Excel Tutorial Spreadsheet.xlsx, and ANOVA Excel Tutorial Spreadsheet.xlsx Part II: Using the data in the INDEPENDENT tab in the t-test Excel Spreadsheet, run an independent samples t-test to see if there is a mean difference in Age First Diagnosed for Males and Females. Using the data in the PAIRED tab in the t-test Excel Spreadsheet, run a paired samples t-test to see if there is a mean difference in pretest and posttest scores for student who were enrolled in a statistics course. Using the data in the ANOVA Excel Spreadsheet, run an analysis of variance to see if there is a mean difference in Age First Diagnosed for the three Race categories listed. *MAKE SURE YOU ANSWER THE QUESTIONS IN THE BOXES ON EACH SPREADSHEET. You can type your responses directly in the boxes. When you have finished, please save and upload both spreadsheets to Excel Assignment 4 in Blackboard by the end of Module 4. Please note: unlike previous Excel exercises where the dataset in the Excel exercises was the same as the dataset in the tutorials, this tutorial may have a different dataset than the one shown in the tutorial. The processes for running the t-tests and ANOVA are the same as shown in the video. ANOVA Excel Tutorial Spreadsheet_.xlsx t-test Excel Tutorial Spreadsheet_.xlsx Excel Exercise Module 4-t-test ANOVA.docx

Leave a Reply

Your email address will not be published.

Scan the code