Business Analytics with Excel

Description

Download HW 5 Using this Olympic medal count data, generate a formula to predict the total number of medals won by a country.One of the medal counts is rejected as a significant predictor because its p-value is above 5% also is it True or False.

Don't use plagiarized sources. Get Your Custom Assignment on
Business Analytics with Excel
From as Little as $13/Page

Unformatted Attachment Preview

Rank
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
36
38
39
39
41
42
42
44
45
46
Team/NOC
Gold
United States of America
People’s Republic of China
Japan
Great Britain
ROC
Australia
Netherlands
France
Germany
Italy
Canada
Brazil
New Zealand
Cuba
Hungary
Republic of Korea
Poland
Czech Republic
Kenya
Norway
Jamaica
Spain
Sweden
Switzerland
Denmark
Croatia
Islamic Republic of Iran
Serbia
Belgium
Bulgaria
Slovenia
Uzbekistan
Georgia
Chinese Taipei
Turkey
Greece
Uganda
Ecuador
Ireland
Israel
Qatar
Bahamas
Kosovo
Ukraine
Belarus
Romania
Silver
39
38
27
22
20
17
10
10
10
10
7
7
7
7
6
6
4
4
4
4
4
3
3
3
3
3
3
3
3
3
3
3
2
2
2
2
2
2
2
2
2
2
2
1
1
1
Bronze
41
32
14
21
28
7
12
12
11
10
6
6
6
3
7
4
5
4
4
2
1
8
6
4
4
3
2
1
1
1
1
0
5
4
2
1
1
1
0
0
0
0
0
6
3
3
Total
33
18
17
22
23
22
14
11
16
20
11
8
7
5
7
10
5
3
2
2
4
6
0
6
4
2
2
5
3
2
1
2
1
6
9
1
1
0
2
2
1
0
0
12
3
0
113
88
58
65
71
46
36
33
37
40
24
21
20
15
20
20
14
11
10
8
9
17
9
13
11
8
7
9
7
6
5
5
8
12
13
4
4
3
4
4
3
2
2
19
7
4
46
48
49
50
50
52
53
54
55
56
56
58
59
59
59
59
63
63
63
66
67
68
69
70
71
72
72
74
74
74
77
77
77
77
77
77
83
84
85
86
86
86
86
86
86
86
86
Venezuela
India
Hong Kong, China
Philippines
Slovakia
South Africa
Austria
Egypt
Indonesia
Ethiopia
Portugal
Tunisia
Estonia
Fiji
Latvia
Thailand
Bermuda
Morocco
Puerto Rico
Colombia
Azerbaijan
Dominican Republic
Armenia
Kyrgyzstan
Mongolia
Argentina
San Marino
Jordan
Malaysia
Nigeria
Bahrain
Saudi Arabia
Lithuania
North Macedonia
Namibia
Turkmenistan
Kazakhstan
Mexico
Finland
Botswana
Burkina Faso
Côte d’Ivoire
Ghana
Grenada
Kuwait
Republic of Moldova
Syrian Arab Republic
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
3
2
2
2
2
2
1
1
1
1
1
1
0
0
0
0
0
0
0
4
3
3
2
2
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
4
3
1
1
0
5
4
3
2
2
0
1
1
1
1
0
0
0
1
4
2
2
1
3
2
2
1
1
1
0
0
0
0
0
0
8
4
2
1
1
1
1
1
1
1
1
4
7
6
4
4
3
7
6
5
4
4
2
2
2
2
2
1
1
1
5
7
5
4
3
4
3
3
2
2
2
1
1
1
1
1
1
8
4
2
1
1
1
1
1
1
1
1

Purchase answer to see full
attachment