colleen is searching online for tickets two weeks ago the cost to fly from orlando to hartford was 200$ . Now the cost is 335$ w
2 answers:
You might be interested in
Table for the question is attached in the picture below :
Answer:
SELECT distinct(TRUCK_ID), WEIGHT from SHIPMENT where WEIGHT < 800 ;
Step-by-step explanation:
The Structured query language (SQL) defined above, returns only the TRUCK_ID and Weight column from the shipment table as they are the only two columns listed after the select keyword. The condition is added using the WHERE keyword on the weight table, this filters the result returned to include only rows where the weight value is less than 800. The distinct keyword used alongside the TRUCK_ID column ensures that a certian TRUCK_ID value isn't returned more than once (Hence, it is used to avoid duplicates).
Answer:
See below
Step-by-step explanation:
<h3>Continuation of the question</h3><u>Data in the table:</u>
<u>PH 4 5 6 7 8 9 10 11 </u>
<u>Bacteria 116 120 131 136 141 151 148 163</u>
- <em>Create a scatter plot to represent the data: Based on the data and your scatter plot, what do you think a good linear function would be to represent the data?</em>
<em>See attached for scatter plot</em>
We can see the chart is close to linear function. Let's build one based on data in the table
<u>The line will be in the form of:</u>
- y = mx + b
<u>If we use two points and get the equation</u>
- (4, 116) and (8, 141)
<u>Finding the slope:</u>
- m = (141-116)/(8-4) = 25/4 = 6.25
<u>Then, finding y-intercept:</u>
- 116 = 6.25*4 + b
- b = 116 - 25 = 91
<u>So the line is:</u>
- y = 6.25x + 91
<em>Note: This is approximate best fit graph and it is attached as well. Exact formula for the line is built by using different method and is very close to the one above</em>
