Questions
Q1: A sample with two variables (x and y) is given in the table. According to...

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

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

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

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

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

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

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

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

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

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