Data Interpretation Practicum - Assignment Example

Application Week 7: Data Interpretation Practicum Zelana Hardison Walden Data Interpretation Practicum The aim of this studyis to investigate the telecommunications industry and inter-connectivity charges or termination charges between the providers in relation to the consumer and find out if the customer satisfaction depends on the terminal charges (Chen, 2014). Telecom operators have a service level agreements that allow customers to communicate with each other; this turns to be a lucrative business to operators who engage in interconnection (Tutorials Point, 2014). The survey was carried out on simple random sample, and the respondents we asked on the duration of the time they spend on their last call. Moreover, whether they preferred mode of call termination network. Research Question How can business leaders in the telecommunications industry shape the future of the telecommunications industry to arrive at a sustainable business value? REGRESSION ANALYSIS Is the statistical analysis that involves estimating the relationship between variables. It was selected because, for any business including telecommunication industry to thrive and be sustainable, it is not only critical to providing services that customers prefer, but also it is essential that the organization retain their clients. Regression analysis was chosen because it will provide a regression equation which can be used to predict how consumers will behave when a particular terminal charge is applied. Hypothesis H0: Business leaders are shaping the future in the telecommunications industry has a significant relationship with sustainable business value. H1: Business leaders are shaping the future in the telecom industry has no significant relationship with sustainable business value. Data findings and analysis Table 1.1: The table shows the descriptive statistics of the 30 randomly collected callers. Descriptive Statistics N Minimum Maximum Mean Std. Deviation How many minutes did you spend on your last call 30 6 20 13.47 4.392 Please choose which interconnection method you prefer 30 1 3 2.17 .791 Valid N (list wise) 30 The table shows that the mean calling time is 13.47 minutes while the minimum and maximum calling duration is 6 and 20 minutes respectively. Table 1: Frequency distribution table How many minutes did you spend on your last call Frequency Percent Valid Percent Cumulative Percent Valid 6 2 6.7 6.7 6.7 7 3 10.0 10.0 16.7 8 2 6.7 6.7 23.3 9 1 3.3 3.3 26.7 11 1 3.3 3.3 30.0 12 1 3.3 3.3 33.3 13 2 6.7 6.7 40.0 14 2 6.7 6.7 46.7 15 7 23.3 23.3 70.0 16 1 3.3 3.3 73.3 17 1 3.3 3.3 76.7 18 4 13.3 13.3 90.0 19 1 3.3 3.3 93.3 20 2 6.7 6.7 100.0 Total 30 100.0 100.0 Table 2: Histogram showing the distribution of duration of calls From the histogram, it is evident that many callers had spent 15 minutes. Table 3: Frequency distribution of the preferred interconnection method Please choose which interconnection method you prefer Frequency Percent Valid Percent Cumulative Percent Valid Calls on net 14 46.7 46.7 46.7 Calls both on and off net 11 36.7 36.7 83.3 I do not know 5 16.7 16.7 100.0 Total 30 100.0 100.0 Table 4: Histogram showing the preferred interconnection method From the histogram, it is clear that the results are normally distributed although a high number of callers prefer choice 1 which is on-net calls. Regression Analysis Determining how the model fits Model Summary Model R R Square Adjusted R Square Std. Error of the Estimate Change Statistics R Square Change F Change 1 .350a .123 .092 4.186 .123 3.921 Model Summary Model Change Statistics Durbin-Watson df1 df2 Sig. F Change 1 1a 28 .058 1.271 a. Predictors: (Constant), Please choose which interconnection method you prefer b. Dependent Variable: How many minutes did you spend on your last call The model summary shows that the R-value is 0.123 meaning that the two variables have a poor relationship. It, therefore means that most callers prefer using option 1 which is on-net. The value of R2 0.123 meaning that the independent variable (how many minutes did you call last) can only 12.3 % of the dependent variable (Preferred choice of interconnection). Given that the option 1 = was on net, 2=off net and 3= I do not know. It, therefore, means that option 1 had much influence on the predicted results. Statistical Significance ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 68.722 1 68.722 3.921 .058b Residual 490.745 28 17.527 Total 559.467 29 a. Dependent Variable: How many minutes did you spend on your last call b. Predictors: (Constant), Please choose which interconnection method you prefer The ANOVA table above shows whether the overall regression model to be a good fit for the data. The table shows that the independent variable does not statistically significantly predict the dependent variable, F(1, 28) = 3.921, p > 0.05 Estimated model co-efficient Coefficients Model Unstandardized Coefficients Standardized Coefficients t B Std. Error Beta 1 (Constant) 17.681 2.261 7.819 Please choose which interconnection method you prefer -1.945 .982 -.350 -1.980 Coefficientsa Model Sig. 95.0% Confidence Interval for B Lower Bound Upper Bound 1 (Constant) .000 13.049 22.313 Please choose which interconnection method you prefer .058 -3.957 .067 a. Dependent Variable: How many minutes did you spend on your last call The general equation which can be used to predict how many minutes a caller spend on calling is in the form Minutes spent Y = 17.681 – 1.945X Statistical significance of the independent variable The p-value is greater than 0.05, therefore, the variables are not statistically different and, therefore, the null hypothesis is not rejected. As a result, the null hypothesis is accepted. H0: Business leaders are shaping the future in the telecommunications industry has a significant relationship with sustainable business value. In conclusion it is clear that business manager’s in the telecommunication sector should try as much as possible to take care of the online callers because most of them tend to call longer and they also prefer using the online tariff (Gusoy, 2010). It is also evident that most callers do not like calling across the network. This may be attributed to higher charges that operators charge their customers. In this light, therefore, it could be advisable that the managers should reduce the off-line charges although they should be careful so that they do not make losses (NMTC, 2014). References Chen, Y. (2014). Telecommunications Service Industry. TIER Industry Report - Telecommunication Service Industry, 1-14. Gü soy, U. Ş. (2010). Customer churn analysis in telecommunication sector. Istanbul University Journal of the School Of Business Administration, 39(1), 35-49. National Mobile Telecommunications Company K.S.C.P. SWOT Analysis. (2014). National Mobile Telecommunications SWOT Analysis, 1-7. Tutorials Point. (2014). Telecom Interconnect Billing. Retrieved from Simply Easy Learning: http://www.tutorialspoint.com/telecom-billing/interconnect-billing.htm Read More