Hello!

If possible can you please teach me in excel formulas?

Thank you!

Autumn

1. If Indiana stayed the same size in area, but had the same population density as Alaska, how many people would we expect to live in Indiana? How does this compare to the actual population of Indiana?

2. If Alaska stayed the same size in area, but had the same population density of Illinois, how many people would you expect to live in Alaska? How does this compare the Alaska’s actual population?

3. If France had the same ratio of museums to population as the US, what would you expect France to have as the total museums in their country?

3. In this section we have said that the Richter scale and other logarithmic scales are compressed. Explain in a way that a fellow student could understand what is meant by a compressed scale, and use a couple of examples to show how the compression works in practice.

Numerical Analysis:

Make a matlab code that computes the Midpoint rule/method for a given function f'(t,y) = y' =  t + y from 0 < t < 4 (inclusive) with h=0.5 and with initial condition y(0) = 0.
Please make output display in tabular form and not in a plot, that doesn't help show the actual values.

Solve the following non-monic quadratic problems:

a) Rick's driving speed was measured over a 10.minute period and the following relationship was found to exist: s = -4t² + 31t, what s is the speed in kilometres per hour after t minutes. When was Rick travelling at 60 km/h?

b) The temperature inside a tent was measured over a period of time and the following quadratic relationship was found to exist: T = -2h² + 11h + 21, where T is the temperature in degrees Celsius after h hours. When was the temperature 0 degrees and when was the temperature 26 degrees?

c) A tourist, high above the ground enjoying the sights from a hot-air balloon, unfortunately drops a camera and watches it fall to the ground. The height of the camera above the ground , h (in metres) t seconds after it has been dropped can be represented by the relationship: h = -5t² + 192. At what height above the ground was the camera dropped and how long does it take for the camera to fall to the ground?

d) A policeman on a motorbike is following a car along a highway. After a short time, the driver of the car notices the policeman and starts to slow down, finally stopping on the side of the road. The speed of the car during this time can be represented by the quadratic function S = -3t² + 17t + 70, where S is the speed of the car in kilometres per hour, t minutes after the policeman started following. Calculate how long the car was under surveillance for until it stopped and figure out if during this time, did the driver break the speed limit of 100km/h?

e) Hayden's owners are going to build a dog kennel for him. It will be 1m high and twice as long as it is wide, and it will have an opening at one end. The opening has an area of 0.5m². When they are finished, they are going to paint the outside of it, including the base of the kennel, to keep it waterproof. Write an algebraic expression for the area of the kennel that is to be painted.

(a) Design an algorithm that reveals some secret integer number from the set {1, 2, ... , n} by guessing random numbers within the given range until the secret number has been guessed. Numbers should be replaced after being guessed such that ​it is possible to guess 2 and then 2 again​, assuming 2 is in the given range. The algorithm should return both the secret number as well as the number of guesses taken.

(b) If possible, calculate the tightest Big-​O​ approximation for the average runtime complexity of the algorithm from part (a). If it is not possible, explain why not. Note: assume that choosing a random number takes ​O(1)​ time.

(c) If possible, calculate the tightest Big-​O​ approximation for the worst case runtime complexity of the algorithm from part (a). If it is not possible, explain why not. Note: assume that choosing a random number takes ​O(1)​ time.

(d) In a single run, is it possible that of the algorithm from part (a) finds the secret number in fewer guesses than a standard binary search algorithm? If so, please provide a concrete example of one such situation.

A device consists of 100 independent modules of equal functionality. Zk is the event that the kth group works reliably. a) What is the probability that the device will work reliably at P (Zk) = 99%?

There are four independently operating machines in a hall, which do not fail within a certain period of time with the probabilities 0.9, 0.95, 0.8 and 0.85, respectively. Calculate the probability that in this period a) all four machines work b) no machine works c) exactly one machine works d) exactly two machines work e) exactly three machines work f) at least one machine works

Use the Laplace transform to solve the given initial-value problem.

y'' + 6y' + 34y = δ(t − π) + δ(t − 3π), y(0) = 1, y'(0) = 0

y(t) =( ? )+ ( ? )· U (t − π) + ( ? )· U (t − ? )

Find most general solution to

t² y'' - 3ty' + 8y = 20t^-2

Please state any methods you apply.

Given a set of samples which belong to two classes C1 and C2, assume C1 and C2 are linearly separable, please prove that perceptron learning algorithm applied to the samples will terminate after a finite number of iterations.

How many ways can you arrange 2,3,4 letters of the title "the endless summer"?

       - Assume that your given 2 spaces , 3 spaces , 4 spaces where you are able to use all the letters (must include the repeated letters)

       - Finding the total number of ways to order them in these certain spaces and finding the sum of all 3

          -

Look online to find an interest rates for each of the following:

a) Credit Card

What is the rate charged for overdue monthly balances? Clearly state your answer.

b) Car Company (for financing a new car)

Include your sources (links) AND a screencapture of where on the page you found the information.

Numerical Analysis: Perform the steps of the secant method to approximate the first three positive roots of the transcendent equation x = sin (πx).

Suppose we use the ElGamal signature scheme with p = 65539, ? = 2, ? = 33384. We send signed messages (m, r, s): (809, 18357, 1042) = hi and (22505, 18357, 26272) = bye. (a). Show that the same value of k was used for each signature. (b). Use this fact to find this value of k and to find the value of “a” such that ? ≡ ?? (??? ?).

You have been hired as a consultant to advise Sandbaggers, Inc., a company that purchases silica sand, cleans it, and then sells the silicon dioxide to manufacturers of computer chips. Sandbaggers, Inc., operates two cleaning plants: Plant A and Plant B.

They obtain their supply of silica sand from three independent suppliers (Sand Solutions, Dirt Dudes, and Terra Firma) who are willing to supply the sand in the following amounts and at the following prices:

Shipping costs in dollars per ton from each supplier to each of the plants are as follows:

Labor costs at each of the plants are as follows:

Plant capacities are as follows:

The cleaned and processed silicon dioxide is sold at $50 per ton to the chip manufacturers. Sandbaggers, Inc., can sell all they can produce.

Determine how Sandbaggers, Inc. should plan its operation at the two plants to maximize its profit. The executives of Sandbaggers, Inc. would also like to know whether or not both plants are able to operate at maximum capacity and whether they should look for additional suppliers based on your analysis. Prepare a report for the Sandbaggers, Inc. executives detailing your plan and addressing their questions regarding plant capacity and suppliers.

1-An explanation of how you set up the problem and arrived at your answers. This should include:

• A list of your decision variables and what they represent
• Your objective function, what it represents, all math used to obtain it, and a brief explanation of your math
• All constraints, what they represent, and a brief explanation of how you determined the constraints

2-CAN I HAVE THE SOLUTION DONE WITH SIMPLEX METHOD ???