table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl62 {background:#FCE4D6; mso-pattern:black none;} .xl65 {font-weight:700; text-align:center; vertical-align:middle; background:#FCE4D6; mso-pattern:black none; white-space:normal;}

Percent of County Residents in Poverty

0.195

0.134

0.207

0.164

0.227

0.282

0.124

0.153

0.146

0.228

0.083

0.123

0.111

0.215

0.121

0.206

0.108

0.207

0.195

0.239

0.134

0.252

0.264

0.154

0.155

0.142

0.132

0.160

0.157

0.123

0.128

0.259

0.131

0.216

0.166

0.127

0.195

0.166

0.191

0.132

0.232

0.228

0.120

0.102

0.147

0.242

0.230

0.186

0.120

0.170

0.212

0.140

0.208

0.240

0.163

0.197

0.079

0.111

0.171

0.211

0.124

0.301

0.239

0.125

0.175

0.326

0.203

0.141

0.185

0.133

0.199

0.183

0.170

0.161

0.053

0.049

0.299

0.297

0.331

0.095

0.227

0.091

0.156

0.075

0.159

0.187

0.141

0.142

0.126

0.174

0.086

0.072

0.339

0.147

0.231

0.186

0.201

0.264

0.136

0.108

0.146

0.168

0.157

0.139

0.166

0.099

0.240

0.191

0.308

0.155

0.188

0.172

0.099

0.147

0.119

0.101

0.071

0.351

0.231

0.140

0.221

0.168

0.136

0.129

0.176

0.059

0.117

0.161

0.259

0.068

0.198

0.147

0.147

0.159

0.203

0.182

0.310

0.121

0.202

0.301

0.155

0.108

0.114

0.239

0.165

0.212

0.180

0.123

0.208

0.083

0.119

0.110

0.193

0.281

0.095

0.259

0.134

0.258

0.169

0.073

0.176

0.225

0.075

0.240

0.098

0.117

0.175

0.151

0.114

0.114

0.165

0.177

0.091

0.219

0.151

0.180

0.262

0.187

0.139

0.197

0.087

0.107

0.189

0.147

0.183

0.209

0.245

0.177

0.104

0.267

0.137

0.077

0.279

0.256

0.158

0.211

0.241

0.147

0.118

0.140

Poverty rates are normally distributed across counties in the United States. The US Department of Poverty states that the average poverty rate in counties across America is 16%. You believe that this is incorrect; you think that the actual mean poverty rate in counties across America is higher. 23.Conduct a hypothesis test from your sample of 200 counties to determine whether to reject or fail to reject the initial statement that the mean poverty rate is 16%. Test at a 5% level of significance. 24 _Enter your level of significance into cell z17 in the Calculations tab. Enter your confidence level in cell z18 in the Calculations tab. In your report 25.Under the \"Hypothesis Test\" header, introduce the scenario and claim for this hypothesis test. 26. State your null and alternative hypothesis in sentence format and in mathematical format. 27.State the Greek letter that will represent your population parameter. 28.Define the meaning of this population parameter within this test. 29. State your level of significance. 30.Explain whether you've chosen to use a left-tailed test, right-tailed test, or two-tailed test, and why. 31.Under the \"Calculations\" header, show your calculations and resulting value for your test statistic (the z-score). 32.State your p-value. 33.Interpret your p-value within the context of your scenario. 34.Under the \"Test Decision and Test Conclusion\" header, state the test decision based on the p-value method. 35. State the conclusions of your hypothesis test using proper verbiage. 36.Under the \"Normal Curve\" header, insert a drawn image of your bell curve with appropriate labeling for your test statistic, p-value, level of significance, sample mean, and claimed mean