Chapter 7 Assignment File HW

xlsx

School

Northeast Community College *

*We aren’t endorsed by this school

Course

218

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by KidInternet8738

Chapter 7 Assignment: Complete the following problems from the textbook. All assignments will be grad credit as long as they are complete, turned in on time, and include use of Excel fun where appropriate. This includes following any prompts added to the problems in E Assignments turned in late, incomplete, or without work shown will receive partial Chapter 7 Problems: 5, 7, 15, 17, 25, 27, 35, and 37+

ded at full nctions Excel. l credit.

#5 Random Numbers # to Sample #7 Random Numbers # to Sample 91 156 182 76895 302 639 221 78402 243 482 79 24300 563 342 288 67358 633 580 251 29037 473 155 197 63450 91 599 201 20010 275 435 86 12564 385 569 87 47295 105 291 319 90785 22 18703 39 81841 Instead of using Table 7.1 in your book, use Excel to generate random numbers in the column noted and then cut-and-paste them as values into the yellow cells.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

#15 NFL Poll #17 57 a) 0.949791 20 b) 0.889556 61 c) 0.643552 57 d) It seems like those who are 18-29 use the internet more 86 e) 0.762437 80 74 79 72 83 73 74 a) 68 b) 17.893625071

e than the other age groups

502 100 10 o=populatio 515 100 u= populati 494 100 n= total num a) n = 90 10.54093 492 512 P = 0.657218 a) n = 90 10.54093 The probability of 0.094 is smalle 505 525 P = 0.657218 a) n = 100 10 484 504 P = 0.682689 Comment: The probability for C is much higher than the other two probabilities µ CR = σ CR = µ M = σ M = µ W = σ W = σ x̅ = ≤ x̄ ≤ σ x̅ = ≤ x̄ ≤ σ x̅ = ≤ x̄ ≤

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

on of SD ion mean mer of pupulation elements er than 0.328

21.68 2.3 o=population of SD 18.8 2.05 u= population mean n= total numer of pupulation elem a) n = 50 0.325269 21.18 22.18 P = 0.875753 a) n = 50 0.289914 18.3 19.3 P = 0.91541 c) Which? 0.91541 Why? The standard deviation is lower for female graduates which leads to a lower standard erro d) n = 120 0.187139 18.5 P = 0.054457 µ M = σ M = µ F = σ F = σ x̅ = ≤ x̄ ≤ σ x̅ = ≤ x̄ ≤ σ x̅ = x̄ ≤

ments or. Less error means more accuracy!

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

0.3 a) n = 100 0.045826 b) 0.2 0.4 P = 0.970904 c) 0.25 0.35 P = 0.724766 p = σ p̅ = Normally distributed with an e(pbar)=0.3 and SE=0.045825757 ≤ p̅ ≤ ≤ p̅ ≤

0.12 a) n = 540 0.013984 y distributed with an e(pbar)=0.12 and SE=0.01 0.03 b) 0.09 0.15 P = 0.96807 0.015 c) 0.105 0.135 P = 0.71657 d) Which of these probabilities is higher and why? 0.71657 Because bigger sample sizes reduce error which increases accuracy (probabilities) Part b is higher. We are less likely to be accurate if we are looking for a range of values closer to the p = σ p̅ = ≤ p̅ ≤ ≤ p̅ ≤

e mean (if we make the target smaller, we are less likey to be accurate)

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version