Question: Check your progress. Use this Lab to assess whether you can: Histogram Creation: Select Bin Width: Determine an appropriate bin width for a histogram and
Check your progress. Use this Lab to assess whether you can: Histogram Creation: Select Bin Width: Determine an appropriate bin width for a histogram and justify your choice. Describe Data Distribution: Use a histogram to describe the shape of the data distribution. Data Start by downloading the actor datafile to your computer. actor- lab 1.xlsx Download actor- lab 1.xlsx This is the first of several lab designed to teach you how to use Excel sheet and google slides . Later in the course, you will be expected to complete more extensive labs and in-class quizzes/exams using the Excel sheet skills learned in these early labs. Lab Instructions: Create a first histogram for the distribution of ages, and adjust the bin width 5. Describe the distribution of ages of the Best Actor Oscar winners. Your description should include: shape, a typical interval of representative ages, and any outliers (unusual ages). Post the screen shot of this histogram on the slide. Create a second histogram for the distribution of ages, and adjust the bin width other than 5. Try both smaller and larger bin widths. Choose a bin width so that your second histogram does not look like the first. Your description should include: shape. Post the screen shot of this histogram on the slide. Rubric for Lab Assignment Total Points: 40 Histogram Creation (15 Points) Appropriate Bin Width (5 Points): The selected bin width for the first histogram is suitable and justified. Explanation is clear and demon
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
