Statistics Concepts and Descriptive Measures

   Purpose of Assignment  The aim of this assignment to orient students to the key concepts in statistics. This assignment allure present students to the talk of statistics. Students allure besides get a fortune to warm-up on evaluating some basic described statistics using Excel® prior to the career initiate.  Assignment Steps This assignment has an Excel® dataset spreadsheet resolute. You allure be required to singly do one of the three basissets.  Resource: Microsoft Excel®, Statistics Concepts and Described Measures Basis Set Download the Statistics Concepts and Described Measures Data Set.   Choose one of the forthcoming basissets to full this assignment: Consumer Food Financial Hospital Answer each of the forthcoming in a completion of 90 words: For each shaft, identify whether the basis is innate or innate. Identify the smooth of mass for the basis in each shaft. For each shaft containing innate basis: Evaluate the moderation and median Interpret the moderation and median in homely non-technical terms Use the Excel =AVERAGE exercise to ascertain the moderation Use the Excel =MEDIAN exercise to ascertain the median For each shaft containing innate basis: Evaluate the exemplar solution and place Interpret the exemplar solution and place in homely non-technical terms Use the Excel =STDEV.S exercise to ascertain the exemplar solution For place (consummation appreciate minus the narrowness appreciate), ascertain the consummation appreciate using the Excel =MAX exercise and ascertain the narrowness appreciate using the Excel's =MIN exercise