I have attached the Excel document because I can't share a link without an email. If I need to use more questions to help with completing this please let me know and I will post again.

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% 1 Average Annual Snowfall in Inches for Bozeman, MT: MSU Weather Station: 1930-2023 2 Year Snow (inches) 3 2023 68.0 4 2022 145.9 5 2021 96.5 6 2020 93.8 V 2019 90.7 8 2018 107.6 9 2017 129.5 10 2016 62.8 11 2015 70.4 12 2014 95.5 13 2013 57.6 14 2012 92.8 15 2011 112.9 16 2010 95.0 17 2009 149.9 8T 2008 137.7 19 2007 104.5 20 2006 80.9 21 2005 96.8 22 2004 45.8 23 2003 102.3 24 2002 63.2 25 2001 68.5 26 2000 90.7 27 1999 80.5 28 1998 109.2 29 1997 113.2 30 1996 118.7 31 1995 83.3 32 1994 86.5 33 1993 74.4 34 1992 60.9\f\f