9. Give an example of a spreadsheet formula that uses cell references and the most efficient formula to mathematically calculate each of the following: If A1=15, B1=100, C1-200 Calculate the product of 15 and 100 Calculate the average of 15, 100, 200 Calculate the highest number of 15,100, 200 Calculate the difference of 200 and 100 Calculate the lowest number of 15, 100, 200 Formula
Q: 14x^2-13x-12 using factor by grouping
A: let K=14x2-13x-12
Q: In a particular city, taxicabs charge passengers $2.20 for entering a cab and then $0.50 for each…
A:
Q: Assignment: Consider the region bounded by the parabolas: 2 2 y = x² + 4x + 3 and y = x + 2x + 3.…
A: We need to find volume.
Q: Approximate the area under each curve over the specified interval by using the indicated number of…
A:
Q: Find the vector parametrization r(t) of the line L that passes through the points (4, 1, 2) and (9,…
A: The line L passes through points 4,1,2 and 9,3,7
Q: Solve the given differential equation by separation of variables. y In(x) dx = (y + ¹)² dy
A:
Q: Find a Cartesian equation relating and y corresponding to the parametric equations Write your answer…
A:
Q: If you want to earn 15% annual simple interest on an investment, how much should you pay for a note…
A: Simple interest Formula is given as SI = P×R×t100 Where P is the principal amount R is the rate of…
Q: The radius of a right circular cone is increasing at a rate of 1.2 in/s while its height is…
A: given radius of a right circular cone is increasing at a rate of 1.2ins and height is decreasing at…
Q: Use the one-to-one property of logarithms to find an exact solution for If there is no solution,…
A: Here we have given a logarithmic expression: ln7+ln7x2-6=ln39 Properties we will use here are given…
Q: Use the chain rule to find dz dt || dz dt z = sin(x) cos(y), x = √t₁ y || LO 5 + |
A:
Q: In this problem, y=c₁ex + c₂e-x is a two-parameter family of solutions of the second-order DE y" - y…
A: Given that , y = c1ex + c2e-x is a solution of the differential equation y''-y =0. We have to…
Q: If land that can be farmed L is eroding continuously at a rate of 4.5% per year because of changing…
A: “Since you have asked multiple questions (a and b are not related to each other), we will solve the…
Q: Separating the variables in the equation A. ve *dy = xảy ydy B. = xex dx II C. Jdy = xe-X d D. ydy =…
A: Given data differential equation ye-xdydx=x
Q: (a) Show that (b) Solve the equation -1 cos(2 tan ¹x): = (d) Find the general solution to cos 7x…
A: Note : As per our Guidelines , we can solve first part as your all parts not too small . Please…
Q: Consider the function are true? 1. lim f(x) = 70 II. lim f(x) = 70 III. lim x) = 100 X-8 IV. lim x)…
A: Given function f( x ) = 100 - 12000400 + 3000axWhere a < 0 < 1
Q: Find a parametrization of the line in which the planes x+y+z=4 and y + z = 8 intersect. Find the…
A:
Q: (a) Find the intervals of increase or decrease. (b) Find the local maximum and minimum values. (c)…
A: Given conditions: The given function is y=x⋅x+3 What we need to find: (a) Intervals of increase or…
Q: 2. Consider the function: a) Determine the derivative. y = 2sinx b) Calculate the exact value of x…
A:
Q: 2 Find the curvature of the parabola given by Y = X = = x ² a+ x=2 Sketch the circle of curvature at…
A:
Q: x² c² and y=c²x² is 2 C - 2 Find c> 0 such that the area of the region enclosed by the parabolas y =…
A:
Q: Σ(-1)" √TI 2n + 3
A:
Q: 5. Consider the following function: f(x)= e* (3x³) a. Determine the critical points of such function…
A: For a function f( x ) , we can find critical points by f'( x ) = 0 Inflection points by f''( x ) =…
Q: When an initial amount of money, A, in dollars, is invested into an account that earns interest…
A: Total 4 parts Value at time t Average and instantaneous rate of change
Q: Find the equation for the plane through the points Po(-2,-4,5), Qo(4, -3,1), and Ro(-3,4,-3 Using a…
A:
Q: Evaluate the double integral ∬(x^4)dA, where D is the top half of the disc with center the origin…
A:
Q: Let F(x, y, z) = xi + yj + zk. Evaluate the integral of F along each of the following paths. (a)…
A:
Q: This was for question D I did not need A,B,C
A: We need to compute the average rate of change of the future value of the account between year 9 and…
Q: Given the function f(x) = 18x + 3, determine the intervals where increasing and decreasing, and the…
A: The function fx=-2x3-12x2-18x+3⇒f'x=-6x2-24x-18=-6x2+4x+3=-6x+3x+1⇒f''x=-12x-24=-12x+2
Q: A tumor is injected with 0.82 grams of Iodine-125. After 1 day, the amount of lodine-125 has…
A: Law of Decay is given as P = P0e-kt where P is the amount after time t P0 is the initial amount k…
Q: A circular swimming pool has a diameter of 12 m, the sides are 3 m high, and the depth of the water…
A:
Q: ou want to earn 13% annual simple interest on an investment, how much should you pay for a note that…
A: We know that the formula A=p(1+rt) Where A is an amount and P= principal r= rate of interest t=…
Q: An Internet bookstore charges $20 shipping for orders under $100 but provides free shipping for…
A: C(x) = x + 20 if x < 100 = x if x ≥ 100
Q: (3) Find the equation of the line tangent to f(x)=√x atx=4
A:
Q: Quadratic equations are not nol in the form f(x) = ax²+bx+c to find (h, k). Begin by completing the…
A:
Q: Use the chain rule to find əz Əs z = (x - y)², x = s²t, y = st² дz at = and az z =…
A: ∂z∂s = ∂z∂x×∂x∂s using chain rulewhere∂z∂x is partial differentiation of z with respect to x keeping…
Q: If you want to earn 15% annual simple interest on an investment, how much should you pay for a note…
A: It is given that the annual simple interest on the investment is 15%. also the amount after 3…
Q: The daily demand function for x LED lights sold by a major retailer is p=722.5-0.25z dollars, and…
A: Given Demand Function p = 722.5 - 0.25x Given average cost function C¯ = 250 + 2x Let profit…
Q: The region bounded by f(x) = -3x² + 18x + 81, x = ( volume of the solid of revolution. Find the…
A:
Q: Find the exact slope of the tangent line to the parametric curve t = ㅠ 3 Give an exact answer, do…
A: We know that the slope formula of parametric equation is dy/dx=(dy/dt)/(dx/dt)
Q: If f is a differentiable function and f'(x)=x4 point at =x²+2x³ - 15x²2, then f has an inflection 3
A:
Q: -5.4 Rewrite e =h as an equivalent logarithmic equation. Enclose arguments of functions in…
A: Given :- e-5.4=h To Rewrite :- The given equation as an equivalent logarithmic equation.
Q: 5. The golf ball manufacturer, Pro-T, has developed a profit model that depends on the number x of…
A: To find : maximum profit and values of x and y to maximize it.
Q: (4) Suppose V(t) represents the volume (in gallons) of water in a tank at time t, where t is the…
A: Solving the problem
Q: - Consider the surface F(x, y, z) = x626 + sin(y³z6) — 10 = 0. Find the following partial…
A:
Q: The Candy Factory sells candy by the pound, charging $1.60 per pound for quantities up to and…
A: Given, px = 1.60x for x ≤ 301.30x+k for x > 30 We have to find the value of k such that…
Q: 1 9 3 * 3 2 * -2 4 - 4 -4 The graph above shows the base of an object. Compute the exact value of…
A:
Q: Use the graph of the function f shown to the right to find f(-4), f(-3), and f(-2). f(-4)= f(-3) =…
A:
Q: Find the mass of the two-dimensional a density function of p(x)= x³-5x + 6. object. An oversized…
A:
Q: State the domain, vertical asymptote, and end behavior of the function. g(x) = ln (3x +21) + 1.1…
A: gx=ln3x+21+1.1
Step by step
Solved in 3 steps with 1 images
- 1. Suppose that, in Example 2.27, 400 units of food A, 600 units of B, and 600 units of C are placed in the test tube each day and the data on daily food consumption by the bacteria (in units per day) are as shown in Table 2.6. How many bacteria of each strain can coexist in the test tube and consume all of the food? Table 2.6 Bacteria Strain I Bacteria Strain II Bacteria Strain III Food A 1 2 0 Food B 2 1 1 Food C 1 1 2How do i find the occupancy rate for multiple lots? This spreadsheets contains more lots than given. I only provided are part of lot 1 and a part of lot 2 because the file is too large. They all run together in one file and need the occupancy rate which is column D on my spreadsheet. LotCode LotCapacity LotOccupancy OccupancyRate TimeStamp Day Lot01 863 174 11/20/2016 8:01 Sunday Lot01 863 179 11/20/2016 8:27 Sunday Lot01 863 189 11/20/2016 9:01 Sunday Lot01 863 197 11/20/2016 9:27 Sunday Lot01 863 226 11/20/2016 10:01 Sunday Lot01 863 247 11/20/2016 10:27 Sunday Lot01 863 331 11/20/2016 11:01 Sunday Lot01 863 400 11/20/2016 11:27 Sunday Lot01 863 469 11/20/2016 12:01 Sunday Lot01 863 510 11/20/2016 12:34 Sunday Lot01 863 594 11/20/2016 13:07 Sunday Lot01 863 618 11/20/2016 13:27 Sunday Lot01 863 637 11/20/2016 14:01 Sunday Lot01 863 655 11/20/2016 14:27 Sunday Lot01 863 634 11/20/2016 15:01 Sunday Lot01 863 597…Johnson Filtration, Inc. provides maintenance service for water-filtration systems. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. Repair Time(hours) Months SinceLast Service Type ofRepair Repairperson 2.9 2 electrical Dave Newton 3.0 6 mechanical Dave Newton 4.8 8 electrical Bob Jones 1.8 3 mechanical Dave Newton 2.9 2 electrical Dave Newton 4.9 7 electrical Bob Jones 4.2 9 mechanical Bob Jones 4.8 8 mechanical Bob Jones 4.4 4 electrical Bob Jones 4.5 6 electrical Dave Newton Ignore for now the months since the last maintenance service (x1 ) and the repairperson who performed the service. Develop the estimated simple linear regression equation to predict the repair time (y) given the…
- A company that sells digital devices has its stores in several cities in Albania. The Marketing Manager plans to transmite an advertisement for the digital camera product on local television and watch sales of that product, to see the link that exists with the number of ads transmitted and product sales. After two days, the results were presented in the following table: City Trasmitted Sales(in 000 Euro) Durrës 4 15 Sarandë 2 8 Fier 5 21 Berat 6 24 Lezhë 3 17 S S = 1.58 S = 6.1 a) What is the dependent variable?b) Construct the scatterdiagram of this connection.c) Calculate the coefficient of variation and the coefficient of determination.d) Interpret the relationship between two variables.e) What is the equation that connects these two variables? Explain the values for a and b.f) What is the expected level of sales if 10 ads are trasmittedAn engineer is studying the mileage performance characteristics of 5 types of gasoline additives. In the road test he wishes to use cars as blocks; however, because of a time constraint, he must use an incomplete block design. He runs the balanced design with the five blocks that follow. Car Additive 1 2 3 4 5 1 NA 17 14 13 12 2 14 14 NA 13 10 3 12 NA 13 12 9 4 13 11 11 12 NA 5 11 12 10 NA 8 - Verify that this is a balanced incomplete block design - Obtain the estimates of the treatment means and the treatments effectsIt is often said that the economy of Arizona depends on the “Five C’s”: Copper, Cattle, Cotton, Citrus, andClimate. Assume a (highly simplified) model of the Arizona Economy that depends only on C1, C2, C3, C4,and C5, which represent the number of economic units (pennies, pounds, etc) purchased of each of the FiveC’s, respectively. Further assume that the Utility, or Economic Value (which is different from DollarValue), can be described by the function:U(C1, C2, C3, C4, C5) = C1∙C2∙C3∙C4∙C5As a mathematical function, does U have a maximum or minimum value? What values of Ci correspond tothe minimum value of U? What values of Ci correspond to the maximum value of U? Do these values of Cimake sense from an economic standpoint?
- An entrepreneur is deciding how to subdivide a large old home toconvert it to a Bed-and-Breakfast (B&B). There are four alternatives: OptionA renovates all rooms, but leaves all walls intact, so the result would be twodouble rooms and three single rooms on the top floor, and on the main floor two further single rooms with a shared bathroom. Option B would renovate only the second floor but combine the single rooms in the main floor to create a single room with a bathroom. Option C combines the main floor rooms to create a single room with a bathroom, and combines the three single rooms on the top floor to create two double rooms. Finally option D would create five double rooms, each with its own bathroom. There are three event possibilities, a high demand, an average demand, and a low demand. The entrepreneur believes the probability of each event depends on the layout and availability of the rooms. Below are the details of the predicted income and the probability of occurrence…Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rods is $2,200, and the cost required to set up the production line for the 6-cylinder connecting rods is $3,300. Manufacturing costs are $12 for each 4-cylinder connecting rod and $16 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufactured the following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line. Once the line has been set up, the weekly production capacities are 6,000 6-cylinder connecting rods and 8,000 4-cylinder connecting rods. Let x4 = the number of 4-cylinder connecting rods produced next week x6 = the number of 6-cylinder connecting rods produced next week s4 = 1 if the production line is set up to…Consider two small companies, each with 9 employees including 1 boss with the highest salary in each company, and 8 people working for them with lower salaries. The table below gives the annual salaries of the people in each company. These salaries are identical except for the fact that Small Company B is more profitable overall, and their boss decides to keep a much higher salary than the boss of Small Company A. Small Company A Small Company B $85 000 (boss A) $360 000 (boss B) $65 000 $65 000 $60 000 $60 000 $40 000 $40 000 $35 000 $35 000 $35 000 $35 000 $35 000 $35 000 $30 000 $30 000 $30 000 $30 000 For each of the two companies, calculate the mean, median, and mode, and show your answers and calculations in the space below (rounded to the nearest thousands place). After you answer this question, answer the two follow-up questions about the results you just calculated.
- Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computerized wheel alignment and balancing machine. Managers feel that maintenance expense is related to usage of the machine, and they have collected the following information on weekly usage of the machine (in hours) and annual maintenance expense (in hundreds of dollars) from 10 other companies that own the machine.Company Weekly Usage(hours) Annual maintenance Expense(hundreds of dollars)A 13 17.0B 10 22.0C 20 30.0D 28 37.0E 32 47.0F 17…A diabetic patient needs at least 30 units of vitamin A, at least 45 of vitamin C, andat least 30 of vitamin E each day. Each brand X multivitamin capsule contains 4units of A, 6 of C, and 2 of E; each brand Y capsule contains 5 units of A, 3 of C,and 5 of E. If each brand X capsule costs ₱ 6 and each brand Y costs ₱ 9, howmany capsules should the patient take each day in order to minimize the cost?The following question is based on the following information about the stocks of KT Corporation, International Flavors & Fragrances, and Quality Systems. Price Dividend Yield KT (KT Corporation) $16 7% IFF (InternationalFlavors & Fragrances) $56 2% QSII (Quality Systems) $80 2% You invested a total of $11,600 in shares of the three stocks at the given prices, and expected to earn $272 in annual dividends. If you purchased a total of 200 shares, how many shares of each stock did you purchase? KT IFF QSII