IF YOU HAVE THE DATA, THE GRAPH AND THE EQUATION, PLEASE EXPLAIN STEP BY STEP HOW TO GET THAT RESULTA) USING EXCEL OR RB) MANUALLY ConcentrationObtain extracted solution (ml) mg/mlcontrol12345048121620Absorbance(A) Inhibition0.3010.2840.2710.2490.2030.103Inhibition%= (A control- A sample/ A control) * 1005.8610.0717.2632.5265.82 % inhibition706050403020100-10LO5y = 3.559x - 16.40R² = 0.8571015Cocentration in mg/mL2025

The question has been answered in step2

Answered: IF YOU HAVE THE DATA, THE GRAPH AND THE…

IF YOU HAVE THE DATA, THE GRAPH AND THE EQUATION, PLEASE EXPLAIN STEP BY STEP HOW TO GET THAT RESULT A) USING EXCEL OR R B) MANUALLY

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: In just a few phrases, describe ALIGN.

A: Given: We have to ALIGN in just few Phrases .

Q: Draw flow chart to estimated salary for the proportion of workers 6 people 5 ID per hour where…

A: 1) For start and stop we have to use oval symbol 2)For calculation we have to use rectangle 3)For…

Q: In just a few phrases, describe ALIGN.

A: The word ALIGN, commonly referred to as alignment, describes how a text is positioned on the screen.…

Q: ou overhear your friend saying that he is repaying a loan at P5,000 every month for the next three…

A: According to the Question below the solution:

Q: PROBLEM 11 Solutions Plus is an industrial chemicals company that produces specialized cleaning…

A: answer starts from step 2

Q: Ineed help with the SQL query for the following question: 1. Get top 5 list of most liked and…

A: Explanation: The below query selects the Top 5 table data based on city, rating and price. The…

Q: In just a few phrases, describe ALIGN.

A: ALIGN: ALIGN is the phrase that is used while attempting to describe how a text is displayed on the…

Q: Explain the following Excel functions, illustrate your answer using example. SUM COUNTIF IF SUMIF

A: The function SUM is used to add the numbers in a certain range given by the user as shown below:…

Q: What is logical field, what are benefits of using this? Explain with example

A: A logical field is a data field that contains any of the following value pairs: a yes/no true/false…

Q: A large spreadsheet contains the following information about local restaurants. A sample portion of…

A: A filter is used in a spreadsheet to select which particular values need to be displayed and which…

Q: Use the table to answer the question. Mayer is looking for a lawn service to take care of his…

A: According to the information given:- Mayer is looking for lawn service for his mother. So we have…

Q: Explain the purpose of decision table in data and processing models and method of creating a…

A: Given:

Q: Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer…

A: Required: Using the “Green Savings” worksheet, provide the formulas to calculate the savings for…

Q: In just a few phrases, describe ALIGN.

A: Solution:-

Q: Choose the correct Excel function to find P(Z ≤0.87)

A: answer is

Q: Using a flow chart, show the flow of funds from fund suppliers to fund demanders!

A: Here is the chart of the flow between the suppliers to demanders.

Q: Question: Define the term "present value", and provide an example.

A: Here is the detailed explanation of the solution

Q: In any type of excel analysis the output range may be one cell or range of cells : A) true. B)…

A: Explanation: A group of cells is defined as a range. One cell is not considered as range. For…

Q: List the name of the division that has more projects than division of “human resource" Tables:…

A: Given Table : Division (DID, dname, managerID) Employee (empID, name, salary, DID) Project (PID,…

Q: Established in 1914, ABC-books is well-known in Accra, Kumasi and Tamale. The shop has operated…

A: answer is in given below :

Q: Select the best answer from the given choices: Using the company schema, when creating the…

A: Actually, database is used to stores the data.

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: Consider these factors while determining the sentinel value you want to use.

A: Sentinel value: An algorithm that employs the existence of a sentinel value as a condition for…

Q: In Excel, how do I figure out how many things I have

A: Introduction: Microsoft Excel: Excel is a spreadsheet application developed by Microsoft Individuals…

Q: 1. To get the TOTAL SALES, add beginning stock and purchased. 2. To get the TOTAL PRICE,…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: With reference to the criteria, what precisely do we mean when we say "complete and consistent"?

A: Introduction: Usually, a good requirements document will include a development plan with additional…

Q: In just a few phrases, describe ALIGN.

A: Alignment relates to the placement and arrangement of text. Microsoft Word's default defaults align…

Q: Why we use decision tables?

A: A decision tree is a tool for making decisions that use a tree-like model of options and their…

Q: Draw the result after applying each of the relational algebra operations on the following table

A: note that sigma is selection operation that can select only based on condition. pi is projection…

Q: Which of the following statements is accurate with respect to the above diagram?

A: the answer is :

Q: If any of the following choices are applicable, please tick them. According to this statement,…

A: Here we discuss small about constraint :…

Q: 1. Determine the Marketing Budget of each location using the Marketing Budget Policy Table Marketing…

A: Location Population Marketing Budget Quezon City 27,61,720 33140640 Makati 5,10,383 3572681…

Q: As of the time of writing, Damon Davis was completing out the paperwork for Drano Plumbing. He…

A: Spreadsheet for Accounting: The unadjusted trial balance, adjustments, adjusted trial balance, and…

Q: Write a SQL statement to get the list of all the tasks that started after 2022-05-10. Include all…

A: This is very simple. We simply need to use the Left Join functionality to perform this. Note: The…

Q: How to do multiple regression in Excel (Please Provide Step-by-Step Instructions)

A: Multiple regression is a mathematical technique that uses several independent variables to make…

Question

IF YOU HAVE THE DATA, THE GRAPH AND THE EQUATION, PLEASE EXPLAIN STEP BY STEP HOW TO GET THAT RESULT

A) USING EXCEL OR R
B) MANUALLY

Concentration
Obtain extracted solution (ml) mg/ml
control
1
2345
0
4
8
12
16
20
Absorbance(A) Inhibition
0.301
0.284
0.271
0.249
0.203
0.103
Inhibition%= (A control- A sample/ A control) * 100
5.86
10.07
17.26
32.52
65.82

% inhibition
70
60
50
40
30
20
10
0
-10
LO
5
y = 3.559x - 16.40
R² = 0.857
10
15
Cocentration in mg/mL
20
25

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Please submit an Excel file that may be used to calculate imputed interest and taxable social security benefits. The spreadsheet should include formulae to help with the computations.
T Shirt Sales t-shirt price quantity sold total revenue $15 400 $6,000 50 100 150 200 250 300 350 400 $10 $15 $17 $25
1) Holiday Inn hires you to examine three hotel locations that can each use some updating. They have $4 million available for the updates. The future revenue projected for each hotel is tied to how much renovation is done, according to the following table: Renovation Amount Future Revenue (in millions) (in millions) $0 $1 $2 $3 Hotel A Hotel B Hotel C $4 $7 $8 $9 $3 $6 $10 $12 $14 $3 $7 $8 $13 $4 $11 $15 Use dynamic programming to determine how to best allocate the $4 million in renovations between the three hotels (assume you can only use $1 million increments).
Below is a set of data containing information about a pizza shop. The data table contains the day data was collected, the amount of customers that bought pizzas that day, and the average amount of pizzas each customer bought. Amount of Customers Average Volume Bought Day Monday Tuesday Wednesday Thursday Friday 15 4 12 17 10 3 25 7 What Excel function would help figure out how many pizzas were bought in total the week this data was collected? [Spreadsheet Modeling] O COUNTIF O IF O SUMPRODUCT O SUM
Q: Why do we use LINQ ? Explain it with some examples.
As of the time of writing, Damon Davis was completing out the paperwork for Drano Plumbing. He estimated a $50,000 net profit would be made. He counted the columns of the balance sheet and knew how much was in the credit column ($300,000) and how much was in the negative column ($400,000). What, in your opinion, was the most plausible reason for the discrepancy in the results? What should he do next to identify the issue's cause if this wasn't the cause of the issue?
Please show the working steps in excel, thank you.
With reference to the criteria, what precisely do we mean when we say "complete and consistent"?
choose a minimum of 10 functions that you wish to demonstrate based on your creativity and skill (should include at least 1 chart & 1 formula). List and describe the chosen functions that you have applied to the data.
Please provide answer and explanation as well
Draw ERD and mention Entity, Attribute & relationship. Question:- A departmental store operates in several cities. In a city, there is one headquarter coordinating the local operations. A city may have several stores. stores hold any amount of items. Customers place their orders for any number of items to a given store.
Consider these factors while determining the sentinel value you want to use.