Assessment 3 Risk and Technology

Assessment 3 Risk and Technology

Table of Contents
INTRODUCTION...........................................................................................................................3
PART A...........................................................................................................................................3
Task 1...........................................................................................................................................3
Task 2...........................................................................................................................................6
Task 3...........................................................................................................................................6
Task 4...........................................................................................................................................7
PART B...........................................................................................................................................7
PART C...........................................................................................................................................8
Task 6...........................................................................................................................................8
TASK 7........................................................................................................................................9
CONCLUSION..............................................................................................................................11
REFERENCES................................................................................................................................1

INTRODUCTION
The present report has been based on QET which is a travel agency that allow the customer
to book tickets through online sites. Along with this, the study will be divided into 4 part such as
in A it will be discussing about numerical analysis of data base and analysis the relation between
customer satisfaction and refund time. Moreover, in Part B the study will be focusing on
problem areas in QET in current booking system. The study in Part C will depict about relation
to implementing automation solutions. Lastly, in section D the study will provide appropriate
recommendation so that it can enhance their solution.
PART A
Task 1
Regression test
Null hypothesis: There is no significant relationship between the mean value of refund time and
net promotor, customer satisfaction.
Alternative Hypothesis: There is a significant relationship between the mean value of refund
time and net promotor, customer satisfaction.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.744408
R Square 0.554144
Adjusted R Square 0.553249
Standard Error 1.978607
Observations 1000
ANOVA
df SS MS F
Significance
F
Regression 2 4851.115
2425.55
8
619.573
1 1.3295E-175
Residual 997 3903.141
3.91488
5
Total 999 8754.256

Coefficient
s
Standard
Error t Stat P-value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 7.91613 0.198954 39.78878 4.5E-208 7.525713 8.306546 7.525713 8.306546
Net
Promoter
Score -1.11975 0.048972 -22.865 2.3E-93
-
1.215851 -1.02365 -1.21585 -1.02365
Customer
Satisfaction 0.251301 0.066828 3.760421 0.000179 0.120162 0.382441 0.120162 0.382441
T-Test
H0: There is no difference in the business travelers refund times and leisure traveler refund
times.
H1: There is a difference in the business travelers refund times and leisure traveler refund times.
Group Statistics
businesstravel N Mean Std. Deviation Std. Error
Mean
refundtime 1.00 488 1.8012 3.10319 .14047
2.00 512 1.3848 2.80522 .12397
Independent Samples Test
Levene's
Test for
Equality of
Variances
t-test for Equality of Means