Econ 203 Lab Session

class: center, middle, inverse, title-slide

# Econ 203 Lab Session
## A taste
### Marcelino Guerra
### January 23, 2020

---

class: inverse, center, middle, clear

# Introduction
---

# About me

<br/>

---

# Making Better Decisions

---

# Grading System
<br/>

<table style="text-align:center">
  <tr>
    <td> <span style="font-weight:bold">Task<span> </td>
    <td> <span style="font-weight:bold">Weight<span>  </td>
    <td> <span style="font-weight:bold">Date/Time<span> </td>
    <td> <span style="font-weight:bold">Location<span> </td>
  </tr>
  <tr>
    <td> Midterm I </td>
    <td>20% </td>
    <td>March 2, 7:00 – 9:00 pm</td>
    <td>Foellinger</td>
  </tr>
  <tr>
    <td> Midterm II  </td>
    <td> 20% </td>
    <td>April 20, 7:00 – 9:00 pm</td>
    <td>Foellinger</td>
  </tr>
  <tr>
    <td> Final </td>
    <td>20% </td>
    <td>TBA</td>
    <td>TBA</td>
  </tr>
  <tr>
    <td> Excel Lab Quiz I </td>
    <td>5%</td>
    <td>March 5-6</td>
    <td>Oregon Lab</td>
  </tr>
    <tr>
    <td> Excel Lab Quiz II </td>
    <td>5%</td>
    <td>April 23-24</td>
    <td>Oregon Lab</td>
  </tr>
   <tr>
    <td> Final Project </td>
    <td>10%</td>
    <td>May 3, 11:45 pm</td>
    <td>Moodle</td>
  </tr>
   <tr>
    <td> Homework </td>
    <td>15% (2 lowest dropped)</td>
    <td>Due 11:45pm the Sunday of that week</td>
    <td>Mindtap</td>
  </tr>
   <tr>
    <td> PLQs </td>
    <td>5% (2 lowest dropped)</td>
    <td> Due 11:45pm the night before lecture </td>
    <td>Mindtap</td>
  </tr>
</table>
---

# Conflict Exams
<br/>
.font120[
If you need to apply for a conflict exam, let me know no later than next week. Students must show proof of conflict and **travel plans are not a valid reason for a conflict**. And, please, **use your university account (@illinois.edu)** for communication.
]

---
class: inverse, center, middle, clear

# Course's Platforms
---

# Course's Platforms

## Get familiar with them!

* [Course Website (Compass2g)](https://compass2g.illinois.edu/)

*	 [Q & A Forum (Piazza)](https://piazza.com/illinois/spring2020/econ203/home)

* Homework system **through compass**

*	[Moodle](https://learn.illinois.edu/)

## Econ 203 for <svg style="height:0.8em;top:.04em;position:relative;fill:steelblue;" viewBox="0 0 581 512"><path d="M581 226.6C581 119.1 450.9 32 290.5 32S0 119.1 0 226.6C0 322.4 103.3 402 239.4 418.1V480h99.1v-61.5c24.3-2.7 47.6-7.4 69.4-13.9L448 480h112l-67.4-113.7c54.5-35.4 88.4-84.9 88.4-139.7zm-466.8 14.5c0-73.5 98.9-133 220.8-133s211.9 40.7 211.9 133c0 50.1-26.5 85-70.3 106.4-2.4-1.6-4.7-2.9-6.4-3.7-10.2-5.2-27.8-10.5-27.8-10.5s86.6-6.4 86.6-92.7-90.6-87.9-90.6-87.9h-199V361c-74.1-21.5-125.2-67.1-125.2-119.9zm225.1 38.3v-55.6c57.8 0 87.8-6.8 87.8 27.3 0 36.5-38.2 28.3-87.8 28.3zm-.9 72.5H365c10.8 0 18.9 11.7 24 19.2-16.1 1.9-33 2.8-50.6 2.9v-22.1z"/></svg>-users

* If you are interested in programming language, all the Excel work is translated to <svg style="height:0.8em;top:.04em;position:relative;fill:steelblue;" viewBox="0 0 581 512"><path d="M581 226.6C581 119.1 450.9 32 290.5 32S0 119.1 0 226.6C0 322.4 103.3 402 239.4 418.1V480h99.1v-61.5c24.3-2.7 47.6-7.4 69.4-13.9L448 480h112l-67.4-113.7c54.5-35.4 88.4-84.9 88.4-139.7zm-466.8 14.5c0-73.5 98.9-133 220.8-133s211.9 40.7 211.9 133c0 50.1-26.5 85-70.3 106.4-2.4-1.6-4.7-2.9-6.4-3.7-10.2-5.2-27.8-10.5-27.8-10.5s86.6-6.4 86.6-92.7-90.6-87.9-90.6-87.9h-199V361c-74.1-21.5-125.2-67.1-125.2-119.9zm225.1 38.3v-55.6c57.8 0 87.8-6.8 87.8 27.3 0 36.5-38.2 28.3-87.8 28.3zm-.9 72.5H365c10.8 0 18.9 11.7 24 19.2-16.1 1.9-33 2.8-50.6 2.9v-22.1z"/></svg> [here](https://github.com/guerramarcelino/Econ203).

*	**Not required whatsoever**. Just for fun!

---
class: inverse, center, middle, clear

# Some Excel Functions <br/> & <br/> Data Analysis Package
---

# Basic Functions

.pull-left[

- **=SUM()** to sum a column or a row of numbers

- **=COUNT()** to count the number of cells

- **=SQRT(x)** returns the square root of x

- **=(x)^2** returns the squared value of x
]
.pull-right[
- **=AVERAGE()** returns the average of the argument

- **=STDEV()** returns the standard deviation of the argument

- **=VAR()** returns the variance of the argument

- **Ctrl+Shitf+down (or right)** to select multiple rows/columns 
]

---
# Installing Data Analysis Package<sup>1</sup>

<br/>

.footnote[
[1] Use the right mouse button to play, pause or save the video.
]
---
# Descriptive Statistics<sup>1</sup>

<br/>

.footnote[
[1] Use the right mouse button to play, pause or save the video.
]
---
# IF() function<sup>1</sup>

<br/>

.footnote[
[1] Use the right mouse button to play, pause or save the video.
]
---
# Histogram<sup>1</sup>

<br/>

.footnote[
[1] Use the right mouse button to play, pause or save the video.
]
---
# Wrapping up!

<br/>

- Take a look at the Excel file attached (lab1.xlsx).

- More information about the IF() function in pages 202-203. It will be important in the future (dummy variables).

- There are great people in room 15, DKH basement, from 10:00 am to 5:00 pm ready to help you.

- **Start the homework before the Lab Session**.

- Ask questions on Piazza.