Question: please use exce!!! screenshot the work/answers through exce!! please and thank you. will thumbs up! 36 FILE The American Society of The American Society of



please use exce!!! screenshot the work/answers through exce!! please and thank you. will thumbs up! 36 FILE The American Society of The American Society of PeriAnesthesia Nurses (ASPAN: www.aspan.org )is a national organization serving nurses practicing in ambulatory surgery, preanesthesia, and postanesthesia care. The organization consists of the 40 components listed below. State/Region Membership 95 399 531 239 631 384 73 562 270 Alabama Maryland, Delaware, DC Connecticut Florida Georgia Hawaii linois Indiana lowa Kentucky Louisiana Michigan Massachusetts 197 258 411 480 97 289 Maine Minnesota, Dakotas Missouri, Kansas Mississippi Nebraska North Carolina Nevada 282 90 115 542 106 New Jersey, Bermuda 517 Alaska, Idaho, Montana, Oregon, Washington 708 New York Ohio Oklahoma Arkansas California New Mexico Pennsylvania Rhode Island Colorado South Carolina Texas Tennessee 891 708 68 1,165 79 575 53 409 237 1,026 167 Utah 67 Virginia Vermont, New Hampshire Wisconsin West Virginia 414 144 311 62 Use statistical software to answer the following questions. a. Find the mean, median, and standard deviation of the number of members per component. b. Find the coefficient of skewness, using the software. What do you conclude about the shape of the distribution of component size? please screenshot answers/work through excel! please use exce!!! screenshot the work/answers through exce!! please and thank you. will thumbs up! 36 FILE The American Society of The American Society of PeriAnesthesia Nurses (ASPAN: www.aspan.org )is a national organization serving nurses practicing in ambulatory surgery, preanesthesia, and postanesthesia care. The organization consists of the 40 components listed below. State/Region Membership 95 399 531 239 631 384 73 562 270 Alabama Maryland, Delaware, DC Connecticut Florida Georgia Hawaii linois Indiana lowa Kentucky Louisiana Michigan Massachusetts 197 258 411 480 97 289 Maine Minnesota, Dakotas Missouri, Kansas Mississippi Nebraska North Carolina Nevada 282 90 115 542 106 New Jersey, Bermuda 517 Alaska, Idaho, Montana, Oregon, Washington 708 New York Ohio Oklahoma Arkansas California New Mexico Pennsylvania Rhode Island Colorado South Carolina Texas Tennessee 891 708 68 1,165 79 575 53 409 237 1,026 167 Utah 67 Virginia Vermont, New Hampshire Wisconsin West Virginia 414 144 311 62 Use statistical software to answer the following questions. a. Find the mean, median, and standard deviation of the number of members per component. b. Find the coefficient of skewness, using the software. What do you conclude about the shape of the distribution of component size? please screenshot answers/work through excel
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
