{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# hw1 - MSPE PROGRAM Econ 506 Fall 2011 Homework 1 Due Friday...

This preview shows pages 1–2. Sign up to view the full content.

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 non-zero 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.

{[ snackBarMessage ]}

### Page1 / 3

hw1 - MSPE PROGRAM Econ 506 Fall 2011 Homework 1 Due Friday...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online