Course Orientation
1/12/23
Tell us about yourself
email: robert_b@payap.ac.th
Office: PC314 (Office hrs by appointment)
Cellox Bath Tissue
Product name | Rolls | Price |
---|---|---|
Family Jumbo | 32 | 299 Baht |
Family size | 30 + 2 free | 254 baht |
Family budget | 24 + 6 free | 249 baht |
Which is most economical?
Product name | Rolls | Length | Price |
---|---|---|---|
Family Jumbo | 32 | 937m | 299 Baht |
Family size | 32 | 665m | 254 baht |
Family budget | 30 | 531m | 249 baht |
Product name | Rolls | Length | Price | Price /roll | Price /m |
---|---|---|---|---|---|
Family Jumbo | 32 | 937m | 299 baht | 9.34 | 0.32 |
Family Size | 32 | 665m | 254 baht | 7.94 | 0.38 |
Family Budget | 30 | 531m | 249 baht | 8.30 | 0.46 |
An example for group discussion
Goal: develop a fire evacuation plan to rally in front of the school in minimal time
500 primary students in the school
Exit | Exit rates | Distance to the rally point | Mean time to door |
---|---|---|---|
Front door | 60 per min | 20 m | 10 sec |
Side door | 20 per min | 80 m | 20 sec |
Back door | 30 per min | 120 m | 10 sec |
\[\eqalign{ t_f &= 10 + \frac{60F}{60} +20 &= 30 + F\\ t_s &= 20 + \frac{60S}{20} +80 &= 100 + 3S\\ t_b &= 10 + \frac{60B}{30} +120 &= 130 + 2B\\ \\ t_f &= t_s = t_b\\ 500 &= F + S + B\\ }\]
\[\eqalign{ 30 + F &= 100 + 3S\\ \color{red}{-100} + 30 + F &= 100 + 3S + \color{red}{-100}\\ \color{red}{\frac{1}{3}}\times(-70 + F) &= 3S\times\color{red}{\frac{1}{3}}\\ \frac{F - 70}{3} &= S\\ }\]
\[\eqalign{ 30 + F &= 130 + 2B\\ \color{red}{-130} + 30 + F &= 130 + 2B+ \color{red}{-130}\\ \color{red}{-130} \times \left(-100 + F\right) &= 2B\times\color{red}{\frac{1}{2}}\\ \frac{F - 100}{2} &= B\\ }\]
\[\eqalign{ 500 &= F + S + B\\ \color{red}{6}\times 500 &= \left(F + \frac{F - 70}{3} + \frac{F - 100}{2}\right)\times\color{red}{6}\\ 3000 &= 6F + \frac{6(F - 70)}{3} + \frac{6(F - 100)}{2}\\ 3000 &= 6F + 2(F - 70) + 3(F - 100)\\ 3000 &= 6F + 2F - 140 + 3F -300\\ \color{red}{440} + 3000 &= (6+5)F - 440+\color{red}{440}\\ \color{red}{\frac{1}{11}}\times 3440 &= 11F\times\color{red}{\frac{1}{11}}\\ 312.7 &= F\\}\]
\[\eqalign{ F &= 312.7\\ S &= \frac{T_f - 70}{3} &= \frac{312.7-70}{3} &= \frac{242.7}{3} &= 80.9\\ B &= \frac{T_f - 100}{2} &= \frac{312.7-100}{3} &= \frac{212.7}{2} &= 106.35\\}\]
\[total = 313+ 81 +106 = 500\]
\[t_s = 30 + F = 343\ sec = 5 min,\ 43\ sec\]
\[time = t_{delay} + t_{doorway} + t_{walkaway}\]
\[time_{front} = 10 + 500 + 20 = 530\ secs\] \[time_{side} = 20 + 1500 + 80 = 1600\ secs\]
\[time_{back} = 20 + 1000 + 120 = 1140\ secs\]
Front Door | Side Door | Back Door | Total | Target | ||
---|---|---|---|---|---|---|
Exit Rate | 1 | 3 | 2 | |||
Delay | 10 | 20 | 10 | |||
Transit Time | 10 | 80 | 120 | |||
Exit time | 0 | 0 | 0 | |||
Fixed time | 0 | 0 | 0 | |||
Total time | 0 | 0 | 0 | 0 | (max) | |
Number of students | 0 | 0 | 0 | 0 | = | 500 |
Front Door | Side Door | Back Door | Total | Target | ||
---|---|---|---|---|---|---|
Exit Rate | 1 | 3 | 2 | |||
Delay | 10 | 20 | 10 | |||
Transit Time | 10 | 80 | 120 | |||
Exit time | 317 | 237 | 208 | |||
Fixed time | 20 | 100 | 130 | |||
Total time | 338 | 337 | 338 | 338 | (max) | |
Number of students | 318 | 78 | 104 | 500 | = | 500 |
Information-based decision making: data analysis and statistical analysis to support decision making, use of logic analysis and application to solve everyday problems in real life.
Identify the key issues of related to a decision
Acquire data related to the key issues and develop it as an accurate dataset
Apply appropriate data processes leading to statistically sound insights
Apply numerical and data analytics, reasoning and logic to prioritize possible solutions
Apply systematic thinking and reasoning to solve problems.
Develop collaboration and cooperation teamwork skills to deliver quality results on time.
Hadley Wickham, Garrett Grolemund, 2017. R for Data Science: Import, tidy, transform, visualize and model data. O’Reilly Media
Eric Denardo, 2005. The Science of Decision Making: A Problem-based approach using Excel. John Wiley
Barbara Illowsky, Susan Dean, 2022. Introduction to Statistics. Open Stax Foundation.3rd edition. https://openstax.org/details/books/introductory-statistics
Batzinger, 2023. Slides and Activity Worksheet Sheets for GE193
WorldData.AI,2022. World Data curated datasets for AI and data science. http://worlddata.ai
Kaggle, 2022. Kaggle datasets. https://www.kaggle.com
Douglas C. Montgomery, 2017. Design and Analysis of Experiments. John Wiley & Sons, 9th edition.
Nathan Taback, 2022. Design and Analysis of Experiments and Observational Studies Using R. CRC Press
Software (Cost) | Key selling point | Documentation |
---|---|---|
RStudio with R (freeware) | Data, statistical functions, graphing, and project documentation in 1 file | A powerful programming language that supports all aspects of data analytics, including AI and project report writing |
LibreOffice Spreadsheet (freeware) Spreadsheeet app of LibreOffice | Cell by cell processing; nice graphics and Solver/Data function preinstalled; | Project reports and documentation will need to be written in separate application; good graphics |
MS Excel (US$160 , w Office US$350, free online and for students) | Spreadsheet component of MS Office; Adequate but limited graphics | Solver and Data functions require installed add-on (not available in free online version); Project reports require MS Word; Product is revised every 2 years; Obsolete in 6 yrs |
Google Spreadsheet (freeware) | Spreadsheet component of Google Docs; Supports collaboration | No solver and limited Data analytics; Project Graphics and documentation requires a separate application |