Stats

profileCap
MobileData_PrashNair.xlsx
Home>Mathematics homework help>Statistics homework help>Stats

Variables

Variable descriptions:
Income Annual Income of the smart phone user in dollars ($)
Gender Gender of the smart phone user
Age Age of the smart phone user in Years
State State where the smart phone user resides
geoTribe The geoTribe the smart phone user belongs https://geotribesonline.com/geoTribes/Content/popupTribes.aspx?id=1
OwnsTablet The smart phone user also owns a Tablet device
UsedforPayment Used the smart phone as an eftpos, a credit card
PostPaid The smart phone is on a post paid contract
MonthlyBill The amount spent last month on the smart phone in dollars ($)
MonthlyCap The monthly smart phone cap in dollars ($)
PercentForWork The percentage use of smart phone for work in percentage
Calls The number of calls made last month
SMS The number of text messages sent last month
MMS The number of multi-media messages sent last month
Data The monthly data allowance on the smart phone in GB
OnLinePurchase Used the smart phone to purchase an item online
SocialNetworking Used the smart phone to visit a social networking site
MonthlySocialNet The number of visits to social networking site using the smart phone last month
EntertainmentContent Most frequent downloaded entertainment content
SatisfactionWithProvider The level of satisfaction with the smart phone service provider
SatisfactionWithPlan The level of satisfaction with the smart phone plan
https://geotribesonline.com/geoTribes/Content/popupTribes.aspx?id=1

Data

Respondent Income Gender Age State geoTribe OwnsTablet UsedForPayment PostPaid MonthlyBill ($) MonthlyCap PercentForWork% Calls SMS MMS Data OnLinePurchase SocialNetworking MonthlySocialNet EntertainmentContent SatisfactionWithProvider SatisfactionWithPlan
1 $98,191 Male 33 NSW Independents Yes Yes Yes 66 45 15 23 16 1 1 Yes Yes 15 Music, Video and Movies Very Satisfied Little Dissatisfied
2 $62,500 Female 33 VIC Crusaders Yes Yes Yes 60 45 10 21 16 3 1 Yes Yes 13 Music, Video and Movies Moderately Satisfied Moderately Satisfied
3 $99,742 Female 32 VIC Crusaders Yes Yes Yes 98 95 10 12 22 1 3.5 Yes Yes 9 News and Weather Apps Very Satisfied Moderately Satisfied
4 $55,000 Female 19 QLD Struggleville No No Yes 73 70 0 22 21 0 2.5 No Yes 8 News and Weather Apps Very Satisfied Very Satisfied
5 $99,671 Male 36 QLD Achievers No Yes No 20 0 5 30 3 0 0.1 Yes Yes 10 IM and Social Network Apps Very Satisfied Very Satisfied
6 $103,200 Female 31 VIC Achievers Yes Yes Yes 105 95 35 54 11 0 3 No Yes 15 Music, Video and Movies Moderately Satisfied Very Satisfied
7 $98,955 Male 52 NSW Suburban Splendour Yes Yes Yes 96 95 40 7 5 3 3.5 Yes Yes 3 IM and Social Network Apps Moderately Satisfied Very Satisfied
8 $101,800 Female 41 NSW Crusaders Yes Yes Yes 55 45 35 22 4 0 1.5 Yes Yes 1 Games Very Satisfied Very Satisfied
9 $101,534 Female 58 WA Rokafella Yes Yes Yes 95 95 10 10 14 3 3 No Yes 9 eBooks Moderately Satisfied Little Dissatisfied
10 $97,930 Female 42 VIC Independents No Yes Yes 98 45 20 46 13 0 1 Yes Yes 40 Games Very Dissatisfied Very Dissatisfied
11 $90,025 Male 32 VIC Independents Yes Yes No 50 0 20 28 19 0 0.5 Yes Yes 6 Games Little Dissatisfied Very Satisfied
12 $101,782 Female 56 ACT Achievers Yes Yes Yes 88 70 15 34 20 4 2 No Yes 4 Games Moderately Satisfied Little Dissatisfied
13 $102,384 Female 45 VIC Suburban Splendour Yes Yes Yes 74 55 35 33 8 2 1 No Yes 3 Music, Video and Movies Little Dissatisfied Moderately Satisfied
14 $48,652 Female 39 SA Struggleville No Yes Yes 61 45 0 42 18 0 1 No Yes 4 Music, Video and Movies Little Dissatisfied Little Dissatisfied
15 $101,262 Female 25 VIC Achievers Yes Yes Yes 99 95 20 44 15 2 3 Yes Yes 20 Games Very Satisfied Very Dissatisfied
16 $93,853 Male 41 NSW Twixters Yes Yes Yes 26 20 15 14 1 0 0.2 No Yes 9 Games Very Satisfied Very Satisfied
17 $98,678 Female 26 QLD Preppies Yes Yes No 70 0 0 41 5 0 1 Yes Yes 11 Games Moderately Satisfied Very Satisfied
18 $99,398 Female 35 NSW Achievers Yes Yes Yes 54 45 15 11 8 0 1 Yes Yes 3 Music, Video and Movies Very Dissatisfied Very Dissatisfied
19 $45,000 Male 34 SA Slender Meanz No No Yes 37 0 0 14 14 0 0 No No 0 eBooks Very Satisfied Little Dissatisfied
20 $96,286 Female 34 NSW Independents Yes Yes Yes 95 95 15 2 12 0 2.5 No Yes 3 Music, Video and Movies Very Satisfied Little Dissatisfied
21 $96,210 Female 55 QLD True Blue Yes Yes No 30 0 5 20 12 0 1 Yes Yes 0 IM and Social Network Apps Little Dissatisfied Moderately Satisfied
22 $58,500 Male 38 NSW Independents Yes Yes Yes 61 55 0 22 0 0 1.5 No Yes 1 Maps and Navigation Apps Little Dissatisfied Very Satisfied
23 $99,082 Male 34 NT Independents Yes Yes Yes 86 55 5 28 16 0 1 Yes No 0 Games Very Satisfied Little Dissatisfied
24 $69,000 Female 23 VIC Independents Yes Yes Yes 70 70 0 7 12 1 2.5 No Yes 5 Games Very Satisfied Very Satisfied
25 $40,000 Female 44 NSW Suburban Splendour Yes Yes Yes 55 45 0 23 12 3 1.5 No Yes 15 Music, Video and Movies Very Satisfied Moderately Satisfied
26 $99,063 Male 37 VIC Crusaders Yes Yes Yes 55 45 20 67 8 0 1.5 Yes Yes 6 Music, Video and Movies Very Satisfied Moderately Satisfied
27 $100,378 Male 37 WA Independents Yes Yes Yes 65 45 15 13 7 0 1.5 No Yes 1 Music, Video and Movies Moderately Satisfied Very Satisfied
28 $101,912 Female 38 WA Suburban Splendour Yes Yes Yes 78 70 10 32 16 0 2 No Yes 19 Music, Video and Movies Very Satisfied Very Satisfied
29 $82,000 Female 23 NSW Achievers No No Yes 72 70 5 37 9 0 2.5 No Yes 9 Music, Video and Movies Very Satisfied Very Satisfied
30 $96,531 Female 38 SA Independents Yes Yes Yes 75 45 5 25 2 1 1.5 Yes Yes 1 IM and Social Network Apps Moderately Satisfied Moderately Satisfied
31 $97,200 Male 35 SA Achievers Yes Yes No 50 0 25 45 16 0 1 No Yes 6 IM and Social Network Apps Moderately Satisfied Very Satisfied
32 $250,250 Male 55 NT Rokafella Yes Yes Yes 55 45 10 13 12 1 1.5 Yes Yes 15 Music, Video and Movies Moderately Satisfied Moderately Satisfied
33 $100,818 Female 34 SA Independents Yes Yes Yes 75 70 15 12 21 0 2 Yes Yes 1 Music, Video and Movies Very Satisfied Moderately Satisfied
34 $99,650 Female 37 SA Achievers Yes Yes Yes 96 95 5 24 2 1 3 No Yes 6 Games Moderately Satisfied Very Satisfied
35 $97,338 Male 35 VIC Independents Yes Yes No 50 0 20 26 21 0 2.5 Yes Yes 1 Music, Video and Movies Very Satisfied Very Satisfied
36 $99,993 Male 33 SA Independents No Yes Yes 74 55 5 35 16 1 1.5 No Yes 0 Games Little Dissatisfied Little Dissatisfied
37 $99,374 Female 39 SA Independents Yes Yes Yes 117 95 5 68 13 3 3 No Yes 4 Games Very Satisfied Very Dissatisfied
38 $98,364 Female 59 WA Grey Power Yes Yes Yes 64 55 35 24 18 1 1.5 No Yes 0 Games Little Dissatisfied Moderately Satisfied
39 $151,500 Male 56 QLD Boomers Yes Yes Yes 90 70 10 4 17 0 2 No Yes 10 Other Very Satisfied Very Dissatisfied
40 $52,000 Male 18 SA Debtstars No No Yes 51 35 0 17 10 1 0.5 Yes Yes 8 Games Moderately Satisfied Very Dissatisfied
41 $96,445 Male 36 QLD Suburban Splendour No No Yes 81 55 5 66 13 4 1 Yes Yes 4 Music, Video and Movies Very Satisfied Moderately Satisfied
42 $99,524 Male 40 WA Achievers Yes Yes Yes 55 45 5 2 12 1 1.5 No Yes 0 Games Moderately Satisfied Very Satisfied
43 $102,800 Female 54 TAS Suburban Splendour Yes Yes Yes 78 70 50 45 18 4 2.5 No Yes 0 IM and Social Network Apps Very Satisfied Very Dissatisfied
44 $70,000 Male 52 SA True Blue Yes Yes Yes 60 35 0 37 10 1 0.5 No Yes 0 Games Moderately Satisfied Very Dissatisfied
45 $96,907 Male 45 NSW Independents Yes Yes Yes 64 55 15 23 22 3 1.5 Yes Yes 0 IM and Social Network Apps Moderately Satisfied Little Dissatisfied
46 $99,336 Male 33 QLD Crusaders Yes Yes Yes 101 95 5 39 10 2 2.5 Yes Yes 4 Music, Video and Movies Moderately Satisfied Very Dissatisfied
47 $156,750 Female 36 QLD Preppies Yes Yes Yes 57 55 15 15 12 0 1.5 No No 0 Games Very Satisfied Very Satisfied
48 $97,568 Female 36 VIC Achievers Yes No Yes 54 45 20 5 17 1 1 No Yes 38 News and Weather Apps Very Satisfied Moderately Satisfied
49 $95,877 Female 43 VIC Crusaders No No Yes 71 55 20 43 15 1 1.5 Yes Yes 0 Music, Video and Movies Very Satisfied Moderately Satisfied
50 $54,000 Female 35 NSW Struggleville Yes No Yes 77 70 0 10 22 2 2 No Yes 6 Music, Video and Movies Moderately Satisfied Moderately Satisfied
51 $100,583 Male 49 QLD Suburban Splendour Yes Yes Yes 70 70 50 16 5 0 2 No No 0 Games Moderately Satisfied Very Satisfied
52 $98,772 Male 35 ACT Independents No Yes No 50 0 5 51 3 0 0.5 Yes Yes 6 IM and Social Network Apps Very Dissatisfied Moderately Satisfied
53 $99,991 Male 44 SA Suburban Splendour Yes Yes Yes 58 35 5 17 1 3 1 Yes Yes 0 News and Weather Apps Very Satisfied Little Dissatisfied
54 $51,000 Male 19 QLD Twixters No No Yes 55 35 0 22 5 1 0.5 Yes Yes 15 Music, Video and Movies Very Dissatisfied Little Dissatisfied
55 $100,146 Male 39 QLD Crusaders No Yes Yes 49 35 15 10 6 1 0.5 No Yes 9 News and Weather Apps Very Satisfied Very Dissatisfied
56 $95,641 Female 36 SA Independents Yes Yes Yes 72 70 5 17 10 3 2.5 Yes Yes 6 Music, Video and Movies Moderately Satisfied Very Satisfied
57 $96,757 Male 37 VIC Preppies Yes Yes Yes 62 45 40 49 9 0 1 No No 0 News and Weather Apps Very Satisfied Little Dissatisfied
58 $97,485 Male 34 VIC Achievers No Yes No 50 0 50 20 5 2 0.5 No Yes 3 Other Moderately Satisfied Moderately Satisfied
59 $97,864 Male 52 WA Suburban Splendour Yes Yes Yes 86 70 10 57 11 2 2.5 No Yes 0 Music, Video and Movies Moderately Satisfied Moderately Satisfied
60 $101,595 Male 45 TAS Achievers No Yes Yes 100 95 15 23 24 3 3 No Yes 3 Music, Video and Movies Moderately Satisfied Very Satisfied
61 $103,265 Female 53 NSW Suburban Splendour Yes Yes Yes 78 55 35 39 18 3 1.5 No No 0 News and Weather Apps Very Satisfied Moderately Satisfied
62 $156,225 Male 44 QLD Suburban Splendour Yes Yes Yes 71 70 15 12 16 0 2.5 Yes No 0 Music, Video and Movies Very Satisfied Very Satisfied
63 $125,000 Male 55 SA Fortunats No Yes Yes 46 45 5 6 16 1 1 No Yes 4 Music, Video and Movies Very Dissatisfied Very Satisfied
64 $45,000 Female 38 VIC Debtstars Yes Yes Yes 83 70 0 59 19 3 2.5 No Yes 0 Music, Video and Movies Little Dissatisfied Moderately Satisfied
65 $100,361 Male 26 WA Achievers Yes Yes Yes 11 0 10 5 2 0 0 Yes No 0 News and Weather Apps Moderately Satisfied Very Satisfied
66 $101,928 Male 42 NSW Suburban Splendour Yes Yes No 40 0 35 22 14 1 0.5 Yes Yes 9 eBooks Very Satisfied Very Dissatisfied
67 $68,900 Male 18 NSW Crusaders Yes Yes Yes 72 70 0 19 18 2 2 No Yes 25 Music, Video and Movies Very Satisfied Very Satisfied
68 $100,200 Male 35 VIC Suburban Splendour Yes Yes Yes 85 70 35 18 16 0 2.5 Yes No 0 eBooks Very Satisfied Moderately Satisfied
69 $101,722 Female 35 NSW Crusaders Yes Yes Yes 79 55 35 53 15 1 1.5 Yes Yes 4 Music, Video and Movies Moderately Satisfied Moderately Satisfied
70 $250,000 Male 35 QLD Suburban Splendour Yes Yes Yes 65 45 40 14 5 0 1.5 Yes No 0 IM and Social Network Apps Very Satisfied Moderately Satisfied
71 $86,000 Female 28 NSW Independents Yes Yes Yes 87 70 15 14 22 1 1.5 No Yes 31 IM and Social Network Apps Moderately Satisfied Very Satisfied
72 $160,000 Female 56 SA Grey Power No Yes Yes 70 70 35 4 25 2 1.5 No Yes 0 Other Moderately Satisfied Moderately Satisfied
73 $97,832 Male 40 VIC Achievers No Yes Yes 82 70 50 48 9 0 2.5 No Yes 0 Music, Video and Movies Moderately Satisfied Very Dissatisfied
74 $98,864 Female 27 QLD Twixters Yes No Yes 74 70 0 23 4 0 2.5 No Yes 19 Music, Video and Movies Very Satisfied Very Satisfied
75 $225,000 Male 40 WA Preppies Yes No No 50 0 15 24 5 0 0.5 Yes No 0 eBooks Very Satisfied Very Satisfied
76 $63,450 Female 19 VIC Struggleville Yes Yes Yes 25 0 0 1 14 0 0.1 No Yes 5 IM and Social Network Apps Moderately Satisfied Very Satisfied
77 $42,000 Male 32 VIC Debtstars Yes Yes No 50 0 0 42 23 0 0.5 No Yes 0 Music, Video and Movies Moderately Satisfied Very Satisfied
78 $102,420 Male 55 ACT Suburban Splendour Yes Yes Yes 45 35 15 14 4 0 0.5 Yes No 0 eBooks Moderately Satisfied Very Satisfied
79 $100,150 Female 39 SA Crusaders Yes Yes Yes 95 95 50 29 9 0 2.5 Yes Yes 0 IM and Social Network Apps Very Satisfied Moderately Satisfied
80 $99,064 Female 41 NSW Achievers No Yes No 30 0 15 27 5 0 1 No Yes 13 IM and Social Network Apps Moderately Satisfied Little Dissatisfied
81 $95,110 Female 28 NSW Crusaders Yes Yes No 50 0 5 22 17 2 2.5 Yes Yes 15 IM and Social Network Apps Very Satisfied Moderately Satisfied
82 $97,146 Female 52 NSW Boomers Yes Yes No 50 0 15 54 6 1 1 No Yes 6 Music, Video and Movies Very Satisfied Very Satisfied
83 $85,000 Female 24 NSW Achievers No No Yes 74 55 5 48 20 5 1 No Yes 19 Music, Video and Movies Moderately Satisfied Moderately Satisfied
84 $98,660 Female 39 QLD Independents No No No 20 0 5 24 10 0 0.1 No Yes 9 IM and Social Network Apps Very Dissatisfied Little Dissatisfied
85 $150,500 Female 51 WA Rokafella Yes Yes Yes 166 120 15 48 17 5 4 Yes No 0 Music, Video and Movies Very Dissatisfied Very Dissatisfied
86 $100,969 Female 50 NSW Suburban Splendour Yes No Yes 131 120 35 59 15 0 3.5 Yes Yes 0 Music, Video and Movies Little Dissatisfied Little Dissatisfied
87 $96,053 Male 44 VIC Achievers No No Yes 49 35 60 53 17 0 1.5 No No 0 Music, Video and Movies Very Satisfied Moderately Satisfied
88 $95,931 Male 29 WA Achievers Yes Yes Yes 121 120 0 8 22 3 3.5 No Yes 25 Music, Video and Movies Little Dissatisfied Very Satisfied
89 $35,350 Female 53 QLD Slender Meanz No No No 30 0 0 19 12 0 0.2 No Yes 0 Games Moderately Satisfied Little Dissatisfied
90 $96,656 Male 37 ACT Preppies Yes Yes Yes 68 55 5 28 3 1 1.5 No Yes 3 Games Very Satisfied Moderately Satisfied
91 $90,164 Female 46 NSW Suburban Splendour No No Yes 58 45 15 13 17 4 1 Yes Yes 5 Games Very Satisfied Moderately Satisfied
92 $150,600 Male 56 NSW Fortunats No No Yes 66 45 35 32 14 0 1 No No 0 Games Moderately Satisfied Moderately Satisfied
93 $94,562 Female 34 VIC Independents No Yes Yes 128 120 20 64 12 0 3.5 Yes No 0 Games Moderately Satisfied Moderately Satisfied
94 $95,017 Female 38 NSW Preppies Yes Yes Yes 68 55 45 4 13 1 1.5 Yes Yes 3 eBooks Very Satisfied Little Dissatisfied
95 $99,371 Male 37 NSW Independents No No Yes 79 55 50 72 20 0 1.5 Yes No 0 Games Moderately Satisfied Little Dissatisfied
96 $69,000 Male 36 NSW Independents Yes Yes Yes 42 0 0 11 23 0 0 No No 0 Games Very Satisfied Moderately Satisfied
97 $38,000 Female 42 TAS Independents Yes Yes Yes 44 0 0 2 15 0 0 No No 0 Music, Video and Movies Moderately Satisfied Little Dissatisfied
98 $95,957 Female 54 QLD Boomers No Yes Yes 60 55 40 22 17 3 2.5 No Yes 0 Other Very Satisfied Moderately Satisfied
99 $101,095 Male 39 NSW Achievers Yes Yes No 20 0 35 2 2 1 0.1 Yes Yes 6 Other Very Satisfied Moderately Satisfied
100 $97,277 Female 35 VIC Crusaders Yes Yes No 20 0 20 8 8 0 0.1 Yes No 0 eBooks Very Satisfied Very Satisfied
101 $96,511 Male 33 NSW Achievers Yes Yes Yes 131 120 15 63 10 0 4 Yes No 0 Music, Video and Movies Moderately Satisfied Little Dissatisfied
102 $98,645 Female 36 WA Crusaders Yes Yes Yes 98 95 5 45 22 0 3 Yes Yes 0 eBooks Moderately Satisfied Little Dissatisfied
103 $96,290 Male 39 NSW Achievers Yes Yes Yes 62 35 15 44 2 0 1 No Yes 6 Games Very Satisfied Moderately Satisfied
104 $59,000 Female 20 QLD Struggleville No No Yes 28 0 0 9 22 0 0 No No 0 Maps and Navigation Apps Very Satisfied Little Dissatisfied
105 $93,250 Male 58 NT Boomers No No No 40 0 5 36 15 1 0.5 No Yes 6 Games Moderately Satisfied Very Satisfied
106 $95,314 Female 37 NSW Crusaders No No No 40 0 15 13 3 1 2 No Yes 6 Games Little Dissatisfied Little Dissatisfied
107 $189,000 Male 20 SA Crusaders Yes Yes Yes 57 55 10 10 0 0 2.5 Yes No 0 News and Weather Apps Moderately Satisfied Very Satisfied
108 $96,997 Male 36 QLD Achievers Yes No No 40 0 5 7 14 0 2 No No 0 Maps and Navigation Apps Little Dissatisfied Very Dissatisfied
109 $145,000 Male 61 NSW Grey Power No Yes Yes 44 35 60 5 6 2 1 No Yes 0 Games Moderately Satisfied Moderately Satisfied
110 $97,351 Female 38 TAS Achievers No No No 20 0 5 23 19 0 0 No No 0 News and Weather Apps Moderately Satisfied Moderately Satisfied
111 $79,000 Male 20 VIC Crusaders Yes No Yes 110 95 0 46 15 1 2.5 Yes Yes 6 Music, Video and Movies Moderately Satisfied Moderately Satisfied
112 $80,000 Male 32 VIC Independents Yes Yes Yes 102 95 20 26 15 0 2.5 No No 0 News and Weather Apps Very Satisfied Moderately Satisfied
113 $155,000 Male 44 TAS Preppies Yes No Yes 59 55 15 45 11 0 2.5 Yes Yes 25 IM and Social Network Apps Very Satisfied Very Dissatisfied
114 $102,983 Male 37 QLD Crusaders No Yes Yes 111 95 15 50 10 3 2.5 Yes Yes 6 eBooks Moderately Satisfied Little Dissatisfied
115 $97,321 Female 29 NT Achievers Yes Yes Yes 106 95 0 44 12 3 2.5 Yes No 0 eBooks Moderately Satisfied Very Satisfied
116 $93,448 Female 60 QLD True Blue Yes Yes Yes 61 55 50 28 7 0 2.5 No No 0 Games Moderately Satisfied Moderately Satisfied
117 $98,305 Female 53 WA Boomers No No Yes 126 120 50 32 26 0 3.5 No Yes 31 IM and Social Network Apps Moderately Satisfied Little Dissatisfied
118 $95,818 Female 41 QLD Twixters No No Yes 16 0 5 9 2 0 0 Yes Yes 2 eBooks Moderately Satisfied Moderately Satisfied
119 $75,000 Female 39 NSW Crusaders Yes No Yes 31 0 0 8 16 0 0 Yes No 0 Maps and Navigation Apps Very Dissatisfied Very Dissatisfied
120 $97,176 Male 44 SA Suburban Splendour Yes Yes Yes 41 35 5 3 9 3 1 Yes Yes 5 IM and Social Network Apps Very Satisfied Very Satisfied
121 $94,675 Female 45 SA Suburban Splendour No No No 40 0 5 22 6 1 2 No Yes 0 eBooks Very Satisfied Very Satisfied
122 $101,413 Male 45 QLD Suburban Splendour Yes Yes Yes 104 95 15 6 24 0 2.5 No No 0 Music, Video and Movies Very Dissatisfied Little Dissatisfied
123 $72,000 Female 36 VIC Crusaders Yes No Yes 123 120 10 33 28 0 3.5 No Yes 0 Games Very Dissatisfied Very Dissatisfied
124 $55,000 Male 24 NSW Struggleville No Yes No 20 0 0 9 11 0 0.1 No Yes 8 News and Weather Apps Very Satisfied Moderately Satisfied
125 $96,073 Female 34 VIC Independents Yes Yes Yes 45 45 20 1 8 1 1 Yes Yes 3 Games Very Satisfied Moderately Satisfied
126 $96,509 Female 52 WA True Blue Yes Yes Yes 101 95 5 13 20 0 2.5 No Yes 0 Games Very Satisfied Very Dissatisfied
127 $94,600 Male 33 QLD Crusaders No No No 30 0 5 16 10 1 0.2 Yes Yes 4 IM and Social Network Apps Very Satisfied Moderately Satisfied
128 $100,846 Female 37 NSW Preppies Yes Yes No 30 0 35 28 10 0 1 Yes Yes 20 IM and Social Network Apps Moderately Satisfied Moderately Satisfied
129 $58,000 Male 19 VIC Independents Yes Yes Yes 32 0 0 6 13 0 0 Yes No 0 News and Weather Apps Very Satisfied Moderately Satisfied
130 $54,000 Female 42 QLD Struggleville No No Yes 47 45 0 6 19 2 1 No Yes 5 IM and Social Network Apps Moderately Satisfied Moderately Satisfied
131 $95,297 Female 49 NSW Suburban Splendour No Yes Yes 59 35 50 17 14 1 1 Yes Yes 0 eBooks Moderately Satisfied Moderately Satisfied
132 $88,887 Female 42 VIC Achievers No Yes Yes 59 55 20 28 18 2 2.5 Yes Yes 5 eBooks Moderately Satisfied Moderately Satisfied
133 $230,000 Male 40 SA Achievers Yes Yes Yes 216 0 45 47 13 1 0 No No 0 eBooks Very Dissatisfied Very Dissatisfied
134 $97,000 Male 32 VIC Achievers Yes Yes Yes 58 55 20 30 8 0 1.5 Yes No 0 Music, Video and Movies Very Satisfied Very Satisfied
135 $58,000 Female 34 VIC Debtstars Yes Yes Yes 113 95 10 45 21 0 2.5 No No 0 News and Weather Apps Very Satisfied Moderately Satisfied
136 $96,691 Female 40 QLD Twixters Yes Yes No 20 0 5 21 11 0 0.1 No Yes 8 IM and Social Network Apps Moderately Satisfied Very Satisfied
137 $100,267 Female 49 NSW Suburban Splendour No No Yes 71 55 35 17 14 0 2.5 No Yes 25 IM and Social Network Apps Very Satisfied Moderately Satisfied
138 $102,770 Male 33 NSW Achievers Yes No Yes 77 70 35 16 16 0 2 Yes Yes 38 IM and Social Network Apps Moderately Satisfied Very Satisfied
139 $100,345 Male 40 NSW Crusaders No Yes No 70 0 35 41 14 1 0.5 Yes Yes 0 eBooks Moderately Satisfied Very Satisfied
140 $180,000 Male 51 SA Rokafella Yes Yes Yes 61 55 50 19 6 0 1.5 Yes Yes 0 IM and Social Network Apps Moderately Satisfied Very Satisfied
141 $98,673 Female 53 SA Suburban Splendour Yes Yes No 30 0 5 29 2 1 0.2 No Yes 5 eBooks Very Satisfied Moderately Satisfied
142 $95,000 Male 28 VIC Crusaders Yes Yes Yes 70 70 20 14 25 0 2 Yes Yes 20 Music, Video and Movies Very Satisfied Very Satisfied
143 $162,000 Male 35 VIC Suburban Splendour Yes Yes Yes 95 95 35 19 12 0 3 Yes Yes 1 Maps and Navigation Apps Moderately Satisfied Moderately Satisfied
144 $100,601 Female 31 NSW Suburban Splendour Yes Yes Yes 100 95 35 10 31 1 2.5 No Yes 6 eBooks Very Dissatisfied Very Satisfied
145 $98,853 Male 46 QLD Suburban Splendour No Yes No 30 0 5 26 7 2 1 No Yes 6 Other Moderately Satisfied Moderately Satisfied
146 $97,756 Female 42 SA Crusaders Yes Yes Yes 64 55 5 30 18 1 1 Yes Yes 0 Maps and Navigation Apps Moderately Satisfied Moderately Satisfied
147 $70,000 Female 43 NSW True Blue Yes Yes Yes 124 120 0 9 9 2 3.5 No Yes 6 Music, Video and Movies Moderately Satisfied Little Dissatisfied
148 $165,000 Female 39 WA Preppies Yes Yes Yes 55 55 15 3 16 3 2.5 Yes Yes 4 IM and Social Network Apps Very Satisfied Very Satisfied
149 $95,570 Female 52 WA Boomers Yes No Yes 38 20 50 13 0 1 0.2 No Yes 0 eBooks Moderately Satisfied Moderately Satisfied
150 $95,838 Female 35 ACT Suburban Splendour Yes Yes Yes 121 120 5 48 11 4 3.5 No No 0 Games Moderately Satisfied Moderately Satisfied

Q1

MonthlyBill ($) Mean $67.65
Median 64
Mean $67.65 Mode 50
Standard Error $2.55 Variance $959.67
Median $64.00 Standard Deviation $30.98
Mode $50.00 Max $216.00
Standard Deviation $31.18 Min $11.00
Sample Variance $972.46 Range $205.00
Kurtosis $2.82 1st Quartile $49.25
Skewness $1.05 3nd Quartile $84.50
Range $205.00 Interquartile $35.25
Minimum $11.00 Coef of Variantion 45.79%
Maximum $216.00
Sum $10,147.00
Count $150.00

Q2

Row Labels Sum of MonthlyBill ($)
Achievers $1,999.00
Suburban Splendour $1,940.00
Independents $1,747.00
Grand Total $5,686.00

Total Achievers Suburban Splendour Independents 1999 1940 1747

Q3

MonthlyBill ($)
Mean 67.6466666667 Mean 67.6466666667 Lower Higher
Standard Error 2.5461843482 Confidence Level(95.0%) 5.031293825 62.6153728417 72.6779604916
Median 64
Mode 50
Standard Deviation 31.1842622214
Sample Variance 972.4582102908
Kurtosis 2.820304198
Skewness 1.0528035482
Range 205
Minimum 11
Maximum 216
Sum 10147
Count 150
Confidence Level(95.0%) 5.031293825
Response Sample Size = n 150
Yes Count of Yes 114 Yes
Yes Count of No 36 No
Yes Sample proportion = point estimate P bar  Proportion of all smart phone owners in Australia that use their phone as a  payment device
No P(Yes) 0.76
Yes P(No) 0.24
Yes n*p>5 114 TRUE Normal Curve
Yes n*(1-p)>5 36 TRUE
Yes Confidence Level 0.95
Yes Signifiance Level 0.05
Yes alpha/2 0.025
Yes z upper 1.9599639845
Yes Standard Error 5.23
Yes Margin of Error 10.25
Yes Lower Limit -9.49
Yes Upper Limit 11.01
Yes The 95% confidence interval for the proportion of customer who use cell phone to pay bills
Yes
Yes
No Gender Sample Size = n 150
Yes Male Count of Yes 71 Male
Yes Female Count of No 79 Female
Yes Female
Yes Female P(Yes) 0.4733333333
Yes Male P(No) 0.5266666667
Yes Female n*p>5 71
Yes Male n*(1-p)>5 79
Yes Female Confidence Level 0.95
Yes Female Signifiance Level 0.05
No Female alpha/2 0.025
Yes Male z upper 1.9599639845
Yes Female Standard Error 6.12
Yes Female Margin of Error 11.99
Yes Female Lower Limit -11.51
Yes Female Upper Limit 12.46
Yes Male
Yes Female
Yes Female
Yes Male
Yes Female
No Female
No Male
Yes Male
Yes Female
Yes Female
Yes Male
Yes Male
Yes Female
No Female
No Female
No Male
Yes Male
Yes Female
Yes Female
No Male
Yes Male
Yes Female
Yes Female
Yes Male
Yes Male
Yes Male
Yes Male
Yes Female
Yes Male
Yes Male
Yes Male
Yes Female
Yes Female
Yes Female
Yes Female
Yes Male
Yes Male
Yes Male
Yes Male
No Male
No Female
Yes Male
Yes Male
Yes Male
Yes Male
Yes Female
Yes Male
Yes Male
No Female
No Male
Yes Male
No Male
No Male
Yes Female
No Male
Yes Female
No Female
No Male
Yes Female
Yes Male
No Female
Yes Male
Yes Male
Yes Female
Yes Female
Yes Female
Yes Female
Yes Female
Yes Female
No Female
No Female
No Male
Yes Male
No Female
Yes Male
No Female
No Male
Yes Female
No Female
Yes Male
Yes Male
Yes Female
No Female
No Male
No Female
Yes Male
No Female
Yes Male
No Female
Yes Male
Yes Female
Yes Male
No Male
Yes Male
Yes Female
No Male
Yes Male
Yes Male
Yes Male
Yes Female
Yes Female
Yes Female
No Female
No Female
Yes Male
Yes Female
Yes Male
Yes Female
Yes Male
Yes Female
Yes Female
Yes Male
Yes Female
Yes Male
No Female
Yes Female
Female
Male
Male
Female
Female
Female
Male
Male
Male
Female
Male
Male
Female
Male
Female
Female
Female
Female
Female

Q4

Q5

Q6

CI - Template

- Instructions
1. Cells shaded in blue are for inputs (it is important that you do not change any other cells)
2. Cells shaded in green represent final results or important calculations
3. Non-shaded cells show intermediate results
Confidence Interval for mean (σ known) Confidence Interval for mean (σ unknown) Confidence Interval for proportion (π)
Data Data Data
Population Standard Deviation (σ) Sample Standard Deviation (s) Sample Size
Sample Mean (X) Sample Mean (X) Count of Successes
Sample Size Sample Size Confidence Level
Confidence Level Confidence Level
Intermediate Calculations Intermediate Calculations Intermediate Calculations
Standard Error of the Mean ERROR:#DIV/0! =C10/SQRT(C12) Standard Error of the Mean ERROR:#DIV/0! =H10/SQRT(H12) Sample Proportion ERROR:#DIV/0! =M11/M10
Degrees of Freedom -1 =H12-1 Z Value 0.0000 =NORMSINV(1-(1-M12)/2)
Z Value 0.0000 =NORMSINV(1-(1-C13)/2) t Value ERROR:#NUM! =TINV(1-H13,H17) Standard Error of the Proportion ERROR:#DIV/0! =SQRT(M16*(1-M16)/M10)
Margin of Error ERROR:#DIV/0! =ABS(C18*C16) Margin of Error ERROR:#NUM! =ABS(H18*H16) Margin of Error ERROR:#DIV/0! =ABS(M17*M18)
Confidence Interval Confidence Interval Confidence Interval
Interval Lower Limit ERROR:#DIV/0! =C11-C19 Interval Lower Limit ERROR:#NUM! =H11-H19 Interval Lower Limit ERROR:#DIV/0! =M16-M19
Interval Upper Limit ERROR:#DIV/0! =C11+C19 Interval Upper Limit ERROR:#NUM! =H11+H19 Interval Upper Limit ERROR:#DIV/0! =M16+M19

HT - Template

- Instructions
1. Cells shaded in blue are for inputs (it is important that you do not change any other cells)
2. Cells shaded in green represent final results or important calculations
3. Non-shaded cells show intermediate results
4. In cells D7 and J7 the ONLY valid values are '<', '>' or '<>'. Note that '<>' represents not equal.
Hypothesis Test for µ (Mean) Hypothesis Test for π (Proportion)
Hypotheses =IF(D12=">","≤",IF(D12="<","≥","=")) Hypotheses =IF(K12=">","≤",IF(K12="<","≥","="))
Null Hypothesis µ = =IF(E12="","",E12) Null Hypothesis π = =IF(L12="","",L12)
Alternative Hypothesis µ <> Alternative Hypothesis π <>
Test Type Two =IF(D12="<","Lower",IF(D12=">","Upper","Two")) Test Type Two =IF(K12="<","Lower",IF(K12=">","Upper","Two"))
Level of significance Level of significance
α α
Critical Region Critical Region
Degrees of Freedom -1 =E23-1 Lower Critical Value ERROR:#NUM! =IF(L13="Two",NORMSINV(L15/2),IF(L13="Lower",NORMSINV(L15),NORMSINV(1-L15)))
Lower Critical Value ERROR:#NUM! =IF(E13="Two",-(TINV(E15,E17)),IF(E13="Lower",-(TINV(E15*2,E17)),TINV(E15*2,E17))) Upper Critical Value ERROR:#NUM! =IF(K11="=",-L17,"")
Upper Critical Value ERROR:#NUM! =IF(D11="=",-E18,"") Sample Data
Sample Data Sample Size
Sample Standard Deviation Count of 'Successes'
Sample Mean
Sample Size Sample proportion, p ERROR:#DIV/0! =L21/L20
Standard Error ERROR:#VALUE! =SQRT(L11*(1-L11)/L20)
Standard Error of the Mean ERROR:#DIV/0! =E21/SQRT(E23) Z Sample Statistic ERROR:#DIV/0! =(L23-L11)/L24
t Sample Statistic ERROR:#VALUE! =(E22-E11)/E25 p-value ERROR:#DIV/0! =IF(L13="Two",2*(1-NORMSDIST(ABS(L25))),IF(L25*L17>0,1-NORMSDIST(ABS(L25)),NORMSDIST(ABS(L25))))
p-value ERROR:#VALUE! =IF(D11="=",TDIST(ABS(E26),E17,2),IF(E26*E18>0,TDIST(ABS(E26),E17,1),1-TDIST(ABS(E26),E17,1)))
Decision
Decision ERROR:#DIV/0! =IF(L26<L15,"Reject Null Hypothesis", "Fail to reject Null Hypothesis")
ERROR:#VALUE! =IF(E27<E15,"Reject Null Hypothesis", "Fail to reject Null Hypothesis")

SS - Template

- Instructions
1. Cells shaded in blue are for inputs (it is important that you do not change any other cells)
2. Cells shaded in green represent final results or important calculations
3. Non-shaded cells show intermediate results
Sample size for a Mean Sample size for a Proportion
Data Data
Population Standard Deviation Estimate of True Proportion
Sampling Error Sampling Error
Confidence Level Confidence Level
Intermediate Calculations Intermediate Calculations
Z value 0.0000 =NORM.S.INV((1+C12)/2) Z value 0.0000 =NORM.S.INV((1+H12)/2)
Calculated Sample Size ERROR:#DIV/0! =((C15*C10)/C11)^2 Calculated Sample Size ERROR:#DIV/0! =(H15^2*H10*(1-H10))/H11^2
Result Result
Sample Size Needed ERROR:#DIV/0! =ROUNDUP(C16,0) Sample Size Needed ERROR:#DIV/0! =ROUNDUP(H16,0)