Descriptive
Statistics:
I am used
both collected data and created data on 497 people to show the descriptive
statistics of a sample of Georgia.gov users such as age, gender, salary , and
if they are a state employee. I am also showing statistics of how many online
applications they use and visits to the portal per week. I will try and see who
is the primary audience and if there is any relationship between number of
times a user visited a site and the number or applications used. This data will
help us better understand who is coming to the portal and what services they
are using. We will then be able to improve the portal so it can provide more services
to the people who are needing them the most.
The first category
was age. Age was categorized into four groups: (1) if 20 or younger, (2) if 21
to 40, (3) if 41 to 60, (4) if 61 or older. Age group two has the highest frequency
of usage. This age group (age 21-40) tends to be the younger working class and
have young families. This shows that the portal is being used by younger
business people who tend to be more familiar and comfortable with technology.
None of the descriptive statistics were very useful in this case.
|
Age Group |
Frequency |
|
1 |
125 |
|
2 |
241 |
|
3 |
93 |
|
4 |
38 |
Gender was the
next category studied. All that can be displayed is number of males and
females.
Salary was the
next category analyzed. The most useful statistics were:
Mean -
$55,721
Median - $54,200
Min - $10,100
Max - $130,700
The next
section of data I analyzed was how many are users are State Employees?
After all the general data was analyzed, I wanted to know if there was any correlation between number of visits per week and the number of online applications used.
As shown in the scatter chart below, surprisingly there is almost no correlation between number of visits per week and the number of online applications used.
|
|
Apps used |
# of Visits a week |
|
Apps used |
1 |
|
|
# of Visits a week |
0.0343052 |
1 |
Below are
the descriptive statistics for each of the categories used.
|
Age |
|
Gender |
|
OwnHome |
|
|
|
|
|
|
|
|
|
Mean |
2.0885319 |
Mean |
1.4788732 |
Mean |
1.4688128 |
|
Standard Error |
0.0385375 |
Standard Error |
0.0224301 |
Standard Error |
0.0224069 |
|
Median |
2 |
Median |
1 |
Median |
1 |
|
Mode |
2 |
Mode |
1 |
Mode |
1 |
|
Standard Deviation |
0.85913571 |
Standard Deviation |
0.50005679 |
Standard Deviation |
0.49952921 |
|
Sample Variance |
0.73811417 |
Sample Variance |
0.25005679 |
Sample Variance |
0.24952943 |
|
Kurtosis |
-0.2202968 |
Kurtosis |
-2.0008705 |
Kurtosis |
-1.9923159 |
|
Skewness |
0.55677631 |
Skewness |
0.08483885 |
Skewness |
0.12537057 |
|
Range |
3 |
Range |
1 |
Range |
1 |
|
Minimum |
1 |
Minimum |
1 |
Minimum |
1 |
|
Maximum |
4 |
Maximum |
2 |
Maximum |
2 |
|
Sum |
1038 |
Sum |
735 |
Sum |
730 |
|
Count |
497 |
Count |
497 |
Count |
497 |
|
Confidence Level(95.0%) |
0.0757169 |
Confidence Level(95.0%) |
0.0440704 |
Confidence Level(95.0%) |
0.0440244 |
|
Married |
|
Salary |
|
Children |
|
|
|
|
|
|
|
|
|
Mean |
1.5171062 |
Mean |
55721.328 |
Mean |
0.9436697 |
|
Standard Error |
0.02243753 |
Standard Error |
1335.20559 |
Standard Error |
0.04725297 |
|
Median |
2 |
Median |
54200 |
Median |
1 |
|
Mode |
2 |
Mode |
46600 |
Mode |
0 |
|
Standard Deviation |
0.5002109 |
Standard Deviation |
29766.4015 |
Standard Deviation |
1.05343384 |
|
Sample Variance |
0.25021094 |
Sample Variance |
886038657 |
Sample Variance |
1.10972285 |
|
Kurtosis |
-2.0033642 |
Kurtosis |
-0.63563 |
Kurtosis |
-0.7469306 |
|
Skewness |
-0.0686579 |
Skewness |
0.3805944 |
Skewness |
0.74652423 |
|
Range |
1 |
Range |
120600 |
Range |
3 |
|
Minimum |
1 |
Minimum |
10100 |
Minimum |
0 |
|
Maximum |
2 |
Maximum |
130700 |
Maximum |
3 |
|
Sum |
754 |
Sum |
27693500 |
Sum |
469 |
|
Count |
497 |
Count |
497 |
Count |
497 |
|
Confidence Level(95.0%) |
0.0440842 |
Confidence Level(95.0%) |
2623.3565 |
Confidence Level(95.0%) |
0.0928407 |
|
Apps used |
|
# of Visits a week |
|
State Employee? |
|
|
|
|
|
|
|
|
|
Mean |
12.940423 |
Mean |
21.14268 |
Mean |
1.5727606 |
|
Standard Error |
0.3386739 |
Standard Error |
0.5474949 |
Standard Error |
0.0144871 |
|
Median |
12.878222 |
Median |
20.651208 |
Median |
1.6159246 |
|
Mode |
4.7445959 |
Mode |
33.328759 |
Mode |
2 |
|
Standard Deviation |
7.5501649 |
Standard Deviation |
12.205589 |
Standard Deviation |
0.3229144 |
|
Sample Variance |
57.005593 |
Sample Variance |
148.9764 |
Sample Variance |
0.1042746 |
|
Kurtosis |
-1.1354206 |
Kurtosis |
-1.0018941 |
Kurtosis |
-1.21807 |
|
Skewness |
0.09538646 |
Skewness |
0.109323 |
Skewness |
-0.2639536 |
|
Range |
26.579761 |
Range |
63.759783 |
Range |
1 |
|
Minimum |
0.1458476 |
Minimum |
1.2402411 |
Minimum |
1 |
|
Maximum |
26.7256081 |
Maximum |
65 |
Maximum |
2 |
|
Sum |
6431.3843 |
Sum |
10507.759 |
Sum |
781.63982 |
|
Count |
497 |
Count |
497 |
Count |
497 |
|
Confidence Level(95.0%) |
0.6654054 |
Confidence Level(95.0%) |
1.075695 |
Confidence Level(95.0% |
0.0284597 |