statistics excel question

User Generated

YhzvabkAnpug

Mathematics

Description

need help with excel formulas and making them work.


distribution making problems

stat 123.xls

Unformatted Attachment Preview

Value Assigned Comments Item Binomial probability distribution table What is the probability that in a sample of 12 people, that at least 5 people have health care insurance? What is the probability of one store at random having monthly sales between 150 and 155 ? In a random sample of 16 stores, what is the standard deviation of the sampling distribution? In a random sample of 10 stores, what is the probability that the average sales will be between 150 and 155? Mean of the 92.15% confidence Interval Error of the 92.15% confidence Interval Explain what this confidence interval "means" to someone who has no statistics background, and who has taken no statistics courses Total 2 2 2 2 2 2 2 2 2 2 1 2 1 2 2 2 15 15 Has Health Care Insurance? 1 1 1 1 1 1 1 1 0 1 0 1 1 1 0 1 0 1 1 1 1 1 1 1 1 1 0 0 1 1 0 0 0 1 0 0 0 1 0 0 0 0 1 0 1 1 = yes 0 = no Based on this distribution, construct a binomial probability distribution for a sample of 12 people. Columns should include x, P(x) , cumulative P What is the probability that in a sample of 12 people, that at least 5 peo 0 1 1 0 0 1 1 1 1 1 1 0 1 0 1 1 0 1 0 0 0 0 0 1 1 1 1 0 1 1 1 0 0 1 1 0 1 0 1 1 1 1 1 1 1 1 1 0 0 1 1 0 0 0 1 0 0 0 1 0 0 0 Monthly Sales 154.9603923 148.8052937 159.2395899 155.2883493 153.6971655 151.6927938 161.5532625 159.5574583 157.9830616 148.3716693 160.4535061 157.3291053 154.2035995 150.9223313 140.9770545 146.007015 151.9204995 147.7118264 148.1770056 167.6455856 153.1806908 146.9225032 138.4035483 139.7843795 152.1336828 154.4767071 155.0763461 155.5474939 155.6316335 148.185082 156.5247346 153.2579887 151.7224252 144.5192544 155.6397371 158.7007006 159.1057987 154.2991578 150.8872021 160.930527 157.6167421 164.2298509 162.6677392 154.5928314 147.5807637 153.4288464 Assume the monthly sales data in column A is normally distributed and represents the monthly sales at different stores. All figures are in $100,000. a. What is the probability of one store at random having monthly sales between 150 an b. In a random sample of 16 stores, what is the standard deviation of the sampling distr c. In a random sample of 10 stores, what is the probability that the average sales will be 149.6715328 160.5426184 149.1531618 158.6261994 160.0575348 170.3564982 174.5636024 155.6993749 152.3621728 150.2541597 150.8065754 159.9703052 142.1083932 152.1018618 146.0513801 156.7593978 144.475817 139.7538205 162.3818759 150.4293829 150.3755431 155.3330146 156.9952412 159.9081231 157.6134406 153.7734335 149.0642132 157.92944 153.5251346 153.3665688 163.82036 157.9425299 146.5856173 155.5053047 152.2494387 157.768173 155.6597573 155.0950089 151.8707115 147.8212795 149.4695977 152.8676382 159.1117331 154.2573438 167.9558688 158.0762325 151.6160007 148.2507975 156.4307587 153.8781323 144.845663 157.1422451 154.0722912 147.7166012 163.8449709 147.5603955 161.8676658 157.0243882 150.90609 152.889125 145.1620034 164.9991197 156.8597788 147.8640212 160.9682346 159.5307191 155.2428313 148.7624292 148.4594447 159.4283464 153.6277529 147.9225745 154.058983 157.7135487 152.5665909 150.4954668 155.0390477 156.8438512 158.1581279 157.5312451 153.6282099 147.039869 151.9740323 159.8369778 143.1359948 154.2559659 156.523725 152.8839886 146.4679923 163.8308919 162.486677 154.7470999 151.6229583 153.5743906 152.0878647 160.1414084 151.1412444 153.338404 150.3573509 166.7162639 150.8155589 157.8450753 155.0166877 148.863806 158.2632291 159.9530066 152.4434885 154.0135401 161.3643969 142.4836143 169.3057044 155.0978056 144.1603223 154.4716389 148.8219647 160.042269 155.9396862 156.435745 148.9040784 160.0202092 147.0488593 146.6385226 157.9180691 151.0938507 163.3828476 150.6107725 151.4647335 147.5251708 157.7330165 159.8355045 157.2852859 155.5237765 157.9945144 150.0043397 147.6374206 136.3329563 144.7217352 159.1846928 160.2865774 149.173489 146.816488 154.8026382 140.8583109 146.7597764 153.3143865 158.0889608 156.9097646 154.6546725 145.3152897 153.0442529 148.9917515 157.0813317 150.6858809 153.0437891 149.6147803 155.1786506 154.4905201 155.970177 148.0379757 154.0621958 164.7227788 157.0734873 162.628831 148.7314609 151.4587104 148.4699766 169.530095 153.3587176 171.2846194 146.2246661 155.91455 146.1149538 153.0595938 162.923098 144.0385501 161.5088565 150.6799942 149.5134308 158.4146532 152.6458124 148.9923995 155.9604909 155.5845399 153.2704784 153.4933614 155.4863622 156.0663492 160.343289 159.6963927 155.9082745 157.5132507 154.9934138 152.0902794 148.6047501 157.821433 154.8318261 161.8665744 149.8173294 148.7091419 155.5935711 157.1206764 155.2822511 151.7090965 153.9166926 145.5851095 157.8738676 155.7079765 155.8388755 156.9941975 159.1474626 147.758538 155.1505881 160.6944312 162.1024518 155.7495995 157.6349275 143.7127418 156.6026737 165.9211836 151.1098396 155.0460394 150.9537021 148.3673993 146.5944849 160.731334 160.2501385 157.9402516 147.9056852 151.3092986 145.5431727 145.4301316 156.1664846 159.4922339 154.6796108 153.2195853 152.6189573 150.8319298 153.4813834 154.0181308 147.8492874 151.2446813 157.8231246 151.0907538 159.6468843 164.4402716 160.8541704 157.5870698 150.8545967 163.5355335 147.1625553 144.9501093 158.7344656 154.3699552 155.6702552 164.243657 145.2453586 160.9207044 156.3745588 151.2293745 146.4720169 154.075961 149.5091744 150.68481 162.4296516 154.7716221 156.5207169 146.783487 153.8877706 152.1534233 153.9520332 158.9087885 154.1393164 152.204371 156.9438843 154.484074 155.6178274 152.4050032 138.8880179 157.2831576 146.3318137 155.8812625 160.5701352 153.8721637 157.9968063 153.9534111 152.1688188 158.7426101 154.7966219 151.802629 164.2181184 156.0046036 148.4291449 152.0762686 147.2875744 157.9209135 163.970563 155.7070215 142.5181569 151.3579406 144.4596098 156.1380947 147.2875744 160.1437277 160.5994664 155.4716898 157.5263338 160.3216521 140.9281601 147.1405364 157.2836897 155.7879483 149.3173756 144.9601229 148.2493514 155.8976607 151.5413152 151.1838497 151.9701442 156.4911742 159.1011875 159.1987172 154.3993887 155.6931608 159.0108474 161.7099048 147.6462746 155.9939284 152.5174236 150.0226614 147.4240122 160.3537254 144.9701091 152.9082653 155.1094767 150.8929797 154.7244398 149.4787518 151.0478348 146.6608689 159.2241467 147.3735626 150.5784127 158.7992808 161.528979 158.8309448 157.9305723 155.757744 151.8672872 160.3924563 149.5370731 160.5793301 149.555811 149.9445586 154.6389701 166.9941327 144.3457774 145.626637 154.371333 152.8928562 146.1247354 150.1176536 161.4084619 149.6213696 147.6919221 147.1006732 162.9286368 145.5740591 143.9575141 144.6062112 151.466241 162.2217002 152.4582018 152.9842399 163.6525582 159.8977002 154.5153902 160.0186812 157.0353431 152.4439592 150.1244339 138.2505349 154.3851255 164.1598926 152.4596207 149.7833188 155.2968076 150.0494961 156.8736736 163.6043186 153.0256583 161.3663614 139.3087502 163.3781819 155.5441719 158.7589401 155.1604106 147.5832057 149.4138616 152.2144459 138.2215038 152.756698 145.6593242 156.473671 160.3513107 144.9083635 159.2908581 156.5086911 157.0004458 159.1077768 154.4536855 156.9009857 147.5921414 156.9666808 157.6387883 158.587373 142.808031 160.7210067 156.2234144 157.260252 145.7841524 154.7841186 163.7492284 144.609349 150.4129302 147.6559198 166.5519546 155.8326273 150.7189774 162.5318334 151.9696531 157.0525666 149.3391216 147.9317695 149.7727323 154.3225955 161.7679124 146.5251677 161.7806544 153.1204186 145.5740591 158.6757896 148.317277 165.6982665 158.5499519 160.7693691 149.1747577 153.3462552 137.9591328 158.0589066 146.7683166 152.5528939 151.0442059 168.6277307 143.3952281 149.992307 148.7165907 149.9093066 147.8709789 155.8379205 161.2136754 163.2828213 148.856521 158.6261994 156.2401332 156.4217888 162.013094 153.3287042 162.4829389 156.5432951 147.800966 156.0921811 155.0511621 152.8199443 163.4839379 154.6112828 155.1894144 154.5490256 150.0523473 152.4325677 151.6923027 143.2521737 158.9486653 148.8750474 145.157938 152.3149564 155.3767999 145.1863688 148.9001221 147.9310055 156.2204608 153.3116171 155.5869136 157.1007312 153.113918 156.881402 152.4259171 159.8620799 155.3994259 148.9414996 163.8379314 160.9314274 152.3507337 167.4404036 148.6280923 161.545159 155.126291 153.1255208 155.9488743 157.2943581 144.1088904 150.6016185 150.1436424 152.598214 161.5320077 157.3237438 157.6487199 161.5562912 152.3797852 152.4396891 161.8234234 151.0011231 at the average sales will be between 150 and 155? Monthly Sales 154.9603923 148.8052937 159.2395899 155.2883493 153.6971655 151.6927938 161.5532625 159.5574583 157.9830616 148.3716693 160.4535061 157.3291053 154.2035995 150.9223313 140.9770545 146.007015 151.9204995 147.7118264 148.1770056 167.6455856 153.1806908 146.9225032 138.4035483 139.7843795 152.1336828 154.4767071 155.0763461 155.5474939 155.6316335 148.185082 156.5247346 153.2579887 151.7224252 144.5192544 155.6397371 158.7007006 159.1057987 154.2991578 150.8872021 160.930527 157.6167421 164.2298509 162.6677392 154.5928314 147.5807637 153.4288464 Construct a 92.15% confidence interval around the mean monthly sales v Mean of the confidence interval Error Explain what this confidence interval "means" to someone who has no sta If answer is not legible there will be no credit, and the answer must be in 149.6715328 160.5426184 149.1531618 158.6261994 160.0575348 170.3564982 174.5636024 155.6993749 152.3621728 150.2541597 150.8065754 159.9703052 142.1083932 152.1018618 146.0513801 156.7593978 144.475817 139.7538205 162.3818759 150.4293829 150.3755431 155.3330146 156.9952412 159.9081231 157.6134406 153.7734335 149.0642132 157.92944 153.5251346 153.3665688 163.82036 157.9425299 146.5856173 155.5053047 152.2494387 157.768173 155.6597573 155.0950089 151.8707115 147.8212795 149.4695977 152.8676382 159.1117331 154.2573438 167.9558688 158.0762325 151.6160007 148.2507975 156.4307587 153.8781323 144.845663 157.1422451 154.0722912 147.7166012 163.8449709 147.5603955 161.8676658 157.0243882 150.90609 152.889125 145.1620034 164.9991197 156.8597788 147.8640212 160.9682346 159.5307191 155.2428313 148.7624292 148.4594447 159.4283464 153.6277529 147.9225745 154.058983 157.7135487 152.5665909 150.4954668 155.0390477 156.8438512 158.1581279 157.5312451 153.6282099 147.039869 151.9740323 159.8369778 143.1359948 154.2559659 156.523725 152.8839886 146.4679923 163.8308919 162.486677 154.7470999 151.6229583 153.5743906 152.0878647 160.1414084 151.1412444 153.338404 150.3573509 166.7162639 150.8155589 157.8450753 155.0166877 148.863806 158.2632291 159.9530066 152.4434885 154.0135401 161.3643969 142.4836143 169.3057044 155.0978056 144.1603223 154.4716389 148.8219647 160.042269 155.9396862 156.435745 148.9040784 160.0202092 147.0488593 146.6385226 157.9180691 151.0938507 163.3828476 150.6107725 151.4647335 147.5251708 157.7330165 159.8355045 157.2852859 155.5237765 157.9945144 150.0043397 147.6374206 136.3329563 144.7217352 159.1846928 160.2865774 149.173489 146.816488 154.8026382 140.8583109 146.7597764 153.3143865 158.0889608 156.9097646 154.6546725 145.3152897 153.0442529 148.9917515 157.0813317 150.6858809 153.0437891 149.6147803 155.1786506 154.4905201 155.970177 148.0379757 154.0621958 164.7227788 157.0734873 162.628831 148.7314609 151.4587104 148.4699766 169.530095 153.3587176 171.2846194 146.2246661 155.91455 146.1149538 153.0595938 162.923098 144.0385501 161.5088565 150.6799942 149.5134308 158.4146532 152.6458124 148.9923995 155.9604909 155.5845399 153.2704784 153.4933614 155.4863622 156.0663492 160.343289 159.6963927 155.9082745 157.5132507 154.9934138 152.0902794 148.6047501 157.821433 154.8318261 161.8665744 149.8173294 148.7091419 155.5935711 157.1206764 155.2822511 151.7090965 153.9166926 145.5851095 157.8738676 155.7079765 155.8388755 156.9941975 159.1474626 147.758538 155.1505881 160.6944312 162.1024518 155.7495995 157.6349275 143.7127418 156.6026737 165.9211836 151.1098396 155.0460394 150.9537021 148.3673993 146.5944849 160.731334 160.2501385 157.9402516 147.9056852 151.3092986 145.5431727 145.4301316 156.1664846 159.4922339 154.6796108 153.2195853 152.6189573 150.8319298 153.4813834 154.0181308 147.8492874 151.2446813 157.8231246 151.0907538 159.6468843 164.4402716 160.8541704 157.5870698 150.8545967 163.5355335 147.1625553 144.9501093 158.7344656 154.3699552 155.6702552 164.243657 145.2453586 160.9207044 156.3745588 151.2293745 146.4720169 154.075961 149.5091744 150.68481 162.4296516 154.7716221 156.5207169 146.783487 153.8877706 152.1534233 153.9520332 158.9087885 154.1393164 152.204371 156.9438843 154.484074 155.6178274 152.4050032 138.8880179 157.2831576 146.3318137 155.8812625 160.5701352 153.8721637 157.9968063 153.9534111 152.1688188 158.7426101 154.7966219 151.802629 164.2181184 156.0046036 148.4291449 152.0762686 147.2875744 157.9209135 163.970563 155.7070215 142.5181569 151.3579406 144.4596098 156.1380947 147.2875744 160.1437277 160.5994664 155.4716898 157.5263338 160.3216521 140.9281601 147.1405364 157.2836897 155.7879483 149.3173756 144.9601229 148.2493514 155.8976607 151.5413152 151.1838497 151.9701442 156.4911742 159.1011875 159.1987172 154.3993887 155.6931608 159.0108474 161.7099048 147.6462746 155.9939284 152.5174236 150.0226614 147.4240122 160.3537254 144.9701091 152.9082653 155.1094767 150.8929797 154.7244398 149.4787518 151.0478348 146.6608689 159.2241467 147.3735626 150.5784127 158.7992808 161.528979 158.8309448 157.9305723 155.757744 151.8672872 160.3924563 149.5370731 160.5793301 149.555811 149.9445586 154.6389701 166.9941327 144.3457774 145.626637 154.371333 152.8928562 146.1247354 150.1176536 161.4084619 149.6213696 147.6919221 147.1006732 162.9286368 145.5740591 143.9575141 144.6062112 151.466241 162.2217002 152.4582018 152.9842399 163.6525582 159.8977002 154.5153902 160.0186812 157.0353431 152.4439592 150.1244339 138.2505349 154.3851255 164.1598926 152.4596207 149.7833188 155.2968076 150.0494961 156.8736736 163.6043186 153.0256583 161.3663614 139.3087502 163.3781819 155.5441719 158.7589401 155.1604106 147.5832057 149.4138616 152.2144459 138.2215038 152.756698 145.6593242 156.473671 160.3513107 144.9083635 159.2908581 156.5086911 157.0004458 159.1077768 154.4536855 156.9009857 147.5921414 156.9666808 157.6387883 158.587373 142.808031 160.7210067 156.2234144 157.260252 145.7841524 154.7841186 163.7492284 144.609349 150.4129302 147.6559198 166.5519546 155.8326273 150.7189774 162.5318334 151.9696531 157.0525666 149.3391216 147.9317695 149.7727323 154.3225955 161.7679124 146.5251677 161.7806544 153.1204186 145.5740591 158.6757896 148.317277 165.6982665 158.5499519 160.7693691 149.1747577 153.3462552 137.9591328 158.0589066 146.7683166 152.5528939 151.0442059 168.6277307 143.3952281 149.992307 148.7165907 149.9093066 147.8709789 155.8379205 161.2136754 163.2828213 148.856521 158.6261994 156.2401332 156.4217888 162.013094 153.3287042 162.4829389 156.5432951 147.800966 156.0921811 155.0511621 152.8199443 163.4839379 154.6112828 155.1894144 154.5490256 150.0523473 152.4325677 151.6923027 143.2521737 158.9486653 148.8750474 145.157938 152.3149564 155.3767999 145.1863688 148.9001221 147.9310055 156.2204608 153.3116171 155.5869136 157.1007312 153.113918 156.881402 152.4259171 159.8620799 155.3994259 148.9414996 163.8379314 160.9314274 152.3507337 167.4404036 148.6280923 161.545159 155.126291 153.1255208 155.9488743 157.2943581 144.1088904 150.6016185 150.1436424 152.598214 161.5320077 157.3237438 157.6487199 161.5562912 152.3797852 152.4396891 161.8234234 151.0011231 he mean monthly sales value. Lower limit of confidence interval or Upper limit of confidence Interval someone who has no statistics background, and who has taken no statistics courses d the answer must be in this yellow box.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags