Assignment I for EC 233
(due by Tuesday, 23 October 2018 at 23:55)
•This assignment is to be completed by teams of one, two or three students.
•You will use the data we gathered in the class questionnaire to answer the questions. The
Excel file with the data will be available on Moodle.
•The answers must be typed in the spaces below between the questions, not handwritten.
Insert any charts/graphic objects here, too. You can adjust the amount of space between the
questions to fit your answers. Do not attach Excel or other printouts or hand-written material. You
must only submit the Word document, and in Word format, to Moodle.
•Moodle has a 1MB size limit for students uploads (such as assignments). In order to
reduce file size, you can use the "Reduce File Size" in the File menu Word.
•E-mailed assignments will not be accepted. You must upload your assignment to Moodle.
It is sufficient for one person to upload the answers for each team.
•You can use Excel, R or other statistical packages to find the answers. Please consult the
graphical methods section in your book and other extra material for help. The graduate assistant for
the course, Melikşah Demirtaş, will answer your questions on R in a PS session on 19 October
Friday, 15:00 at NB Z12.
•You may want to use “Data Analysis” under the “Data” tab in Excel. You can use the
“Histogram” and “Descriptive Statistics” options here. If “Data Analysis” does not appear under
the “Data” tab, use Excel “Add-ins” under “Options” to install it using “Analysis ToolPak”. If you
are using Mac, this option may not be available. You can install StatPlus instead. For descriptive
statistics simple commands like AVERAGE() are sufficient, though. Also, note that Excel has
different variance (and standard deviation) formulae for samples (VAR.S ()) and for populations
(VAR.P()). “Descriptive Statistics” may not yield the variance/standard deviation you need.
•Carry out the necessary calculations and report the final results (so write 4 instead of
2x2).
•Use 6 decimal places.
Questionnaire Questions
1. What is the month of your birth?
2. How many movies did you see during the last seven days?
3. How much time (in hours per week e.g. 1.5 hours for 90 minutes or 0.75 hours for 45 minutes)
did you spend studying during the last seven days?
4. Was Boğaziçi University's Economics department your first choice in the university entrance
exam?
G. G. AkinEC 233Fall 2018
4
