Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started