# need theese problems asap

**habg1**

**needs to be done in Excel**

**1.6.** Table 1-2 gives data on the Consumer Price Index (CPI), S&P 500 stock index, and three-month Treasury bill rate for the United States for the years 1980-2007.

- Plot these data with time on the horizontal axis and the three variables on the vertical axis. If you prefer, you may use a separate figure for each variable.
- What relationships do you expect to find between the CPI and the S&P index and between the CPI and the three-month Treasury bill rate? Why?
- For each variable, “eyeball” a regression line for the scattergram.

** 1.7.** Table 1-3 gives you data on the exchange rate between the U.K. pound and the U.S. dollar (number of U.K. pounds per U.S. dollar) as well as the consumer price indexes in the two countries for the period 1985-2007.

- Plot the exchange rate (ER) and the two consumer price indexes against time, measured in years.
- Divide the U.S. CPI by the U.K. CPI and call it the relative price ration (RPR).
- Plot ER against RPR.
- Visually sketch a regression line through the scatterpoints.

** 1.8.** Table 1-4 2010 McGraw-Hill Higher Education, contains data 1247 cars from 2008. Is there a strong relationship between a car’s MPG (miles per gallon) and the number of cylinders it has?

- Create a scatterplot of the combined MPG for the vehicles based on the number of cylinders.
- Sketch a straight line that seems to fit the data.
- What type of relationship is indicated by the plot?

- 7 years ago
- 15

**Answer(0)**

**Bids(1)**

**other Questions(10)**

- Profile essay local community
- ACC260 Week 2 The Enron and WorldCom Scandals
- Challenges of teamwork in a Healthcare workplace
- Finc 355 and 430 week 7
- Identify five different IT systems that have affected business in the past few years (i.e., business software applications, networks, hardware,...
- QuickSort_RecursiveSearch
- Annotated Bibliography Paper
- Fin - Homework
- BUS 640 Week 1 Economics of Risk and Uncertainty Applied Problems
- XMGT 216 Week 4 Assignment Ethical Issues and Management Paper

### Principles of Econometrics

NOT RATED**1.6.**Table 1-2 gives data on the Consumer Price Index (CPI), S&P 500 stock index, and three-month Treasury bill rate for the United States for the years 1980-2007.- Plot these data with time on the …

8 years ago### Data Collection & Probability Distribution - LOOKING FOR SOMEONE WHO UNDERSTAND ECONOMETRICS/EXCEL/SCATTERPLOTS

NOT RATEDComplete problems 1.6, 1.7, and 1.8 and submit to your instructor. Complete your assignment in Excel and submit your completed Excel workbook to your Instructor for grading.

**1.6.**Table 1-2 gives data …8 months ago