I have the following data for a sample of 97 observations:

I now need to find out the Skewness. However I cannot use Excel's built in functions(=Skew) or Data Tool. How can I write the formula in an Excel cell to find the skewness? I know the result should be -0.52

Q2. Solar or photovoltaic (PV) cells convert sunlight to electricity and are commonly used to power calculators, satellites, remote communication systems, and even pumps. The conversion of light to electricity is called the photoelectric effect. It was first discovered in 1839 by Frenchman Edmond Becquerel, and the first PV module, which consisted of several cells connected to each other, was built in 1954 by Bell Laboratories. The PV modules today have conversion efficiencies of about 12 to 15 percent. Noting that the solar energy incident on a normal surface on earth at noontime is about 1000 W/m2 during a clear day, PV modules on a 1-m2 surface can provide as much as 150 W of electricity. The annual average daily solar energy incident on a horizontal surface in the United States ranges from about 2 to 6 kWh/m2. A PV-powered pump is to be used in Arizona to pump water for wildlife from a depth of 180 m at an average rate of 400 L/day. Assuming a reasonable efficiency for the pumping system, which can be defined as the ratio of the increase in the potential energy of the water to the electrical energy consumed by the pump, and taking the conversion efficiency of the PV cells to be 0.13 to be on the conservative side, determine the size of the PV module that needs to be installed, in m2. (TOTAL 25 MARKS)

Subatomic Speculating

[6][6] (a) Which processes below are physically forbidden? Why?

(i) τ++τ−→μ++e− (ii) p+n¯→p+n (iii) u+u¯→s¯ + s(i) τ++τ−→μ++e− (ii) p+n¯→p+n (iii) u+u¯→s¯ + s

(iv) γ+γ → μ++μ−(v)n+π−→p¯+Λ (vi) p+p¯→γ+γ+γ (iv) γ+γ → μ++μ−(v)n+π−→p¯+Λ (vi) p+p¯→γ+γ+γ

[5][5] (b) The Future Circular Collider (FCC), if built, will collide two beams of protons, each beam having an average energy of 50 TeV. How much energy would a beam in a fixed-target experiment have to have to get the same average total amount of useable energy per collision?

[4][4] (c) An experiment is performed at Fermilab to find a new particle XX from the scattering process

p+p→K++K++Xp+p→K++K++X

What are the values of the electric charge, strangeness, and baryon number of the XX particle? What quarks must it be made of?

Most important in the work below is to show THE FORMULA'S USED IN EXCEL especially for the table asked to be built in (c).

5. According to a recent study, 9% of adults have been diagnosed with diabetes. 8 adults are randomly selected and then each is tested to see if she or he has diabetes. Use this situation to answer the parts below.

(a) Recognizing that this is a binomial situation, give the meaning S and F in this context. That is, define what you will classify as a "success" and what you will classify as a "failure" as it refers to diabetes. S = F =

(b) Next, give the values of n, p, and q. n = p= q=

(c) Construct the complete binomial probability distribution for this situation in a table out to the right.

(d) Using your table, find the probability that exactly two adults have diabetes.

(e) Find the probability that at least 1 adults have diabetes.

(f) Find the probability that less than two adults are diabetic.

(g) Find the mean and standard deviation of this binomial probability distribution.

(h) By writing a sentence, interpret the meaning of the mean value found in (g) as tied to the context of adults with diabetes.

(i) Is it unusual to have 2 adults with diabetes? Briefly explain your answer giving supporting numerical evidence. (Hint: 2 Sigma Rule)

Let's look at a super conductor: so resistivity really is zero exactly, and some of our electrostatics assumptions about E=0 in a conductor and the charge is all on the surface really are true

a) Show the magnetic field must be constant inside

b) If you built a loop out of superconducting material, show that the magnetic flux through that loop must be constant

c) Turns out B is not only constant in a super conductor, but zero. Why? Eddy currents on the surface create B equal and opposite to whatever you're throwing at it to cancel out B and make it zero inside. Show why the currents must be all on the surface of the superconductor.

d) Superconductivity is caused by electrons forming so-called "Cooper Pairs" that slalom around the atoms and never slowing down, or transferring energy to heat, or causing resistance.There is a critical temperature where electron pairs rattle apart and atoms vibrate so much that you can't dodge them anyway. What if you made a ball of this stuff above the critical temperature and stuck a magnetic field B₀ in the z-direction through it. Then dump the liquid nitrogen so it cools enough to superconduct. Find the induced surface current K as a function of angle (theta) from the z-axis.

A and B, both dealers in real estate, find a parcel of land to purchase for $100,000 as an investment. They believe it can be sold in 2 years for $200,000. They either will buy the land as tenants-in-common for $100,000 and jointly contribute it to a partnership or contribute $50,000 each to an equal partnership, which then will buy the land.

(a) How should they structure the transaction?

(b) Assume the AB partnership purchased the land for $100,000 in Year One and it appreciated in value to $200,000 by the beginning of Year Three. At that point, C joins the partnership as an equal partner by contributing $100,000 cash to be used by the partnership to improve the land and sell it. The partners believe they can sell the land for $450,000. What result for tax and book purposes if the partnership sells the improved parcel of land for $450,000 and allocates the gain to reflect the appreciation at the time of C’s entry into the partnership?

(c) What results to the partners under the facts of (b), above, if they elect to use a reverse Internal Revenue Code Section 704(c) allocation under Regulation Section 1.704-1(b)(2)(iv)(f)(5) and they apply the traditional method of allocation.

(d) What result on a sale of land for $450,000 if the capital accounts of the partners are not adjusted when C joins the partnership and the agreement does not include any special allocation to reflect the built-in-gain at the time C became a partner?

Braxton Technologies, Inc., constructed a conveyor for A&G Warehousers that was completed and ready for use on January 1, 2021. A&G paid for the conveyor by issuing a $150,000, four-year note that specified 5% interest to be paid on December 31 of each year, and the note is to be repaid at the end of four years. The conveyor was custom-built for A&G, so its cash price was unknown. By comparison with similar transactions it was determined that a reasonable interest rate was 12%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:
1. Prepare the journal entry for A&G’s purchase of the conveyor on January 1, 2021.
2.Prepare an amortization schedule for the four-year term of the note.
3. Prepare the journal entry for A&G’s third interest payment on December 31, 2023.
4.If A&G’s note had been an installment note to be paid in four equal payments at the end of each year beginning December 31, 2021, what would be the amount of each installment?
5. By considering the installment payment of requirement 4, prepare an amortization schedule for the four-year term of the installment note.
6. Prepare the journal entry for A&G’s third installment payment on December 31, 2023.

Online trolls drive us crazy saying that our cars are big, heavy and that they drive like boats. Well, our solution to everything is more horsepower. Even, in 1921, the Dodge Brothers built a boat named the SS Delphine and it had a whopping 3000 HP. So, how much horsepower would a Challenger SRT® Hellcat Redeye Widebody need to tow the SS Delphine up the industry standard: Davis Dam Grade Climb?

The video of the question on YouTube:

https://youtu.be/6JLrBj3dqvM

Pro Tips

Davis Dam assumed grade = 7%

Air density is sea level conditions (.002377 slugs/f^t3)

w(weight) of the SS Delphine + trailer + Redeye = 3,922,000 + 150,000 + 4451 Lbs

Crr = coefficient of rolling resistance = .015

Assume Combined CDA is 1555 ft^2

SAE J2807 (Davis Dam Grande Climb) - min speed is 40mpg (59 ft/s)

F(drag) = 1/2p x V^2 x C(d)A

F(rolling resistance) = W x cos x Crr

F(weight) = W x sin

F(sum) = F(drag) + F(rr) + F(weight)

P = F(sum)XV

convert to horsepower = P(1hp/550ft lbf/sec)

Question

Which of the following are true statements about what happens in the design phase

In the design phase we specify the architecture, technical components, modules, interfaces and data

In the design phase we are interested in how the system will be built

Design take the analysis statement and adds to it

In the design phase we construct the system

Question

The System Design is (Choose all correct answers)

Group of answer choices

The System Design is the process in which we go through to design the system

The System Design is the blueprint used to build the system

The end result of the design phase

From the System Design, the system is constructed

Question

What is the effect of a poor job done in the analysis phase? Choose all correct answers

Good people in the later stages can turn around a poor analysis in many cases

Poor analysis means you will have to just work harder in the design phase to bring the analysis up to speed

The overall success of the project will be negatively impacted

A poor analysis generally means a poor design will be created

Question

What are the benefits of a success Analysis phase? Choose all correct answers

Builds organizational trust

Increases the chance your project will ultimately be successful

Helps build user buy in and acceptance of the to be system

Can make the organization stronger