# Excel Lab #1 – Organizing and Displaying Data

The most important part of statistics is accurately and effectively communicating the results of a study. For this lab, you will be conducting a statistical study of your choosing and reporting out your results.

Lab Procedure:

• Think of a topic or question that you’re interested in exploring further that can be studied through data.
• As this is a Business Stat course, your question should have clear business applications. And yes, while sports and video games are businesses, looking at touchdown passes or points scored in a favorite game are not business applications. If you choose to study sports, entertainment, video games, etc., it needs to have a focus purely on the business aspect of the field.
• Find a source for your data (or use one of the suggested data source sites listed on Canvas)
• The data must be quantitative and ratio-level (See Chapter 1, section 2)
• You will need between 30 – 60 data values
• You will need to provide a direct link to the source of the data
• Using Excel, perform the following statistical analyses
• Calculate the relevant and necessary descriptive statistics (See Chapter 3, page 87)
• Use Excel to generate a frequency histogram (See Chapter 2, page 52)
• It should be accurate, with the proper number of classes
• All axes should be properly labeled
• See textbook, Canvas for examples of properly formatted histograms
• Write a report that is suitable to be published in a student newspaper or online news site.
• See pages 70-71 in the textbook for a sample statistical report
• The report should be 2 – 3 paragraphs in length
• The audience for your article should be the general public. This is an exercise in creating authentic and professional work, not just outlining steps you did for an assignment. Write this as it was assigned to you by a supervisor at a new job, not an instructor in a stat class.
• As shown in the sample report, yours should include an introduction/background, statistical analysis (both in words and with graphics), and conclusion based on the analysis
• The report should include both a frequency distribution table and the frequency histogram that you created with Excel. (See sample report)
• These figures should be titled, formatted, and appropriately sized (see sample report)
• Please review the Excel Lab Scoring rubric for additional expectations
• To submit, you will upload two files to the Canvas assignment link.
• The Excel file needs to be uploaded as an actual Excel file (.xls or .xlsx, NOT a PDF)
• The written report should be submitted as a .PDF file. For help converting a word document to a PDF, use Google.