Lab Assignment #1
1. Suppose that a 4th grade language arts teacher at Zach White School in El Paso,
Texas, administers a 25-item test at the end of Chaps. 15 of the book: Charlottes
Web to test her students reading comprehension of these chapters. The data is provided below.
-Use Excel to the right of the table to find the sample size, mean, standard
deviation, and standard error of the mean for these data. Label your
answers, and round off the mean, standard deviation, and standard error
of the mean to two decimal places; use number format for these three
figures.
question 2. Suppose that the Human Resources department of your company has administered
a Morale Survey to all middle-level managers and that you have been
asked to summarize the results of the survey. You have decided to test your
Excel skills on one item to see if you can do this assignment correctly, and you
have selected item #21 to test out your skills. The data is provided below.
-Use Excel to create a table of these ratings, and at the right of the table use
Excel to find the sample size, mean, standard deviation, and standard error
of the mean for these data. Label your answers, and round off the mean,
standard deviation, and standard error of the mean to two decimal places
using number format.
question 3. Suppose that a 5th grade science teacher at Deer Creek Elementary School in
Bailey, Colorado, is using a textbook based on basic geology that typically requires about eight class days to teach each chapter. At the end of Chap. 8, the teacher gives a 15-item true-false quiz on this chapter. The data is provided below.
-Use Excel to create a table for these data, and at the right of the table, use
Excel to find the sample size, mean, standard deviation, and standard error
of the mean for these data. Label your answers, and round off the mean,
standard deviation, and standard error of the mean to three decimal places
using number format.
**attached is the photo that was not shown for each question, please make sure you send me excel sheet for assignment.
