PLZ read carefully

profilerude-1
qnt561_opulence_team_a_data.xlsx
Home>Reading homework help>PLZ read carefully

ChartDataSheet_

This worksheet contains values required for MegaStat charts.
NormalPlot 1/31/2016 14:19.27
89.58 -2.2461975356
110.29 -1.965272419
114.34 -1.7861555613
117.46 -1.6508684855
120.78 -1.5404250053
121.22 -1.4461035929
128.25 -1.3631364655
128.58 -1.2886181677
129.8 -1.2206403488
130.46 -1.1578786036
130.46 -1.0993740653
132.02 -1.0444087949
132.34 -0.9924303205
133.98 -0.9430036962
134.41 -0.8957798189
135.54 -0.8504737864
136.51 -0.8068496911
137.79 -0.7647096738
138.04 -0.7238858749
142.61 -0.6842344044
144.8 -0.6456307493
145.86 -0.6079662226
147.88 -0.5711451806
150.48 -0.5350828151
151.35 -0.4997033822
151.91 -0.4649387655
152.96 -0.4307272993
153.23 -0.3970127959
153.54 -0.3637437333
157.52 -0.3308725717
157.83 -0.2983551728
159.16 -0.2661503012
160.13 -0.2342191939
160.19 -0.2025251833
160.89 -0.1710333647
161.43 -0.1397102989
161.46 -0.1085237438
162.43 -0.0774424085
164.4 -0.0464357248
166.43 -0.0154736315
169.64 0.0154736315
169.84 0.0464357248
175.81 0.0774424085
176.2 0.1085237438
177.28 0.1397102989
177.29 0.1710333647
177.41 0.2025251833
178.16 0.2342191939
180.23 0.2661503012
183.25 0.2983551728
187.38 0.3308725717
187.68 0.3637437333
187.9 0.3970127959
194.01 0.4307272993
194.2 0.4649387655
194.95 0.4997033822
195.55 0.5350828151
201.76 0.5711451806
203.18 0.6079662226
206.18 0.6456307493
206.95 0.6842344044
209.73 0.7238858749
210.33 0.7647096738
210.72 0.8068496911
215.56 0.8504737864
217.37 0.8957798189
218.85 0.9430036962
218.94 0.9924303205
221.62 1.0444087949
222.62 1.0993740653
224.36 1.1578786036
224.68 1.2206403488
226.03 1.2886181677
230.64 1.3631364655
230.84 1.4461035929
239.37 1.5404250053
248.34 1.6508684855
252.87 1.7861555613
258.05 1.965272419
282.45 2.2461975356

Raw Data

Obs Sex MonthlyPurchasesAmt
1 1 132.34
2 2 230.64
3 1 160.19
4 2 121.22
5 1 218.85
6 2 130.46
7 1 130.46
8 2 128.58
9 1 224.68
10 2 187.38
11 1 133.98
12 2 258.05
13 1 194.2
14 2 177.29
15 1 224.36
16 2 129.8
17 1 230.84
18 2 215.56
19 1 177.41
20 2 210.72
21 1 177.28
22 2 221.62
23 1 128.25
24 2 110.29
25 1 194.01
26 2 132.02
27 1 89.58
28 2 226.03
29 1 160.89
30 2 117.46
31 1 164.4
32 2 150.48
33 1 209.73
34 2 239.37
35 1 157.83
36 2 161.46
37 1 152.96
38 2 282.45
39 1 145.86
40 2 210.33
41 1 169.64
42 2 114.34
43 1 206.18
44 2 222.62
45 1 183.25
46 2 162.43
47 1 135.54
48 2 147.88
49 1 248.34
50 2 194.95
51 1 136.51
52 2 159.16
53 1 144.8
54 2 153.23
55 1 180.23
56 2 157.52
57 1 252.87
58 2 120.78
59 1 142.61
60 2 137.79
61 1 151.91
62 2 160.13
63 1 187.68
64 2 161.43
65 1 218.94
66 2 187.9
67 1 217.37
68 2 201.76
69 1 138.04
70 2 166.43
71 1 175.81
72 2 151.35
73 1 195.55
74 2 169.84
75 1 178.16
76 2 153.54
77 1 203.18
78 2 134.41
79 1 176.2
80 2 206.95

Data

Obs Sex MonthlyPurchasesAmt Sex Value
1 1 132.34 Male 1
2 2 230.64 Female 2
3 1 160.19
4 2 121.22
5 1 218.85
6 2 130.46
7 1 130.46
8 2 128.58
9 1 224.68
10 2 187.38
11 1 133.98
12 2 258.05
13 1 194.2
14 2 177.29
15 1 224.36
16 2 129.8
17 1 230.84
18 2 215.56
19 1 177.41
20 2 210.72
21 1 177.28
22 2 221.62
23 1 128.25
24 2 110.29
25 1 194.01
26 2 132.02
27 1 89.58
28 2 226.03
29 1 160.89
30 2 117.46
31 1 164.4
32 2 150.48
33 1 209.73
34 2 239.37
35 1 157.83
36 2 161.46
37 1 152.96
38 2 282.45
39 1 145.86
40 2 210.33
41 1 169.64
42 2 114.34
43 1 206.18
44 2 222.62
45 1 183.25
46 2 162.43
47 1 135.54
48 2 147.88
49 1 248.34
50 2 194.95
51 1 136.51
52 2 159.16
53 1 144.8
54 2 153.23
55 1 180.23
56 2 157.52
57 1 252.87
58 2 120.78
59 1 142.61
60 2 137.79
61 1 151.91
62 2 160.13
63 1 187.68
64 2 161.43
65 1 218.94
66 2 187.9
67 1 217.37
68 2 201.76
69 1 138.04
70 2 166.43
71 1 175.81
72 2 151.35
73 1 195.55
74 2 169.84
75 1 178.16
76 2 153.54
77 1 203.18
78 2 134.41
79 1 176.2
80 2 206.95

T-Test Data Setup

Obs Sex MonthlyPurchasesAmt Obs Sex MonthlyPurchasesAmt Sex Value
1 1 132.34 2 2 230.64 Male 1
3 1 160.19 4 2 121.22 Female 2
5 1 218.85 6 2 130.46
7 1 130.46 8 2 128.58
9 1 224.68 10 2 187.38
11 1 133.98 12 2 258.05
13 1 194.2 14 2 177.29
15 1 224.36 16 2 129.8
17 1 230.84 18 2 215.56
19 1 177.41 20 2 210.72
21 1 177.28 22 2 221.62
23 1 128.25 24 2 110.29
25 1 194.01 26 2 132.02
27 1 89.58 28 2 226.03
29 1 160.89 30 2 117.46
31 1 164.4 32 2 150.48
33 1 209.73 34 2 239.37
35 1 157.83 36 2 161.46
37 1 152.96 38 2 282.45
39 1 145.86 40 2 210.33
41 1 169.64 42 2 114.34
43 1 206.18 44 2 222.62
45 1 183.25 46 2 162.43
47 1 135.54 48 2 147.88
49 1 248.34 50 2 194.95
51 1 136.51 52 2 159.16
53 1 144.8 54 2 153.23
55 1 180.23 56 2 157.52
57 1 252.87 58 2 120.78
59 1 142.61 60 2 137.79
61 1 151.91 62 2 160.13
63 1 187.68 64 2 161.43
65 1 218.94 66 2 187.9
67 1 217.37 68 2 201.76
69 1 138.04 70 2 166.43
71 1 175.81 72 2 151.35
73 1 195.55 74 2 169.84
75 1 178.16 76 2 153.54
77 1 203.18 78 2 134.41
79 1 176.2 80 2 206.95

Overall - Histogram

Descriptive statistics
MonthlyPurchasesAmt
count 80
mean 174.4570
sample standard deviation 39.8116
sample variance 1,584.9619
minimum 89.58
maximum 282.45
range 192.87
Confidence Interval 165.73 to 183.18
population variance 1,565.1498
population standard deviation 39.5620
skewness 0.3806
kurtosis -0.4150
coefficient of variation (CV) 22.82%
1st quartile 144.2525
median 168.0350
3rd quartile 206.3725
interquartile range 62.1200
mode 130.4600
low extremes 0
low outliers 0
high outliers 0
high extremes 0
normal curve GOF
p-value .2487
chi-square(df=4) 5.400
E 11.429
O(-1.07) 11
O(-0.57) 15
O(-0.18) 14
O(+0.18) 9
O(+0.57) 8
O(+1.07) 8
O(inf.) 15
1/31/2016 14:19.27 (1)
Frequency Distribution - Quantitative
MonthlyPurchasesAmt cumulative
lower upper midpoint width frequency percent frequency percent
80.0 < 100.0 90.0 20.0 1 1.3 1 1.3
100.0 < 120.0 110.0 20.0 3 3.8 4 5.0
120.0 < 140.0 130.0 20.0 15 18.8 19 23.8
140.0 < 160.0 150.0 20.0 13 16.3 32 40.0
160.0 < 180.0 170.0 20.0 16 20.0 48 60.0
180.0 < 200.0 190.0 20.0 9 11.3 57 71.3
200.0 < 220.0 210.0 20.0 11 13.8 68 85.0
220.0 < 240.0 230.0 20.0 8 10.0 76 95.0
240.0 < 260.0 250.0 20.0 3 3.8 79 98.8
260.0 < 280.0 270.0 20.0 0 0.0 79 98.8
280.0 < 300.0 290.0 20.0 1 1.3 80 100.0
299.9999
80 100.0
Frequency Distribution - Quantitative
MonthlyPurchasesAmt cumulative
lower upper midpoint width frequency percent frequency percent
50 < 100 75 50 1 1.3 1 1.3
100 < 150 125 50 22 27.5 23 28.8
150 < 200 175 50 34 42.5 57 71.3
200 < 250 225 50 20 25.0 77 96.3
250 < 300 275 50 3 3.8 80 100.0
299.99
80 100.0

Normal Curve Plot

-2.246197535640817 -1.9652724189717774 -1.7861555612610771 -1.650868485473737 -1.5404250053004738 -1.4461035929181751 -1.3631364655496254 -1.2886181677160637 -1.2206403488473501 -1.1578786036450242 -1.0993740652715556 -1.044408794872596 -0.992430320 51921043 -0.94300369618010627 -0.89577981888358915 -0.85047378635746862 -0.80684969106197935 -0.76470967378638721 -0.72388587485264355 -0.68423440435168836 -0.64563074927598219 -0.60796622258963939 -0.5711451805595068 -0.53508281508632238 -0.49970338220778376 -0.46493876548308039 -0.43072729929545767 -0.39701279585878191 -0.36374373325425935 -0.33087257172641926 -0.29835517279388102 -0.26615030120687433 -0.23421919391461965 -0.20252518334641723 -0.17103336471311076 -0.13971029888186212 -0.1085237437982694 -7.7442408521528686E-2 -4.6435724770527133E-2 -1.5473631502458951E-2 1.5473631502458951E-2 4.6435724770526994E-2 7.7442408521528686E-2 0.10852374379826926 0.13971029888186212 0.17103336471311062 0.20252518334641723 0.23421919391461951 0.26615030120687433 0.29835517279388085 0.33087257172641926 0.36374373325425924 0.39701279585878191 0.4307272992954575 0.46493876548308039 0.49970338220778371 0.53508281508632238 0.57114518055950669 0.60796622258963939 0.64563074927598207 0.68423440435168836 0.72388587485264322 0.76470967378638721 0.80684969106197912 0.85047378635746862 0.89577981888358904 0.94300369618010627 0.9924303205192091 1.044408794872596 1.0993740652715556 1.1578786036450242 1.2206403488473503 1.2886181677160637 1.363136465549625 1.4461035929181758 1.5404250053004735 1.650868485473737 1.7861555612610764 1.9652724189717774 2.2461975356408153 89.58 110.29 114.34 117.46 120.78 121.22 128.25 128.58000000000001 129.80000000000001 130.46 130.46 132.02000000000001 132.34 133.97999999999999 134.41 135.54 136.51 137.79 138.04 142.61000000000001 144.80000000000001 145.86000000000001 147.88 150.47999999999999 151.35 151.91 152.96 153.22999999999999 153.54 157.52000000000001 157.83000000000001 159.16 160.13 160.19 160.88999999999999 161.43 161.46 162.43 164.4 166.43 169.64 169.84 175.81 176.2 177.28 177.29 177.41 178.16 180.23 183.25 187.38 187.68 187.9 194.01 194.2 194.95 195.55 201.76 203.18 206.18 206.95 209.73 210.33 210.72 215.56 217.37 218.85 218.94 221.62 222.62 224.36 224.68 226.03 230.64 230.84 239.37 248.34 252.87 258.05 282.45

Normal Score

MonthlyPurchasesAmt

Histogram

80 100 120 140 160 180 200 220 240 260 280 299.99990000000003 1. 25 3.75 18.75 16.25 20 11.25 13.750000000000002 10 3.75 0 1.25

MonthlyPurchasesAmt

Percent

Histogram

50 100 150 200 250 299.99 1.25 27.500000000000004 42.5 25 3.75

MonthlyPurchasesAmt

Percent

Bar Graph - Sex

Frequency Distribution - Qualitative
Sex
frequency percent
1 40 50.0
2 40 50.0
80 100.0

Histogram

1 2 50 50

Sex

Percent