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

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

View Full Document Right Arrow Icon
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. Find a sample of 100 observations from the Uniform Distribution between 0 and 1.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/27/2012 for the course ECON 506 taught by Professor Staff during the Spring '08 term at University of Illinois, Urbana Champaign.

Page1 / 3

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

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online