Visualizing Frequencies Excel Project 1 A THE UNIVERSITY OF ARIZONA Before you begin... In the Project...

Transcribed Image Text:

Visualizing Frequencies Excel Project 1 A THE UNIVERSITY OF ARIZONA Before you begin... In the Project 1 Excel Work document, filter as necessary to complete the two-way tables found in the two worksheets. The following slides will then ask you to complete various tasks regarding your Excel project. Most slides will require you to annotate the slides. Make sure you show your math computations and answer the questions in complete sentences. Task 1: Class Standing 1. Display your relative frequency table. 10 points Relative Relative Team Argentina Frequency Frequency Team Frequency Frequency Australia Mexico Morocco Belgium Netherlands Brazil Cameroon Canada Poland Portugal Qatar Costa Rica Croatia Denmark Ecuador England France Germany Ghana Iran Japan Saudi Arabia Senegal Serbia South Korea Spain Switzerland Tunisia Uruguay US Wales Task 1: 2. Use Excel to create a frequency bar graph and pie chart for the foreign-born data. Paste your graphs below. 20 points a. Bar Graph b. Pie Chart Task 2: 3. Looking at the Top Finishers tab, examine both variables. Are these variables categorical or numerical? Explain your answer. 10 points 4. Explain how to use a filter (not the two-way table) to count the number of top finishers that were from France AND were First place finishes. 10 points Task 2: 5. Display your two-way table. 10 points Place 1 2 3 Total Western Europe Locat Eastern Europe ion South America North America Total Task 2: 6. Find each proportion: 20 points a. Find the proportion of Western European countries that were Third place finishes. Show your work. Leave your answer as an unsimplified fraction. b. Find the proportion of Second place finishers that were from South America. Show your work. Leave your answer as an unsimplified fraction. Task 2: 7. Use Excel to create a multi-bar graph for the Top Finishers data. Display that graph here. 10 points Acrobat File Edit View Window Help Project 1 Excel Work S... + Create All tools Edit Convert Sign All tools Export a PDF Edit a PDF Request e-signatures NEW Relative Argentina Australia Frequency Frequency Foreign-Born Players in FIFA 2022 Team Poland Croatia Ghana Morocco Canada Fill & Sign A Tunisia Create a PDF De Stylize this PDF NEW Combine files Organize pages Scan & OCR Protect a PDF Belgium Brazil Cameroon Canada Costa Rica Croatia Camaroon Austrialia Portugal France Morocco Wales Qatar Croatia Tunisia Senegal Wales Tunisia Croatia Denmark Ecuador England France Germany Ghana Iran Japan Senegal Redact a PDF Compress a PDF Prepare a form Send for comments Serbia United States Denmark Morocco Ghana Serbia Croatia View more Check out new e-sign tools Use web forms, send in bulk, add branding, and more. See All 58,277 2 A England Wales Spain Portugal Tunisia Costa Rica Tunisia Mexico Austrialia Iran Morocco Austrialia Camaroon Tunisia Senegal 3 FEB 2 7 O O 1 tv N Find text or tools Q W 00 Wed Feb 7 2:48 PM 1 107 76.9% > > C Q Q CILLA- ...CEMEN Acrobat File Edit View Window Help Project 1 Excel Work S... + Create All tools Edit Convert Sign All tools Export a PDF Edit a PDF Request e-signatures NEW Fill & Sign A Create a PDF De Stylize this PDF NEW Combine files Organize pages Scan & OCR Protect a PDF Redact a PDF Compress a PDF Prepare a form Send for comments View more Check out new e-sign tools Use web forms, send in bulk, add branding, and more. See All 58,277 2 A 3 Qatar Qatar Croatia Qatar Qatar Senegal Morocco Japan Canada Senegal Canada Senegal Morocco Ghana Belgium Camaroon United States Camaroon Morocco Spain Poland Camaroon Wales Ghana Wales Switzerland United States Morocco Morocco Austrialia Portugal Senegal France Uruguay Canada Ghana Senegal Tunisia Morocco Switzerland Canada Portugal United States Serbia FEB 2 7 O O 2 Find text or tools Q 00 Wed Feb 7 2:48 PM tv l W 2 107 < > (2 Q Q CILLA- ...CEMEN Acrobat File Edit View Window Help Project 1 Excel Work S... + Create All tools Edit Convert Sign All tools Export a PDF Edit a PDF Tunisia Morocco Germany Tunisia Request e-signatures Wales NEW Camaroon Wales Fill & Sign A Ghana Create a PDF De Qatar Croatia Senegal Stylize this PDF NEW Camaroon Morocco Combine files Austrialia Organize pages Scan & OCR Camaroon Ecuador Qatar Morocco Netherlands Protect a PDF Redact a PDF Compress a PDF Prepare a form Send for comments Germany Austrialia Senegal Qatar Senegal Canada Canada Tunisia Wales Qatar Portugal Ghana View more Check out new e-sign tools Use web forms, send in bulk, add branding, and more. See All 58,277 2 A 3 Portugal Austrialia Tunisia Ecuador Tunisia France Morocco Serbia United States Senegal Austrialia Wales Switzerland FEB 2 7 O O 3 Find text or tools Q 00 Wed Feb 7 2:48 PM tv l W 3 107 < > (2 Q Q CILLA- ...CEMEN Visualizing Frequencies Excel Project 1 A THE UNIVERSITY OF ARIZONA Before you begin... In the Project 1 Excel Work document, filter as necessary to complete the two-way tables found in the two worksheets. The following slides will then ask you to complete various tasks regarding your Excel project. Most slides will require you to annotate the slides. Make sure you show your math computations and answer the questions in complete sentences. Task 1: Class Standing 1. Display your relative frequency table. 10 points Relative Relative Team Argentina Frequency Frequency Team Frequency Frequency Australia Mexico Morocco Belgium Netherlands Brazil Cameroon Canada Poland Portugal Qatar Costa Rica Croatia Denmark Ecuador England France Germany Ghana Iran Japan Saudi Arabia Senegal Serbia South Korea Spain Switzerland Tunisia Uruguay US Wales Task 1: 2. Use Excel to create a frequency bar graph and pie chart for the foreign-born data. Paste your graphs below. 20 points a. Bar Graph b. Pie Chart Task 2: 3. Looking at the Top Finishers tab, examine both variables. Are these variables categorical or numerical? Explain your answer. 10 points 4. Explain how to use a filter (not the two-way table) to count the number of top finishers that were from France AND were First place finishes. 10 points Task 2: 5. Display your two-way table. 10 points Place 1 2 3 Total Western Europe Locat Eastern Europe ion South America North America Total Task 2: 6. Find each proportion: 20 points a. Find the proportion of Western European countries that were Third place finishes. Show your work. Leave your answer as an unsimplified fraction. b. Find the proportion of Second place finishers that were from South America. Show your work. Leave your answer as an unsimplified fraction. Task 2: 7. Use Excel to create a multi-bar graph for the Top Finishers data. Display that graph here. 10 points Acrobat File Edit View Window Help Project 1 Excel Work S... + Create All tools Edit Convert Sign All tools Export a PDF Edit a PDF Request e-signatures NEW Relative Argentina Australia Frequency Frequency Foreign-Born Players in FIFA 2022 Team Poland Croatia Ghana Morocco Canada Fill & Sign A Tunisia Create a PDF De Stylize this PDF NEW Combine files Organize pages Scan & OCR Protect a PDF Belgium Brazil Cameroon Canada Costa Rica Croatia Camaroon Austrialia Portugal France Morocco Wales Qatar Croatia Tunisia Senegal Wales Tunisia Croatia Denmark Ecuador England France Germany Ghana Iran Japan Senegal Redact a PDF Compress a PDF Prepare a form Send for comments Serbia United States Denmark Morocco Ghana Serbia Croatia View more Check out new e-sign tools Use web forms, send in bulk, add branding, and more. See All 58,277 2 A England Wales Spain Portugal Tunisia Costa Rica Tunisia Mexico Austrialia Iran Morocco Austrialia Camaroon Tunisia Senegal 3 FEB 2 7 O O 1 tv N Find text or tools Q W 00 Wed Feb 7 2:48 PM 1 107 76.9% > > C Q Q CILLA- ...CEMEN Acrobat File Edit View Window Help Project 1 Excel Work S... + Create All tools Edit Convert Sign All tools Export a PDF Edit a PDF Request e-signatures NEW Fill & Sign A Create a PDF De Stylize this PDF NEW Combine files Organize pages Scan & OCR Protect a PDF Redact a PDF Compress a PDF Prepare a form Send for comments View more Check out new e-sign tools Use web forms, send in bulk, add branding, and more. See All 58,277 2 A 3 Qatar Qatar Croatia Qatar Qatar Senegal Morocco Japan Canada Senegal Canada Senegal Morocco Ghana Belgium Camaroon United States Camaroon Morocco Spain Poland Camaroon Wales Ghana Wales Switzerland United States Morocco Morocco Austrialia Portugal Senegal France Uruguay Canada Ghana Senegal Tunisia Morocco Switzerland Canada Portugal United States Serbia FEB 2 7 O O 2 Find text or tools Q 00 Wed Feb 7 2:48 PM tv l W 2 107 < > (2 Q Q CILLA- ...CEMEN Acrobat File Edit View Window Help Project 1 Excel Work S... + Create All tools Edit Convert Sign All tools Export a PDF Edit a PDF Tunisia Morocco Germany Tunisia Request e-signatures Wales NEW Camaroon Wales Fill & Sign A Ghana Create a PDF De Qatar Croatia Senegal Stylize this PDF NEW Camaroon Morocco Combine files Austrialia Organize pages Scan & OCR Camaroon Ecuador Qatar Morocco Netherlands Protect a PDF Redact a PDF Compress a PDF Prepare a form Send for comments Germany Austrialia Senegal Qatar Senegal Canada Canada Tunisia Wales Qatar Portugal Ghana View more Check out new e-sign tools Use web forms, send in bulk, add branding, and more. See All 58,277 2 A 3 Portugal Austrialia Tunisia Ecuador Tunisia France Morocco Serbia United States Senegal Austrialia Wales Switzerland FEB 2 7 O O 3 Find text or tools Q 00 Wed Feb 7 2:48 PM tv l W 3 107 < > (2 Q Q CILLA- ...CEMEN