At the very least, you can write "Proficient in Excel" on your resume.
The review sheet for the test is here.
Many questions in the world, including questions you will face in your future job, cannot be answered without analyzing some data. In this class, you have learned something about how to answer questions using data. This skill is widely applicable.
At the very least, you can write "Proficient in Excel" on your resume. The review sheet for the test is here.
0 Comments
The next few activities will teach you about using confidence intervals for proportions and means.
We will use the few remaining classes reviewing for the final exam. Go to the Test Schedules page and find the review sheet if you don't have one. Today (Wednesday), we will continue our work with scatterplots, regression lines and correlations.
In the first half of the class, we will do another application about scatterplots, regression lines, and correlations. This application will be based on a dataset of used cars for sale in New Jersey right now. During the second half of the class, you will take a test on these subjects. Good luck! As you know, the semester is almost over. We will only cover one more topic: using statistical inference with sample means and sample proportions. After covering this topic, we will review all of the work we have done so you can be better prepared for the final exam. In the end, I would like all of you to be able to claim some level of expertise in using Excel. You should be able to put the following statement on your resume: "Proficient in Excel." Here are your expectations.
Today, I will introduce you to a dataset that I have constructed which contains information about nations around the world.
We will first become familiar with the data by looking at how various variables are distributed. Next, we will guess at how poor nations differ from rich nations. Enter your expectations here. Finally, we'll test out some relationships to see
Today we looked at data from RateMyProfessors.com about William Paterson faculty. The names were removed from the data file to protect the innocent (and the guilty).
We looked at the distributions of each of the variables. The distribution of the hotness ratings were skewed to the right. The distribution of overall ratings was skewed to the left. Then we looked at the data in order to answer this question: Do easier professors get higher overall ratings? We looked at a crosstab of overall ratings by easiness. We found that the answer appears to be yes. An overwhelming majority (over 70%) of professors who were rated as very easy also got very high overall ratings. Meanwhile, professors who were rated as very difficult were very unlikely to get a very high rating. OK  if people rate their professors partly based on how easy the class was, how do we know who is really a "good teacher"? How do we separate out "good teaching" from simple easiness? Next week, we will look at a method that allows you to do this. For homework, please read pp. 292297 and pp. 300305 about regression. This is the technique we will be using with the RateMyProfessor data. You should know the following for the test:
* percentiles * frequencies * crosstab (how to obtain it and how to interpret it * chisquare test statistic (how to obtain it and how to interpret it.) Complete the following survey to generate data for a demonstration we will do today: Click here to take the survey!
Survey results Quarter quiz 2 coming up next week.. As you may know, we have a test coming up next week, but it won't be very difficult. The test will cover: * Percentiles (What does it mean to say that someone's income is at the 50th percentile or at the 90th percentile? What does it mean to say that someone is at the 50th percentile in terms of height? The 90th percentile in terms of height?) We talked about this last week. * Frequency distributions. Just a table telling you the percentage of cases that are in a particular category of a variable. We talked about these in the past as well but we can go over them further. * Looking for associations between variables with crosstabs. We did this with the assignment looking at gender and college at William Paterson. We will do more of these today. What does it mean to say that one variable is associated with another? * Using the chisquare test with the crosstab. We haven't done this but we will get practice obtaining the chisquare test statistic and interpreting it today. So the test will cover four topics  but the emphasis will be on the last two topics (associations with crosstabs, and chisquare tests.) In order to demonstrate statistical inference, we are going to take a brief, anonymous survey as a class. Click here to take the survey!

Jacob Felson, PhD
Jacob Felson received his doctorate in sociology from Penn State University in December, 2009. He received a master's in sociology from Penn State in 2004, and a bachelor's degree, also in sociology, from the University of Chicago in 2002 Archives
December 2010
Categories 