Balance of Payments for the U.S. Transaction Amount U.S. goods exports +$100 U.S. goods imports -$80 U.S. services exports +40 U.S. services imports -90 Net investment income +20 Net transfers -15 Foreign purchases of assets in U.S. +30 U.S. purchases of foreign assets abroad -10 Balance on capital account +5 Refer to the above data. The United States has a balance of goods:

Predictive Analytics using Tableau Create a new file using Tableau Desktop and connect to the ManySportsData.xlsx data file.  Save the file as a Tableau Packaged Workbook (.twbx) using a meaningful file name. Continue to use this file for the next four questions. Make sure to clearly label your work so I can find it for each question. Without a Tableau file showing your work and related analysis, your grade for each question will be adjusted accordingly. Please upload your completed Tableau file to this question. 

What interpersonal zone is used when the medic is assessing breath and other body odors?

A patient is ordered to receive a dopamine infusion to manage hypotension. The ordered infusion rate is 5 mcg/kg/min. The patient’s weight is 70 kg. The dopamine solution is available in a concentration of 400 mg in 250 mL. How many milliliters per hour (mL/hr) should be administered to deliver the prescribed dose?

Start with the PivotTable created in the previous question, create an Excel Forecast Sheet to project the annual enrollment of male undergraduate students who attend colleges in the State of Kentucky until 2030 at 95% Confidence Interval. The Seasonality option should be Set Manually at 6 cycles.  According to your analysis, in 2028 the enrollment of male undergraduate students in Kentucky is projected to be [2028Enrollment] (enter a whole number, appropriately rounded, with a comma separator; x,xxxx). 

Tableau Desktop – Trend Lines Create a Tableau View showing annual Operating Expenses per Participant/Men’s Team for the Basketball teams at University of Connecticut and University of Michigan-Ann Arbor. Add Institution Name to the Color Marks so each university is displayed using a unique color. Then, add the Linear Trend Lines to the analysis.   Right-click on one of the trend lines and select Describe Trend Model… to open the dialog box.  Based on the information, enter the value of the model R-Squared in the space below (using all decimal points as displayed on Tableau, i.e., 0.xxxxxx)

Based on the Indiana University (IU) Bloomington’s annual revenues from selected sports programs data provided above, use Excel Fill Series to estimate the Baseball revenues for 2024 through 2030 using the Linear Trend and calculate the amount of annual changes.  According to the analysis, IU’s revenue from Baseball would [IncORDec] (enter increase or decrease) each year by $[ChangeAmount]. The revenue is estimated to be $[2027BaseballRevenue] in 2027.  Enter a number with comma separators with no decimal point (xxx,xxx,xxx; e.g., 123,456,789).

Honor Pledge This exam is open-note and open-book. However, the submitted work must be the product of YOUR OWN effort. Do not share your answers, files, ask anyone for answers, or let someone else complete the exam for you. Before you begin, please select one of the two options below:

The Indiana University (IU) Bloomington’s annual revenues from selected sports programs data is provided above. If the university expects the Football revenues to go from $61,330,602 in 2023 to $75,000,000 in 2030, use Excel Fill Series to estimate the IU’s Football Revenues for 2024 – 2029 using the Linear Trend and calculate the amount of annual changes.  According to the analysis, IU must [IncORDec] (enter increase or decrease) the annual revenue by $[ChangeAmount] (xxx,xxx,xxx) each year in order to reach the target.  Enter a number with comma separators with no decimal point (xxx,xxx,xxx; e.g., 123,456,789).

Refer to the diagram. If the initial aggregate demand and supply curves are AD0 and AS0, the equilibrium price level and level of real domestic output will be