STAT-245 Lab #2 Instructions Wi2022 (Version 2.0) Frocedure: 1. Find a dataset online with a sample size around 50-500. Copy and paste the link so that the raw data can be verified, 2. Upload the dataset into a new excel spreadsheet and save the file using the format: Lastname Firstname STAT_245_Section VersionNumber. 3. Construct a frequency distribution table using 5-10 categories, and use it to make a well-labelled chart of your choice. (5) 4. Use the functions in excel to find the following (10) a. Mean, Median, Mode b. Range, Midrange c. Standard deviation d. The 90 percentile e. The four quartiles f. A value with a z-score over 2 g. The z-score of the 10th percentile 5. Comment on the data/distribution. Use the terminology we have learned in class. What insights into the dataset have you gained through this analysis? (5) Rubric: Gradable Components Possible Mark Comments Formatting 5 Spelling/Grammar 5 Questions 20 Professionalism 20 Total 50 The professionalism component for the this lab will be based on your attendance and participation in class activities (including the show and tell component)