Please use the data in the attached file.
Calculate all measures of central tendency for data that are interval or ratio in measurement.
Calculate the standard deviation for data that are interval or ratio in measurement.
Assume this is a sample of students, calculate a t-test that compares boys and girls on the number of absences (you can assume equal variances). Is there a significant difference in absences between gender?
Assume this is a sample of students and that students receive an A grade if their score is 90 or above. Calculate a chi-square test to determine whether girls achieve more A grades than boys in math. Calculate a chi-square test to determine whether girls achieve more A grades than boys in reading.
This solution provides a step by step method for the calculation of a chi square test statistic for the number of absences and gender and a two-sampled t-test. Formulas for the calculations and an interpretation of the results are also included. An interactive Excel sheet is included and a Word document, containing the compete solution. The user can edit the inputs in the spreadsheet and obtain the complete results for a new set of data in a future problem.