AutoSave @ (0 [ B ASSIGN#2 RCM DocuSign 4aBbCcDdEe|ll AaBbCcDc Empha: Heading 1 B. DESCRIPTIVE STATISTICS 1. Once you have downloaded, saved, and opened the file, clean the data (if applicable). Now, use these cleaned data to answer the following questions. Produce a box-and-whisker plot. Then \"Add Data Labels.\" Cut-and-paste the plot into Word document. Then, use the 6 data values associated with the Data Labels. Use these values t judgement on the shape of the distribution: is it roughly normal? Using ToolPak, produce descriptive statistics. Include (a) minimum and maximum values, (b) range, (c) mean, (d) median, and (e) standard deviation. Then, fill out the table below and give it a title. The title of the table can be found in Row 1 of your Excel file. Provide both a statistical and plain language interpretation of the min/max values, range, mean, median, and standard deviation. 13610 Insert Draw Design (=101 References Mailings Review A Calibri = B I Uvab Pane ke a (o Zele T\\ 6. For all Z-scores below, please (a) indicate the X;, X-bar, and standard deviation, (b) the shaded area(s) under the curve you intend to solve, (c) all work in solving the equation (as we did in class on Thursdays (2/15 & 2/22), (d) the calculated z-score(s), (e) the corresponding values/area(s) from Appendix A/Table on D2L, and (f) the statistical interpretations. All needs to be in the final document you upload. You can take a picture and embed or convert to a PDF. Sven is a college student at MSU and an avid and expert skier who really thrives only on powder days (i.e., fresh snowfall 3\" or more). He has a decision to make for next year and needs all the information he can before he buys any season passes. His choices are (a) no passes; (b) 1 pass either Bridger or Big Sky; or (c) 2 passes1 each at Bridger and Big Sky. The Big Sky pass is $2,550 as he wants unlimited access to the Tram. Bridger pass is $1,075 as he needs to ski on the weekends. Sven recently took SOCI202 and knows that z-scores will give him the information he wants. He's trying to be realistic and just wants a good snow total. So, he calculates the following based on historical data in Assignment #2 Excel file: a. What is the statistical likelihood of having an epic winter like that in 2009? b. What is the statistical likelihood of having a dry winter like that in 2004? (Side note: it was so dry that MSU students would dance, chant, and pray to the snow god Ullr.) c. What is the statistical likelihood of between 75 and 100 inches? d. Lastly, what is the combined statistical likelihood of getting the extremes: lowest and highest ever snowfalls? 9. Based on 8a 8d, provide both a statistical and practical answer to the question: how many ski passes should Sven buy? Page1of2 537words [X English (United States) 'T,'; Accessibility: Investigate [T 2 Search (Cmd + Ctrl + U) AaBbCcDAH N 4% Strong S Di (J Comments / Editing v ) ictate Add-ins =11 E & o X FIRY 150%