Problem Definition and Business Intelligence Required
Nike is an American multinational company which deals in design, manufacture and sale of athletic footwear, apparel, gear and accessories and other related services. Its profile specifies that it engages in innovation and production of products which serve the athletes of today and the future (“About Nike – Company Profile”, 2018). Keeping in line with this, they engage in an array of community service programs, primary among which are getting children actively engaged in sports and physical activities through their coaching and programs and promoting equality in communities by supporting partners in furthering the agenda of bringing about just that (“Nike Global Community Impact”, 2018).
They have over 70 partners with whom they engage to live up to the commitment of championing equality (“What We Do | Nike Global Community Impact”, 2018). Another cause that Nike has been pursuing is that of sustainable innovation whereby they actively involve sustainability practices in their business process and production with a focus on reducing carbon emissions. Nike maintains that the organization believes that is efforts towards sustainable innovation transcends the act of just ensuring low emissions. Nike has been actively making efforts to innovate in ways which leads to products which use lesser resources and lasts longer, adopting a business model which is circular instead of linear (“Sustainable Innovation”, 2018).
2. Problem definition and business intelligence
The report deals with addressing the following research questions in regard to Nike’s sales and customer response to their services and products.
- What the top selling product categories are and what the worst selling products are?
The initial exploratory analysis is done using statistical tools of descriptive statistics such as mean and bar charts. This is followed up by inferential statistical approaches of ANOVA to verify the difference in profits among groups labelled by product category and then Tukey’s post hoc test is used to find the order of the groups (Berenson et al., 2012). The level of significance was taken to be 5%. The ANOVA method is used to test for difference between means of more than one group on the basis of the same factor, such as profit in this case or more than one factor in general (Anderson et al., 2016).
- Does there exist any difference in the sales in terms of payment method by customers?
There are two kinds of payment methods adopted by the customers, namely, credit card and Paypal. It is to be seen if the purchases via one is greater than the other or not. Two sample t-test for means is therefore used to check if any such difference exist or not. The level of significance was taken to be 5%. According to Hair (2015), since only two groups exist, the purchases using credit and by Paypal can be treated as two separate samples and the difference between the sample means can then be done using independent samples t-test.
- Does user group have any impact on attitude of the customer and how?
Results of the Selected Analytics Methods and Technical Analysis
Users had been divided into 3 groups in the data on the basis of how much they use Nike services and products. The five attitude aspects of satisfaction, brand awareness, preference, purchase intentions and loyalty could then be compared among the groups using five separate one way ANOVA with level of significance taken as 5%.The factors for the five ANOVA are the five behavioral attribute variables.
- Does gender play a part in the observed attitudes of the customers and how?
The tentative difference between the two genders for the five customer attributes defined in the data are verified using independent sample t-test with level of significance taken to be 5% (Larson-Hall, 2015).
3. Analysis and results
1.What the top selling product categories are and what the worst selling products are?
The measure of how well a product is selling could be taken to be the profit incurred for the specific product category. Using this rationale, the mean profits for each product and the percentage of total profit accounted for by each product is calculated and scrutinized. The following table gives the means for each category.
Case Summaries |
|||
Profit Total |
|||
Product Class |
Mean |
Std. Deviation |
% of Total Sum |
Mens shoes |
15.8934 |
.40738 |
48.2% |
Mens clothing |
6.0000 |
.00000 |
15.6% |
Womens shoes |
6.5000 |
.00000 |
2.8% |
womens clothing |
4.2000 |
.00000 |
16.2% |
customise |
25.0000 |
.00000 |
10.8% |
boys shoes |
3.3000 |
.00000 |
5.6% |
girls shoes |
7.0000 |
.00000 |
0.5% |
girls clothing |
4.0000 |
.00000 |
0.3% |
Total |
8.2003 |
5.87634 |
100.0% |
Table 1: Case summaries of Profits from Products
Clearly, it is seen that customized products yield maximum mean profit amount whereas boys’ shoes yield minimum or least mean profit amount. The following figure shows the mean profits by product category for Nike as given in the data. However it is seen that maximum proportion of the total profits is accounted for by men’s shoes, then men’s clothing, followed by women’s shoes and customized products with girls’s clothing, shoes having the least contribution to profits.Conducting one way ANOVA over the categories with profit as factor it was seen that customized products had maximum of all the other products whereas boys’ shoes had least. The following tables shows the summary of the ANOVA and Tukey’s post hoc test that gives the result.
ANOVA |
|||||
Profit Total |
|||||
Sum of Squares |
df |
Mean Square |
F |
Sig. |
|
Between Groups |
12589.034 |
7 |
1798.433 |
43106.405 |
.000 |
Within Groups |
14.936 |
358 |
.042 |
||
Total |
12603.970 |
365 |
Table 2: Summary table of ANOVA comparing profits for product groups
Profit Total |
||||||||
Tukey HSD |
||||||||
Product Class |
N |
Subset for alpha = 0.05 |
||||||
1 |
2 |
3 |
4 |
5 |
6 |
7 |
||
boys shoes |
51 |
3.3000 |
||||||
girls clothing |
2 |
4.0000 |
||||||
womens clothing |
116 |
4.2000 |
||||||
Mens clothing |
78 |
6.0000 |
||||||
Womens shoes |
13 |
6.5000 |
||||||
girls shoes |
2 |
7.0000 |
||||||
Mens shoes |
91 |
15.8934 |
||||||
customise |
13 |
25.0000 |
||||||
Sig. |
1.000 |
.632 |
1.000 |
1.000 |
1.000 |
1.000 |
1.000 |
|
Means for groups in homogeneous subsets are displayed. |
||||||||
a. Uses Harmonic Mean Sample Size = 6.634. |
||||||||
b. The group sizes are unequal. The harmonic mean of the group sizes is used. Type I error levels are not guaranteed. |
Table 3: Group Mean profits of Product groups
1. Does there exist any difference in the sales in terms of payment method by customers?
The mean of the purchases made through Credit cards was found to be $3.0587 through PayPal and $5.1183 through Credit card. A two sample t-test was done to test whether the purchase using Credit card differs from that made through Paypal. It was seen that the conjecture that there is no difference was rejected at 5% in favour of alternative that mean purchase amount through Credit card is higher than that through Paypal.
Discussion of the Results and Recommendations
The following tables gives the summarized results of the t-test:
Group Statistics |
|||||
|
Method |
N |
Mean |
Std. Deviation |
Std. Error Mean |
Payment |
Paypal |
366 |
3.0587 |
3.31311 |
.17318 |
Credit Card |
366 |
5.1183 |
5.14040 |
.26869 |
Table 4: Summary of mean transactions by Paypal and Credit card
Independent Samples Test |
||||||||||
|
Levene’s Test for Equality of Variances |
t-test for Equality of Means |
||||||||
F |
Sig. |
t |
df |
Sig. (2-tailed) |
Mean Difference |
Std. Error Difference |
95% Confidence Interval of the Difference |
|||
Lower |
Upper |
|||||||||
Payment |
Equal variances assumed |
194.451 |
.000 |
-6.443 |
730 |
.000 |
-2.05956 |
.31967 |
-2.68714 |
-1.43199 |
Equal variances not assumed |
-6.443 |
623.621 |
.000 |
-2.05956 |
.31967 |
-2.68732 |
-1.43181 |
Table 5: Summary of t-test for difference in Paypal and Credit card transactions
2. Does user group have any impact on attitude of the customer and how?
The five customer attribute outcomes of brand awareness, satisfaction, and preference for the brand and purchase intention are scrutinized for the three customer groups based on their history of purchase, the groups being labelled as, heavy users, mediums users and low users. Since there are more than two groups, one way ANOVA is carried out for each of the five outcomes being considered as the factor on the basis of which there might be a tentative difference among the groups (Cronk, 2017). The mean brand awareness scores for each group, the mean satisfaction scores, mean preference scores and purchase intention score for each groups are given in the following tables:
DESCRIPTIVES |
|||||
|
N |
Mean |
Std. Deviation |
||
Awareness of Nike |
Light Users |
27 |
2.81 |
1.711 |
|
Medium Users |
51 |
4.90 |
1.676 |
||
Heavy Users |
72 |
6.46 |
.604 |
||
Total |
150 |
5.27 |
1.857 |
||
Satisfacition with Nike |
Light Users |
27 |
2.52 |
1.156 |
|
Medium Users |
51 |
5.39 |
1.041 |
||
Heavy Users |
72 |
6.07 |
.775 |
||
Total |
150 |
5.20 |
1.601 |
||
Preference for Nike |
Light Users |
27 |
2.41 |
1.526 |
|
Medium Users |
51 |
2.82 |
1.584 |
||
Heavy Users |
72 |
4.46 |
1.652 |
||
Total |
150 |
3.53 |
1.834 |
||
Purchase Intention for Nike |
Light Users |
26 |
4.23 |
1.861 |
|
Medium Users |
51 |
4.04 |
1.907 |
||
Heavy Users |
72 |
5.01 |
1.193 |
||
Total |
149 |
4.54 |
1.646 |
||
Loyalty for Nike |
Light Users |
27 |
3.85 |
1.537 |
|
Medium Users |
51 |
4.14 |
1.575 |
||
Heavy Users |
72 |
3.94 |
1.591 |
||
Total |
150 |
3.99 |
1.569 |
Table 6: Customer behaviour scores for each user group
It was seen from the results of the ANOVA that for the factor brand awareness, the difference between the three groups light users, medium users and heavy users was significant. The difference among the three groups in terms of satisfaction, preference and purchase intent were also found to vary significantly. Brand loyalty however was found to not be so significantly different among the groups.
ANOVA |
||||||
|
Sum of Squares |
df |
Mean Square |
F |
Sig. |
|
Awareness of Nike |
Between Groups |
271.334 |
2 |
135.667 |
82.253 |
.000 |
Within Groups |
242.459 |
147 |
1.649 |
|||
Total |
513.793 |
149 |
||||
Satisfacition with Nike |
Between Groups |
250.450 |
2 |
125.225 |
139.932 |
.000 |
Within Groups |
131.550 |
147 |
.895 |
|||
Total |
382.000 |
149 |
||||
Preference for Nike |
Between Groups |
121.528 |
2 |
60.764 |
23.518 |
.000 |
Within Groups |
379.805 |
147 |
2.584 |
|||
Total |
501.333 |
149 |
||||
Purchase Intention for Nike |
Between Groups |
31.443 |
2 |
15.722 |
6.212 |
.003 |
Within Groups |
369.523 |
146 |
2.531 |
|||
Total |
400.966 |
148 |
||||
Loyalty for Nike |
Between Groups |
1.769 |
2 |
.884 |
.356 |
.701 |
Within Groups |
365.224 |
147 |
2.485 |
|||
Total |
366.993 |
149 |
Table 7: ANOVA table for difference in customer behaviour among user groups
The results of Tukey’s post Hoc test suggested that the factor brand awareness was found to be greatest for heavy users and least for light users. The following table and subsequent figure shows the mean score of brand awareness for the three groups.
Awareness of Nike |
||||
Tukey’s HSD |
||||
Website User Group |
N |
Subset for alpha = 0.05 |
||
1 |
2 |
3 |
||
Light Users |
27 |
2.81 |
|
|
Medium Users |
51 |
|
4.90 |
|
Heavy Users |
72 |
|
|
6.46 |
Sig. |
1.000 |
1.000 |
1.000 |
|
Means for groups in homogeneous subsets are displayed. |
||||
a. Uses Harmonic Mean Sample Size = 42.533. |
||||
b. The group sizes are unequal. The harmonic mean of the group sizes is used. Type I error levels are not guaranteed. |
Table 8: Post-Hoc test for ANOVA on Awareness among user groupsThe results of Tukey’s post Hoc test suggested that the factor product satisfaction for Nike products was found to be greatest for heavy users and least for light users. The following table and subsequent figure shows the mean score of product satisfaction for the three groups.
Satisfacition with Nike |
||||
Tukey ‘s HSD |
||||
Website User Group |
N |
Subset for alpha = 0.05 |
||
1 |
2 |
3 |
||
Light Users |
27 |
2.52 |
|
|
Medium Users |
51 |
|
5.39 |
|
Heavy Users |
72 |
|
|
6.07 |
Sig. |
1.000 |
1.000 |
1.000 |
|
Means for groups in homogeneous subsets are displayed. |
||||
a. Uses Harmonic Mean Sample Size = 42.533. |
||||
b. The group sizes are unequal. The harmonic mean of the group sizes is used. Type I error levels are not guaranteed. |
Table 9: Post-Hoc test for ANOVA on Satisfaction scores among user groupsFigure 4: Mean Satisfaction scores against User Groups
The results of Tukey’s post Hoc test suggested that the factor preference for Nike brand and its products was found to be greatest for heavy users and it was least for light users. However although the difference between heavy users vary significantly with those of light users, the difference is not so pronounced between the medium users and heavy users whereas it is pronounced for medium and light users. Consequently, the three groups could grouped into two subsets. The following table and subsequent figure shows the mean score of preference for Nike for the three groups.
Preference for Nike |
|||
Tukey HSD |
|||
Webiste User Group |
N |
Subset for alpha = 0.05 |
|
1 |
2 |
||
Light Users |
27 |
2.41 |
|
Medium Users |
51 |
2.82 |
|
Heavy Users |
72 |
|
4.46 |
Sig. |
.459 |
1.000 |
|
Means for groups in homogeneous subsets are displayed. |
|||
a. Uses Harmonic Mean Sample Size = 42.533. |
|||
b. The group sizes are unequal. The harmonic mean of the group sizes is used. Type I error levels are not guaranteed. |
Report Formatting
Table 10: Post-Hoc test for ANOVA on preference scores among user groupsThe results of Tukey’s post Hoc test suggested that the factor purchase intent of the customers found to be greatest for heavy users and it was least for light users. However although the difference between heavy users vary significantly with those of light users, the difference is not so pronounced between the light users and medium users or medium users and heavy users. Consequently, the three groups could be grouped into two subsets. The following table and subsequent figure shows the mean purchase intent scores for the three groups.
Purchase Intention for Nike |
|||
Tukey’s HSD |
|||
Website User Group |
N |
Subset for alpha = 0.05 |
|
1 |
2 |
||
Medium Users |
51 |
4.04 |
|
Light Users |
26 |
4.23 |
4.23 |
Heavy Users |
72 |
|
5.01 |
Sig. |
.847 |
.067 |
|
Means for groups in homogeneous subsets are displayed. |
|||
a. Uses Harmonic Mean Sample Size = 41.691. |
|||
b. The group sizes are unequal. The harmonic mean of the group sizes is used. Type I error levels are not guaranteed. |
Table 11: Post-Hoc test for ANOVA on purchase intention scores among user groups1. Does gender play a part in the observed attitudes of the customers and how?
The five customer attribute outcomes of brand awareness, satisfaction, and preference for the brand and purchase intention were then scrutinized for differences with the consumers having been grouped as per their gender. Since there are just two groups, independent two sampled t-tests were carried out for each of the five outcomes on the basis of which there might be a tentative difference between men and women consumers. The following table gives the mean of the outcome scores for men and women separately.
Group Statistics |
|||||
|
Gender |
N |
Mean |
Std. Deviation |
Std. Error Mean |
Awareness of Nike |
Female |
99 |
5.01 |
1.982 |
.199 |
Male |
51 |
5.78 |
1.474 |
.206 |
|
Satisfaction with Nike |
Female |
99 |
5.15 |
1.619 |
.163 |
Male |
51 |
5.29 |
1.579 |
.221 |
|
Preference for Nike |
Female |
99 |
3.18 |
1.886 |
.190 |
Male |
51 |
4.22 |
1.527 |
.214 |
|
Purchase Intention for Nike |
Female |
99 |
4.69 |
1.614 |
.162 |
Male |
50 |
4.26 |
1.688 |
.239 |
|
Loyalty for Nike |
Female |
99 |
3.45 |
1.605 |
.161 |
Male |
51 |
5.04 |
.774 |
.108 |
Table 12: Customer behaviour scores for each Gender
Having conducted the t-tests for awareness, satisfaction, preference, purchase intention and loyalty for the two gender based groups, having assumed unequal variance between the two groups, it was seen that the conjecture for no difference for the brand awareness was rejected at 5% level of significance. The alternate conjecture that awareness of the men is greater than that of the women was thus favored as opposed to the null hypothesis. Again, the t-test to test for differences between the two groups in terms of satisfaction having assumed unequal variance in scores for the two groups , was found to fail to reject the hypothesis of no difference which is the null hypothesis at 5% level of confidence.
The test for difference in preference between men and women consumers of Nike products was found to reject the conjecture of no difference or null hypothesis at 5% level of significance, where the variance of the two groups was assumed to be unequal. The test for difference in purchase intent for men and women was found to fail to reject the hypothesis of no difference which is the null hypothesis at 5% level of confidence. Finally the test for no differences in loyalty between the two groups revealed that there is sufficient evidence to support the rejection of the no difference conjecture or null hypothesis, having assumed unequal variances and at 5% level of significance. The following table gives the summarized results for the five t-tests.
Independent Samples Test |
||||||||||
Levene’s Test for Equality of Variances |
t-test for Equality of Means |
|||||||||
F |
Sig. |
t |
df |
Sig. (2-tailed) |
Mean Difference |
Std. Error Difference |
95% Confidence Interval of the Difference |
|||
Lower |
Upper |
|||||||||
Awareness of Nike |
Equal variances assumed |
15.031 |
.000 |
-2.460 |
148 |
.015 |
-.774 |
.315 |
-1.396 |
-.152 |
Equal variances not assumed |
-2.699 |
129.296 |
.008 |
-.774 |
.287 |
-1.342 |
-.207 |
|||
Satisfacition with Nike |
Equal variances assumed |
.040 |
.842 |
-.515 |
148 |
.607 |
-.143 |
.277 |
-.689 |
.404 |
Equal variances not assumed |
-.520 |
103.358 |
.604 |
-.143 |
.274 |
-.687 |
.402 |
|||
Preference for Nike |
Equal variances assumed |
3.925 |
.049 |
-3.383 |
148 |
.001 |
-1.034 |
.306 |
-1.638 |
-.430 |
Equal variances not assumed |
|
-3.617 |
121.260 |
.000 |
-1.034 |
.286 |
-1.600 |
-.468 |
||
Purchase Intention for Nike |
Equal variances assumed |
.837 |
.362 |
1.501 |
147 |
.135 |
.427 |
.284 |
-.135 |
.989 |
Equal variances not assumed |
|
1.479 |
94.612 |
.142 |
.427 |
.289 |
-.146 |
1.000 |
||
Loyalty for Nike |
Equal variances assumed |
63.582 |
.000 |
-6.655 |
148 |
.000 |
-1.585 |
.238 |
-2.055 |
-1.114 |
Equal variances not assumed |
|
-8.155 |
147.515 |
.000 |
-1.585 |
.194 |
-1.969 |
-1.201 |
Levels of Achievement
Table 13: Summaries of t-tests for difference in behaviour scores between genders
4. Discussion
Drawing upon the results of the analysis it could thus be said that the Nike’s customized products seem to have maximum profit amount per item whereas its sales on boy’s shoes constitute lowest profit amount. However, looking at the picture from a sales perspective, profits from men’s apparel and shoes make up for the bulk proportion of the total profits. The least profit is seen to come from the products aimed towards minors and among them it’s particularly low for girl’s shoes and clothing. Hence it could be said that the key consumer section for Nike are adults and more so it is adult males. Although amount of profit is maximum for customized products the overall figures indicate that sales of apparel and shoes far exceed that of customized products making their contribution to profits greater owing to number of items sold rather than the profit per item.
The maximum transactions were found to be made through Credit Card rather than PayPal. Upon looking at the observed customer behaviour attributes or brand awareness, satisfaction, preference and intent of purchase it was seen that consumers who were classed as heavy users had significant higher scores than low users, who were also significantly different from medium users. However brand loyalty was found to be consistent among the three groups where overall loyalty score for all the consumers was found to be 3.99 and standard deviation 1.569.
It is hence suggested that Nike has managed to maintain the loyalty of its consumers across sections of its market. Again the discrepancies in the score among men and women suggested that men constitute the major portion of its consumer base since brand awareness, preference and loyalty was found to be distinctively higher for males than females betraying that men are more likely to opt for Nike products than women. The behavioural score of satisfaction, purchase intent and loyalty was however found to be more or less similar for both the genders.
Hence Nike would benefit by targeting adult men and focus their attention on men’s clothing and footwear. Also given the fact that women’s apparel come a close second to men’s clothes, it presents good market opportunity for Nike and hence they could focus on bringing about more innovations to target the female consumer population. Given the fact that brand awareness in women are not as pronounced as in men, it could also prove to be beneficial to investing to increase brand awareness among women.
References
Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2016). Statistics for business & economics. Nelson Education.
Berenson, M., Levine, D., Szabat, K. A., & Krehbiel, T. C. (2012). Basic business statistics: Concepts and applications.
Cronk, B. C. (2017). How to use SPSS®: A step-by-step guide to analysis and interpretation. Routledge.
Hair Jr, J. F., Wolfinbarger, M., Money, A. H., Samouel, P., & Page, M. J. (2015). Essentials of business research methods. Routledge.
Larson-Hall, J. (2015). A guide to doing statistics in second language research using SPSS and R. Routledge.
About Nike – Company Profile. (2018).
Nike Global Community Impact. (2018).
Sustainable Innovation. (2018).
What We Do | Nike Global Community Impact. (2018).