|
Q1: A sample with two variables (x and y) is given in the table. According to the sample, please develop an excel spreadsheet to calculate the missing values given in the table of “summary output” attached below. The excel spreadsheet needs to be submitted together with your assignment. Note: use “data analysis toolpak” to check your answers, but calculations, equations and steps should be done for each "?" value |
|
x |
y |
|
1.0 |
5.2 |
|
1.5 |
7.2 |
|
2.0 |
5.5 |
|
2.5 |
4.9 |
|
3.0 |
7.3 |
|
3.5 |
9.5 |
|
4.0 |
11.3 |
|
4.5 |
10.9 |
|
5.0 |
11.8 |
|
5.5 |
12.3 |
|
6.0 |
11.7 |
|
6.5 |
12.1 |
|
SUMMARY OUTPUT |
||||||
|
Regression Statistics |
||||||
|
Multiple R |
? |
|||||
|
R Square |
? |
|||||
|
Adjusted R Square |
? |
|||||
|
Standard Error |
? |
|||||
|
Observations |
? |
|||||
|
ANOVA |
||||||
|
df |
SS |
MS |
F |
Significance F |
||
|
Regression |
? |
? |
? |
? |
? |
|
|
Residual |
? |
? |
? |
|||
|
Total |
? |
|||||
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
|
Intercept |
3.602 |
? |
? |
? |
? |
? |
|
Slope |
1.476 |
? |
? |
? |
? |
? |
In: Statistics and Probability
A CI is desired for the true average stray-load loss μ (watts) for a certain type of induction motor when the line current is held at 10 amps for a speed of 1500 rpm. Assume that stray-load loss is normally distributed with σ = 2.9. (Round your answers to two decimal places.)
(a) Compute a 95% CI for μ when n = 25 and x = 51.2
( , ) watts
(b) Compute a 95% CI for μ when n = 100 and x = 51.2.
( , ) watts
(c) Compute a 99% CI for μ when n = 100 and x = 51.2.
( , ) watts
(d) Compute an 82% CI for μ when n = 100 and x = 51.2
( , ) watts
(e) How large must n be if the width of the 99% interval for μ is to be 1.0? (Round your answer up to the nearest whole number.)
n=
You may need to use the appropriate table in the Appendix of Tables to answer this question.
In: Statistics and Probability
Assume that you have the following information:-
Market Info:- Real interest rate = 2.0%; Expected inflation = 4.0%; Rm = 12.0%; Tax = 30.0%.
Com. Stock info:- Par value = $1.0 ; Market value (price) = ?? ; Beta = 1.60 ; No. of outstanding shares = 1,000,000.0 ; EPS $3.0 ; pay-out ratio = 30.0%;
Growth in EPS & Dividends = 5.0% ;
Preferred Stock info:- Par value = $100.0; Dividend per share = 10.0%; Rp=8.0%; No. of outstanding shares = 100,000.0; Price = ????
Bonds info:- Par value = $1,000.0; Coupon interest = 4.0% ; YTM = 6.0%; Time to maturity = 20 years ; No. of bonds = 100.0; Price = ???
1- Calculate the WACC using historical weights in the capital structure.
2 - Calculate the WACC using market weights in the capital
structure.
3 - The before and after tax cost of debt.
4 -The before and after tax cost of equity.
5 - The before and after tax cost of preferred stock.
In: Finance
The city of Stillwater is planning to install a new settling tank as an upgrade to their existing water treat plant. You run a batch settling test using a 2.0 m column and coagulated water from their existing tank and collect the following data (Table 1). Using this data, design a settling tank to remove 65% of the influent suspended solids. Assume a design flow of 0.5 m3/s. Use scale up factors of 0.65 for overflow rate and 1.75 for detention time (Eckenfelder 1980). Discuss your results.
Table 1. Percent suspended solids removal as a function of time and depth.
|
Sampling time (min) |
|||||||
|
Depth (m) |
5 |
10 |
20 |
40 |
60 |
90 |
120 |
|
0.5 |
41 |
50 |
60 |
67 |
72 |
73 |
76 |
|
1.0 |
19 |
33 |
45 |
58 |
62 |
70 |
74 |
|
2.0 |
15 |
31 |
38 |
54 |
59 |
63 |
71 |
In: Civil Engineering
Select True or False from each pull-down menu, depending on whether the corresponding statement is true or false.
? True False 1. Using the standard normal curve, the z−z−score representing the 90th percentile is 1.28.
? True False 2. The mean and standard deviation of a normally distributed random variable which has been standardized are one and zero, respectively.
? True False 3. A random variable XX is normally distributed with a mean of 150 and a variance of 36. Given that X=120X=120, its corresponding z−z− score is 5.0
? True False Let z1z1 be a z−z− score that is unknown but identifiable by position and area. If the area to the right of z1z1 is 0.8413, the value of z1z1 is 1.0
My answer was
1. T
2. T
3.F
4. T
but I didnt get credit for that so I think there is something wrong
In: Statistics and Probability
|
Consider the following: |
|||||||||
|
Returns |
|||||||||
|
Scenario |
Probability |
Auto |
Gold |
Portfolio (75% auto, 25% gold) |
|||||
|
Recession |
1/3 |
-8 |
+20 |
.75(-8) + .25 (20) = -1.0% |
|||||
|
Normal |
1/3 |
+5 |
+3 |
.75(5) + .25 (3) = +4.5% |
|||||
|
Boom |
1/3 |
+18 |
-20 |
.75(18) + .25 (-20) = +8.5% |
|||||
|
Expected Return |
|||||||||
|
Auto |
(-8+5+18)/3 = 5% |
||||||||
|
Gold |
(+20+3-20)/3 = 1% |
||||||||
|
Portfolio |
(-1+4.5+8.5)/3 = 4% |
||||||||
|
Variance |
|||||||||
|
Auto |
(169+0+169)/3 = 112.7 (std. 10.6%) |
||||||||
|
Gold |
(361+4+441)/3 = 268.7 (std. 16.4%) |
||||||||
|
Portfolio |
(25+.25 +20.25)/3 = 15.2 (std 3.9%) |
||||||||
|
Homework: |
|||||||||
|
1) Show expected return & variance of a 90% auto, 10% gold portfolio |
|||||||||
|
2) Show expected return & variance of a 25% auto 75% gold portfolio |
|||||||||
In: Finance
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Product G Product B Selling price per unit $ 170 $ 200 Variable costs per unit 70 120 Contribution margin per unit $ 100 $ 80 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 550 units 200 units The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management is thinking about operating the machine for two shifts, which will increase its productivity by another eight hours per day for 22 days per month. This change would require $10,000 additional fixed costs per month. (Round hours per unit answers to 1 decimal place. Enter operating losses, if any, as negative values.)
In: Accounting
A CI is desired for the true average stray-load loss μ (watts) for a certain type of induction motor when the line current is held at 10 amps for a speed of 1500 rpm. Assume that stray-load loss is normally distributed with σ = 2.2. (Round your answers to two decimal places.)
(a) Compute a 95% CI for μ when n = 25 and x = 56.7.
(answer,answer) watts
(b) Compute a 95% CI for μ when n = 100 and x = 56.7.
(answer,answer) watts
(c) Compute a 99% CI for μ when n = 100 and x = 56.7.
(answer,answer) watts
(d) Compute an 82% CI for μ when n = 100 and x = 56.7.
(answer,answer) watts
(e) How large must n be if the width of the 99% interval for μ is to be 1.0? (Round your answer up to the nearest whole number.)
In: Statistics and Probability
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Product G Product B Selling price per unit $ 50 $ 80 Variable costs per unit 10 48 Contribution margin per unit $ 40 $ 32 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 600 units 200 units The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management is thinking about operating the machine for two shifts, which will increase its productivity by another eight hours per day for 22 days per month. This change would require $4,000 additional fixed costs per month. (Round hours per unit answers to 1 decimal place. Enter operating losses, if any, as negative values.)
In: Accounting
Chemistry: Calorimetry and Heats of Reaction
Mass of water in styrofoam cup: 100g
Mass of KCl: 1.650g
Initial Temperature: 20.6degC
Final Temperature: 19.6degC
q=(75g)(1.0 cal/g x degC)(-1degC)= -75cal
qreaction= -qcontents
-75 cal = 75 cal --> 0.075kCal
1.650g KCl = 0.2214 mol KCl
0.075kCal/0.02214mol = 3.39kCal mol KCl
Is this the standard heat of solution?
If this is the standard heat of solution, how would I determine the percent error of my result?
I was given this equation:
Percent error = |lit value - exptl value/lit value| x 100
with this information:
KCl(s) --> K+(g) + Cl-(g) dH=167.1kCal/mol
K+(g) + Cl-(g --> dH=163.0 kCal/mol
KCl(s) --> K+(aq) + Cl-(aq) dH=??
I know this question was super long. I'm sorry I'm confused and I'm not really sure where to begin.
In: Chemistry