qnt/561

profilerholmes123
inferential_statistics_and_findings_1.xlsx

Data

Number Sex Age Group Rate of Customer Experience (1-5) Rate of Product Brought(1-5) Recommend this company
1 F 18-29 5 5 Yes Independent Variable: Public Image
7 M 18-29 5 5 Yes Dependent Variable: Sales
8 M 18-29 5 5 Yes
10 F 18-29 5 5 Yes
13 M 18-29 5 5 Yes
14 F 18-29 3 5 Yes
15 F 18-29 5 5 Yes
16 M 18-29 4 4 Yes
17 M 18-29 2 3 No
18 M 18-29 5 4 Yes
19 F 18-29 4 5 Yes
20 F 18-29 4 3 Yes
21 F 18-29 5 4 Yes
22 M 18-29 5 4 Yes
23 F 18-29 5 4 Yes
24 F 18-29 5 4 Yes
25 F 18-29 5 5 Yes
26 M 18-29 5 5 Yes
27 M 18-29 4 5 Yes
28 M 18-29 2 2 No
29 M 18-29 4 4 Yes
30 M 18-29 5 4 Yes
31 M 18-29 4 4 Yes
32 F 18-29 4 3 Yes
33 F 18-29 4 3 Yes
34 F 18-29 1 1 No
35 M 18-29 4 3 Yes
36 F 18-29 5 3 Yes
37 F 18-29 4 4 Yes
38 F 18-29 4 4 Yes
39 F 18-29 4 4 Yes
40 F 18-29 5 3 Yes
41 F 18-29 5 5 Yes
42 M 18-29 4 5 Yes
43 M 18-29 2 2 No
44 M 18-29 5 5 Yes
45 M 18-29 3 5 Yes
46 M 18-29 5 3 Yes
47 M 18-29 5 5 Yes
48 M 18-29 4 5 Yes
49 F 18-29 4 4 Yes
50 F 18-29 5 4 Yes
51 F 18-29 4 4 Yes
52 M 18-29 4 5 Yes
53 F 18-29 5 4 Yes
54 F 18-29 4 4 Yes
55 M 18-29 5 5 Yes
56 M 18-29 4 3 Yes
57 M 18-29 5 4 Yes
58 M 18-29 5 5 Yes
59 M 18-29 5 5 Yes
60 F 18-29 5 3 Yes
61 F 18-29 5 3 Yes
62 M 18-29 5 4 Yes
63 F 18-29 5 5 Yes
64 F 18-29 5 5 Yes
65 F 18-29 4 5 Yes
66 M 18-29 5 5 Yes
67 F 18-29 4 5 Yes
68 F 18-29 4 5 Yes
69 F 18-29 5 5 Yes
70 F 18-29 3 5 Yes
71 F 18-29 4 4 Yes
72 F 18-29 5 5 Yes
73 M 18-29 1 2 No
74 F 18-29 4 5 Yes
75 F 18-29 4 3 Yes
76 F 18-29 4 4 Yes
77 F 18-29 3 4 Yes
78 M 18-29 5 4 Yes
79 M 18-29 3 4 Yes
80 F 18-29 3 4 Yes
81 F 18-29 3 4 Yes
82 M 18-29 5 5 Yes
83 M 18-29 5 5 Yes
84 M 18-29 5 5 Yes
85 F 18-29 5 5 Yes
86 F 18-29 5 4 Yes
87 F 18-29 5 4 Yes
88 F 18-29 4 4 Yes
89 F 18-29 5 5 Yes
90 M 18-29 5 5 Yes
91 M 18-29 5 5 Yes
92 F 18-29 5 5 Yes
93 F 18-29 5 5 Yes
94 F 18-29 5 5 Yes
95 F 18-29 5 5 Yes
96 M 18-29 4 5 Yes
97 F 18-29 5 5 Yes
98 M 18-29 5 4 Yes
99 M 18-29 5 5 Yes
100 M 18-29 5 4 Yes
101 F 18-29 5 4 Yes
102 M 18-29 3 3 Yes
103 M 18-29 4 4 Yes
104 F 18-29 4 4 Yes
105 F 18-29 5 5 Yes
106 F 18-29 5 4 Yes
107 F 18-29 5 4 Yes
108 F 18-29 5 5 Yes
109 M 18-29 5 5 Yes
110 M 18-29 5 5 Yes
111 M 18-29 3 5 Yes
112 M 18-29 5 4 Yes
113 F 18-29 5 5 Yes
114 F 18-29 5 5 Yes
115 F 18-29 5 5 Yes
116 M 18-29 5 4 Yes
117 M 18-29 4 4 Yes
118 F 18-29 4 4 Yes
119 F 18-29 5 4 Yes
120 F 18-29 5 5 Yes
121 F 18-29 5 5 Yes
122 M 18-29 4 4 Yes
123 F 18-29 2 2 No
124 F 18-29 4 5 Yes
125 M 18-29 4 3 Yes
126 M 18-29 4 5 Yes
127 M 18-29 3 4 Yes
128 M 18-29 3 5 Yes
129 F 18-29 3 3 Yes
130 F 18-29 5 4 Yes
131 M 18-29 5 5 Yes
132 M 18-29 4 5 Yes
133 F 18-29 4 5 Yes
134 F 18-29 5 5 Yes
135 M 18-29 5 5 Yes
136 F 18-29 5 5 Yes
3 F 30-39 5 5 Yes
4 F 30-39 5 5 Yes
9 M 30-39 5 5 Yes
12 F 30-39 5 5 Yes
14 F 30-39 5 5 Yes
16 F 30-39 4 5 Yes
17 F 30-39 4 4 Yes
18 F 30-39 3 4 Yes
19 M 30-39 4 4 Yes
20 M 30-39 4 3 Yes
21 F 30-39 5 5 Yes
22 F 30-39 4 4 Yes
23 F 30-39 1 3 No
24 F 30-39 5 4 Yes
25 F 30-39 5 4 Yes
26 F 30-39 4 4 Yes
27 M 30-39 4 3 Yes
28 M 30-39 4 4 Yes
29 M 30-39 5 4 Yes
30 F 30-39 5 5 Yes
31 F 30-39 5 5 Yes
32 M 30-39 5 5 Yes
33 F 30-39 5 5 Yes
34 F 30-39 5 5 Yes
35 F 30-39 5 5 Yes
36 M 30-39 5 3 Yes
37 M 30-39 4 3 Yes
38 M 30-39 4 5 Yes
39 F 30-39 4 4 Yes
40 F 30-39 4 5 Yes
41 F 30-39 4 5 Yes
42 F 30-39 4 5 Yes
43 F 30-39 4 3 Yes
44 F 30-39 5 3 Yes
45 F 30-39 4 4 Yes
46 M 30-39 5 4 Yes
47 M 30-39 4 4 Yes
48 M 30-39 1 2 No
49 F 30-39 4 5 Yes
50 F 30-39 3 5 Yes
51 F 30-39 3 3 Yes
52 M 30-39 5 5 Yes
53 M 30-39 5 3 Yes
54 M 30-39 4 5 Yes
55 M 30-39 4 3 Yes
56 M 30-39 4 3 Yes
57 F 30-39 5 3 Yes
58 F 30-39 5 3 Yes
59 F 30-39 5 3 Yes
60 M 30-39 4 5 Yes
61 M 30-39 4 5 Yes
62 F 30-39 5 3 Yes
63 F 30-39 4 4 Yes
64 F 30-39 4 4 Yes
65 F 30-39 5 5 Yes
66 F 30-39 5 3 Yes
67 M 30-39 5 5 Yes
68 M 30-39 5 3 Yes
69 F 30-39 5 3 Yes
70 F 30-39 5 3 Yes
71 F 30-39 5 4 Yes
72 F 30-39 5 4 Yes
73 M 30-39 5 5 Yes
74 F 30-39 4 5 Yes
75 F 30-39 4 5 Yes
76 F 30-39 5 5 Yes
77 M 30-39 5 4 Yes
78 M 30-39 5 4 Yes
79 F 30-39 5 5 Yes
80 M 30-39 5 5 Yes
81 M 30-39 4 4 Yes
82 F 30-39 5 4 Yes
83 F 30-39 3 5 Yes
84 F 30-39 5 5 Yes
85 F 30-39 4 3 Yes
86 F 30-39 5 3 Yes
87 M 30-39 5 3 Yes
88 M 30-39 4 3 Yes
89 M 30-39 5 5 Yes
90 M 30-39 4 5 Yes
91 F 30-39 5 4 Yes
92 F 30-39 5 5 Yes
93 F 30-39 4 4 Yes
94 F 30-39 5 5 Yes
95 M 30-39 4 3 Yes
96 F 30-39 4 5 Yes
97 M 30-39 3 3 Yes
98 M 30-39 4 4 Yes
99 F 30-39 5 4 Yes
100 M 30-39 5 4 Yes
101 F 30-39 5 4 Yes
102 F 30-39 4 5 Yes
103 F 30-39 5 3 Yes
104 M 30-39 5 4 Yes
105 M 30-39 5 3 Yes
106 F 30-39 5 3 Yes
107 F 30-39 4 3 Yes
108 F 30-39 2 2 No
109 M 30-39 4 3 Yes
110 M 30-39 5 3 Yes
111 M 30-39 5 5 Yes
112 F 30-39 4 3 Yes
113 F 30-39 5 5 Yes
114 F 30-39 4 5 Yes
115 F 30-39 4 5 Yes
116 F 30-39 5 5 Yes
117 F 30-39 5 5 Yes
118 F 30-39 4 5 Yes
119 F 30-39 5 4 Yes
120 M 30-39 4 4 Yes
121 F 30-39 5 4 Yes
122 F 30-39 3 3 Yes
123 F 30-39 5 4 Yes
124 M 30-39 5 5 Yes
125 M 30-39 5 4 Yes
126 M 30-39 5 3 Yes
127 F 30-39 5 3 Yes
128 F 30-39 5 5 Yes
129 F 30-39 5 4 Yes
130 F 30-39 5 4 Yes
131 F 30-39 5 4 Yes
132 M 30-39 5 4 Yes
133 M 30-39 5 4 Yes
134 M 30-39 5 4 Yes
135 M 30-39 5 5 Yes
136 F 30-39 4 5 Yes
137 F 30-39 5 4 Yes
138 M 30-39 4 4 Yes
139 M 30-39 4 4 Yes
140 F 30-39 5 4 Yes
141 F 30-39 5 4 Yes
142 F 30-39 3 4 Yes
143 M 30-39 4 5 Yes
144 M 30-39 4 4 Yes
145 F 30-39 5 5 Yes
146 F 30-39 4 4 Yes
147 M 30-39 4 5 Yes
148 M 30-39 4 4 Yes
149 F 30-39 2 2 No
150 M 30-39 4 4 Yes
151 F 30-39 5 4 Yes
152 M 30-39 4 4 Yes
153 F 30-39 5 4 Yes
154 M 30-39 5 5 Yes
155 F 30-39 5 5 Yes
156 M 30-39 2 2 No
157 F 30-39 4 5 Yes
158 M 30-39 5 5 Yes
159 M 30-39 4 5 Yes
160 M 30-39 4 5 Yes
161 F 30-39 5 5 Yes
2 M 40-49 5 5 Yes
5 M 40-49 5 5 Yes
6 M 40-49 5 5 Yes
19 F 40-49 3 5 Yes
20 M 40-49 3 5 Yes
21 M 40-49 3 4 Yes
22 M 40-49 3 3 Yes
23 F 40-49 3 3 Yes
24 F 40-49 4 4 Yes
25 M 40-49 5 4 Yes
26 M 40-49 5 4 Yes
27 M 40-49 5 3 Yes
28 M 40-49 5 4 Yes
29 M 40-49 3 4 Yes
30 F 40-49 4 3 Yes
31 F 40-49 4 3 Yes
32 F 40-49 4 3 Yes
33 F 40-49 5 3 Yes
34 F 40-49 4 4 Yes
35 F 40-49 4 4 Yes
36 F 40-49 5 5 Yes
37 M 40-49 5 5 Yes
38 M 40-49 3 5 Yes
39 M 40-49 4 3 Yes
40 F 40-49 5 3 Yes
41 M 40-49 5 4 Yes
42 M 40-49 4 4 Yes
43 F 40-49 4 4 Yes
44 F 40-49 5 4 Yes
45 F 40-49 3 5 Yes
46 F 40-49 5 4 Yes
47 F 40-49 4 4 Yes
48 M 40-49 5 5 Yes
49 M 40-49 4 5 Yes
50 M 40-49 5 4 Yes
51 M 40-49 5 4 Yes
52 F 40-49 3 5 Yes
53 M 40-49 5 4 Yes
54 M 40-49 5 4 Yes
55 F 40-49 5 5 Yes
56 F 40-49 5 5 Yes
57 F 40-49 5 5 Yes
58 F 40-49 5 4 Yes
59 M 40-49 5 4 Yes
60 M 40-49 5 3 Yes
61 M 40-49 1 3 No
62 F 40-49 5 3 Yes
63 F 40-49 4 5 Yes
64 F 40-49 5 5 Yes
65 F 40-49 5 5 Yes
66 F 40-49 3 5 Yes
67 M 40-49 2 2 No
68 F 40-49 5 4 Yes
69 F 40-49 5 4 Yes
70 F 40-49 5 5 Yes
71 M 40-49 5 5 Yes
72 M 40-49 5 5 Yes
73 M 40-49 5 3 Yes
74 F 40-49 4 4 Yes
75 M 40-49 5 5 Yes
76 M 40-49 5 5 Yes
77 M 40-49 5 5 Yes
78 F 40-49 1 2 No
79 F 40-49 5 5 Yes
80 F 40-49 4 5 Yes
81 M 40-49 4 5 Yes
82 M 40-49 5 4 Yes
83 F 40-49 5 5 Yes
84 F 40-49 3 5 Yes
85 M 40-49 4 5 Yes
86 F 40-49 5 4 Yes
87 M 40-49 4 5 Yes
88 F 40-49 5 4 Yes
89 F 40-49 5 5 Yes
11 F 50-59 5 5 Yes
12 M 50-59 5 4 Yes
13 M 50-59 4 4 Yes
14 M 50-59 4 4 Yes
15 F 50-59 4 3 Yes
16 M 50-59 5 4 Yes
17 M 50-59 4 5 Yes
18 F 50-59 5 3 Yes
19 M 50-59 4 4 Yes
20 F 50-59 2 3 No
21 F 50-59 4 4 Yes
22 M 50-59 5 4 Yes
23 M 50-59 3 3 Yes
24 M 50-59 5 5 Yes
25 M 50-59 5 5 Yes
26 F 50-59 4 5 Yes
27 F 50-59 4 5 Yes
28 M 50-59 4 4 Yes
29 M 50-59 5 4 Yes
30 M 50-59 5 3 Yes
31 M 50-59 5 4 Yes
32 F 50-59 4 4 Yes
33 F 50-59 5 4 Yes
34 F 50-59 5 5 Yes
15 F Older than 60 5 5 Yes
16 F Older than 60 4 3 Yes
17 F Older than 60 5 4 Yes
18 M Older than 60 4 3 Yes
19 F Older than 60 4 4 Yes
20 F Older than 60 5 5 Yes
21 M Older than 60 5 5 Yes
Total:
18-29 558 550
30-39 668 621
40-49 320 312
50-59 105 98
Older than 60 32 29
1683 1610

Anova

Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Rate of Customer Experience (1-5) 384 1683 4.3828125 0.727745594
Rate of Product Brought(1-5) 384 1610 4.1927083333 0.7095028285
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 6.9388020833 1 6.9388020833 9.6556753509 0.0019573897 3.8536271797
Within Groups 550.4661458333 766 0.7186242113
Total 557.4049479167 767

Two-Sample

t-Test: Two-Sample Assuming Equal Variances
Rate of Customer Experience (1-5) Rate of Product Brought(1-5)
Mean 4.3828125 4.1927083333
Variance 0.727745594 0.7095028285
Observations 384 384
Pooled Variance 0.7186242113
Hypothesized Mean Difference 0
df 766
t Stat 3.1073582592
P(T<=t) one-tail 0.0009786949
t Critical one-tail 1.6468453043
P(T<=t) two-tail 0.0019573897
t Critical two-tail 1.9630657604

Descriptive Statistics

Rate of Customer Experience (1-5) Rate of Product Brought(1-5)
Mean 4.3828125 Mean 4.1927083333
Standard Error 0.0435335597 Standard Error 0.0429844578
Median 5 Median 4
Mode 5 Mode 5
Standard Deviation 0.8530800631 Standard Deviation 0.8423199087
Sample Variance 0.727745594 Sample Variance 0.7095028285
Kurtosis 3.1004285636 Kurtosis -0.137253168
Skewness -1.6599564644 Skewness -0.74592845
Range 4 Range 4
Minimum 1 Minimum 1
Maximum 5 Maximum 5
Sum 1683 Sum 1610
Count 384 Count 384
Confidence Level(95.0%) 0.0855946921 Confidence Level(95.0%) 0.0845150606