Homework from Chapter 1 (Part 2)
- Due Nov 8, 2021 by 11:59am
- Points 5
- Submitting a file upload
- Available until Jan 31, 2022 at 11:59am
Use either Microsoft Excel or Google Sheets to create and submit this assignment. If you are not already familiar with Excel or Sheets, use the learning resources in Module 1 to come up to speed.
Use the data from Chapter 1, Problem 1, to create this spreadsheet.
Column A: Label Observation, number 1 through 40
Column B: Label Researcher A, use data from assignment
Column C: Label Researcher B, use data from assignment
Column D: subtract "B" from "A" (Label column A-B)
Column E: use a function to find the minimum value in "A" or "B" (Label column Minimum)
Row 41: Label Column A "Total" and use a function to compute the total of the 40 observations for each researcher
Row 42: Label Column A "Average" and use a function to compute the average of the 40 observations for each researcher
As a "finishing touch," make the column headers and row headers Bold.