Create excel chart using data
a. Calculate all measures of central tendency for data that are interval or ratio in measurement
b. Calculate the standard deviation for data that are interval or ratio in measurement
c. 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?
d. 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.
The solution provides step by step method for the calculation of Descriptive statistics, test statistic for population mean and chi square test for association. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.