This project taught me how use Microsoft Excel for Statistical Analysis. Through Excel, we used functions such as pivot tables and ANOVA to draw conclusions about several sets of data. We also took data and used it to form a visual aid. Statistics was one of my favorite classes because I was able to use math with real world data and make inferences based on patterns and trends.
Statistics Project in Excel
Cost Benefit Analysis
In this project, we learned how to make an entire workbook detailing our costs and our benefits so that we could place them side by side and compare the pros and cons of implementing an SAP system into a company. We looked at this implementation across several different discount rates and used relative and absolute cell referencing so all sheets of the workbook would update automatically, which taught me how to work more efficiently in Excel and save time.
Blue Revolution
Blue Revolution was a large group project in terms of participation and workload. With a team of 6, we had to create a company that would have direct benefits to our local community. This also had to be a specific need that would only fit Dallas. We had to present our proposal to the Chamber of Commerce, represented by our classroom and professor, and the team with the best presentation and proposal was awarded half of their proposed budget. Our take away from this project was that team work and attention to detail are crucial in real world situations. Our execution of these two elements led our team to victory.