# Hofstra University Type of Statistical Tests and Excel Worksheet For the first two problems below, refer to the spreadsheet ttest HW. 1.For this problem,

Hofstra University Type of Statistical Tests and Excel Worksheet For the first two problems below, refer to the spreadsheet ttest HW. 1.For this problem, refer to tab q1. There are two sets of data: Dataset 1 and 2. Plot both on a scatter plot and plot the linear regression line using Excel. Show the R2 value. Interpret these plots  what information can you extract about the direction and strength of the correlation? 2.For this problem, refer to tab q2 This spreadsheet contains 7 pairs of distributions. Plot the distributions (one pair per plot) and perform two-tailed t tests for independent samples for each pair (? = 0.05). DO NOT use statistical software  show your work in a spreadsheet (without using the TTEST function in excel) and turn this in for credit. How are the distribution pairs different from each other? What is the same? How do the different parameters of the distributions effect the resulting p values? 3.You are designing an experiment to test the effectiveness of a new type of radiation therapy on prostate cancer. The primary endpoint of the study is to reduce mean rectal dose to the patient. How would you design the experiment? What type of statistical tests could you use? dataset 1
x
dataset 2
y
7
9
9
12
14
16
16
14
16
16
16
17
19
21
24
15
16
17
25
27
15
15
15
16
19
18
17
18
20
22
25
24
x
25
25
26
27
27
27
26
30
30
31
30
31
30
28
32
32
32
32
32
34
34
34
35
35
34
35
36
37
38
40
39
43
y
7
9
9
12
14
16
16
14
16
16
16
17
19
21
24
15
16
17
25
27
15
15
15
16
19
18
17
18
20
22
25
24
23
25
26
27
29
34
28
30
28
31
30
31
36
37
41
30
32
32
45
43
34
34
32
33
34
35
36
37
38
40
39
43
55,66416
88,32114
181,2807
109,7176
62,01106
88,68763
99,92234
126,6699
106,0939
112,4378
109,5714
86,95215
138,1473
101,2335
98,87814
114,6797
108,3933
97,48328
113,0504
160,7124
122,9907
94,27795
89,13131
1
147,7546
196,9003
102,0502
75,77831
162,1854
150,7833
109,2828
91,26118
124,9567
69,80871
117,6438
89,48302
82,22769
153,7181
116,214
169,0439
71,54503
124,6106
73,15275
139,7487
167,2014
155,9396
30,3847
142,2692
115,3484
128,3709
81,88746
76,7537
117,4522
104,0123
122,0899
88,57613
155,8043
112,9335
135,1288
104,5539
106,1
126,5612
123,3382
83,11388
73,21537
83,65117
76,02144
111,4297
100,13
101,1677
77,33688
128,7096
120,5459
2
109,7783
82,26777
155,8788
115,8551
131,8574
98,2821
67,97942
136,8635
127,5144
177,9611
162,0682
172,1322
100,0449
92,54694
79,23653
149,9192
241,5632
159,1029
99,07744
163,4654
84,86679
73,0212
158,6977
98,88378
142,6394
186,2614
127,5009
99,73901
98,09453
109,8596
117,5229
110,018
100,2041
111,3818
112,4848
104,6653
96,55412
115,2243
110,2051
105,6442
102,4252
103,9961
99,59368
97,51888
125,1852
107,1025
89,25162
104,1411
122,7246
3
111,4299
125,1545
108,802
107,1126
109,6052
113,2374
115,1606
165,6359
90,53514
93,56499
119,9212
113,9878
100,397
121,5397
130,0598
91,92557
106,8427
89,24187
116,6716
118,276
128,6515
93,27265
120,9498
112,1338
142,8391
121,1349
108,0637
104,9625
100,0367
128,0749
119,005
107,8461
109,3107
112,1534
109,9272
106,5778
115,6042
103,1701
121,7434
99,42062
108,06
115,2356
110,7075
100,9817
115,531
110,9795
105,112
112,4223
114,5369
4
115,317
118,4127
114,1647
121,1642
109,75
125,0771
133,291
115,8529
114,3168
109,3653
110,2643
97,96465
114,4628
106,1866
127,5589
116,5584
115,5493
128,9855
97,24352
118,2965
104,421
108,5663
117,5844
123,9169
106,6338
120,5315
100,0871
96,93
109,4238
90,78767
97,70743
74,31979
97,55259
93,3625
123,8636
144,9192
134,8516
135,1238
126,2291
123,1183
127,9997
92,48386
129,9969
81,23479
124,8506
90,0221
86,70812
99,11574
78,73502
110,3834
136,6558
104,015
121,8968
113,8889
139,0837
106,2004
117,0313
169,2251
137,5096
87,58777
136,875
87,81856
110,2378
116,9448
130,8801
100,4657
122,9086
152,4737
64,26836
84,15805
138,6786
102,9452
5
113,4729
151,9574
203,9224
62,92418
78,64037
111,9
115,0204
119,2742
102,5014
163,7859
78,61754
123,1591
154,5899
130,008
90,11495
119,8222
102,3042
91,01265
169,1262
107,0933
91,87992
84,76122
119,848
55,16634
49,15364
122,7159
63,40922
99,00604
146,0161
151,886
176,7814
74,61751
149,2683
128,0115
165,0976
123,8063
147,6079
160,5769
98,53156
96,5574
61,83806
111,5
129,2178
85,27445
117,8812
100,7439
155,8578
110,6526
120,2511
117,7608
70,42477
113,3681
98,04697
99,73345
106,379
40,62056
92,37099
128,1492
112,899
97,61826
101,8194
84,08019
93,26267
96,00808
105,533
124,1111
109,495
108,0857
89,94765
133,4869
115,6515
123,5851
115,263
129,3851
146,3006
99,6408
123,0215
126,3032
109,7896
155,8866
86,51322
98,3329
111,8696
110,6288
104,6532
98,48707
129,7901
108,5503
90,63767
151,1081
131,8918
145,7322
6
87,34731
80,28046
94,49969
83,71654
132,0316
155,4616
104,9733
137,1694
145,3552
120,3537
104,0975
93,29489
68,47582
104,0593
121,3802
107,5317
123,7162
116,8495
141,813
89,77996
110,2636
124,6826
99,95661
126,2178
44,02191
133,3431
133,4729
114,9525
100,8824
97,68035
46,80904
158,8287
140,4309
71,51263
55,90938
99,59002
142,2335
148,306
136,3839
145,721
185,1955
46,8275
133,7803
112,8278
85,045
143,6706
97,73233
146,1731
147,653
160,9322
71,6016
109,5551
109,358
155,9798
132,0723
66,60563
79,63261
124,0071
107,2115
106,5485
135,7945
150,8525
119,3896
113,056
164,0223
109,7437
99,18682
95,71881
92,34393
111,9607
89,33943
65,39815
79,16271
120,4689
136,1908
138,8625
165,5087
83,9845
142,7488
111,9603
98,77323
99,76689
131,351
125,594
66,65171
134,5927
129,8056
104,328
86,44962
91,52988
80,33305
108,7948
100,6721
102,5133
115,3128
102,8642
69,26733
95,63098
114,7795
163,0046
73,63931
81,09729
132,3369
79,49904
119,8493
98,9238
158,8671
132,467
98,71981
89,45239
98,80475
210,7545
113,0151
106,897
107,0986
175,6526
45,71168
159,4989
86,22876
104,0654
142,0962
77,54197
132,0287
112,0183
59,04771
122,6922
138,2156
140,5144
92,36074
114,3545
139,8929
136,3375
99,42637
64,13329
125,904
127,6987
174,9347
52,84797
100,8283
132,3691
110,9409
196,1507
100,3115
20,44901
144,1943
59,03917
167,5955
131,153
101,2334
75,79743
189,2938
127,3815
95,43589
87,20467
107,7843
165,2513
76,58032
118,353
92,72814
152,6595
89,16939
114,1041
159,018
135,2986
109,594
121,5
167,6659
143,6155
78,1184
114,4331
135,5565
73,16361
116,9281
108,3641
116,921
90,67818
66,15236
84,26162
154,9974
106,8864
87,16326
145,2286
132,0556
89,29774
135,7988
136,6495
91,42978
122,9572
101,1022
140,0192
79,71042
100,1952
129,699
108,0912
123,8334
151,7011
99,76738
83,70021
147,4948
99,5024
117,6388
96,0329
72,34891
87,26395
141,4937
100,0366
106,3956
117,2009
138,2436
113,6575
103,7963
89,54069
123,9876
59,88064
81,80044
127,6718
120,7249
79,35584
122,8884
121,2673
81,57676
108,2774
148,4501
98,1555
77,6589
113,8101
96,55629
101,3911
119,8439
108,684
100,8454
85,23855
90,31397
85,43574
95,47605
152,2525
113,5437
96,81549
106,9313
115,8879
116,6258
117,6492
136,173
101,7468
118,5228
95,15323
115,9573
123,3661
125,4354
127,7395
78,25413
93,75695
101,5307
71,66171
76,35476
118,5835
118,6138
132,1904
118,7743
91,59723
109,6226
92,80372
130,8118
73,73719
130,6267
121,9543
128,5542
96,11316
114,7312
109,0152
73,73962
121,6348
120,6223
92,16548
139,7607
67,63706
100,1361
100,6201
92,8708
94,06533
121,5931
89,02891
111,6531
99,79707
106,9193
156,3764
96,99542
131,2525
110,9088
110,7555
64,33736
134,4986
7
40,64199
92,12255
171,7191
100,8162
155,8752
139,0728
91,10997
191,5342
149,9373
151,1031
78,61465
89,117
140,8577
162,9901
113,9448
183,4774
109,888
143,7222
115,1347
158,758
101,9168
113,7446
54,66739
127,0902
118,5894
136,1238
128,528
88,2266
141,5615
219,4063
89,34144
152,2914
91,88935
78,66296
70,08753
138,0147
116,3298
149,948
107,3995
67,98551
107,0661
112,0493
139,496
66,58267
41,2749
133,3537
113,7086
99,58361
110,8983
107,3838
153,9686
83,43569
96,52321
116,3073
154,4999
116,1761
136,6673
128,0629
127,2547
140,9009
164,9895
113,542
103,0395
114,4931
102,7236
54,52774
107,2172
114,0281
101,2088
104,795
139,6697
111,9805
109,2825
94,1277
96,62615
107,5783
113,0702
119,3266
149,2458
142,5576
81,26728
152,1581
86,34803
171,7091
114,7829
99,47053
61,48872
100,4485
147,0115
100,0961
99,18031
78,48776
81,82589
83,93816
95,36907
137,0153
115,7333
121,597
162,3721
157,6362
115,1437
93,73313
67,24847
127,6306
207,5231
156,8831
123,9983
71,0844
65,96554
93,79902
-34,6873
131,6955
164,7398
119,4234
101,9167
169,1158
97,89029
91,82507
152,0387
115,2204
89,62037
149,3331
95,76894
174,5883
89,82435
91,24197
89,85224
129,2501
167,2034
129,627
145,8831
165,213
109,8666
152,9449
110,02
198,9976
125,4113
93,18083
119,0173
85,68384
96,11153
118,6407
60,50517
126,0165
98,45328
129,3039
109,8957
99,37536
122,0663
122,1237
158,6029
78,77114
93,15126
80,63728
96,31701
97,87054
99,40573
98,74576
97,7507
104,3088
120,2776
136,7291
101,241
153,8583
130,9462
139,2721
86,47519
66,1235
117,8467
118,2639
69,19371
74,33903
118,4495
134,8748
142,5523
87,96169
124,5109
124,7419
109,2302
84,7551
83,49255
127,7724
69,63039
102,9217
113,3714
136,2313
101,3804
54,03367
128,9912
124,3144
141,16
81,20182
82,7954
95,36997
74,77161
222,6542
129,8613
88,87495
131,9729
164,1811
142,1039
151,666
134,2298
54,7142
84,60427
157,3937
107,0766
125,3681
137,197
74,14313
122,6045
97,60847
56,03333
130,7293
81,23675
94,88662
61,43121
90,88145
132,5813
177,8603
69,73805
128,8127
135,9355
156,7586
165,3948
70,76482
117,4549
164,2277
136,8042
170,999
163,6595
208,752
10,19907
101,726
76,58032
118,353
92,72814
152,6595
89,16939
114,1041
159,018
135,2986
109,594
121,5
167,6659
143,6155
78,1184
114,4331
135,5565
73,16361
116,9281
108,3641
116,921
90,67818
66,15236
84,26162
154,9974
106,8864
87,16326
145,2286
132,0556
89,29774
135,7988
136,6495
91,42978
122,9572
101,1022
140,0192
79,71042
100,1952
129,699
108,0912
123,8334
151,7011
99,76738
83,70021
147,4948
99,5024
117,6388
96,0329
72,34891
101,4547
58,05509
94,15053
171,8893
117,3717
153,4234
180,3963
103,3892
98,61531
62,31521
103,9081
86,41229
106,2286
105,9767
85,86544
69,21269
99,89251
115,585
79,17315
129,0896
109,2349
104,5737
151,4693
207,2473
148,9057
140,7076
115,1888
120,1915
138,2572
92,88079
55,29765
132,1645
86,92535
130,7487
81,77831
64,86331
58,8628
126,2441
193,1816
123,0175
134,6201
120,7524
124,2038
209,619
83,74927
108,6444
88,05163
87,26395
141,4937
100,0366
106,3956
117,2009
138,2436
113,6575
103,7963
89,54069
123,9876
59,88064
81,80044
127,6718
120,7249
79,35584
122,8884
121,2673
81,57676
108,2774
148,4501
98,1555
77,6589
113,8101
96,55629
101,3911
119,8439
108,684
100,8454
85,23855
90,31397
85,43574
95,47605
152,2525
113,5437
96,81549
106,9313
115,8879
116,6258
117,6492
136,173
101,7468
118,5228
95,15323
143,5619
125,2076
101,9095
144,6843
74,77184
119,7768
123,0177
177,954
136,5451
116,3224
61,33016
56,16366
138,6252
86,99266
105,3524
80,22332
122,2641
124,1152
184,7888
187,715
157,4653
158,3594
68,21312
166,0309
77,3371
51,02198
241,6501
127,7467
88,48253
115,317
117,7604
32,19888
86,378
136,1728
116,4216
48,48421
95,34031
108,9973
118,2533
47,84892
125,2134
176,1621
51,29094
132,5516
168,7461
130,2139
138,5626
95,99847
107,5924
69,21138
110,1398
92,89528
88,67869
172,89
110,3177
140,1974
130,0123
74,40451
39,40567
57,64974
126,0376
102,9517
145,3801
99,8021
62,10788
118,8533
159,0419
125,6168
107,5618
98,16267
165,7249
151,5723
97,81394

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
Hofstra University Type of Statistical Tests and Excel Worksheet For the first two problems below, refer to the spreadsheet ttest HW. 1.For this problem,
For \$10/Page 0nly
Calculator

Total price:\$26
Our features