*****Show step-by-step in Excel******

An automobile rental company wants to predict the yearly maintenance expense (Y) for an automobile using the number of miles driven during the year ( X1 ) and the age of the car ( X2 , in years) at the beginning of the year. The company has gathered the data on 10 automobiles and the regression information from Excel is presented below. Use this information to answer the following questions.

Summary measures Multiple R 0.9689 R-Square 0.9387 Adj R-Squared 0.9212 StErr of Estimate 72.218

a. Use the information above to write out the estimated linear regression model.

b. Interpret each of the estimated coefficients of the regression model in part (a).

c. Identify and interpret the coefficient of determination ( R2 ) and the adjusted R2 .

d. Does the given set of explanatory variables do a good job of explaining changes in the maintenance costs? Explain why or why not.

For this exercise, round all regression parameters to three decimal places.

Characteristics of traffic flow include density D, which is the number of cars per mile, and average speed s in miles per hour. Traffic system engineers have investigated several methods for relating density to average speed. One study† considered traffic flow in the north tube of the Lincoln Tunnel and fitted an exponential function to observed data. Those data are partially presented in the table below.

(a) Make an approximate exponential model of D as a function of s.
D(s) =

(b) Express using functional notation the density of traffic flow when the average speed is 24 miles per hour.
D

Calculate that density. (Round your answer to the nearest whole number.)
cars/mi

(c) If average speed increases by 1 mile per hour, what can be said about density? (Round your answer to one decimal places.)

The density D decreases by  %.

Consider the following hypothetical natural experiment. The United States imposes a 25% tariff on imported automobiles (cars) in 2020 but does not do so on imported trucks. Canada does not impose such a tariff. In 2020 vehicles (cars+light trucks) in the U. S. (noncommercial) averaged 30 mpg while vehicles in Canada averaged 35 mpg. In 2025 vehicles in the US averaged 35 mpg while vehicles in Canada averaged 45 miles per gallon. Assume (this is a hypothetical natural experiment) that there are no differences between drivers and economic conditions in Canada and the U.S. In an actual analysis of such a situation any observable differences would be addressed using some matching algorithm. a. Using the difference in difference estimator calculate the yearly impact of the tariff on fuel efficiency for all vehicles. b. Assuming that there were 10 million vehicle (car and light truck) sales in the U.S. in 2025 and that each vehicle drives on average 10,000 miles per year, how much more gasoline would be consumed by U. S. drivers in 2025 due to the tariff?

(Show all work for credit) A population is in Hardy-Weinberg equilibrium with two alleles, B and B at a frequency 0.8 (B) and 0.2 (b). Allele B results in blue colored flowers and is dominant to the allele b which results in white flowers.

I. Find the percentages for each genotype for the following generation

II. Calculate the percentage of each phenotype

III. Calculate the allele frequency in the new generation

Suppose in one economy, if people have no disposable income, they still spend 5 million dollars. For every dollar they earn, these people save 0.2 dollars and spend 0.8 dollars. The investment level is 2 million dollars, and government spending is 1 million dollars. The government takes 1 million dollar tax. There is no import or export. What is the output in the goods market equilibrium for this economy? Show your computation

1. The following table shows the data for Canada’s aggregate production function with constant return to scale and the output elasticity with respect to capital equal to 0.3.

a). Find the values of total factor productivity for the given years above.

I only used the Capital output elasticity(0.3) mentioned in the question here even though in my notes it mentions it being 0.7 in Canada

Y= (A)(K^αK*)(N^αN)

A= TFP, Y= GDP, K= Capital, N=Labor αK=Capital output elasticity, αN=Labor output elasticity

A= Y/(K^αK)(N^αN) THEREFORE

TFP(1961)= (264.5)/((525.6)^0.3(6.06)) = 6.65

TFP(1971)= (437.7)/((824.7)^0.3(8.08)) = 7.23

TFP(1981)= (647.3)/((1277.4)^0.3(11.31)) = 6.69

TFP(1991)= (808.1)/((1715.1)^0.3(12.86)) = 6.73

TFP(2001)= (1120.1)/((2071.1)^0.3(14.94)) = 7.59

TFP(2010)= (1325)/((2668.7)^0.3(17.04)) = 7.29

Just want to verify my numbers are correct here before moving forward?

b). Complete the following table by calculating the average annual growth rates (%) for GDP, capital stock, employment, and total factor productivity. While it is not necessary to show all your calculations, show the formulae you use, and also explain and illustrate how you obtain your answers.

1. Lucy always uses an alpha level of 0.01 (two-tailed). Charlie always uses an alpha level of 0.05 (two-tailed). Which researcher is more likely to make a Type I Error. Lucy or charlie?

2. A researcher is interested in whether blood pressure decreases among adults who eat dark chocolate. The mean systolic blood pressure of the population is 135 with a standard deviation of 15. She tests a sample of 100 adults who eat dark chocolate and finds their mean systolic blood pressure to be 120. What is the null hypothesis?

   		μ = 135
   		μ ≠ 135
   		μ  > 135
   		μ ≥ 135

3. According to Cohen's d conventions, which of the following would be considered to be a medium effect size?

   		-0.55
   		0.81
   		-0.98
   		0.17

4. With α = 0.05, what is the critical t value for a one-tailed test with n = 15?

   		t = 1.761
   		t = 1.753
   		t = 2.145
   		t = 2.131

5. What z-score values form the boundaries for the middle 68% of a normal distribution?

   		z = +0.2 and z = - 0.2
   		z = +0.4 and z = - 0.4
   		z = +0.8 and z = - 0.8
   		z = +1.0 and z = - 1.0

1. A disk drive manufacturer sells storage devices with capacities of one terabyte, 500 gigabytes, and 100 gigabytes with probabilities 0.5, 0.3, and 0.2, respectively. The revenues associated with the sales in that year are estimated to be $50 million, $25 million, and $10 million, respectively.

Let X denote the estimated revenue of storage devices during that year. Determine the probability mass function of X, E(X), and Var(X).

Consider the Cobb-Douglas production function ?=??^??^??^? where ?, ?, ?, ? are positive constants and ?+?+?<1. Let ? be the amount of labor, ? the amount of capital, and ? be the amount of other materials used. Let the profit function be defined by ?=?−(??+??+??) where the costs of labor, capital, and other materials are, respectively, ?, ?, and ?.

Determine whether second order conditions for profit maximization hold, when the profit function is defined by ?=?−(30?+20?+10?) with ?=5?^0.3?^0.4?^0.2.

An investor wishes to measure the investment risk presented by an asset which has the following distribution:                   

State   Return   Probability                       

1       10%         0.5                      

2        20%        0.3

3        50%        0.2   

(i) Evaluate any three different measures of investment risk for this asset. Where necessary, you may assume a benchmark return of 25%.     

(ii) State two key properties of Value at Risk (VaR).