Stat excel hw

Example Output for HW #1, Excel Portion

1. Find the mean, median, and standard deviation.

RDPct

Mean 8.492

Standard Error 0.2801

Median 8.05

Mode 6.5 Standard Deviation 1.980604

Sample Variance 3.922792

Kurtosis 0.419288

Skewness 0.854601

Range 8.3

Minimum 5.2

Maximum 13.5

Sum 424.6

Count 50

2. The data is symmetric because the mean of 8.492 is almost equal to the median of 8.05.

(Note: It could also be argued here that the data is slightly skewed to the right).

3. Frequency Histogram

0

2

4

6

8

10

12

14

6 7 8 9 10 11 12 13 14 More

F re

q u

e n

cy

R & D Percent

Histogram for R & D Percentages

Frequency