Detailed Report on Mobile Phone Usage, Spending, and Affordability

This report provides a comprehensive analysis of mobile phone usage and spending habits among different user groups. It examines various factors influencing mobile phone bills, including call frequency, messaging, and data consumption. The analysis, conducted using Excel, categorizes users by gender and geo tribes (Achievers, Independents, Suburban Splendour) to understand lifestyle-related usage patterns. The report also investigates mobile phone affordability by comparing user income and expenses, determining average monthly bill costs, and assessing the prevalence of mobile payment adoption. Furthermore, it evaluates whether users are leveraging smartphones for work purposes and identifies relationships between usage patterns and bill amounts. The analysis concludes by considering the adequacy of the sample size (150 users) and suggesting criteria for expanding the dataset to enhance accuracy and precision in future analyses. The findings highlight the diverse ways individuals utilize mobile phones and the factors driving their associated costs.

Q1. An Overall View of Mobile Phone spends per month.
This data is all about the analysis of the use of the mobile devices by the variety of the users. There is a
different type of the user have the different use of the mobile devices, by that there is the different
impact on the cost of the monthly income. The analysis is done with the help of the excel. The data set is
provided over the different user, the category of the user is divided into the two major category, one is
male and other is female. Other than this it provides the details about the income of the user and the
expenses of the users. The user is divided into the different type of the geo trades.
This is all about the different amount spend by the user over the smartphones, there is a different type
of the user, for the calculate the values there is the use of the excel, by the help of that it is easy to find
out the values of the total cost over the bills are 10147. This shows that there this is a large amount of
the cost as per the bills of the smartphones. The outcome of the bills is including the calls, messages and
the data uses by the users. There is an analysis of all the use of the smartphones after that the bills are
prepared for all the users.
Q2. Monthly Bill vs Lifestyle Factors
There are a different type of the user and all the different use of the mobile phones, as the lifestyle
changes the use of the devices are also changed. As compare to the lifestyle then there are number of
the user have the different uses in terms of there are use of them in the different forms, like some of the
user use for the calling, some of the use of the message and the some of the use of the data use,
maximum all the user use all these techniques into the mobile device but the category is divided in
terms of the large use of the particular technology. Same as for this case there are various of the user
have the different users. Other than this use of the devices for the online services and the online
payment. Many of the users use the devices for the personal use and for the working use. The
percentage of the working use of the mobile devices is low as compared to the use of the devices for the
personals and the other users. As per the use of the devices, the costing of the bill depends on the use
of the devices for the different purpose of the use.
The analysis is over the three different categories of the geo Tribe, that are Achievers, Independents and
Suburban Splendour. The outcomes are calculated with the help of the pivot table. There is another
option for the analysis that is the sorting and the selecting the values from the column. The result
shows the values of the Achievers is 28, the value of the Independents is 25 and the value of the
Suburban Splendour is 27. The total outcome of all the three is 80.
Q3. Mobile Phone Affordability
This is related to the affordability of the smartwatches of the by the users, there is a different type of the
user are present and all have the different base salary. There is a different type of the smartphones are
present, the category of smartphones is depending upon the use of the phone and this is depending
upon the number of the services that are used by the user. There is need to calculate the average values
of the monthly bills. There are need to analyse all the factor that will affect the working of the system.
The estimate of the average number of the 67.64. this is the average number of the costing of the
mobile bill that has gained by the user.
While using the mobile devices there are need to analysis the working of all the devices and the usage of
the devices by the different users. While the smartphones are used then they are used can be used for

the mobile payment, there are different another type of the payment mode. Some of the common
payment modes are cash or by swiping the card. Thera is many users who are using the smartphones
can pay the payment by the use of the mobile devices. there is a dataset of all the users are present and
there is need to analyse the data of the all the users. There is need to find out the how many users can
use the payment mode into the mobile devices. The outcomes are in terms of the out of 150 users the
114 users are using the smartphone for the payment and the rest 34 are the using the other mode of
the payment. This analysis is done with the help of the pivot table, that is the feature of the Excel.
There are two different type of the user of the smartphones, the two users are male and the female. The
need of both the user is different and the purpose and the usage of both the user are also different.
There are need analysis the user that have to pay for the use of the smartphones. The analysis is done
over the data set and then this is done with the help of the pivot table. The results are in terms of what
the 57 male and 57 females are using the smartphones for the payment and the 22 female and the 14
males do not use the smartphones do the payment. The ratios of the most number of the user are
higher as compared to the non-users.
Q4. Mobile Phone Usage
This is all about the analysis the use of the smartphones. There is a different type of the users and all
have the different type of the outcomes form the smartphones. The users are divided into the different
type of the subgroups and all the other subgroups have the different use of the smartphones. There are
need to analyse the use of the smartphones for the purpose of working, as per the analysis was done by
the business insider then they show that the less than 75 % of the user is using the smartphones for the
working purpose. This analysis is done as per to verifies the working of the all the user and the use of the
smartphones by them. For that, the analysis is done of the dataset that is present of the 150 users. The
analysis is done with the help of the scatter diagram and the diagram show the percentage use of the
smartphones by the users. This shows the none of the users have the value greater than the 75 percent.
This shows that the analysis that was done earlier was perfect and shows the correct outcomes.
This analysis is all about the number of calling done by the user by the use of the smartphones. Thera
are analysis is done previously and the result shows that there is an average of 27 calls done by the user.
but this may vary as there are a lot of the other means of the communication, the aim of the calling is to
communicate with the other users, as the technology increase then the use of the smartphones are also
changing. There are a lot of the other means of the tools or the feature of the smartphones are present
by the use of them it is easy to communicate with the other users. There are some of the other means
of the communication are data use social media and the text messages. By the use of the all the other
features, it is easy to communication and the costing also become low. So, there is a reduction in the
average number of the call made by the users. The average number of the calls that are done by both
the type of the user is 25.69.
Q5. Relationships
There is a number of the user use the smartphones and all of them are using this for the different
purposes. There are need to analysis the factor that affects the costing of the mobile bills. There is a
different type of the user that has makes a large number of calls, some of them make a large number of
the messages and the many of them are the use of a large number of the data allowances. All these are
a factor that affects the cost of the mobile bills. There are a need to analysis the all the factors and find

out the which one of the factors has the huge impact on the costing of the bills. The analysis is done one
by one and finds out the most important factor that affects the costing of the bills. The analysis is done
over the calls then this shows that the costing of the bill increases as the number of the call increase.
After that the analysis of the message that was done by the user are analysis this shows that as the
number of the messages are increasing the cost of the bill also increases but not much as compared to
the calls. The last analysis is done over the data used by the user, this shows that as the number of the
user increase of the data then the costing of the bill also increases. After the analysis, this is coming to
the output that as the number of the calls and the number of the data usage are increasing then the
costing of the bill increases as compared to the messages.
Q6. Appropriate Sample Size
This is the last analysis that is done over the provided dataset. The dataset is of the all about the use of
the smartphones by the different users. There is a different type of the user and all have the different
purposes. There are data of the only 150 users. This is sufficient to analyse the data but if there need to
find out the analysis more efficient then there is need to increase the size of the data set, as the size of
the data set is increased then the analysis becomes more precise and the outcomes are more acceptable
by the users. So, there are need to add the more users for the analysis, but as per the analysis there are
some of the condition is applied into the system, there are two conditions are applied as per the new
users for the analysis. One of the online purchase of the user is within in the 6 percent, for this the
analysis is performed and find out the result, that shows that the 114 user that can come into the new
analysis as per the condition, the next condition is in term of the bills of the user is within the $4 and the
analysis is done as reaches to the result that there are total of 144 users have then billed less than $4. As
both, the condition should follow then the total possible number of the users is 144. For the new
analysis, the total 114 new users can be added to get the more accurate and the precise outcomes with
the help of the analysis.