MSPE PROGRAM
Econ 506, Fall 2011
Homework 1
Due Friday Sept. 9, 2011 at the beginning of the recitation session
This homework has two parts I & II.
The first part you have to use Excel. In the
second part you have to solve some problems assigned from the textbook. You are
required to do both parts.
I.
Use Excel for the following: You will turn in your completed Excel worksheets.
i)
First sheet
:
Put your name in A1
Generate a sample of 10 observations from the Uniform Distribution between 0 and 10.
Convert them to integers by rounding to zero decimal places. Set up a table with six
columns. Compute a table with cols:
Y
Y
2
y=Y
Y
y
2
y
3
y
4
Find the sum of each column
Find the mean of your sample (
Y
).
Find the sample variance in two ways:
using y
2
and using Y
2
.
Find the sample standard deviation (s).
Find Sk = Sum y
3
/n/s
3
and Kur = Sum y
4
/n/s
4
(These will not be the same as calculated by Excel because of the small sample
correction.)
Also find each of these values using the Excel functions.
ii)
Second sheet
:
Put your name in
A1
Put your
UIN
in
A2
Put the last digit of your UIN in
A3
unless it is zero.
In that case, put the last nonzero
value in
A3
.
Call this value
z
for what follows.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '08
 Staff
 Standard Deviation, Variance, Mean, Sample standard deviation

Click to edit the document details