20250310 Graphical Descriptions (Using Google Sheet/Excel)
QUALITATIVE DATA Example 2.1: Data are from Statistic With Technology, Dr. Kozak https://stats.libretexts.org/Bookshelves/Introductory_Statistics/Statistics_with_Technology_2e_(Kozak)/02%3A_Graphical_Descriptions_of_Data/2.01%3A_Qualitative_Data One Dollar teaches us how to use Google Sheets/Excel to get the given's Relative Frequency. First, copy the provided data and paste it into the Google spreadsheet. Then, add another column, namely "Relative Frequency," next to the Frequency. See the steps below. Note: Letters and Numbers depends on the column and row of the data you want to calculate Category Frequency Relative Frequency (sum=1) Ford 5 0.1 Chevy 12 0.24 Honda 6 0.12 Toyota 12 0.24 Nissan 10 0.2 Other 5 0.1 Total 50 1 This image shows the result after I did the given instructions. However, these data samples are from the textbook "Statistic with Technology" by Kozak. Reference: 2.1: Qualitative Data - Statistics LibreTexts Example 2.1.2: D...