Descriptive Statistics with EXCEL

 

 

 

 

 

 

 

 

 

 

 

U.S. PRESIDENTS

 

 

 

 

 

 

A

B

 

 

 

 

 

 

1

President

Age at Death

Describe Data

 

 

 

2

Washington

67

Use the Descriptive Statistics Tool

 

3

Madison

85

 

 

 

 

 

 

4

Jackson

78

1-Variable Statistics

 

5

Tyler

71

Find descriptive statistics for the presidents data:

 

6

Fillmore

74

Input data in columns A and B.

 

 

 

7

Lincoln

56

1.  Select Tools.

 

 

 

 

8

Hayes

70

2.  Select Data Analysis.

 

 

 

9

Cleveland

71

3.  Select Descriptive Statistics and press OK.

 

 

10

Roosevelt

60

4. Determine Input Range: B2:B37, highlight data with cursor.

 

11

Harding

57

5.  Choose Output Range if you like the output on the same

 

12

Roosevelt

63

spreadsheet.  For example, input A40:B60. For a new sheet choose

 

13

Kennedy

46

New Work Sheet Ply.

 

15

Monroe

73

6. Check Summary Statistics and click OK.

 

 

16

Van Buren

79

You will see the entire Summary Statistic below. 

 

17

Polk

53

 

 

 

 

 

 

18

Pierce

64

 

 

 

 

 

 

19

Johnson

66

 

 

 

 

 

 

20

Garfield

49

 

 

 

 

 

 

21

Harrison

67

 

 

 

 

 

 

22

Taft

72

 

Age at Death

 

 

 

23

Coolidge

60

 

 

 

 

 

 

24

Truman

88

 

Mean

69.02777778

 

 

 

25

Johnson

64

 

Standard Error

1.870186355

 

 

 

26

Jefferson

83

 

Median

67.5

 

 

 

27

Adams

80

 

Mode

67

 

 

 

28

Harrison

68

 

Standard Deviation

11.22111813

 

 

 

29

Taylor

65

 

Sample Variance

125.9134921

 

 

 

30

Buchanan

73

 

Kurtosis

-0.498887188

 

 

 

31

Grant

63

 

Skewness

0.079131592

 

 

 

32

Arthur

56

 

Range

44

 

 

 

33

McKinley

58

 

Minimum

46

 

 

 

34

Wilson

67

 

Maximum

90

 

 

 

35

Hoover

90

 

Sum

2485

 

 

 

36

Eisenhower

78

 

Count

36

 

 

 

37

Nixon

81

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2-Variable Statistics

 

 

 

 

 

 

Find descriptive statistics for the two sections of the statistics class:

 

 

 

 

 

 

 

 

 

 

 

A

B

 

 

 

 

 

 

1

Section 1   Grade

Section 2   Grade

Input data in columns A and B.

 

 

 

2

90

99

1.  Select Tools.

 

 

 

 

3

89

98

2.  Select Data Analysis.

 

 

 

4

66

100

3.  Select Descriptive Statistics and press OK.

 

 

5

77

100

4. Determine Input Range: A2:B31, highlight data with cursor.

 

6

99.9

99.9

5.  Choose Output Range if you like the output on the same

 

7

66

100

spreadsheet.

 

 

 

 

8

57

98

For example, input A40:B60. For a new sheet choose New Work

 

9

44

44

Sheet Ply.

 

 

 

 

10

66

99

6. Check Summary Statistics and click OK.

 

 

11

78

33

 

 

 

 

 

 

12

88

88

You will see the entire Summary Statistic below. 

 

13

99

99

 

 

 

 

 

 

14

97

97

 

 

 

 

 

 

15

100

100

 

 

 

 

 

 

16

99

95

 

 

 

 

 

 

17

99

59

 

Section 1   Grade

 

Section 2   Grade

 

 

18

97

47.9

 

 

 

 

 

 

19

88

100

 

Mean

81.39666667

Mean

78.8

 

20

92

100

 

Standard Error

3.147976848

Standard Error

4.744320258

 

21

93

28.2

 

Median

88

Median

96

 

22

54

98

 

Mode

66

Mode

100

 

23

68

86

 

Standard Deviation

17.2421793

Standard Deviation

25.98571225

 

24

84

56

 

Sample Variance

297.2927471

Sample Variance

675.2572414

 

25

91

28

 

Kurtosis

0.195937297

Kurtosis

-0.955296356

 

26

76

97

 

Skewness

-0.994090684

Skewness

-0.837602198

 

27

73

55

 

Range

62

Range

72

 

28

87

76

 

Minimum

38

Minimum

28

 

29

92

89

 

Maximum

100

Maximum

100

 

30

94

51

 

Sum

2441.9

Sum

2364

 

31

38

43

 

Count

30

Count

30

 

 

 

 

 

 

 

 

 

 

 

copyright 2004 Elisabeth Knowlton