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