Unit 03
Unit 3:
Summarizing Data

Unit 3: Assignment #1 (due before 11:59 pm Central on MON JUN 24):
 Finish collecting the following data from 5 different adults:
 the Person’s 3 letter Initials of their name (e.g. CMA); if the adult doesn’t have three names, use X for the middle name (e.g., CXA);
 their Age (in years using only whole numbers, no fractions or decimals);
 their Height (in inches using only whole numbers, no fractions or decimals);
 the Month of their Birthday; and
 their Favorite Flavor of Ice Cream.
 To stay organized in this course, create a personal cataloging system for all of your materials.
 First, decide where you plan to save your materials for this course:
 locally on your personal device (e.g., your laptop, tablet, or desktop computer) or
 online using a cloudbased storage service (e.g., Google Drive).
 Second, create a new PSY210 main folder named PSY210_SEMESTERYEAR_Materials (e.g. PSY210_Summer2021_Materials).
 Third, take a PARTIAL screenshot of the main PSY210 folder you created. Name the screenshot YourLastName_PSY210_Screenshot_MainFolder.xxx (where xxx is the filetype, for example, .jpg, .png, .jpeg, and the like).
 Your partial screenshot should include only your main PSY210 folder, NOT your entire screen.
 If you can’t remember how to take a partial screenshot, which is also known as a “screenshot of a specific area,” you can revisit this website.
 Now that you’ve created your Unit folders, move any course materials you’ve already created when you were working on Units 1 and 2 into their corresponding Unit folders.
 Fourth, within your main PSY210 folder, create a separate folder for each of the 14 units of our course using the naming convention PSY210_SEMESTERYEAR_UnitXX where XX is the unit number (e.g., PSY210_Summer2021_Unit01).
 These 14 Unit folders will be where you store the materials (files, screenshots, data files, etc.) you create and use for each unit.
 We recommend using what’s called “leading zeros” when creating folders and filenames.
 For example, name the folder PSY210_Summer2021_Unit01, with one leading zero in front of the 1 of Unit 1, rather than PSY210_Summer2021_Unit1, without a leading zero in front of the 1 of Unit 1. Using leading zeros will allow you to alphabetize your files and folders.
 After creating your Unit folders, move any course materials you’ve created so far in this course into their corresponding Unit folders.
 Fifth, take a partial screenshot that shows all 14 of your Unit folders. Name the screenshot YourLastName_PSY210_Screenshot_SubFolders.xxx (where xxx is the filetype, for example, .jpg, .png, .jpeg, and the like).
 Your partial screenshot should include only your 14 Unit folders, NOT your entire screen.
 In this course, you’ll learn how to manage data using a database management system, such as Microsoft Excel, Google Sheets, or Apple Numbers.
 To appreciate why you’re going to learn a database management system, such as Excel (or Apple Numbers or Google Sheets), rather than learn a statistical software program, such as SPSS, look through Burleigh’s (2019) tweet and Schrock’s (2019) tweet.
 Be sure to notice that the majority of data management jobs — not only at the senior and associate level but also at the entry level — require employees to know how to use Excel (or Apple Numbers or Google Sheets), not SPSS.
 The first step in learning to use a data management system is deciding which system you’re going to use. For this course, your choices are (1) Microsoft Excel, (2) Google Sheets, or (3) Apple Numbers. If you’re not sure which data management system you want to use, feel free to look through more than one of the tutorials below.
 For Microsoft Excel, all UWMadison students have free access to Office 365, which includes both online and downloadable desktop versions of the suite of Microsoft products, including Excel.
 For this course, if you choose to use Excel as your data management system, you MUST use the desktop version rather than the Online version.
 For Google Sheets, all UWMadison students already have a UWMadison Google account attached to their @wisc.edu email address.
 For this course, if you choose to use Google Sheets as your data management system, you MUST be signed in to Google using your UWMadison Google account (not your personal Gmail or personal Google account) whenever you are doing work for this course.
 For Apple Numbers, all Mac and iPad users have free access to the Apple Numbers app.
 Next, learn to use the data management system you’ve chosen.
 If you’ve chosen to learn Microsoft Excel, complete Andrews’ (2020) tutorial “Getting Started with Microsoft Excel.”
 If you’ve chosen to learn Google Sheets, complete Andrews’ (2020) tutorial “Getting Started with Google Sheets.”
 If you have chosen to learn Apple Numbers complete Andrews’ (2020) tutorial “Getting Started with Apple Numbers.”
 After completing the tutorial you chose to learn:
 First, save the spreadsheet you created during the tutorial with the filename, YourLastName_PSY210_Unit03_FiveData.
 Second, take a partial screenshot of the spreadsheet you created during the tutorial.
 Name the screenshot YourLastName_PSY210_Unit03_Screenshot_FiveData.xxx (where xxx is the filetype, for example, .jpg, .png, .jpeg and the like).
 Your partial screenshot should include only the part of your spreadsheet that contains data, NOT your entire screen.
 For example, for this screenshot, you will include only the column letters, row numbers, and filled cells in your screenshot, as in these examples.
 Third, export the spreadsheet you created during the tutorial as a .csv file, as demonstrated in the tutorial.
 Name the .csv file, YourLastName_PSY210_Unit03_FiveData.csv.
 Note that when exporting a Microsoft Excel spreadsheet (rather than an Apple Numbers or Google Sheets spreadsheet) to be a .csv file, you’ll be told that “some features might be lost if you save this workbook in the commadelimited (.csv) format.” That’s ok! Go ahead and export the Excel spreadsheet as a .csv file anyway.
 From the Course How To learn “How to Embed an Image into a Discussion Board Post.” Be sure to learn from the Course How To
 how to embed an image rather than “Attach” it,
 how to resize each image so that it is no wider than 500 pixels and no taller than 500 pixels, and
 how to create image descriptions (“alt text”) for your images.
 Go to the Unit 3: Assignment #1 Discussion Board and make a new Discussion Board post in which you
 state which data management system you’ve chosen to use for this course;
 embed the two screenshots you took in step b above (one representing your main PSY210 folder and the other representing your 14 Unit folders); and
 embed the screenshot of the spreadsheet you created when completing the data management system tutorial (the screenshot you saved and named YourLastName_PSY210_Unit03_Screenshot_FiveData.xxx).
Unit 3: Assignment #2 (due before 11:59 pm Central on MON JUN 24):
 To learn why we summarize data using Frequency Distribution Tables, read Poldrack’s (2020) Chapter 3, “Summarizing Data: Summarizing Data Using Tables.”
 Now, you’re going to learn how to make Frequency Distribution Tables, beginning with learning how to make a Frequency Distribution Table for discrete data. Remember, discrete data can take only on a limited set of values (whereas continuous data can take on an infinite set of values).
 First, open Owlcation’s (2014) howto article, “Using Excel’s [Google Sheets’, and Numbers’] COUNTIF Function to Make a Frequency Distribution for Discrete Data.”
 Second, open a new (blank) spreadsheet in your data management system.
 Third, as you are reading through Owlcation’s (2014) howto article, do each of the steps listed, exactly as they are shown in the article, to create a Frequency Distribution Table of Volkswagen models sold at that car dealership.
 For each step, compare the Frequency Distribution Table you are making in your own spreadsheet with the images (figures) shown in Owlcation’s (2014) howto article.
 You want your completed Frequency Distribution Table to look just like the one that is made in Owlcation’s (2014) howto article (with the exception, as stated in Owlcation’s howto article, that your Frequency Distribution Table will also have a total for the Relative Frequencies).
 Fourth, save the spreadsheet you created with the filename, YourLastName_PSY210_Unit03_FrequencyDistribution_Owlcation.
 Fifth, take a partial screenshot of the Frequency Distribution Table you created and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_Owlcation.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Again, your partial screenshot should include only the part of your spreadsheet that contains data, NOT your entire screen.
 Next, you’re going to make Frequency Distribution Tables for discrete data using an assigned data set.
 In this course, whenever you are assigned a data set, the name of each data set will include a threedigit number, such as 001.
 Each student in each Section of this course will be assigned a threedigit number. That threedigit number will be your “unique data set number.”
 You will keep the same unique data set number for all assignments, throughout the entire term.
 To find out your unique data set number, look at this Unique Data Set Number List. NOTE: This is a passwordprotected PDF. To read the PDF, you’ll need to type in a password:
 The password is the email subject heading you’re supposed to use in this course when you email a question.
 Capitalization, punctuation, and spacing matter for this password.
 If you’re initially unable to open the PDF, and you’re sure you’re inputting the correct password:

 Try a different browser. Some browsers are set to a default level of security that interferes with opening passwordprotected files. Using a different browser (which is a good goto solution for a lot of Internetrelated problems) should help.
 Or save the PDF onto your personal device (e.g., your laptop or tablet), and open the PDF there (using Adobe Reader, Preview, or another PDF reader), rather than trying to open the PDF in your browser.
 Now that you know your unique data set number, identify from the list below, your assigned Birth Month Data Set for this assignment. For example, if your unique data set number is 001, your assigned data set for this assignment is Birth Month Data Set 001.
 Download your assigned Birth Month Data Set.
 If you are using the browser Chrome or the browser Firefox, click on the link for your data set, below. When prompted, save the file to your PSY210_Summer2021_Unit03 folder.
 If you are using the browser Safari, rightclick on the link for your data set, below, and select “Download Linked File.”
 Birth Month Data Set 001, Birth Month Data Set 002, Birth Month Data Set 003, Birth Month Data Set 004, Birth Month Data Set 005, Birth Month Data Set 006, Birth Month Data Set 007, Birth Month Data Set 008, Birth Month Data Set 009, Birth Month Data Set 010, Birth Month Data Set 011, Birth Month Data Set 012, Birth Month Data Set 013, Birth Month Data Set 014, Birth Month Data Set 015.
 You will notice that your assigned Birth Month Data Set has the file extension .csv, which stands for “commaseparated values.” Data saved with the file extension .csv can be opened in almost any data management platform.
 Because your assigned Birth Month Data Set has the file extension .csv, no matter what data management platform you have chosen to learn for this course, you will be able to import the data!
 Import your assigned Birth Month Data Set into your chosen data management platform.
 Follow Andrews’ (2020) howto article “How to Import Data from .csv Files.”
 Note that when importing data from a Microsoft Excel .csv file (rather than an Apple Numbers or Google Sheets .csv file) you’ll be told “some features might be lost if you save this workbook in the commadelimited (.csv) format. To preserve these features, save it in an Excel file format,” which you will do next
 Then, save the new spreadsheet in which you have imported your assigned Birth Month Data Set, naming the file, YourLastName_PSY210_Unit03_BirthMonthFrequency.
 If you’re using Microsoft Excel (rather than Apple Numbers or Google Sheets) you’ll need to select “Save As” rather than only “Save” by choosing from the dropdown File menu to “Save As” a “Microsoft Excel (.xlsx)” file.
 Using the skills you learned from Owlcation’s (2014) howto, create a Frequency Distribution Table for your assigned Birth Month Data Set.
 Your Birth Month Data Frequency Distribution Table must include the following:
 a column for Categories (which are the 12 months of the year in chronological order, e.g., January, February, March, April … December)
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 After creating your Birth Month Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_BirthMonthFrequency
 Finally, take a partial screenshot (not a screenshot of your entire screen) of your Birth Month Data Frequency Distribution Table (not your entire screen) and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_BirthMonthFrequency.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Identify from the list below, your assigned Ice Cream Data Set for this assignment. Remember, if your unique data set number is 001, your assigned data set is Ice Cream Data Set 001.
 Download your assigned Ice Cream Data Set:
 If you are using the browser Chrome or the browser Firefox, click on the link for your data set, below. When prompted, save the file to your PSY210_Summer2021_Unit03 folder.
 If you are using the browser Safari, rightclick on the link for your data set, below, and select “Download Linked File.”
 Ice Cream Data Set 001, Ice Cream Data Set 002, Ice Cream Data Set 003, Ice Cream Data Set 004, Ice Cream Data Set 005, Ice Cream Data Set 006, Ice Cream Data Set 007, Ice Cream Data Set 008, Ice Cream Data Set 009, Ice Cream Data Set 010, Ice Cream Data Set 011, Ice Cream Data Set 012, Ice Cream Data Set 013, Ice Cream Data Set 014, Ice Cream Data Set 015.
 Import your assigned Ice Cream Data Set into your chosen data management platform.
 Follow Andrews’ (2020) howto article, “How to Import Data from .csv Files.
 Then, save the new spreadsheet in which you have imported your assigned Ice Cream Data Set, naming the file, YourLastName_PSY210_Unit03_IceCreamFrequency.
 Again, using the skills you learned from Owlcation’s (2014) howto, create a Frequency Distribution Table for your assigned Ice Cream Data Set.
 Your Ice Cream Data Frequency Distribution Table must include the following:
 a column for Categories (which are the following ice cream flavors in alphabetical order: Blue Moon, Chocolate, Cookie Dough, Cookies and Cream, Mint Chocolate Chip, Strawberry, Vanilla)
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 After creating your Ice Cream Data Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_IceCreamFrequency.
 Finally, take a partial screenshot (not a screenshot of your entire screen) of your Ice Cream Data Frequency Distribution Table (not your entire screen) and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_IceCreamFrequency.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Go to the Unit 3: Assignment #2 Discussion Board and make a new Discussion Board post.
 In the first sentence of your Discussion Board post, state your unique data set number (e.g., “My unique data set number is 001”).
 Then, embed each of your three screenshots into your Discussion Board Post.
 one screenshot is of the Frequency Distribution Table you made by following Owlcation’s (2014) howto (YourLastName_PSY210_Unit03_Screenshot_Owlcation.xxx);
 one screenshot is of your Birth Month Data Frequency Distribution Table (YourLastName_PSY210_Unit03_Screenshot_BirthMonthFrequency.xxx); and
 one screenshot is of your Ice Cream Data Frequency Distribution Table (YourLastName_PSY210_Unit03_Screenshot_IceCreamFrequency.xxx).
 Remember to embed and resize your screenshots using the procedures you learned from the Course How To.
Unit 3: Assignment #3 (due before 11:59 pm Central on TUE JUN 25):
 In this assignment, you’re going to learn how to make a Frequency Distribution Table for continuous data. Remember, continuous data can take on an infinite set of values (whereas discrete data can take on only a limited set of values).
 First, open Andrews’ (2020) howto article, “Using Excel’s, Google Sheets’, and Numbers’ COUNTIFS Function to Make a Frequency Distribution for Continuous Data.”
 Second, open a new (blank) spreadsheet in your data management system.
 Third, as you are reading through Andrews’ (2020) Frequency Distribution howto article, do each of the steps listed, exactly as they are shown in the article, to create a Frequency Distribution Table of the hours of sleep students get each night.
 For each step, compare the Frequency Distribution Table you are making in your own spreadsheet with the images (figures) shown in Andrews’ (2020) Frequency Distribution howto article.
 You want your completed Frequency Distribution Table to look just like the one that is made in Andrews’ (2020) Frequency Distribution howto article (with the exception, as stated in Andrews’ Frequency Distribution howto article that your Frequency Distribution Table will also have a total for the Relative Frequencies).
 Fourth, save the spreadsheet you created with the filename, YourLastName_PSY210_Unit03_FrequencyDistribution_Andrews.
 Fifth, take a partial screenshot (not a screenshot of your entire screen) of the Frequency Distribution Table (not your entire screen) you created and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_Andrews.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Now, you’re going to make Frequency Distribution Tables for continuous data using an assigned data set.
 First, using your Unique Data Set Number, identify from the list below, your assigned Age Data Set. For example, if your unique data set number is 001, your assigned data set for this assignment is Age Data Set 001.
 Second, download your assigned Age Data Set.
 Remember: If you are using the browser Chrome or the browser Firefox, click on the link for your data set, below. When prompted, save the file to your PSY210_Summer2021_Unit03 folder.
 Remember: If you are using the browser Safari, rightclick on the link for your data set, below, and select “Download Linked File.”
 Age Data Set 001, Age Data Set 002, Age Data Set 003, Age Data Set 004, Age Data Set 005, Age Data Set 006, Age Data Set 007, Age Data Set 008, Age Data Set 009, Age Data Set 010, Age Data Set 011, Age Data Set 012, Age Data Set 013, Age Data Set 014, Age Data Set 015.
 Third, import your assigned Age Data Set into your chosen data management platform
 Remember to follow Andrews’ (2020) Import Data howto article.
 Then, save the new spreadsheet in which you have imported your assigned Age Data Set, naming the file, YourLastName_PSY210_Unit03_AgeFrequency
 Using the skills you learned from Andrews’ (2020) Frequency Distribution Table howto, create a Frequency Distribution Table for your assigned Age Data Set.
 Use intervals of 5 years, starting with the interval 2024 and ending with the interval 7579 (e.g., 2024, 2529, 3034, 3539, and so forth). Therefore, your first Min cell will be 20 and your last Max cell will be 79.
 Your Age Data Frequency Distribution Table must include the following:
 a column for the Minimum interval value
 a column for the Maximum interval value
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 After creating your Age Data Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_AgeFrequency
 Finally, take a partial screenshot (not a screenshot of your entire screen) of your Age Data Frequency Distribution Table (not your entire screen) and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_AgeFrequency.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Next, identify from the list below, your assigned Height Data Set. Remember, if your unique data set number is 001, your assigned data set is Height Data Set 001.
 Download your assigned Height Data Set:
 Height Data Set 001, Height Data Set 002, Height Data Set 003, Height Data Set 004, Height Data Set 005, Height Data Set 006, Height Data Set 007, Height Data Set 008, Height Data Set 009, Height Data Set 010, Height Data Set 011, Height Data Set 012, Height Data Set 013, Height Data Set 014, Height Data Set 015.
 Import your assigned Height Data Set into your chosen data management platform.
 Remember to follow Andrews’ (2020) Import Data howto article.
 Then, save the new spreadsheet in which you have imported your assigned Height Data Set, naming the file, YourLastName_PSY210_Unit03_HeightFrequency
 Again, using the skills you learned from Andrews’ (2020) Frequency Distribution Table howto, create a Frequency Distribution Table for your assigned Height Data Set.
 Use intervals of 5 inches, starting with the interval 5559 and ending with the interval 8589 (e.g., 5559, 6064, 6569, 7074, and so forth). Therefore, your first Min cell will be 55, and your last Max cell will be 89.
 Your Height Data Frequency Distribution Table must include the following:
 a column for the Minimum interval value
 a column for the Maximum interval value
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 After creating your Height Data Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_HeightFrequency
 Finally, take a partial screenshot (not a screenshot of your entire screen) of your Height Data Frequency Distribution Table (not your entire screen) and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_HeightFrequency.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Go to the Unit 3: Assignment #3 Discussion Board and make a new Discussion Board post.
 In the first sentence of your Discussion Board post, state your unique data set number (e.g., “My unique data set number is 001″).
 Then, embed each of your three screenshots into your Discussion Board Post.
 one screenshot is of the Frequency Distribution Table you made by following Andrews’ (2020) Frequency Distribution howto (YourLastName_PSY210_Unit03_Screenshot_Andrews.xxx,
 one screenshot is of your Age Data Frequency Distribution Table (YourLastName_PSY210_Unit03_Screenshot_AgeFrequency.xxx); and
 one screenshot is of your Height Data Frequency Distribution Table (YourLastName_PSY210_Unit03_Screenshot_HeightFrequency.xxx).
 Remember to embed and resize your screenshots using the procedures you learned from the Course How To.
Unit 3: Assignment #4 (due before 11:59 pm Central on TUE JUN 25):
 To learn why we summarize data using Cumulative Frequency Distribution Tables, read Poldrack’s (2020) Chapter 3, “Summarizing Data: Summarizing Data Using Tables – Cumulative Distributions.”
 To learn how to make Cumulative Frequency Distribution Tables for continuous data:
 First, open Andrews’ (2020) howto article, “Using Excel’s, Google Sheets’, and Numbers’ SUM Function to Make a Cumulative Distribution for Continuous Data.”
 Second, open the spreadsheet you created in Unit 3: Assignment #3 named YourLastName_PSY210_Unit03_FrequencyDistribution_Andrews
 Third, as you are reading through Andrews’ (2020) Cumulative Distribution howto article, do each of the steps listed, exactly as they are shown in the article, to create a Cumulative Frequency Distribution Table of the hours of sleep students get each night.
 Fourth, after creating your Cumulative Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_FrequencyDistribution_Andrews
 Fifth, take a partial screenshot (not a screenshot of your entire screen) of the Cumulative Frequency Distribution Table (not your entire screen) you created and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_Cumulative_Andrews.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Now, you’re going to create a Cumulative Frequency Distribution Table for continuous data using your assigned Age Data Set.
 First, open the spreadsheet you created in Unit 3: Assignment #3 named YourLastName_PSY210_Unit03_AgeFrequency, which contains your Age Data Frequency Distribution Table.
 Second, using the skills you learned from Andrews’ (2020) Cumulative Distribution howto, create an Age Data Cumulative Frequency Distribution Table for your assigned Age Data Set.
 Your Age Data Cumulative Frequency Distribution Table will show how many people are 24 years of age and younger, 29 years of age and younger, 34 years of age and younger, and so forth.
 Your Age Data Cumulative Frequency Distribution Table must include the following:
 a column for the Minimum interval value
 a column for the Maximum interval value
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 a column for Cumulative Absolute Frequency
 a column for Cumulative Relative Frequency
 After creating your Age Data Cumulative Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_AgeFrequency
 Finally, take a partial screenshot (not a screenshot of your entire screen) screenshot of your Age Data Cumulative Distribution Table (not your entire screen) and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_AgeCumulative.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Last, you’re going to create a Cumulative Frequency Distribution Table using your assigned Height Data Set.
 First, open the spreadsheet you created in Unit 3: Assignment #3 named YourLastName_PSY210_Unit03_HeightFrequency, which contains your Height Data Frequency Distribution Table.
 Second, using the skills you learned from Andrews’ (2020) Cumulative Distribution howto, create a Cumulative Frequency Distribution Table for your assigned Height Data Set.
 Your Height Data Cumulative Frequency Distribution Table will show how many people are 59 inches and shorter, 64 inches and shorter, 69 inches and shorter, and so forth.
 Your Height Data Cumulative Frequency Distribution Table must include the following:
 a column for the Minimum interval value
 a column for the Maximum interval value
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 a column for Cumulative Absolute Frequency
 a column for Cumulative Relative Frequency
 After creating your Height Data Cumulative Frequency Distribution Table, be sure to save (again) your spreadsheet, which should already be named, YourLastName_PSY210_Unit03_HeightFrequency.
 Finally, take a partial screenshot (not a screenshot of your entire screen) screenshot of your Height Data Cumulative Frequency Distribution Table (not your entire screen) and save the screenshot with the filename YourLastName_PSY210_Unit03_Screenshot_HeightCumulative.xxx (where xxx is the file type, for example, .jpg, .png, .jpeg, and the like).
 Go to the Unit 3: Assignment #4 Discussion Board and make a new Discussion Board post.
 In the first sentence of your Discussion Board post, state your unique data set number (e.g., “My unique data set number is 001″).
 Then, embed each of your three screenshots into your Discussion Board Post.
 one screenshot is of the Cumulative Frequency Distribution Table you made by following Andrews’ (2020) Cumulative Frequency Distribution howto (YourLastName_PSY210_Unit03_Screenshot_Cumulative_Andrews.xxx);
 one screenshot is of your Age Data Cumulative Frequency Distribution Table (YourLastName_PSY210_Unit03_Screenshot_AgeCumulative.xxx); and
 one screenshot is of your Height data Cumulative Frequency Distribution Table (YourLastName_PSY210_Unit03_Screenshot_HeightCumulative.xxx.
 Remember to embed and resize your screenshots using the procedures you learned from the Course How To.
Unit 3: Assignment #5 (due before 11:59 pm Central on WED JUN 26):
 Meet online with your small Chat Group for a onehour textbased Group Chat at the time and date that your Chat Group previously arranged.
 BEFORE your Chat Group meets online:
 ALL members of your Chat Group must have completed Unit 3: Assignments #1, #2, #3 and #4; do NOT meet until all Chat Group members have completed Unit 3: Assignments #1 through #4;
 ALL members of your Chat Group must have learned from the Course How To:
 “How To Participate in a Group Chat on Your Laptop” OR “How To Participate in a Group Chat on Your Mobile Device”;
 that at least one member of the Chat Group must participate in the Group Chat using the browser Chrome on their laptop (rather than on their mobile device);
 what to do if your Chat Group agrees on a date and time for your Chat, but one member of the Chat Group wants to reschedule or hasn’t joined the Chat within 15 minutes after the agreedupon time; and
 that all Group Chats are required to last ONE FULL HOUR. During that entire hour, the Group Chat should be the ONLY thing you’re doing. If you finish early, then practice the assignment more or discuss further implications
 ALL members of your Chat Group must have read the following:
 Make sure the one member of your Chat Group whose last name comes last alphabetically in your Chat Group has set up the Group Chat room (as instructed in Unit 2: Assignment #5) and according to the instructions in the Course How To (under the topic, “How To Set Up a Group Chat Room on Your Laptop” or “How To Set Up a Group Chat Room on Your Mobile Device”).
 DO NOT begin your onehour Group Chat until all the steps listed above are completed.
 DO NOT begin working on any of the steps listed below until your Chat Group begins their onehour Group Chat.
 BEGIN your onehour Group Chat by doing the following:
 First, introduce yourselves using the preferred first names that each Chat Group member provided in Unit 1: Assignment #2, and, to the degree that you feel comfortable, discuss any statistics anxiety you had coming into this class.
 Second, each Chat Group member needs to indicate ONE of the NINE “How Are You Feeling At the START of Today’s Group Chat?” images. More than one Chat Group member can indicate the same image if that’s how they are feeling, and please refer to each image by its number.
 Third, begin the process of data sharing.
 Each member of the Chat Group must share with the other Chat Group member(s) the .csv file they exported back in Unit 3: Assignment #1 (YourLastName_PSY210_Unit03_FiveData.csv) when working through the “Getting Started” tutorials.
 Each Chat Group members’ .csv file should already contain the data they collected from 5 adults.
 Chat Group members can share their .csv files via email, Dropbox, Google Drive, or any other method of sharing files.
 Fourth, each Chat Group member needs to create a new spreadsheet that contains the combined data from all members of the Chat Group (your own data included).
 Begin by opening a new (blank) spreadsheet in your data management system.
 Then open the two .csv files (if you’re in a Chat Group with only two students, including you) or three .csv files (if you’re in a Chat Group with three students, including you).
 Copy and then paste the data from each of the two or three .csv files into your new spreadsheet.
 When copying/pasting the data from the .csv files into your combined spreadsheet, be sure to keep the data in their respective columns, Person’s Initials, Age (in years), Height (in inches), Month of Birthday, Favorite Flavor of Ice Cream.
 For example, all the Person’s Initials data should be in one column.
 However, you need only one Column Heading (e.g., Person’s Initials) for each column.
 If you are in a Chat Group with only two students (including you), your combined spreadsheet will have 10 data cells in each column; if you are in a Chat Group with three students (including you), your combined spreadsheet will have 15 data cells in each column.
 Fifth, save your combined spreadsheet with the filename YourLastName_PSY210_Unit03_Combined_FiveData
 Next, each Chat Group member is going to make a different type of Frequency Distribution Table using the combined data file they created by combining data from all Chat Group members.
 If your last name comes last alphabetically in your Chat Group, your job is to create a Frequency Distribution Table for discrete data using the combined Favorite Flavor of Ice Cream data. Your combined Ice Cream Frequency Distribution Table must include the following:
 a column for Categories (which you and your Chat Group will need to decide on based on your combined data)
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 If your last name comes first alphabetically in your Chat Group, your job is to create a Frequency Distribution Table for continuous data using the combined Age (in years) data. Your combined Age Frequency Distribution Table must include the following:
 a column for the Minimum interval value (which you and your Chat Group will need to decide on based on your combined data)
 a column for the Maximum interval value (which you and your Chat Group will need to decide on based on your combined data)
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 If you are in a Chat Group of three students (including you), and your last name comes neither first nor last alphabetically in your Chat Group, your job is to create a Frequency Distribution Table for continuous data using the combined Height (in inches) data. Your combined Height Frequency Distribution Table must include the following:
 a column for the Minimum interval value (which you and your Chat Group will need to decide on based on your combined data)
 a column for the Maximum interval value (which you and your Chat Group will need to decide on based on your combined data)
 a column for Absolute Frequency
 a total for Absolute Frequency
 a column for Relative Frequency
 a total for Relative Frequency
 While creating these Frequency Distribution Tables, stay in contact (through your text chat) with the other Chat Group members. Feel free to ask questions, provide advice, and report on your progress.
 After creating your Frequency Distribution Table, take a partial screenshot (not a screenshot of your entire screen) of your Frequency Distribution Table and save the screenshot with the relevant filename:
 YourLastName_PSY210_Unit03_Screenshot_Combined_IceCream.xxx
 YourLastName_PSY210_Unit03_Screenshot_Combined_Age.xxx
 YourLastName_PSY210_Unit03_Screenshot_Combined_Height.xxx
 Next, discuss as a group the barriers to data sharing that you read about in Houtkoop et al.’s (2018) abstract and the benefits of data sharing that you read about in Hunt’s (2019) introduction, as well as the benefits or barriers of data sharing that you experienced during this Group Chat
 Finally, before ending the Group Chat:
 Each Chat Group member needs to indicate ONE of the NINE “How Are You Feeling at the END of Today’s Group Chat?” images. More than one Chat Group member can indicate the same image if that’s how they are feeling, and please refer to each image by its number.
 NOTE: The “How Are You Feeling at the END of Today’s Group Chat” grid of images differs from the “How Are You Feeling at the START of Today’s Group Chat” grid of images.
 As a group, the Chat Group needs to arrange the day, date, and time that your Chat Group will meet to hold the Group Chat for the next Unit (Unit 4: Assignment #5).
 AT THE END of your onehour Group Chat:
 Nominate one member of your Chat Group (who participated in the Chat) to make a post on the Unit 3: Assignment #5 Discussion Board that summarizes your Group Chat in at least 200 words. This Chat Group member should not post their 200word summary of your Group Chat until they have completed their Course Journal for the current Unit.
 At the end of the 200word summary, this member needs to write this sentence filling the blanks: “I have completed my Course Journal for the current Unit. It contains ___ words and the two things I learned during this Unit about which I journaled about are ___ and ___.”
 This member also needs to embed in their Discussion Post (not attach) the screenshot of their Frequency Distribution Table (not their entire screen).

 Remember to embed and resize your screenshot using the procedures you learned from the Course How To.
 Nominate a member of your Chat Group (who participated in the Group Chat using the browser Chrome on their laptop, rather than on their mobile device) to save the Chat transcript, as described in the Course How To (under the topic, “How To Save and Attach a Chat Transcript”).
 This member of the Chat Group needs to make a post on the Unit 3: Assignment #5 Discussion Board and attach the Chat transcript, saved as a PDF, to that Discussion Board post.

 Remember to attach the Chat transcript by clicking on the word “Attach.” (Do not click on the sidebar menu “Files.”)
 This Chat Group member should not post the transcript of your Group Chat until they have completed their Course Journal for the current Unit.
 In their Discussion Board post, this member needs to write this sentence filling the blanks: “I have completed my Course Journal for the current Unit. It contains ___ words and the two things I learned during this Unit about which I journaled about are ___ and ___.”
 This member also needs to embed in their Discussion Post (not attach) the screenshot of their Frequency Distribution Table (not their entire screen).

 Remember to embed and resize your screenshot using the procedures you learned from the Course How To.
 Nominate a third member of your Chat Group (who also participated in the Chat) to make another post on the Unit 3: Assignment #5 Discussion Board that states the name of your Chat Group, the names of the Chat Group members who participated the Chat, the date of your Chat, and the start and stop time of your Group Chat.
 This Chat Group member should not post the names, date, and times of your Group Chat until they have completed their Course Journal for the current Unit.
 In their Discussion Board post, this member needs to write this sentence filling the blanks: “I have completed my Course Journal for the current Unit. It contains ___ words and the two things I learned during this Unit about which I journaled about are ___ and ___.”
 This member also needs to embed in their Discussion Post (not attach) the screenshot of their Frequency Distribution Table (not their entire screen).

 Remember to embed and resize your screenshot using the procedures you learned from the Course How To.
 Across the semester, and to the degree possible, try to trade off which member of your Chat Group does each task (writes and posts the summary; creates the transcript and attaches it; posts the names, date, start/stop time) so that across the semester each member of the Chat Group carries an equal load. You don’t want to create a group work experience like the bottom chart of these charts.
 If only two students participated in the Chat, then one of those two students needs to do two of the above three tasks. However, they need to embed only one screenshot (because they made only one Frequency Distribution Table).
 Before ending the Group Chat, arrange the date and time for the Group Chat you will need to hold during the next Unit (Unit 4: Assignment #5)
Congratulations; you have finished Unit 3! Onward to Unit 4! 
