1. The table below gives the annual total returns on Global Balanced Index Fund from 1999 to 2008. The returns are in the local currency. Use the information in this table to answer the following questions:

a. Calculate the mean absolute deviation (MAD).

2. Calculate the variance.

3. Calculate the standard deviation.

d. Calculate the semi variance (the average squared deviation below the mean), a measure of downward risk.

On October 17, 2007, the classified ads on the web site of The Seattle Times listed the following 13 used Toyota Prius automobiles for sale; the data set below shows the year, color, mileage (in miles) and asking price (in U.S. dollars) for each car:

year     color      mileage     price
2006     green        17043     25995
2007     gray         12628     24980
2005     maroon       24039     24885
2005     silver       48226     23995
2006     black        10522     22995
2004     silver       66345     21995
2007     white         5611     21995
2005     gold         24479     21595
2004     white        14618     20995
2005     silver       53699     20980
2004     silver       47649     17995
2003     white        39600     17500
2005     black       103126     16995

We wish to investigate a possible association between the mileageof each Prius and its price. You should construct a scatterplot of this data.

assume that a linear model is appropriate, regardless of your answer to the previous question.

1. Find the equation of the regression line for this data that predicts price based upon mileage:

2. Use the model to predict the asking price of a Toyota Prius with 450,000 miles, or explain why such a prediction is not appropriate:

3. Use the model to predict the asking price of a Toyota Prius with 45,000 miles, or explain why such a prediction is not appropriate:

4. Compute the residual for the green Prius:

Let’s examine the history of LSUS undergraduate enrollment vs. its tuition and fees. Download the “A3Q1 LSUS enrollment data” Excel file (in CSV format if you don’t have Excel); in it you will see historical information on LSUS undergraduate enrollment, total credit hour production, and tuition and fees. (If you wish, you can verify or look up additional information here, here, and here.)

Calculate annual elasticities for both types of quantity variables (i.e., you will have an elasticity of price vs. headcount, and one of price vs. credit hour). You will get an error message in your calculations when the tuition doesn't change from 2006-2007 and 2016-2017, since the elasticity calculation will be trying to divide by zero; just delete those error values in your Excel table so that the cells are blank. The first headcount elasticity will be calculated based on the 2004 and 2005 values of tuition and headcount and should be about 0.159; the first credit hour elasticity will also be based on the 2004 and 2005 values and should be about -0.348). Calculate the average annual elasticity for headcount (from 2004-2017), and the average annual elasticity for credit hour (from 2004-2017).

Many administrators argue that, to increase revenue to LSUS to cover budget shortfalls, tuition should be raised. Comment on this suggestion, using the evidence you’ve uncovered.

Linear    yt = _______ xt + __________

Quadratic yt = ______ xt^2 + ___________ xt + __________

Exponential yt = __________e-------x

Use each pf the three fitted trend equations to make numerical forecasts for the next 3 years.

using chapter 13 data set 2, the researchers want to find out whether there is a difference among the graduation rates (and these are percentages) of five high schools over a 10-year period. Is there? (hint: are the years a factor?)

Packard Company began operations on 1/1/04. For its second year of operations, 2005, it has the following activity:

In addition to the foregoing, Packard received $25,000 of rents in 2005 of which $15,000 remained unearned as of December 31, 2005. It is anticipated that the remaining amount will be earned in 2006.

The enacted tax rate for 2004 is 40%, and 30% for 2005. For 2006 and all future years, it is 35%. Management has also determined that it is probable that 20 percent of all deferred tax assets will not be realized in the foreseeable future. As of December 31, 2004, there was a temporary difference in depreciation that resulted in future taxable amounts of $23,000. This temporary difference will reverse in 2005. (Note: As of 12/31/2004, the 40% enacted tax rate was the only tax rate that was enacted. The 30% rate and 35% rates were not enacted until after 12/31/2004).

Based on the foregoing, what is the net income of Packard for the year ended December 31, 2005?

The table below gives the annual total returns on Global Balanced Index Fund from 1999 to 2008. The returns are in the local currency. Use the information in this table to answer the following questions:

1. (5.0 pts) Calculate the mean absolute deviation (MAD).

2. (4.0 pts) Calculate the variance.

Solution

3. (2.0 pts) Calculate the standard deviation.

Solution

3. (4.0 pts) Calculate the semi variance (the average squared deviation below the mean), a measure of downward risk.

Solution:

The year-end net income (in millions) for a company for the years 2004-2015 are shown in the provided data set (incomedata.xlsx). Graph the best chart which effectively displays the income data over time.

Income Data:

1. In an imaginary economy, consumers buy only hot dogs and hamburgers. The fixed basket consists of 15 hot dogs and 8 hamburgers. A hot dog cost $2.25 in 2006 and $5.40 in 2007. A hamburger cost $5.75 in 2006 and $7.86 in 2007. Calculate the CPI for both years and then find the inflation rate.

2. In an imaginary economy, consumers buy only sandwiches and magazines. The fixed basket consists of 25 sandwiches and 40 magazines. In 2006, a sandwich cost $4.50 and a magazine cost $3.99. In 2007, a sandwich cost $5.75. If the inflation rate in 2007 was 21 percent, then how much did a magazine cost in 2007?

3. When Anders took out his first two-year membership with Maxima Gym in 2004, the fee was $525.00. He renewed his membership three times; in 2006 for $580.00, in 2008, for $600.00, and again in 2010, for $699.00. What is the OVERALL rate of inflation for Anders' gym membership?

4. In 1949, Sycamore, Illinois built a hospital for about $500,000. In 1987, the county restored the courthouse for about $2.4 million. A price index for nonresidential construction was 12 in 1949, 96 in 1987, and 117.5 in 2000. Calculate the value of the courthouse in 2000 dollars and the value of the hospital in 2000 dollars and compare your answers. Which one cost more?

5. Ruben earned a salary of $60,000 in 2001 and $80,000 in 2006. The consumer price index was 156 in 2001 and 227.25 in 2006. What is Ruben's 2006 salary in 2001 dollars? What does this mean about how his purchasing power increased or decreased?

2. The accompanying data table show the percentage of tax returns filed electronically in a city from 2000 to 2009. Complete the parts below.

Year   Percentage
2000   27
2001   29
2002   35
2003   42
2004   45
2005   49
2006   55
2007   59
2008   61
2009   67

​b) Calculate the MAD for the forecast in part a. ​(Round to two decimal places as​ needed.)

​d) Calculate the MAD for the forecast in part c (Round to two decimal places as​ needed.)