2.Hi, i have a task where i need to calculate the 3 months weighted moving average for May 2021, The
...
eight should be based on the count of sales for the previous period, the actual period and the next period.
In the excel you can see the housing data:
period(month)
sum of prices(K)
sum of the asses value(T)
K/T value (sum of prices/sum of the asses value)
The answer i'm looking for is that for May 2021 the price development in percentage should be 9.5% compared to three month back. To calculate the price development you just divide the K/T value, for example:
period 1 K/T value = 1.4
period 4 K/T value = 1.9
Price development = (1.9/1.4)-1 = 35.7% increase.
So i want to see 9.5% increase on May 2021 compared to 3 months earlier.
View More
12.Consider a fluid bounded by two parallel plates extended to infinity such that no end effects are encountered (unidirectional flow
...
countered (unidirectional flow or parallel flow). The planer walls and the fluids are initially at rest. Lower plate moves to left and upper plate to right. Let the fluids be an oil, where kinematic viscosity (ν) = 2.17 x 10-4m2/s and the distance between both plate (h) is 10 mm. U0 = 0.4 m/s I need to find the governing equation, boundary conditions, initial conditions and to derive velocity distribution in steady state.
Also, Use FTCS explicit method to calculate the velocity distribution as a function of time by implementing these governing equation in Matlab
View More
20.Hi, I need help setting up a simple formula in a Google Sheets spreadsheet.
The spreadsheet is hosted and
...
sted and I can see any changes in realtime. What I need is to take the duration in cells A2:A1000 and factor the dollar value in corresponding cells B2:B1000 in a way that causes the average amount earned per hour to calculate in cell D2. I'd appreciate a bit of help here, and I;d prefer if you could just plug the formula directly into cell D2 using the link below.
The link to the editable document is:
https://docs.google.com/spreadsheets/d/1lEJIPiSZJk9LYUTSA4oeDwyLXCVd18Zdewm6gnjxcXo/edit?usp=sharing
Thanks!
View More
21.Hi, I need help setting up a simple formula in a Google Sheets spreadsheet.
The spreadsheet is hosted and
...
sted and I can see any changes in realtime. What I need is to take the duration in cells A2:A1000 and factor the dollar value in corresponding cells B2:B1000 in a way that causes the average amount earned per hour to calculate in cell D2. I'd appreciate a bit of help here, and I;d prefer if you could just plug the formula directly into cell D2 using the link below.
The link to the editable document is:
https://docs.google.com/spreadsheets/d/1lEJIPiSZJk9LYUTSA4oeDwyLXCVd18Zdewm6gnjxcXo/edit?usp=sharing
Thanks!
View More
24.5 (5 points) There is H3PO4 available in stock solution that has an assay of 77% and a density
...
cific gravity) of 1.24. What is the molarity of this solution?
Using this solution how would 1 L of 2N solution be made.
6 (5 points) H3BO3 is needed to neutralize 20 ML of a 2N solution of NaOH. How much of the acid should I put in 40 ML of the water to exactly neutralize this solution?
7 (6 points) Describe how to make the solutions below :
20% w/v Salt in water.
20% v/v alcohol in water
20% w/w NaCl in water.
8 (three points) I have 0.6 g/dl solution of NaOH. What is M? Whan is N?
9 (six points) There are 3000mL of 3M NaOH. How much of the following do I need to neutralize? (watch your M’s and N’s
a) 3M H3PO4
b) 2M H2SO4
c) 1M HCL
10 (20 points) The following solutions of NaOH are mixed together 20ML of 3N, 40mL of 2N, 60mL of 1N, 80 mL of 4N, and 100mL of 5N.
a) What is the volume and normality of the final solution?
b) How much 4M sulfuric acid would I need to neutralize?
c) How much stock solution of sulfuric acid with an assay of 77% and a specific gravity of 1.14 would I need?
d) How many grams of HCl would I have to put in a 300mL solution of HCl in water to neutralize?
11 (3 points) How much 5N solution can I make with 98 grams of H3PO4 ?
12 (5 points) How much 5N solution of H3AsO4 can I make with 57 mL of stock solution that is 84% assay and 1.14 specific gravity?
13 (5 points) If we have a 4N solution of HCl that has 0.03645g of HCl in the solution, how many microliters of solution do we have?
14 (10 points) If we have 66mL of a solution of concentrated NaOH that has an assay of 88% and a specific gravity of 1.24, how much 3N H3AsO4 can be neutralized?
15 (ten points) If I have 17 mL of a 20% w/v solution of NaOH and I want to neutralize with H2SO4 that is available in a 4% w/v solution, how much of this solution will be required.
16 (ten points)
a) I have an 12mL of Ba(Cl)2 that is 78% assay that contains 8 grams of Ba(Cl)2. What is the specific gravity?
b) How many Moles of Ba(Cl)2 are there?
c) If I have 80 grams of NaOH in a liter of solution that is of an unknown specific gravity, can I calculate molarity and what is it?
d) What is the difference between molarity and normality?
e) I have 77 ml of 77% salt in water. How much 11% can I make?
View More
26.my homework is as follows, I have some given information and then i need to create a income statement, balance
...
t, balance sheet, and statement of retained earnings. Once that is done, I have to calculate a bunch of ratios like current ratio, quick ratio, debt ratio, debt to net worth ratio, times interest earned, average inventory turnover ratio, average age of inventory, receivables turnover ratio, average collection period ratio and so on.
View More