Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
According to OSU's official finals schedule the final exam for this class is Thursday, Dec 12. at 2:00.
Here is the study guide for the final exam.
Here are the data you will use for the final.
Today's Class—
No class. I will come to the lab at class time to see if anyone has any questions. You are welcome to see me anytime in my office.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
I have updated the grades, and thus far 60% of you have A's. Good job!
According to OSU's official finals schedule the final exam for this class is Thursday, Dec 12. at 2:00. It is non-cumulative, and no longer than tradiational finals. I will have a study guide on Thursday.
Today's Class—
Continue studying (CN.4) Regression by taking notes on regression applied to the wine data in this spreadsheet: http://seeds.okstate.edu/Seedsppp/cn,3/(cn,3)QuestionsData.xlsx
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
No class on November 26, because I'm more popular if I do that kind of thing. Have a nice Thanksgiving.
For the remainder of class we will be studying a single, new article: (CN.4) Regression
Today's Class—
Begin studying (CN.4) Regression by completing this worksheet.
There are two data-sets for today. The softball data are here and the basketball data are here.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades HAVE BEEN UPDATED and can be viewed here.
Announcements—
Homework 10 is due by the beginning of class on November 21, and is completed in Google forms (electronic submission only, no hard copy to submit).
Today's Class—
Today we should finish discussing the content in chapter (CN.3) Correlation (also causation?)
Be prepared to take notes.
There are no data for today.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades HAVE BEEN UPDATED and can be viewed here.
Announcements—
Homework 9 is due by the beginning of class on November 19, and is completed in Google forms (electronic submission only, no hard copy to submit).
Today's Class—
Today we will continue taking notes on chapter (CN.3) Correlation (also causation?), using the data at http://seeds.okstate.edu/Seedsppp/cn,3/(cn,3)QuestionsData.xlsx, paying particular attention to section F.
At the last 20 minutes of class students who missed questions 5-9 on Exam 2 can take a similar set of questions to potentially regain half the points they missed.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades HAVE BEEN UPDATED and can be viewed here.
Announcements—
Homework 8 was merely your participation in last week's projects. If you missed only one class you received a 50, and if you missed both you recieved a 0. Everyone else received a 100. If you didn't make a 100 you can listen to a Freakonomics or Planet Money podcast, write a 500 word summary of the podcast (making sure it is obvious you listened to the whole thing), and briefly describe it orally to your classmates. If you missed two classes you must do two of these if you want a 100. Please let me know which podcast episode you wish to listen to before you do it, so that no two students listen to the same one.
Exam 2 answer key is here
Homework 9 is due by the beginning of class on November 19, and is completed in Google forms (electronic submission only, no hard copy to submit).
Today's Class—
Today we will take notes on chapter (CN.3) Correlation (also causation?), and we will use the data at http://seeds.okstate.edu/Seedsppp/cn,3/(cn,3)QuestionsData.xlsx
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
I will hand back Exam 2, and the grades have been entered, but I haven't finished checking all the grades in the link above, including the "final grade thus far" category. You are welcome to begin checking Exam 2, but wait to ask questions about all the grades posted on the spreadsheet. If you feel you deserve partial credit for a question you can submit to me in hard copy a typed explanation of (a) the question (b) why you feel you deserve partial credit and (c) your original test. I will then consider awarding partial credit, but no guarantees. Partial credit will only be considered for those questions involving Excel (not short answer questions).
Today, all guys should go to AGH 412 at the normal time. Girls should not come to class until 3:45, and should come straight to AGH 412.
Today's Class—
Project to be revealed in class.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
Sorry. The tests are not graded yet.
Today I will split the guys and girls for different tasks. Girls will stay in the lab and guys (after we chat a little in the lab) will go to AGH 412 for the rest of class.
On Thursday, all guys should go to AGH 412 at the normal time. Girls should not come to class until 3:45, and should come straight to AGH 412.
Hope you didn't forget that the class project should be uploaded to YouTube by 3:30 today, and you should email me the link to your video.
Today's Class—
Jordan Wright, without an once of trepidation in her bones, will begin class today.
Need volunteer to begin class on November 12.
The projects done in class this week will count for one medium homework grade.
Students, there was a problem in the original data I posted for exam 2: the ID numbers for the egg data (where you are asked to use the VLOOKUP formula) change every time you hit ENTER. I have corrected this problem and have uploaded a corrected data-set here.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
Please check out the new, and hopefully temporary Impression grade. This is what will happen if students do not volunteer to begin class.
Homework 7 is due at the beginning of class today.
If you are in class all this week you will receive a 100 on Homework 8. Others will have to turn in the completed worksheets that we did in class, but wait until after Exam 2 (you will need it to study).
I am postponing the exam until Thursday, October 31.
A study guide is available here
and the data for the exam can be downloaded
here
corrected data can be downloaded here
I will not take attendance in class on Tuesday but I will come to aid anyone who needs help studying for the exam (I won't be giving away information about what's on the test though).
Today's Class—
Sam Baseley will begin class today.
Need volunteer to begin class on October 31.
Today we will finish this worksheet which uses these data.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
Announcements—
Homework 7 is due at the beginning of class on October 24.
I will let today's worksheet on sampling count as Homework 8, so make sure you fill it all out (or as much of the sheet as we cover today). This will count as a medium homework.
With your consent, Exam 2 on CN.2 and TAN.3 will be held Tuesday, October 29. Study guide will be available Thursday.
Today's Class—
Paige Riolo will begin class
Need volunteer to begin next class.
Today we will complete this worksheet using these data.
Today we will complete this worksheet, which will count as Homework 8 (medium homework) and uses these data.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades can be viewed here.
[Regarding his first consulting job]…[My boss] gave me a big stack of data…[and said]…we need to figure out how to help them get their drugs approved faster…I turned to him and said, so what do you want me to do? And he said we are not paying you all this money for me to tell you what to do. You’re just supposed to figure it out. Of all the things I learned [in consulting] that was one of the most important: that you actually are supposed to think…If you reflect back [to college] we never ask kids to really think. The secret to getting good grades in college is to memorize a bunch of stuff. The idea that now I had to have an original thought was shocking.
—Levitt, Steven (interviewee). November 21, 2012. “I Consult, Therefore I Am.” Freakonomics [podcast]. Stephen Dubner [interviewer]. National Public Radio.
Announcements—
Homework 7 is due at the beginning of class on October 24.
I haven't received the survey from Newby or Gulick yet (see October 8 announcements.)
The deadline for the Creative Project: upload presentation to YouTube by 3:30 PM on November 5.
I have added Homework 6 grades, as well as your answers and my answer key. You can challenge me on my answer key and we can discuss the homework, if you like.
Today's Class—
Kurt Gulick will begin class
Need volunteer to begin next class.
After this, I will ask each person to take this survey and tell me if you see any problems. If it looks okay we will have other people take it also and analyze the results.
Will continue working on this worksheet. Either open your saved spreadsheet from last class or use this one
Then we will complete this worksheet using these data.
And then we will complete this worksheet using these data.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades have been updated at here, which includes your grade thus far in class and your Exam 1 grade.
Announcements—
Homework 6, to be completed on Google Forms, is due by the beginning of class on Tuesday, October 15. If you have trouble be sure to watch Video 1 at http://seedsppp.blogspot.com/2012/07/ada4-averages-and-pivot-tables.html.
No class Thursday (enjoy your Fall Break). However, know that you are responsible for everything in chapter CN,1 and must turn Homework 6 in by October 15.
I want Newby, Avery, and Gulick each to use Google Forms to make a survey asking students which class they have taken thus far was the worst course, and why. Send the link to the survey to me when you are done. Please do this by October 15 class.
Today's Class—
Need volunteer to begin next class.
Today we will work on learning the VLOOKUP function and Pivot-Tables in Excel, following the chapter (CN.2) Averages, Pivot-Tables, and the Vlookup function.
We will only review this chapter in this class, and it will be on the test, so please take it seriously.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
Your grades have been updated at here, which includes your grade thus far in class and your Exam 1 grade. These are tentative grades, as I haven't double-checked them.
Announcements—
Today we will begin create a data set on students' ability to successfully shoot basketballs. These data will be used to teach how to use Google Forms, how to manage data, and the material in (CN.2) Averages and pivot-tables.Today's Class—
Need volunteer to begin next class.
Hand back Exam 1 and discuss.
Data on basketball-shooting performances in this class and a previous year should be opened at this link.
Notice that we are missing data on the individual shooters for this class. We will create a survey to gather said data.The class will work together on this survey using the public Google form here. Please have this form opened.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
Part 1 of Exam 1 to be given Thursday.
See September 12 announcements regarding Exam 1.
Today's Class—
No class. No taking attendance. I will simply come to class and give aid to anyone who wants help.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
Homework 4 has been given a preliminary grade and will be given back today. We will discuss. An answer key can be downloaded here.
No class Sept 24. I will come during class time to help anyone needing help. You will not penalized if you don't come.
See September 12 announcements regarding Exam 1.
Today's Class—
Cordell Lloyd will begin class.
We need a volunteer to begin the next class.
Take up Homework 5.
Begin working on a survey to measure reliance on meat as part of a low-carb diet.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
Homework 3 has been graded and will be given back today.
Homework 4 is due by 9:00 PM on September 17.
Homework 5 (a small homework) is due September 19 at the beginning of class.
No class Sept 24. I will come during class time to help anyone needing help. You will not penalized if you don't come.
See September 12 announcements regarding Exam 1.
Today's Class—
Welcome guest speaker Aaron Hoerst, a former student and Koch employee.
Cordell Lloyd will begin class.
We need a volunteer to begin the next class.
Give back Homework 3.
Complete this worksheet using these data, where we repeat the exercise from Sept 12 using real data and Excel Solver.
Begin working on a survey to measure reliance on meat as part of a low-carb diet.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
Homework 4 is due by 9:00 PM on September 17.
Homework 5 (a small homework) is due September 19 at the beginning of class.
No class Sept 24. I will come during class time to help anyone needing help. You will not penalized if you don't come.
Exam 1 will be given in two parts. Part 1 will be given on September 26, and will very closely resemble Sample Exam 1, Part 1.
Part 2 will be given on October 1, and will very closely resemble Sample Exam 1, Part 2.
Let me know if you cannot access the Google form at the link: https://docs.google.com/forms/d/1HpezIHj8s-8XgWmqv-Z9FplnNFCpb13nGyHUDC9fR0M/edit?usp=sharing
Today's Class—
Jacob Rapstine will begin class.
We need a volunteer to begin the next class.
Complete this worksheet where we calculate what premium a business should charge for Guaranteed Tender steaks.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
Homework 2 grades are available at the link above. This sheet allows you to view your answers along with the answer key, using your ID number.
Please go ahead and login to your gmail account.
Homework 3 is due at the beginning of class on September 12. This homework requires you to learn about a very complex topic and communicate it clearly. That is not easy, and I do not expect perfect answers. Just try your best.
Homework 4 is due by 9:00 PM on September 17.
Could Courtney Acton and Kaitlin Arnold see me after class? (you're not in trouble)
Today's Class—
Guy Stuhr will begin class today.
Jacob Rapstine will begin next week's class.
Activity 1: The answer to the worksheet Gulf Wheat Prices, Part B from Thursday's class is in this spreadsheet. We will discuss the answer but will not construct the histogram together.
Activity 2: Begin completing this worksheet on crop insurance.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
The Fall 2013 Career Fair is Tuesday, Sept 24, 12:30-5:00 PM.
Go ahead and add the "Data Analysis" toolbox. File, Options, Add-Ins, Analysis Toolpak, Go
Homework 3 is due at the beginning of class on September 12. This homework requires you to learn about a very complex topic and communicate it clearly. That is not easy, and I do not expect perfect answers. Just try your best.
The deadline for the Creative Project: upload presentation to YouTube by 3:30 PM on November 5.
Today's Class—
Courtney Acton will begin class.
Ask for volunteers to begin next week's class.
Talk about former student Caitlin Harris and the importance of good graphs.
Open your saved spreadsheet from last class.
Finish this worksheet by polishing our histogram. If you were not in class on Tuesday or lost your spreadsheet, use this one.
Then we will begin this worksheet which uses these data.
Permanent Links—
View all deadlines at the AGEC 4213 Calendar.
View grades as I am recording them (by your class ID number) here.
Announcements—
Homework 2 is a medium homework, counting twice as much as a short homework, and is due September 5 at the beginning of class.
The deadline for the Creative Project: upload presentation to YouTube by 3:30 PM on November 5.
Today's Class—
For now on I will ask for volunteers to begin the next class at the beginning of the current class.
All this week we will be learning how to manage and manipulate data, using important Excel function like IF and AND statements, creating attractive charts, and creating historical simulations. These exercises are designed to reinforce basic Excel tools that people use daily at work, and to refine our understanding of histograms and simulations.
First we will complete this worksheet which uses these data.
If we have time we will then begin this worksheet which uses these data.
Announcements—
Homework 2 is a medium homework, counting twice as much as a short homework, and is due September 5 at the beginning of class. It will be taken using Google Forms, something I am experimenting with, so please let me know if you run into any problems. This homework requires you to read sections (A.1) through (A.3) of (CN.1) Histograms and VaR.
Today's Class—
Open your spreadsheet from last class (if you have it) and also open this spreadsheet
Today we finish the worksheet from last class.
Then we will begin working on this worksheet concerning Value-at-Risk (VaR) and the 2008 financial crisis.
Announcements—
The following students did not complete the student information sheet, it appears, and needs to do so immediately: Spencer Lawrence, Bailey Garland.
I am very disappointed in students who only listed 3 or 4 survey items on part B of the class worksheet on August 22. That is evidence of someone who wants to do only the bare minimum, and thus I would not trust any data they collected or data analysis they performed. Do better and show you are worthy of trust.
Homework 1 is due August 29 at the beginning of class.
Today you will be given an ID number to be used specifically for this class. Keep this stored somewhere you can access any time (like your smartphone). I will be asking you to use it occasionally, and with no advanced warning.
Homework 2 is a medium homework, counting twice as much as a short homework, and is due September 5 at the beginning of class. It will be taken using Google Forms, something I am experimenting with, so please let me know if you run into any problems. This homework requires you to read sections (A.1) through (A.3) of (CN.1) Histograms and VaR.
Today's Class—
At the beginning of every class you should check these announcements and download the data for today, saving the spreadsheet on a drive or stick you can access later.
Today we will complete this worksheet using these data.
See if you are able to download data at this link
Announcements for Students
August 22
Announcements—
If you recently added the class make sure you consult the announcements on August 20 and complete the Student Information Sheet.
Homework 1 is due August 29 at the beginning of class.
Today's Class—
Today we are meeting at the Colvin Annex to complete this worksheet.
Announcements for Students
August 20
Announcements—
For next class (on August 22) we will meet at the Colvin Annex. I repeat, do not come to AGH 266 on this day, but the Colvin Annex instead (located by the Colvin Center on Farm Road, next to the tennis courts). Each student will attempt a number of basketball shots and we will record the percent made. Later we will crunch the numbers on these shots to study what determines shooting ability. It is especially important that everyone attend this day and shoot, as we need data on people who are not experienced or are poor at shooting. This activity is mandatory. If you miss this class you must make it up by going to the gym outside of class with my assistant to perform the activity.
Before class on August 22, acquire a gmail address and complete this Student Information Sheet sheet online.
Homework 1 is due August 29 at the beginning of class.
Today's Class—
We will discuss the class syllabus posted online at the class website. Any changes to the syllabus will be made in red font.
Why we study supply and demand: Meet Lindsey Kuzma
Lindsey Kuzma is a market analyst specializing in the market for base oil, which I think is a by-product of oil refineries. Koch knew what they were doing when they hired her. I didn't know her as an undergrad but I have seen her performance and wish she had taken my classes! She spends most all of her time in Excel, studying base oil prices, with a particular emphasis on long-term fundamentals. Each week, she participates in a supply and demand meeting where they discuss the supply and demand of base oil. She is expected to understand the big picture of the base oil market, where the market is heading, and must communicate this understanding to others clearly—that is her job! So when teaching supply and demand, and you feel the need to motivate its importance, simply introduce the students to Lindsey Kuzma!
