Using excel with formulars

for binomial random variable X with n=10, p=0.3, plot its pdf and cdf; then simulate from it a sample of size N=2000, plot its histogram (relative frequency), and cumulative frequency.

i. Examine the monetary policies in place at the start of your specific time period in relation to their effects on macroeconomic issues. For instance, consider the discount rate set by the Fed, the rates on reserves, open market operations, and so on for 2000-2010.

A transformer contains four times as many turns in the secondary coil as it does in the primary coil. If the input voltage is 4000 V, what is the output voltage?

1000 V

2000 V

4000 V

8000 V

16000 V

The overall labor force participation rate peaked at 67.1 percent from 1997 to 2000. After the recession of 2001, it started trending downward. In the aftermath of the 2007–09 recession, the overall labor force participation rate dropped sharply and continued its decline, registering at 62.7 percent in 2015. It changed little in 2016, growing by 0.1 percentage point to 62.8 percent. As a result, from its peak in 2000, the labor force participation rate had declined by 4.3 percentage points by 2016.

1. Discuss economic theory related to the quote above. Be sure to include a definition of Labor Force Participation Rate (LFPR) within your discussion.
2. Locate and incorporate outside research that gives evidence and explanation as to the possible causes of these declines in the Labor Force Participation rate.

The data in the accompanying table represent the population of a certain country every 10 years for the years​ 1900-2000. An ecologist is interested in finding an equation that describes the population of the country over time. Complete parts ​(a) through ​(f) below.

Determine the P-value of this hypothesis test.

P-value = __

c) draw a scatter diagram, treating year as the explanatory variable.

d) plot the residuals against the explanatory variable, year.

e) does a linear model seem appropriate based on the scatter diagram and residual plot?

f) what is the moral?

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.)

In 2020 the United States will use some $10 trillion of manufactured goods as measured by the price level as it will be in 2020—producing $9 trillion and paying for the extra $1 trillion by exporting services. Let’s use that as our unit of the quantity of manufactures—$1 worth at 2020 prices is equal to one unit of manufactured goods. And let’s set our index of the price of manufactured goods in 2000 equal to 1.

Suppose the supply curve for manufactured goods has constant-returns-to-scale, with no producer having (much of) an opportunity cost advantage over any other.

Suppose the demand curve for manufactured goods is a straight line linear function such that an increase in the price from its 2000 value of 1 to a value of 2 would lead to a reduction in the quantity demanded by $1 trillion.

What will be the equilibrium price of manufactures in 2020?