Using Excel

Question 2: An electromagnetic projectile launcher has been built. You are tasked with developing a model for the velocity of the projectile.

The launcher stores energy in a capacitor, which is charged to a voltage, Vi prior to launch. The capacitor discharges to 2,000 V, Vf during the launch. The velocity of the projectile is measured for several different voltages as shown in the table.

1. Create an Excel scatter chart with trendline for data set, selecting the best mathematical model type. Show the trendline equation and goodness of fit R2 on the chart. Include title, labels, and other standard information to properly document the plot.

2. TKE, if the projectile is 30 kg for each launch and the capacitor is 2 F (farad).   Note: Energy remaining stored in the capacitor is not wasted, and can be used in the next launch; this is the residual or final energy stored in the capacitor. It may be helpful to record this for each event. From the problem statement, the residual voltage is 2000 V

3. Determine the energy, Ewaste, which does not transfer from stored energy in the capacitor to kinetic energy

(Ewaste represents energy converted to heat, sound, light, etc.)

Hint: Energy stored in a capacitor is given by the relationship     E = ½ CV2 where C is the capacitance (2 F) and V is the voltage. This is calculated from the various voltage values shown, and the units are Joules (J).      TKE = ½*mass*Velocity2   This velocity corresponds to the charge voltage actually used.

Finally, recall the Law of Conservation of Energy discussed in Lesson 2. Energy in any form remains constant (energy is neither created nor destroyed by changes form), so the total energy of this system must be unchanged. This means that independent of the form (electrical, kinetic, or wasted) the net change in energy must be zero!

                                    in simple terms:            Initial energy = Kinetic Energy + Final Energy + Wasted Energy

4. Show the fraction (percentage), Ewaste/Einitial for each launch.

5. Create a second scatter plot of the fraction loss vs Initial voltage. Include title, labels and other standard information to properly document the plot.

6. Using a trendline model, determine the polynomial which best describes the waste fraction as a function of initial voltage.

     (This is a perfect example of applying the curve fit "in a limited region"; is is not for all possible values of voltage)

During

20182018​,

Chun'sChun's

Book Store paid

$ 273 comma 000$273,000

for land and built a store in

Lockport comma New YorkLockport, New York.

Prior to​ construction, the city of

LockportLockport

charged

Chun'sChun's

$ 1 comma 300$1,300

for a building​ permit, which

Chun'sChun's

paid.

Chun'sChun's

also paid

$ 15 comma 300$15,300

for​ architect's fees. The construction cost of

$ 745 comma 000$745,000

was financed by a​ long-term note​ payable, with interest costs of

$ 36 comma 200$36,200

paid at the completion of the project. The building was completed June​ 30,

20182018.

Chun'sChun's

depreciates the building using the​ straight-line method over 35​ years, with estimated residual value of

$ 332 comma 300$332,300.

Microeconomics has traditionally been built on the foundation of rational choice.   However, since the 70’s insights from blending psychology and economics have been changing the landscape.   Some have argued this new line of thinking, most often associated with behavioral economics, has laid waste to the micro model of choice.  

To what extent does the rational choice model have a future?   Can it absorb the new insights from behavioral? Do you think we will have two competing models of choice going forward?  

Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 60,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $45,800 in accounts receivable; $5,300 in accounts payable; and a $5,800 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($4,800 per month), and rent ($7,300 per month). (2) Prepare a cash budget for each of the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.)

Smarty McGuy intends to charge the parallel plate capacitor inside his intergalactic Ford Pinto (built by Doc Dre) with a lightning strike of 26x10³ amps. Doc Dre's capacitor specifications are listed below:

The distance between the capacitor plates is 5 microns

The surface area of the capacitor plates is 3,844 cm²

There is a dielectric between the capacitor plates

What is the minimum dielectric constant of the material between the plates needed to store all the charge from the lightning assuming that the lightning strike lasts for 6x10^-6 seconds and provides 1.21 Gigawatts of power? Assume the dielectric doesn't reach its breakdown voltage.

1. The human immune system has a lot of back-up plans built into its design. Many cells and other immune components have similar roles. Provide an example of two components that have similar or identical roles in the immune system.

2. If you had to choose, do you feel it would be more detrimental to a person's health to have no T cells or no B cells? Which do you think would impact a person’s overall health more profoundly? Why?

3. Pathogens have many “tricks” to avoid immune detection and “buy time” to establish an infection. If you were a pathogen, which ONE of the following components of the immune system do you believe would be the most helpful to avoid or disable? Provide the reason why you selected it and any support for your choice.

a) Phagocytic cells

b) Inflammation

c) Complement

d) Cytokines

1. Using the R built-in data set called Chick Weight, we want to compare the mean weight across the different types of Diet. IMPORTANT: We only want to compare chicks at the final value of Time, 21. In this problem, use ?? = 0.05.
   1. Make a boxplot to compare weight across the different types of Diet. Based on the boxplot, describe any differences (or lack of differences) you see.
   2. Run an ANOVA to compare weight across the different types of Diet. Is there a significant difference in means?
   3. Regardless of your answer to part b, using Tukey’s HSD approach, which pair or pairs of Diet have significantly different means?
   4. Check the assumptions of the ANOVA: Do the variances look similar across groups? And do the residuals look like they could have come from a Normal Distribution?

Answers should be in the form of R code on how to accomplish each part and include the correct statistical explanation for those that require it in the question. Please be as thorough as possible. Thank you so much!!!

Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow:

Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $44,900 in accounts receivable; $4,400 in accounts payable; and a $4,900 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($3,900 per month), and rent ($6,400 per month).

(2) Prepare a cash budget for each of the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.)

Required information

[The following information applies to the questions displayed below.]

Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow:

Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $44,400 in accounts receivable; $3,900 in accounts payable; and a $4,400 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($3,400 per month), and rent ($5,900 per month).

(2) Prepare a cash budget for each of the months of July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter your final answers in whole dollars.)