In this worksheet, you will explore descriptive statistics and inferential statistics using Microsoft Excel.
To explore descriptive statistics, you will use a sample (n = 30) from the larger Salkind (2017) sample data set (N = 200). To begin, open a new workbook in Excel. Copy and paste the following data into your workbook:
|
Gender
|
Grade
|
Reading Score
|
Mathematics Score
|
|
2
|
8
|
55
|
60
|
|
2
|
2
|
41
|
44
|
|
1
|
8
|
46
|
37
|
|
2
|
4
|
56
|
59
|
|
2
|
10
|
45
|
32
|
|
1
|
10
|
46
|
33
|
|
2
|
8
|
58
|
58
|
|
2
|
6
|
41
|
43
|
|
2
|
8
|
50
|
45
|
|
1
|
2
|
35
|
41
|
|
1
|
4
|
56
|
58
|
|
1
|
6
|
47
|
33
|
|
1
|
2
|
43
|
44
|
|
2
|
2
|
44
|
39
|
|
1
|
6
|
48
|
37
|
|
1
|
8
|
50
|
51
|
|
2
|
4
|
48
|
54
|
|
1
|
2
|
45
|
44
|
|
2
|
6
|
58
|
59
|
|
1
|
4
|
57
|
53
|
|
2
|
6
|
32
|
36
|
|
2
|
4
|
60
|
60
|
|
1
|
4
|
57
|
52
|
|
2
|
2
|
40
|
42
|
|
1
|
2
|
44
|
44
|
|
2
|
6
|
58
|
60
|
|
2
|
2
|
43
|
44
|
|
1
|
8
|
47
|
53
|
|
1
|
10
|
55
|
49
|
|
1
|
2
|
40
|
44
|
Note: For Gender, 1 = male; 2 = female.
Descriptive Statistics Table
For Reading Score and Mathematics Score, insert the obtained values of mean (M; rounded to one or two decimal places), median mode, range, and standard devation (SD; rounded to two decimal places) in the following table:
Table 1
Descriptive Statistics
Variable M Median Mode Range SD
_____________________________________________________________________________
Reading Score ##.## ## ## ## #.##
Mathematics Score ##.## ## ## ## #.##
_____________________________________________________________________________
To test your understanding of these descriptive statistics covered in Chapter 7 of the Salkind (2017) textbook, answer the following questions:
1. For Reading Score, what is the sum of the scores divided by the number of scores? ________
2. For Reading Score, what is the score that occurs most frequently? ________
3. For Mathematics Score, what is the score above which one-half of the scores lie? _______
4. For Reading Score, what is the difference between the highest and lowest score? ______
5. For Mathematics Score, what is the average amount that each of the individual scores varies from the mean of the set of scores? __________
Before moving on, transfer your answers over to the PSY3660 Statistics Answer Sheet (page 1).
t-Test for Independent Means in Excel
To conduct a t-test for independent means in Excel, open a new workbook and copy and paste the following data on Reading Scores:
|
Male Student
|
Female Student
|
|
35
|
32
|
|
40
|
40
|
|
43
|
41
|
|
44
|
41
|
|
45
|
43
|
|
46
|
44
|
|
46
|
45
|
|
47
|
48
|
|
47
|
50
|
|
48
|
55
|
|
50
|
56
|
|
55
|
58
|
|
56
|
58
|
|
57
|
58
|
|
57
|
60
|
Now it's time to interpret the t-test results. Answer the following questions:
1. What is the mean Reading Score for male students? ________
2. What is the mean Reading Score for female students? ________
3. What is the probability value of the t-test (p)? _______
4. Is the probability value greater than or less than .05? _____________
5. Do you reject the null hypothesis? _________
6. What is your conclusion regarding male students and female students in terms of Reading Score?
7. Report your findings in APA format:
For Reading Scores, male students (M = ) [did or did not] differ from female students (M = ), t( ) = , p = . The null hypothesis [is or is not] rejected.
Attachment:- Statistics Worksheet.rar