Business and Management Statistics: Data Analysis Report CW2

Verified

Added on  2022/10/19

|18
|2635
|351
Report
AI Summary
This report presents a comprehensive analysis of student data, focusing on accommodation choices and related variables such as domicile, age, gender, and study habits. Task 1 employs descriptive statistics, including tables and graphs, to analyze quantitative and qualitative variables, exploring relationships between accommodation type and factors like country of origin, age, gender, A-level math status, and part-time work status. Correlation coefficients are used to assess the association between variables. Task 2 involves a scatter plot and regression analysis to examine the relationship between time spent on the internet and commute time. Finally, Task 3 constructs a network diagram and precedence diagram to determine the critical path for a project, including calculations of early start, early finish, late start, late finish, and slack.
tabler-icon-diamond-filled.svg

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
Running head: ANALYSING INFORMATION AND DATA ANALYSIS
Analysing Information and Data Analysis
Name of the Student:
Name of the University:
Author Note:
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
1ANALYSING INFORMATION AND DATA ANALYSIS
Table of Contents
Task 1.........................................................................................................................................2
Introduction................................................................................................................................2
Description of data:....................................................................................................................2
Factors affecting type of accommodation:.................................................................................8
Conclusion................................................................................................................................10
Task 2.......................................................................................................................................11
Task 3.......................................................................................................................................13
Reference..................................................................................................................................16
Document Page
2ANALYSING INFORMATION AND DATA ANALYSIS
Task 1
Table of Content
Introduction................................................................................................................................2
Description of data:....................................................................................................................2
Factors affecting type of accommodation:.................................................................................8
Conclusion................................................................................................................................10
Introduction
Data analysis is widely used to analyse information statistically in each and every
field starting from business strategy to defence strategy of a country and educational
institutes to medical field. Here, a quantitative data analysis will be done on the student’s
information related to their age, gender, domicile, part-time work, A-level math and
accommodation. This will be presented through tables and graphs which will contain
statistical parameters to conclude the overall data.
Description of data:
The data contains information about students related to their accommodation,
domicile, age, gender, duration on a computer, minute spending on exercise, part time work
status, hourly wage, A-level maths status and total GSCE points.
Here, the quantitative variables are described with their mean, median, standard
deviation and skewness and kurtosis.
Table 1A: Descriptive statistics of quantitative variables
Time To
Universit
y
Duration
On A
Computer
?
Minutes Of
Exercise?
Hours Of Part
Time Work?
Document Page
3ANALYSING INFORMATION AND DATA ANALYSIS
Mean 38.8667 89.9933 142.8133333 15.11333333
Standard Error 2.60627 6.23826 11.46489003 0.926868953
Median 30 60 120 15
Mode 30 120 120 0
Standard Deviation 31.9201 76.4028 140.4156527 11.35177996
Sample Variance 1018.89 5837.39 19716.55553 128.8629083
Kurtosis -0.1265 8.72907 3.440046581 1.637877387
Skewness 0.92472 2.26822 1.653809941 0.905571841
Range 132 497 720 60
Minimum 3 3 0 0
Maximum 135 500 720 60
Table 1B: Descriptive statistics of quantitative variables
Part
Time
Hourly
Wage?
A-Level
Maths? Total GCSE Points? A-Level: Total
Points?
Mean 7.0464
1 0.48 75.47213333 214.04
Standard Error 0.3510
5 0.04093 2.55241158 5.898931614
Median 7.425 0 64.5 214
Mode 0 0 57 214
Standard Deviation 4.2995
1 0.50127 31.26052992 72.24686241
Sample Variance 18.485
8 0.25128 977.220731 5219.609128
Kurtosis 0.9705
9 -2.0206 -0.334650795 1.637779033
Skewness 0.1776 0.08088 0.856628132 -0.855963299
Range 22 1 139 380
Minimum 0 0 6 0
Maximum 22 1 145 380
Here, qualitative variables are described as the percentage of grand total across
accommodation type. For example, most of the students from EU like to choose the parents’
home as accommodation which is 13% of the sample size, whereas students from UK never
go for university houses as 0% the sample go for the university house (Cox, 2018). This is
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
4ANALYSING INFORMATION AND DATA ANALYSIS
shown in the below table. This is also explained by a bar chart which is presented in the
figure 1.
Table 2: Percentage of students taking different accommodation across different countries.
Row Labels EU Internationa
l UK Grand
Total
Other 3.31% 1.32% 1.99% 6.62%
Own home 1.99% 2.65% 1.99% 6.62%
parents home 15.89% 9.93% 10.60% 36.42%
Priory Hall 4.64% 1.99% 8.61% 15.23%
Privately rented house or flat 3.31% 8.61% 5.30% 17.22%
University house 1.32% 0.66% 0.00% 1.99%
University self-catering halls of
residence 3.97% 5.30% 6.62% 15.89%
Grand Total 34.44% 30.46% 35.10% 100.00
%
Figure 1: Percentage of students taking different accommodation across different countries.
The above figure shows that the EU presented by the blue bar is longest for the
accommodation type parents’ house and the UK presented by the grey bar is absent for the
university house.
Document Page
5ANALYSING INFORMATION AND DATA ANALYSIS
In the same way, the qualitative variables like, age, gender, A-level math status and
part time work status, are presented in this report in the following tables and figures.
Table 3: Percentage of students taking different accommodation across different age.
Row Labels 18 or 19 20 or 21 over 21 Grand
Total
Other 3.97% 1.32% 1.32% 6.62%
Own home 4.64% 0.00% 1.99% 6.62%
parents home 19.87% 5.30% 11.26% 36.42%
Priory Hall 11.26% 0.00% 3.97% 15.23%
Privately rented house or flat 7.95% 1.32% 7.95% 17.22%
University house 1.99% 0.00% 0.00% 1.99%
University self-catering halls of
residence 11.92% 0.66% 3.31% 15.89%
Grand Total 61.59% 8.61% 29.80
% 100.00%
Figure 2: Percentage of students taking different accommodation across different age.
Table 4: Percentage of students taking different accommodation across gender.
Row Labels Female Male Prefer
not say
Grand
Total
Other 1.32% 5.30% 0.00% 6.62%
Own home 1.99% 3.97% 0.66% 6.62%
parents home 13.25% 21.19% 1.99% 36.42%
Priory Hall 3.97% 11.26% 0.00% 15.23%
Document Page
6ANALYSING INFORMATION AND DATA ANALYSIS
Privately rented house or flat 5.30% 10.60% 1.32% 17.22%
University house 1.32% 0.66% 0.00% 1.99%
University self-catering halls of
residence 2.65% 13.25% 0.00% 15.89%
Grand Total 29.80% 66.23% 3.97% 100.00%
Figure 3: Percentage of students taking different accommodation across gender.
Table 5: Percentage of students taking different accommodation across A-level math status.
Row Labels No Yes Grand
Total
Other 3.33% 3.33% 6.67%
Own home 3.33% 3.33% 6.67%
parents home 21.33% 15.33% 36.67%
Priory Hall 7.33% 8.00% 15.33%
Privately rented house or flat 8.00% 9.33% 17.33%
University house 1.33% 0.67% 2.00%
University self-catering halls of residence 7.33% 8.00% 15.33%
Grand Total 52.00% 48.00% 100.00%
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
7ANALYSING INFORMATION AND DATA ANALYSIS
Figure 4: Percentage of students taking different accommodation across A-level math status.
Table 6: Percentage of students taking different accommodation across part time work status.
Row Labels No Yes Grand
Total
Other 1.99% 4.64% 6.62%
Own home 2.65% 3.97% 6.62%
parents home 5.30% 31.13% 36.42%
Priory Hall 4.64% 10.60% 15.23%
Privately rented house or flat 2.65% 14.57% 17.22%
University house 0.00% 1.99% 1.99%
University self-catering halls of residence 3.31% 12.58% 15.89%
Grand Total 20.53% 79.47% 100.00%
Document Page
8ANALYSING INFORMATION AND DATA ANALYSIS
Figure 5: Percentage of students taking different accommodation across part time work
status.
Factors affecting type of accommodation:
First of all there are variables such as domicile, age and gender that are transformed
into a dummy variable. For domicile two dummies are created domicile_1 and domicile_2.
Domicile_1 carries a value 1 for the students of UK and 0 otherwise. Domicile_2 carries a
value 1 for the students of EU and 0 otherwise and the international students are presented
with the value of 0 of both the dummies. Similarly, age and gender dummies are created.
The below table presents the correlation coefficient table, which shows the association
of variables with each other. The absolute value 1 or close to 1 presents the strong correlation
and the absolute value close to 0 presents the weak association. The below table presents the
highest value of correlation for the column accommodation type which is 0.19543. The
correlation coefficient presents the weak association between time to university and
accommodation type (Keller, 2015). Thus it can be said that the time to university effects the
choice of accommodation type with a very small affect.
Table 7A: Correlation Table
Document Page
9ANALYSING INFORMATION AND DATA ANALYSIS
Accommodation
Type Domicile_1 Domicile_2 Age_1 Age_2
Accommodation Type 1
Domicile_1 -0.1745 1
Domicile_2 0.1446 -0.5305 1
Age_1 -0.129 0.04277 -0.037 1
Age_2 0.17662 -0.079 -0.021 -0.388 1
Gender_1 -0.1067 0.05947 -0.1682 0.15259 0.07103
Gender_2 0.06783 -0.0883 0.14434 -0.1374 -0.0465
Time To University 0.19543 -0.0065 -0.0142 -0.2249 0.00948
Duration On A
Computer? -0.2074 0.12571 -0.0874 0.1078 -0.042
Minutes Of Exercise? 0.05028 -0.0436 0.01876 -0.0043 -0.0638
Part time Work? 0.01046 -0.0139 -0.0633 0.04791 0.09478
Hours Of Part Time
Work? 0.01082 -0.0333 -0.1316 -0.0731 0.10582
Part Time Hourly Wage? 0.05118 0.03434 -0.0926 -0.0753 0.01436
A-Level Maths? -0.0584 0.04355 -0.0135 -0.2236 0.03605
Total GCSE Points? -0.0276 0.03354 0.02906 -0.4098 -0.1971
A-Level: Total Points? -0.138 -0.02 0.05765 0.17003 -0.143
Table 7B: Correlation Table
Gender_
1
Gender_
2
Time To
Universit
y
Duration
On A
Computer
?
Minutes
Of
Exercise
?
Part
time
Work?
Gender_1 1
Gender_2 -0.9121 1
Time To University -0.2083 0.15045 1
Duration On A
Computer? 0.14613 -0.1081 -0.2269 1
Minutes Of Exercise? 0.10574 -0.0779 -0.0474 -0.0327 1
Part time Work? -0.0422 2E-17 -0.0671 0.08729 0.02708 1
Hours Of Part Time
Work? 0.08431 -0.1062 -0.0637 0.00126 0.11493 0.66791
Part Time Hourly
Wage? -0.0092 -0.0074 0.02356 0.04312 -0.0426 0.74479
A-Level Maths? 0.01352 -0.0175 0.10637 0.01708 0.02216 -0.0867
Total GCSE Points? -0.357 0.36665 0.43051 -0.0917 0.0079 -0.1368
A-Level: Total Points? -0.0522 0.08146 -0.0741 -0.0513 -0.0671 0.02088
Table 7C: Correlation Table
Hours Of
Part Time
Work?
Part Time
Hourly
Wage?
A-Level
Maths?
Total
GCSE
Points?
A-Level:
Total
Points?
Hours Of Part Time Work? 1
Part Time Hourly Wage? 0.54704 1
A-Level Maths? 0.01396 0.03714 1
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
10ANALYSING INFORMATION AND DATA ANALYSIS
Total GCSE Points? -0.2287 -0.0143 0.19654 1
A-Level: Total Points? -0.1388 -0.0043 -0.0363 0.07394 1
Conclusion
The above analysis presents that a student take 38.86 minutes to commute to the
university, spend on an average 89.99 minute on computer, does exercise on an average of
142.81 minutes and scores on average of 75.47 in GSCE. The students who stays at 31.13%
of sample stays at parents’ home who does part time job and the percentage is highest in the
list of accommodation type across part time job status. The correlation coefficient table does
not gives a factor that has great effect on accommodation type. However, domicile, age,
gender and time to university has small effects on accommodation type.
Document Page
11ANALYSING INFORMATION AND DATA ANALYSIS
Task 2
The below scatter plot presents the time spent on internet on the vertical axis and time
taken to accommodation on the horizontal axis. The scatter diagram is presented with red
coloured fitted line.
0 20 40 60 80 100 120 140
0
100
200
300
400
500
600
f(x) = − 0.543127835133035 x + 111.102901858837
R² = 0.0514890452845633
SCATTER PLOT WITH FITTED LINE
Figure 6: Scatter plot
The regression equation: The below regression table have information to construct the
equation and the equation is presented below:
Y =0.5431 X+ 111.1
Where, y presents the time spent on internet and x presents the time taken to accommodate.
Table 8: Regression Table
SUMMARY
OUTPUT
Regression
Statistics
Multiple R 0.227
Document Page
12ANALYSING INFORMATION AND DATA ANALYSIS
R Square 0.051
Adjusted R
Square 0.045
Standard Error 74.661
Observations 150
ANOVA
df SS MS F Significance
F
Regression 1 44783.68 44783.68 8.03 0.01
Residual 148 824987.32 5574.24
Total 149 869770.99
Coefficients Standard
Error t Stat P-value Lower 95% Upper
95%
Intercept 111.10 9.62 11.54 0.00 92.08 130.12
Time To
University -0.54 0.19 -2.83 0.01 -0.92 -0.16
The intercept: The intercept term is 111.10 which is statistically significant at 5%
significance level. This implies that when the time taken from student accommodation to
university is 0 minutes then the students will spend 111.10 minutes on internet.
The slope: The slope coefficient is -0.54 which is statistically significant at 5% significance
level. This implies that one unit rise in the time taken from student accommodation to
university will reduce the 0.54 minutes of time spending on internet.
R square: R square is 0.051 which implies that the model contains (100-5.1)% = 94.9% of
error. This indicates that the model is not good fit (Brook, 2018).
1. Prediction for time spent on internet while the time spent to reach university from
accommodation is 20 minutes:
Y =0.5431 X+ 111.1=0.543120+111.1=100.24
100.24 minutes is spent on internet by the student.
2. Prediction for time spent on internet while the time spent to reach university from
accommodation is 30 minutes:
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
13ANALYSING INFORMATION AND DATA ANALYSIS
Y =0.5431 X+ 111.1=0.543130+111.1=94.81
94.81 minutes is spent on internet by the student.
Significance: The p-value for both the intercept and slope term is less than 0.05 which
indicates that both are significant at 5% significance level (Nakagawa, Johnson and
Schielzeth, 2017).
Task 3
Network Diagram
Figure 7: Network Diagram
Precedence Diagram
Figure 8: Precedence Diagram
Document Page
14ANALYSING INFORMATION AND DATA ANALYSIS
Determination of the critical path
Table 9: Calculation of ES, EF, LS, LF, Slack and Total Float
Activity
ID
Preceding
ID Duration Early
Start
Early
Finish
Late
Start
Late
Finish Slack
Total
Float
(LF-EF)
A - 5 0 5 0 5 0 0
B A 3 5 8 5 8 0 0
C B 2 8 10 12 14 4 4
D A 7 5 12 7 14 2 2
E B 6 8 14 8 14 0 0
F C, E 2 14 16 14 16 0 0
G D 2 12 14 14 16 2 2
H F, G 2 16 18 16 18 0 0
I H 6 18 24 18 24 0 0
J G 2 14 16 22 24 8 8
K I, J 2 24 26 24 26 0 0
L K 0 26 26 26 26 0 0
The above table helps to draw the precedence diagram. The table contains the
calculated values of early start, early finish, late start, late finish and slack. The forward pass
and backward pass to determine the early start, early finish and late start, late finish
respectively (Kliem and Ludin, 2019). Now the rule of choosing critical path is to identify the
path where forward pass and backward pass gives the same result or the slack is always zero.
Hence, the critical path is ABEFHIKL.
Total float at associated with each activity
Table 10: Total float of each activity.
Activity ID Preceding ID Total Float (LF-EF)
A - 0
B A 0
C B 4
D A 2
E B 0
F C, E 0
G D 2
H F, G 0
I H 0
J G 8
K I, J 0
Document Page
15ANALYSING INFORMATION AND DATA ANALYSIS
L K 0
The above table is extracted from the table 9. The formula to calculate the float is
described below:
Toatal float =Late startEarly start
Or,
Toatal float =Late finishEarly finish
Using the above formula float is calculated for each activity and presented in the table 10.
The complete duration of the project is 26 days.
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
16ANALYSING INFORMATION AND DATA ANALYSIS
Reference
Brook, R.J., 2018. Applied regression analysis and experimental design. Routledge.
Cox, D.R., 2018. Applied statistics-principles and examples. Routledge.
Keller, G., 2015. Statistics for Management and Economics, Abbreviated. Cengage Learning.
Kliem, R.L. and Ludin, I.S., 2019. Reducing project risk. Routledge.
Nakagawa, S., Johnson, P.C. and Schielzeth, H., 2017. The coefficient of determination R 2
and intra-class correlation coefficient from generalized linear mixed-effects models revisited
and expanded. Journal of the Royal Society Interface, 14(134), p.20170213.
Pritchard, C.L., 2018. Project Management Drill Book: A Self-Study Guide. Routledge.
.
Document Page
17ANALYSING INFORMATION AND DATA ANALYSIS
chevron_up_icon
1 out of 18
circle_padding
hide_on_mobile
zoom_out_icon
logo.png

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]