QNT 561: Descriptive Statistics and Interpretation

profileprincess_92073
week_4_individual_example.docx

Descriptive Statistics

Jane Doe

QNT/561

July 14, 2014

Matthew Radio

SHORT TITLE OF PAPER

1

Running head: DESCRIPTIVE STATISTICS

1

Descriptive Statistics

Numeric Variable: Willingness to Recommend (collected from customer satisfaction survey)

Distribution is not normally distributed.

Central Tendency:

Mean = 4.37

Median = 5

Mode = 5

Dispersion:

Standard deviation = 1.26

Interquartile range (IQR) = 1.00

Range = 5

Number: 250 records

Min/Max: 1 and 5

Confidence Interval: There is a 95% confidence that the population average is between 4.22 and 4.53

See the descriptive statistics in Appendix B and the histogram in Appendix C.

Numeric Variable: Days to Contract Expiration

Central Tendency:

Mean = 388.68

Median = 450.00

Mode = 630.00

Dispersion:

Standard deviation = 242.28

Interquartile range (IQR) = 450.00

Range = 720.00

Number: 250 records

Min/Max: 0 and 720

Confidence Interval: There is a 95% confidence that the customer Days to Contract Expiration is between 358.65 and 418.71

See the descriptive statistics in Appendix B and the histogram in Appendix C.

Attribute Variable Handset Brands

250 customers who called into the contact center within the last three months were selected at random. 46.8% of the customers own a Samsung brand device, 41.6% own an iPhone, 7.6% own an LG, and 4.0% own a brand under the "Other" category (this includes brands like Palm, Kyoceta, and CellTel). See bar chart in Appendix E. Comment by Matthew Radio: Would a pie chart be more effective?

Descriptive Statistics Interpretation

Willingness to Recommend

250 customers were surveyed at random. The customers were asked how likely they would recommend CellTel to a friend or relative. Customers could select from 1 - 5:

5 = Would Definitely Recommend

4 = Very Likely To Recommend

3 = for Undecided

2 = Not Likely to Recommend

1 = Would Definitely Not Recommend

The average score was 4.37, with a variation of plus or minus 0.16. 71.6% of the responses were scored as a 5 - Would Definitely Recommend. There is a 95% confidence that the population score averages between 4.22 and 4.53. Comment by Matthew Radio: What do you mean by “variation”? Do you mean variance, standard deviation, or some other metric of dispersion?

Days to Contract Expiration

250 customers who called into the contact center within the last three months were selected at random. The average time to contract expiration was 388.68 days, with a variation of plus or minus 30.03 days. One half or more of the customers were above 450 days to their contract expiration. 13.20% of the customers have contracts that have already expired. There is a 95% confidence that the population (CellTel's customer base) average days to contract expiration is between 358.65 and 418.71 days.

DESCRIPTIVE STATISTICS

2

APPENDIX A

Raw data used in the analysis

APPENDIX B

Descriptive Statistics Willingness to Recommend and Contract Expiration

Comment by Matthew Radio: What does the “nominal score” mean? Be sure that the meaning of all figures are readily apparent to the reader.

APPENDIX C

Willingness to Recommend and Days to Contract Expiration Histograms

Comment by Matthew Radio: Should each bar be a range and not a single value? If the horizontal scale is continuous, should this be a histogram? (i.e. the bars touch each other)

APPENDIX D

Scatterplot Willingness to Recommend versus Days to Contract Expiration

APPENDIX E

Descriptive Statistics

Attribute Variable Handset Brands

Willingness to Recommend

Percent 1.0 2.0 3.0 4.0 5.0 0.1 0.012 0.016 0.156 0.716

Days to Contract Expiration

Percent 0.0 30.0 60.0 90.0 180.0 270.0 360.0 450.0 540.0 630.0 720.0 0.132 0.032 0.012 0.02 0.076 0.12 0.092 0.104 0.128 0.16 0.124

Willingness to Recommend Score 360.0 720.0 360.0 720.0 540.0 180.0 270.0 630.0 720.0 0.0 360.0 540.0 0.0 540.0 540.0 0.0 30.0 0.0 360.0 720.0 360.0 30.0 630.0 180.0 720.0 450.0 0.0 540.0 180.0 450.0 360.0 270.0 180.0 630.0 30.0 630.0 30.0 450.0 60.0 450.0 90.0 630.0 720.0 360.0 450.0 450.0 0.0 630.0 450.0 630.0 720.0 90.0 450.0 360.0 0.0 0.0 360.0 360.0 60.0 270.0 450.0 180.0 720.0 360.0 720.0 720.0 540.0 630.0 630.0 720.0 630.0 90.0 270.0 450.0 0.0 540.0 270.0 630.0 360.0 0.0 270.0 540.0 60.0 720.0 0.0 0.0 0.0 630.0 540.0 630.0 450.0 540.0 270.0 540.0 270.0 30.0 90.0 630.0 630.0 630.0 540.0 450.0 540.0 630.0 720.0 450.0 540.0 450.0 720.0 630.0 540.0 270.0 30.0 630.0 450.0 450.0 270.0 270.0 360.0 450.0 0.0 540.0 450.0 450.0 450.0 30.0 0.0 450.0 630.0 720.0 540.0 360.0 720.0 0.0 180.0 360.0 540.0 0.0 630.0 540.0 360.0 0.0 720.0 630.0 630.0 180.0 720.0 720.0 0.0 540.0 540.0 270.0 0.0 270.0 180.0 90.0 450.0 720.0 540.0 270.0 270.0 180.0 360.0 0.0 720.0 630.0 720.0 630.0 270.0 270.0 180.0 270.0 0.0 0.0 630.0 450.0 720.0 630.0 450.0 270.0 270.0 180.0 720.0 630.0 360.0 180.0 180.0 270.0 720.0 540.0 540.0 270.0 720.0 180.0 270.0 450.0 270.0 270.0 630.0 0.0 720.0 630.0 540.0 360.0 180.0 540.0 270.0 270.0 270.0 360.0 0.0 630.0 180.0 630.0 540.0 630.0 360.0 540.0 0.0 30.0 540.0 630.0 720.0 180.0 720.0 270.0 630.0 630.0 720.0 540.0 450.0 0.0 630.0 0.0 0.0 630.0 0.0 0.0 270.0 0.0 540.0 360.0 0.0 630.0 720.0 180.0 180.0 360.0 540.0 630.0 5.0 5.0 1.0 5.0 5.0 1.0 5.0 5.0 5.0 1.0 5.0 5.0 5.0 5.0 5.0 1.0 5.0 5.0 4.0 5.0 5.0 4.0 5.0 5.0 5.0 1.0 1.0 5.0 5.0 4.0 5.0 1.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 3.0 5.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 5.0 2.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 4.0 5.0 5.0 1.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 5.0 4.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 5.0 3.0 4.0 5.0 5.0 4.0 5.0 5.0 5.0 5.0 3.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 1.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 5.0 5.0 1.0 5.0 5.0 5.0 5.0 4.0 4.0 4.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 1.0 4.0 4.0 5.0 5.0 5.0 4.0 5.0 5.0 4.0 5.0 5.0 4.0 4.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 4.0 5.0 5.0 4.0 5.0 5.0 5.0 5.0 5.0 5.0 4.0 5.0 5.0 3.0 4.0 5.0 5.0 1.0 5.0 1.0 5.0 5.0 5.0 5.0 4.0 1.0 5.0 2.0 4.0 5.0 5.0 1.0 5.0 5.0 5.0 5.0 1.0 5.0 5.0 5.0 0.0 5.0 5.0 5.0 5.0 1.0 4.0 5.0 1.0 1.0 5.0 5.0 4.0 5.0 5.0 5.0 4.0 5.0 1.0 1.0 5.0 5.0 1.0 5.0 4.0 5.0 5.0 1.0 5.0 2.0 5.0 5.0 5.0 4.0 5.0 5.0 5.0 1.0 5.0 4.0 5.0 5.0

Days to Contract Expiration

Willingness to Recommend Score

CellTel Handset Brands Owned

Customer Handsets iPhone LG Other Samsung 0.416 0.076 0.04 0.468

Percent