**Econ 3790 Lab Homework
# 1
Dr. Usip**

**
Due Date: July 11, Monday. **

Will post MT 1 on Monday (take Home); Due on Tuesday, July 12.

Note: Download/Use the files listed under "Summer
2016 Data files: Dr. Usip"

Question I: Graphical Summarization of Qualitative Data

Download the file 'tvshows.xls' for this question.

In 2004, the top four primetime TV shows were CSI, ER, Everybody loves Raymond,
and Friends. Data in the file indicate the preferred show by a sample of 50
viewers.

1a. Compute the frequency distribution of the **TVshow **variable.

** b**. On the basis of the sample, which TV show had the largest
viewing audience in 2004? Which one was second?

** **

**2a**. Construct a bar chart and label the graph as follows: Title,
horizontal axis, vertical axis, and show the frequencies outside the bars.

b. Use the graph to further justify/explain your answer to part 1b above.

**3a**. Construct a pie chart and label the graph as follows: Title, and show
the frequencies outside the slices.

**b**. Use the pie graph to further justify/explain your answer to
part 1b above.

**
Question 2: Graphical & Numerical Summarization of Quantitative Data**

Download the file 'ncbirths.xls' for this question. Use the age of mothers (agem)
data provided in the __Sheet__ named "agem for HW1".

1a. Use the following class intervals to compute the frequency
distribution of the **agem **variable:

** 15 - 19**

20 - 24

25 - 29

30 - 34

35 - 39

40 - 44

45 - 49

b. How many mothers were 19 years old or younger?

**c.** Most of the mothers were how many years old? Explain/justify your
answer.** **

d. How many mothers were at least 35 years old? Explain/justify your answer.

**2a**. Use the HISTOGRAM command to construct the histogram of the **agem**
an label your graphs as follows: Title, horizontal axis, vertical axis, and show
the frequencies outside the connected bars.

b. Replace the Bin (Upper Limit) values on the horizontal axis with their
corresponding class intervals in 1a above.

c. What type of skewness does the histogram exhibit? Why?

d. What is the practical significance of this type of skewness?
**
**

3. Use the DESCRIPTIVE STATISTICS command to compute the
following summary statistics for the **agem **variable:

a. mean; interpret its meaning.

b. median; interpret its meaning.

c. mode; interpret its meaning.

d. standard deviation

4. From the results in part 3 above,

a. what is the Z-score for the maximum value of the **agem**?

b. what is the Z-score for the minimum value of the **agem**?

c. Based on the Z-scores from 'a' and 'b', does the data contain any
outliers? What is the social significance of your findings**. **

**Top** or Back to **Assignments/What is New**
or **Home page**

**Copyright© 1996, Ebenge Usip, all rights reserved.**

Last revised:
Friday, July 01, 2016.