MATH07005 Mathematics for Computing Assignment Solution 2019/20

This document presents a comprehensive solution to the MATH07005 Mathematics for Computing assignment from the University of the West of Scotland. The solution includes answers to two main questions. Question 1 involves creating and interpreting a box plot for data on light and heavy storage users, along with a descriptive statistical summary of the data, including mean, median, mode, range, standard deviation, and other relevant metrics. Question 2 addresses several sub-problems using data from a student survey. These include calculating percentages for students good in Excel, analyzing male students in a specific age group, determining the percentage of male students using public transport and free Wi-Fi, identifying the least popular social media, and calculating probabilities related to mobile data usage and library internet access. The solution provides detailed tables, charts, and calculations to support the findings, including the analysis of data usage concerning an age group and the relationship between mobile data usage and access to library internet.

Running head: MATHEMATICS FOR COMPUTING MATH07005
MATHEMATICS FOR COMPUTING MATH07005
Name of the Student
University of the West of Scotland

1MATHEMATICS FOR COMPUTING MATH07005
Table of Contents
Solution of Question 1...............................................................................................................2
a) The Box Plot...................................................................................................................2
a) The descriptive summary of the data-.............................................................................2
Solution of Question 2...............................................................................................................4

2MATHEMATICS FOR COMPUTING MATH07005
Solution of Question 1.
a) The Box Plot
The box plot of the given data from the excel sheet is present in figure 1.
Heavy Storage Users
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6
Chart Title Entered via cell I1 on Data Worksheet
Axis Label Entered via cell I2 on Data Worksheet
Double click on scale to set values
Figure 1 (Box plot of heavy storage and lightly storage user)
From the above box plot, can say that-
The average value of the light storage users is 47.80, and the data range is 12 to 120.
The average value of the heavy storage users is 152, and the data range is 55 to 205.
a) The descriptive summary of the data-
There is a total of 15 number of data set for both light storage and heavy storage data
set. The other details are in the below tables-

3MATHEMATICS FOR COMPUTING MATH07005
The table for the light storage users-
Light Storage Users
Mean 47.8
Median 40
Mode 19
Range 108
Minimum 12
Maximum 120
Sum 717
Standard Error 7.6980
Standard Deviation 29.8142
Sample Variance 888.8857
Kurtosis 1.0261
Skewness 1.0644
Q1 25
Q3 61
Inter Quartile Range (IQR) 36
Relative Standard Deviation (RSD) 62.4%
Table 1. (Descriptive summary of Light Storage users)

4MATHEMATICS FOR COMPUTING MATH07005
The table for the heavy storage users-
Heavy Storage Users
Mean 152.0667
Median 165.2996
Mode Not Available
Range 150
Minimum 55
Maximum 205
Sum 2281
Standard Error 11.2996
Standard Deviation 43.7631
Sample Variance 1915.2095
Kurtosis 0.1578
Skewness -0.9920
Q1 131
Q3 179
Inter Quartile Range (IQR) 48
Relative Standard Deviation (RSD) 28.8
Table 2. (Descriptive summary of Heavy Storage users)
In the heavy storage users data set, there is no similar data sample present, so there is no
mode of the heavy storage users data set.
Solution of Question 2.
a) The number of male students responded to the question of the survey is 67.
b) Percentage of Student who is good in Excel is 24%.
Total 75
Good in
Excel 18
Percentage 24%
Table 3. (Details of Excel)

5MATHEMATICS FOR COMPUTING MATH07005
c) Male respondents who are in the age group of 17-19 is 44.78%
Total Male 67
No of the male in the age group 17-19 30
Percentage 44.78%
Table 4. (Details of male age group 17-19 years old)
d) Male respondents who implied they used public transport, among them used free Wi-
Fi is 60.00%
Male who used public transport 25
Among them use free Wi-Fi 15
Percentage 60%
Table 5. (Public Transport and Fee Wi-Fi user among male)
e) The least popular social medium used in the last 24 hours prior to the survey is Spotify
and Youtube (both have one user).
Name of Social Media Total User
Facebook 30
Instagram 3
Messenger 2
Snapchat 4
Spotify 1
Twitter 10
WhatsApp 2
Youtube 1
Table 6. (Social media users)

6MATHEMATICS FOR COMPUTING MATH07005
f) Respondent aged 17-19 and used 0-100MB of data per month on their mobile phone
is 0.07
Total 75
Aged 17-19 and used 0-100MB of data per month 5
Probability 0.07
Table 7. (Data use per month concerning an age group)
g) Respondent selected at random from the group is aged 20-24 or used more than 1GB
of data per month on their mobile phone is 0.5733
Total 75
Aged 20-24 24
Used more than 1GB of data per month 28
Aged 20-24 and used more than 1GB of data per month 9
Probability 0.5733
Table 8. (Probalitiy table of age group or data use in a month)
h) Daily mobile data usage and use of Library internet details are in the table below-
Mobile Data
Users
Library Internet Access
Total Yes No
0-100MB 14 12 2
100-500MB 14 14 0
500MB-1GB 18 17 1
More than 1GB 28 25 3
Table 9. (Number of users who access Library Internet respect to daily data use)

7MATHEMATICS FOR COMPUTING MATH07005
According to the monthly data access who access Library internet.
Daily Mobile Data
Uses
Library Internet Access in Percentage
Yes No
0-100MB 85.71 14.29
100-500MB 100.00 0.00
500MB-1GB 94.44 5.56
More than 1GB 89.29 10.71
Table 10. (Percentage of users who access Library Internet respect to monthly data use)
The bar chart shows the percentage within each interval of monthly mobile phone
data usage who have and do not have access to a library with Internet access in the below-
0-100MB 100-500MB 500MB-1GB More than 1GB
0.00
20.00
40.00
60.00
80.00
100.00
120.00
85.71
100.00 94.44 89.29
14.29
0.00 5.56 10.71
Library Internet Access in Percentage
Yes No
Types of Moble data user
Percentage (%)
Figure 2. (Percentage of users who access Library Internet respect to monthly data
use)