Analysis, Interpretation & Managerial Guidance

Only available on StudyMode
  • Download(s) : 43
  • Published : March 27, 2013
Open Document
Text Preview
Tutorial Workshop Report
Analysis, Interpretation & Managerial Guidance
RBUS2900
Jake Lambert
42354066
Due: 22/10/2012

Table of contents
Page no.

1.0 Task 1 - Catalogue Data3
1.1 Cross Tabulations3
1.2 Correlation Analysis5
1.3 Chi Square test5
2.0 Task 2 - Clothing Expenditure7
2.1Indepdant t-test7
2.2 Grouped t-test8
3.0 Task 3 - Graduate Pay8
3.1 ANOVA 18
3.2 ANOVA 29
4. 0 Multiple Regression Analysis9
5. 0 Appendix11
5.1 Appendix 1 - P-plots11
5.2 Appendix 2 - Tests of normality13

6.0 References14

1.0 Task 1 - Catalogue Data

1.1 Cross Tabulations

Task 1 requires the completion of cross tabulations for variables in the data set. This analysis is appropriate for testing the statistical significant between groups of two less-than interval variables (Zikmund, et al. 2010). Although this type of analysis does not show how strong the association between variables is, relationships are identified and provide a basis for managerial action. All cells have more than 5 observations and thus there should be no issued regarding the observed frequencies. Data should be observed to better understand the relationship between variables relating to catalogue readers. Successful analysis will allow managers to make more informed decisions and more efficiently allocate resources and time. Q1 * Q2 Crosstabulation|

| Q2| Total|
| Female| Male| |
Q1| 30 or younger| Count| 168| 113| 281|
| | % within Q1| 59.8%| 40.2%| 100.0%|
| 31 to 55| Count| 199| 297| 496|
| | % within Q1| 40.1%| 59.9%| 100.0%|
| 56 or older| Count| 128| 74| 202|
| | % within Q1| 63.4%| 36.6%| 100.0%|
Total| Count| 495| 484| 979|
| % within Q1| 50.6%| 49.4%| 100.0%|

Based on this qualitative comparison it can be seen in the margin that information was collected from a sample of 979 respondents. Based on the data it is evident that the majority of catalogue readers form part of the 31 to 55 age demographic, making up 50.6% of respondents. It was also noted that females made up 50.5% of total respondents. In terms of managerial implications it is important to utilise the data to form a target market and management can more efficiently utilise resources. Based on the data it is noted that male’s readers in the 31 to 55 age bracket formed 30.3% of catalogue readers. Although this is the strongest demographic it must also be noted that other categories cannot be ignored as the form a healthy portion of catalogue readers. Q2 * Q7 Crosstabulation|

| Q7| Total|
| 0| 1| 2| 3| |
Q2| Female| Count| 201| 144| 80| 70| 495|
| | % within Q2| 40.6%| 29.1%| 16.2%| 14.1%| 100.0%| | Male| Count| 255| 113| 65| 51| 484|
| | % within Q2| 52.7%| 23.3%| 13.4%| 10.5%| 100.0%| Total| Count| 456| 257| 145| 121| 979|
| % within Q2| 46.6%| 26.3%| 14.8%| 12.4%| 100.0%|

Crosstab analysis was undertaken to understand the relationship between reader’s gender and number of children in the household. It is identified that male and females with no children form 46.6% of the total sample. It appears that the gender split is fairly even and reader figures get gradually smaller as the number of children increase. In this sense managers must acknowledge that the majority of their readers have no or minimal children. This in turn may affect the content and overall style of the catalogue. Q1 * Q4 Crosstabulation|

| Q4| Total|
| Otherwise| Married| |
Q1| 30 or younger| Count| 202| 79| 281|
| | % within Q1| 71.9%| 28.1%| 100.0%|
| 31 to 55| Count| 210| 286| 496|
| | % within Q1| 42.3%| 57.7%| 100.0%|
| 56 or older| Count| 77| 125| 202|
| | % within Q1| 38.1%| 61.9%| 100.0%|
Total...
tracking img