## Lab-Assignment 1 Statistics For Behavioral Sciences

**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. 1–5 of the book: Charlotte’s

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.