Question

• 1.) Using the level of significance of .10, test the claim that the average number of classes skipped by CLC students is less than 5. The sample data used to test the claim is as follows:
  2, 3, 6, 4, 1, 1, 7, 4, 3, 2, 0, 5, 0, 1, 2, 4, 0, 3, 6, 1, 3, 2, 2

  • Find the mean (=average(data))

  • Find sample standard deviation (=stdev.s(data))

  • Find the test value using TTest on your calculator.

  • Find the p-value using T.dist on Excel

  • Find the critical value using T.inv on Excel

  • State conclusion based on p-value

  • Translate conclusion (use complete sentence)

• I NEED HELP SOLVING THIS ON AN EXCEL SHEET USING EXCEL FUNCTIONS PLEASE! IM REALLY CONFUSED!

Answer 1

Note: the letters in the formula indiactes the column numer & numbers indicates the row numbers