Chapter 7 In-Class Excel Practice

xlsx

School

Northeast Community College *

*We aren’t endorsed by this school

Course

218

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

9

Uploaded by KidInternet8738

Report
Observation Random # # to Sample 1 16 2 2 7 9 3 13 12 4 30 2 5 9 21 6 16 28
16642 2400 a) n = 30 438.178 16442 16842 P = 0.351923 n = 50 339.4113 16442 16842 P = 0.44431 n = 100 240 16442 16842 P = 0.595343 n = 400 120 16442 16842 P = 0.904419 b) Higher sample sizes lead to lower error and higher probabilities (more accurate) µ = σ = σ = ≤ x̄ ≤ σ = ≤ x̄ ≤ σ = ≤ x̄ ≤ σ = ≤ x̄ ≤ Standard Error Formulas Finite Population ¯𝒑 ¯𝒙 𝜎_¯𝑥=√((𝑁−𝑛)/ (𝑁−1)) (𝜎/√𝑛) 𝜎_¯𝑝=√((𝑁−𝑛)/(𝑁−1) √((𝑝(1−𝑝))/𝑛)
s for Sampling Distributions Infinite Population 𝜎_¯𝑥= 𝜎/√𝑛 )) 𝜎_¯𝑝=√((𝑝(1−𝑝))/ 𝑛)
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.42 a) n = 300 0.0284956137 Normally distributed with an e(pbar)=0.42 and SE=0.28 0.03 b) 0.39 0.45 P = 0.707564 0.05 c) 0.37 0.47 P = 0.920682 d) Effect Probabilities would increase Why? Bigger sample sizes reduce error which increases accuracy (probabilities) p U = σ = ≤ p̅ ≤ ≤ p̅ ≤ Standard Error Formul Finite Populatio ¯𝒑 ¯𝒙 𝜎_¯𝑥=√((𝑁−𝑛)/ (𝑁−1)) (𝜎/√𝑛) 𝜎_¯𝑝=√((𝑁−𝑛)/(𝑁− √((𝑝(1−𝑝))/𝑛)
las for Sampling Distributions on Infinite Population 𝜎_¯𝑥= 𝜎/√𝑛 −1)) 𝜎_¯𝑝=√((𝑝(1−𝑝))/ 𝑛)
Package # of M&M’s # of Red M&M’s # of Blue M&M’s # of Yellow M&M’s #1 17 2 4 3 #2 15 1 4 0 #3 18 2 5 0 Use the above data to calculate proportions of M&M's by color an Package # of M&M’s p of Red M&M’s p of Blue M&M’s p of Yellow M&M’s #1 17 0.1176470588235 0.2352941176471 0.176470588235294 #2 15 0.0666666666667 0.2666666666667 0 #3 18 0.1111111111111 0.2777777777778 0 x-bar/p-bar 16.66666667 0.0984749455338 0.2599128540305 0.058823529411765 15.18468468 0.1282298105 0.1962896807 0.9887 0.1218542451 n= 3 0.1548750071 0.570826211147783 0.1555879254 Fave M&M Color: Green 0.2371220592 0.123828263110977 Suppose we took another sample, find… 1 0.9887 P = -0.03635518 0.15 0.9887 P = 0.759150223 Yes because the data is normally distributed You are each going to open 3 packages of M&M's. BEFORE EATING ANY, please co each package. Once you are done, please transfer this inform Using the data we collected as a class, what are the expected values of: Using the available information, find the standard error for x-bar and p-bar for your favorite M&M Color. Assume the population mean is normally distributed. …the probability that the average will be within 1 M&M of the population mean. ≤ x̄ ≤ …the probability that the proportion of your favorite color will be within .15 of the population proportion. ≤ p̅ ≤ Are our estimates for the sampling distribution of x-bar reliable? Why or why not? 𝑥 ̅= 𝑅𝑒𝑑 𝑝 ̅= 𝐵𝑙𝑢𝑒 𝑝 ̅= 𝑂𝑟𝑎𝑛𝑔𝑒 𝑝 ̅= 𝑌𝑒𝑙𝑙𝑜𝑤 𝑝 ̅= 𝐺𝑟𝑒𝑒𝑛 𝑝 ̅= 𝐵𝑟𝑜𝑤𝑛 𝑝 ̅= 𝜎= 𝜎_𝑝 ̅ = 𝜎_𝑥 ̅ = 𝜎= 𝜎=
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
No because we don't know what the shape is Are our estimates for the sampling distribution of p-bar reliable? Why or why not?
# of Orange M&M’s # of Brown M&M’s # of Green M&M’s 4 2 2 5 0 5 4 1 6 nd find an average proportion for each color. p of Orange M&M’s p of Brown M&M’s p of Green M&M’s 0.235294117647059 0.117647058823529 0.117647058823529 0.333333333333333 0 0.333333333333333 0.222222222222222 0.055555555555556 0.333333333333333 0.263616557734205 0.057734204793028 0.261437908496732 15.18468468 0.1282298105 0.1962896807 0.1218542 0.154875 0.1555879 ount the number in each package and the number of each color in mation to the M&M Activity Data Sheet. Chapter 7 Activity Submission Describe the sampling distribution of x-bar based on our data collection: Normally distributed with an e(x- bar)=15.18 and a SE=0.57 Describe the sampling distribution of p-bar for your favorite color: No idea what the shape is but e(p-bar)+ 0.2371 and SE=.2456
0.2371221
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