Question 3: Please create a statement of cash flow with indirect method- Please provide answers to each category and a one paragraph analysis of the cash flow using the indirect method.

Statement of Cash Flow with Indirect method

Instructions:You need to show your clear calculation to support each statement provide a paragraph of interpretation related to the result of your analysis on each statement.

Comparative Analysis for balance sheet:

Use the CO2 data and via Multiple regression select the two variables that predict the CO2 level with the best P-value. Make another table with these two variables and answer the questions. Numerical answers are rounded so choose the answer that matches the best:

Hour CO Traffic Wind

1 2.4 50 -0.2

2 1.7 26 0.0

3 1.4 16 0.0

4 1.2 10 0.0

5 1.2 12 0.1

6 2.0 41 -0.1

7 3.4 157 -0.1

8 5.8 276 -0.2

9 6.8 282 0.2

10 6.6 242 1.0

11 6.3 200 2.3

12 5.8 186 3.8

13 5.5 179 4.6

14 5.9  178 5.4

15 6.8 203 5.9

16 7.0 264 5.9

17 7.4 289 5.6

18 7.4 308 4.9

19 6.4 267 3.8

20 5.0 190 2.5

21 3.8  125 1.4

22 3.5 120 0.6

23 3.3 116 0.4

24 3.1 87 0.1

Answer the questions for Assessment:

13. What are the two selected variables? a. Hour and Traffic b. Wind and Traffic c. Hour and Wind

14. Which of the variables has a better P-value and what is this P-value? (Note: numbers are truncated.) a. Traffic; 0.018 b. Traffic; 6.85E-12 c. Wind; 0.0056 d. Wind; 0.174

15. Based on the table, how would you characterize the Regression fit? a. Poor b. Good c. Excellent

16. What is another name for the coefficient 1.274461 and what is its interpretation based on the data? a. The X-intercept; when the average weekday traffic density and the perpendicular wind-speed component are zero.

b. The slope of an average summer weekday's CO2 concentration. It is how much the CO2 concentration will increase when both the average weekday traffic density and the perpendicular wind-speed component increase by 1 unit.

c. The Y-intercept; It is how much the CO2 concentration will increase when both the average weekday traffic density and the perpendicular wind-speed component are zero.

d. The Y-intercept; it is the average summer weekday CO2 concentration when the average weekday traffic density and the perpendicular wind-speed component are zero.

e. None of these

In order to analyze water samples using a spectrophotometer or plate reader, it is necessary to turn the molecules of nitrate into a dye molecule that can be quantified. The first step in turning nitrate (NO₃^-)  into a dye molecule is reducing it to a molecule of nitrite (NO₂^-). This is done by reacting the NO₃^- with cadmium.

After the reduction reaction, the NO₂^- is reacted with two additional reagents. The first reagent, Reagent A, is a solution of sulfanilamide and hydrochloric acid. The second reagent, Reagent B, is a solution of N-(1-naphthyl)-ethylenediamine, called NNED for short. The compounds are mixed with the water sample and produce a purple color. The intensity of the purple color is directly related to the concentration of nitrite in the water sample. We can measure how purple the water turns as absorbance on a spectrophotometer and then convert the absorbance to concentration of nitrate.

To make Reagent A, we will need to make a solution of 10.0 g of sulfanilamide in 1 L of 2.4 molar hydrochloric acid (HCl).

The stock solution of HCl is 6 molar HCl. How many milliliters (mL) of 12 M HCl would you add to produce 0.15 liters (L) of HCl?  mL HCl

After creating 0.15 L of 2.4 molar HCl solution, how many grams of sulfanilamide will be added?  g sulfanilamide

After reacting the nitrate with cadmium to produce nitrite, the nitrite is then reacting with sulfanilamide and N-(1-naphthyl)-ethylenediamine, to produce a purple dye molecule that can be quantified on a spectrophotometer.

The N-(1-naphthyl)-ethylenediamine, called NNED for convenience, reagent is made by mixing 1 gram of NNED in 1 liter of water. However, we don't always want to make an entire liter of solution because the NNED solution only lasts about 1 month before going bad and turning brown.

How many milligrams of NNED will need to be added to make 0.125 liters of solution?

After converting the nitrate into a purple dye, and measuring the absorbance of the purple dye on a spectrophotometer, a standard curve is used to convert the absorbance into concentration.

To make a standard curve, samples with known concentrations of NO₃^- are run on the spectrophotemeter. The samples with known concentrations are called standards. A linear regression is then performed to relate the concentration of NO₃^-  to measured absorbance values.

Here is a link to a spreadsheet containing a simulated data set. There are standards and their related absorbance values, and there are samples from two sites that were diluted, prior to processing and measuring their absorbances. The groundwater originates from the upslope site, and the hope is that the microbes in the soil are removing the NO₃^- from the groundwater before it reaches the downslope site.

Using the given data create a standard curve in Excel, and use Trendline to add a linear regression with the equation. Then use the standard curve and the dilutions to determine the concentration of NO₃^- in all the samples. Using the data analysis tool pack, perform the appropriate t-test to deduce if the nitrate concentration upslope is less than or greater than the nitrate concentration downslope. When performing a t-test using the data analysis tool pack, the output will include the means for both groups.

What is the average NO₃^- concentration at the upslope site?

Report your answer, from the data analysis tool pak output, to 3 decimal places

What is the average NO₃^- concentration at the downslope site?

Report your answer, from the data analysis tool pak output, to 3 decimal places

Given the EPA drinking water quality standard is 10 mg/L of nitrate, is the upslope site safe to drink based only on nitrate content?  (Enter yes or no)

Is the downslope site safe to drink, based only on NO₃^- concentration?  (Enter yes or no)

Assuming the two sites are hydrologically well connected, the transit time between the two sites is fast, and the two sites cannot be treated as independent samples, what kind of t-test should be performed to show that the upslope site is greater than the downslope site? Enter the letter of your answer choice in the answer blank

A. one-tailed unpaired t-test
B. two-tailed unpaired t-test
C. one-tailed paired t-test
D. two-tailed paired t-test

What is the calculated t statistic, rounded to 4 decimal places?

Is the calculated t statistic greater or less than the critical t value reported by the data analysis tool pack?  (enter greater or less)

Is the nitrate concentration at the upslope site significantly greater than the downslope site? (Enter yes or no)

Based on this statistical result, and assuming no diffusion or dilution occurs between the upslope and downslope site, do you think microbes are removing NO₃^- from the ground water?  (Enter yes or no)

DATA

a circular footing 10m in diameter is proposed to carry a total load of 9000 KN. The footing is to be placed at a depth of 2m below ground surface. The soil is normally consolidated silty clay with a unit weight of 20KN/m^3 and undrained shear strength of 50 KPa.

1) determine the short-term factor of safety using the General bearing capacity equation.

2) Calculate the expected consolidation settlement of the footing if the compression index is 0.2 and the initial void ratio is 1.0.

3) if the calculated settlement is not acceptable, indicate the necessary steps to be taken before construction to reduce the consolidation settlement.

Recorded Temperatures in Fahrenheit and participation in inches at a place are as follows:

Temp: 86, 81,83,89,90,74,64

Percipitation: 3.4, 1.8, 3.5, 3.6, 3.7, 1.5, 0.2

A.) Find the sample correlation coefficient of, R

B.) What is the meaning of the value of r that you have calculated in PArt A?

C.) Test the significance of the population correlation coefficient, p at a=0.05

D.) find the value of the coefficient of variation, r^2

E.) What is the meaning of r^2 value you have caluclated in part d?

F.) Find y, when x=70

G.) find the standard error of the estimate

A 3-phase 60 HZ , 200km transmission line has a series impedance of z= 0.10 + j0.35 Ω/km and a capacitive reactance of 0.2 x 10 6 Ω-km. At the receiving end, the line delivers 250 MW @230/30θ kV and 0.95 lagging power factor.

Determine

a) The line impedance and shunt admittance

b) The A, B, C , D parameters

c) Sending end complex power and power factor

d) Is the PF is leading or lagging

e) Voltage regulation for the line

f) Line efficiency

g) Characteristic impedance of the line

Late at night, you are again greeted by the stranger in a dark silk cape. This time he has a coin with probability 0.2 of coming up heads. He suggests a game in which you flip the coin repeatedly, earning $1 for each heads and losing $1 for each tails. The game will continue until you go broke or have a fortune of $3.

a) If you begin the game with $2 in your pocket, what is the probability that after 2 flips, you will have $2?

b) If you begin the game with $1 in your pocket, what is the probability you will ever reach $3?

Un tanque inicialmente tiene 220 galones de agua limpia, pero una solución de sal de concentración desconocida se vierte a un ritmo de 6 galones por minuto. Si a la vez que se vierte se extrae solución a la misma velocidad y si al cabo de 40 minutos la concentración en el tanque fue de 0.2 libras de sal por galón, determine la concentración de la solución vertida (en libras por galón).

The following information is available for four securities:

Stock E(r) Std. Dev. p 1 p 2 p 3 p 4   

1 14% 30% 1.0 0.6 0.4 -0.2

2 10% 25% 1.0 .20 0.5

3 15% 34% 1 0.1

4 9% 22% 1

(a) [30 points] Calculate the expected returns and standard deviations of returns of the following two portfolios: P1 : {31%, 5%, 19%, 45%} P2 : {4%, 35%, 2%, 59%}

(b) [10 points] Which portfolio will be preferred by risk averse investors? Why?