Statistics and Data Analysis - Doc

STATISTICS AND DATA ANALYSIS- EXCEL
REPORT

TABLE OF CONTENTS
SECTION 1.....................................................................................................................................4
A) Description about the data set 1..............................................................................................4
B) Collection of data for dataset 2...............................................................................................4
SECTION 2.....................................................................................................................................4
Proportion of free phone app.......................................................................................................4
SECTION 3.....................................................................................................................................5
Price distribution of paid app.......................................................................................................5
Calculation of Outlier..................................................................................................................6
SECTION 4.....................................................................................................................................7
Distribution of paid app of different categories...........................................................................7
SECTION 5...................................................................................................................................10
Relation between rating and review..........................................................................................10
SECTION 6...................................................................................................................................11
Relation between the different country student and the communication application use by them
...................................................................................................................................................11
REFERENCES..............................................................................................................................................12
Table 1Free and paid apps proportion.............................................................................................4
Table 2Percentage share of paid and free apps................................................................................5
Table 3Statistical calculation...........................................................................................................5
Table 4Inputs for calculation...........................................................................................................6
Table 5Category mix of apps...........................................................................................................7
Table 6Proportion of communication, game and tools apps...........................................................7
Table 7T test for communication and game....................................................................................8
Table 8T test for games and tools....................................................................................................8
Table 9T test for communication and tools.....................................................................................9
Table 10Correlation between variables.........................................................................................10
Table 11Coorelation between country and app use.......................................................................11

Figure 1Free and paid apps total......................................................................................................5
Figure 2Outlier.................................................................................................................................6
Figure 3Boxplot chart......................................................................................................................7
Figure 4Regression chart...............................................................................................................10
Figure 5Communication application use across nations...............................................................11

SECTION 1
A) Description about the data set 1
The data set are combined of the various mobile application related to the different field
such as medical, tools, communication, health, games, video players, education, travel and local,
Arcade, entertainment, photography, news and magazines etc. The data set provide the detail
information about the collected data, their users, content rating, price, last update, current
version, android version etc. The data set also shows the reviews and ratings of customer to
understand the uses and popularity of different category of application.
The presented dataset are secondary data which are collected from the different sources
such as various sites, users etc. There are different types of variables such as categorical variable,
continues variable etc. All the text variables are the part of categorical variable such as different
category of application; tools, medical, education, productivity, travel and local, family games
and their types such as free or paid, content rating etc. (Types of Variables in Statistics and
Research, 2019). In continuous variable all the numeric variables are included such as price of
the application, last updated time, rating of users etc.
B) Collection of data for dataset 2
Data are collected by interviewing the students from the different country that what kind
of application is used by them for communication. The limitation of the dataset while collecting
the data are:
 Time constraints
 Limited respondents etc.
It is based on primary method of data collection and all the variables are categorical variable.
SECTION 2
Proportion of free phone app
Table 1Free and paid apps proportion
Type
Free 3718
Paid 282
Total Result 4000

Table 2Percentage share of paid and free apps
Free 93%
Paid 7%
Total 100%
Figure 1Free and paid apps total
SECTION 3
Price distribution of paid app
Table 3Statistical calculation
Min 0
Q1 1.99
Median 2.99
Q3 4.99
Max 39.99

Calculation of Outlier
Table 4Inputs for calculation
Inputs for calculation Data
Hidden 1.99
Lower 1
Upper 2
Whisker top 35
Whisker bottom 1.99
Figure 2Outlier

Figure 3Boxplot chart
SECTION 4
Distribution of paid app of different categories
Table 5Category mix of apps
Category
COMMUNICATION 10
GAME 29
TOOLS 30
Total Result 69
Pivot table
Table 6Proportion of communication, game and tools apps
COMMUNICATION 14%
GAME 42%

TOOLS 43%
Total 100%
Interpretation: it can be interpreted from the table the proportion of game application are 14%,
tool application is 43% and the communication application are 14%.
Table 7T test for communication and game
t-Test: Two-Sample Assuming Equal Variances
COMMUNICATION GAME
Mean 0.0259559676 0.1336500579
Variance 0.0768208658 0.9822269168
Observations 863 863
Pooled Variance 0.5295238913
Hypothesized Mean Difference 0
df 1724
t Stat -3.0742522011
P(T<=t) one-tail 0.0010717051
t Critical one-tail 1.6457379618
P(T<=t) two-tail 0.0021434103
t Critical two-tail 1.9613409621
Interpretation: There is no significance difference between the communication and game
application in term of price.
Table 8T test for games and tools
t-Test: Two-Sample Assuming Equal Variances
GAME TOOLS
Mean
0.133650057
9
0.106512166
9
Variance 0.982226916 0.382518563

8 4
Observations 863 863
Pooled Variance
0.682372740
1
Hypothesized Mean Difference 0
df 1724
t Stat
0.682426150
4
P(T<=t) one-tail
0.247530602
1
t Critical one-tail
1.645737961
8
P(T<=t) two-tail
0.495061204
3
t Critical two-tail
1.961340962
1
Interpretation: There is no significance difference between the game and tool application in
term of price.
Table 9T test for communication and tools
t-Test: Two-Sample Assuming Equal Variances
COMMUNICATION TOOLS
Mean 0.0259559676 0.1065121669
Variance 0.0768208658 0.3825185634
Observations 863 863
Pooled Variance 0.2296697146
Hypothesized Mean
Difference 0
df 1724
t Stat -3.4917046591

P(T<=t) one-tail 0.0002460227
t Critical one-tail 1.6457379618
P(T<=t) two-tail 0.0004920454
t Critical two-tail 1.9613409621
Interpretation: There is no significance difference between the communication and tool
application in term of price.
SECTION 5
Relation between rating and review
Table 10Correlation between variables
Regression Statistics
Multiple R 0.0816607397
R Square 0.0066684764
Adjusted R Square 0.0064200193
Standard Error 3009026.96996435
Observations 4000
Interpretation: It can be interpreted from the table that the relation between the variable is too
low because it is lower than the .05 which indicate low correlation.
Figure 4Regression chart

SECTION 6
Relation between the different country student and the communication application use by them
Table 11Coorelation between country and app use
Country
Communication
Application
Country 1
Communication Application 0.0313112146 1
In d ia
In d ia
In d ia
K orea
K orea
UK
UK
UK
K u w a it
K u w a it
0123456
1
2
3
1
2
4
5
2
3
5
4
1
2
1
4
5
1
3
1
2
C o m m u n ic a tio n A p p lic a tio n
Figure 5Communication application use across nations
In above chart number from 1 to 5 denotes which are given below.
1 = FB messenger
2 = WhatsApp
3 = Viber
4 = Line
6 = We chat
Interpretation: It can be interpreted from the table that the correlation between the variables is
low because it below to the 0.5. The correlation of the variable is .03. The result indicate that all
the country uses all kind of communication application.

REFERENCES
Online
Types of Variables in Statistics and Research. 2019. [Online]. Available through:
<https://www.statisticshowto.datasciencecentral.com/probability-and-statistics/types-of-
variables/>