1 / 16

Engaging Business Students with a T-Shirt Marketing Project Using Excel

Engage students in real-life project using Excel for analysis, survey, Descriptive statistics, Probability. Includes team roles, brainstorming, statistical functions, and hypothesis testing. Student feedback on relatable example. Contact Georgette Nicolaides at georgette.g.nicolaides@gmail.com

gregorykirkland
Download Presentation

Engaging Business Students with a T-Shirt Marketing Project Using Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Engaging Business Students with a T-Shirt Marketing ProjectUsing Excel Georgette Nicolaides eCOTS 2016

  2. Overview • Outcomes • Immediately apply knowledge to real-life project • Mitigate anxiety with familiar topic • Utilize Excel for analysis • Simple market research project connected to future classes

  3. “30,000 foot view”

  4. Team roles • Coordinator • Recorder • Troubleshooter • Reporter

  5. Brainstorming • Individual • Group • Select variables

  6. Variables • At least two quantitative • At least two categorical • A total of at least six variables

  7. Survey and results • Google Forms • At least 50 responses • Clean data

  8. Descriptive statistics

  9. Histograms & charts

  10. Statistical functions

  11. Pivot table

  12. Probability and inference • Probability • Example: What is the probability that over 50% of female students will buy a small t-shirt? • Confidence intervals • Example: Create a 95% confidence interval for the percentage of male students who will purchase a large or extra large t-shirt. • Hypothesis tests – one and two populations • Historically, SU students are willing to spend $15 on a t-shirt. Has this changed? Test at alpha = 0.05. • Consider the proportion of males who wear large or extra large t-shirts. Then, consider the proportion of females who wear large or extra large t-shirts. Create a 95% confidence interval for the difference.

  13. Statistical report outline • Title • Abstract • Introduction • Methods • Results, Conclusions and Recommendations • Appendix

  14. Student feedback • “The most help was when doing the hypothesis testing for the project it helped me understand the information for the test” • “The t-shirt was helpful because it’s a relatable example.” • “…easy to grasp” • “Was good to relate concepts to personal data” • “It forced us to apply the formulas we learned in class to analyze the data”

  15. Contact information Georgette Nicolaides georgette.g.nicolaides@gmail.com www.linkedin.com/in/georgettenicolaides If you would like copies of the handouts, please visit http://georgettenicolaides.wordpress.com/ecots-2016 If you use this, I would like to hear about any improvements you make Thanks!

More Related