1, A binomial probability experiment is conducted with the given parameters. Compute the probability of x successes in the n independent trials of the experiment.

n=10, p=0.5, x=4

p(4)

​(Do not round until the final answer. Then round to four decimal places as​ needed.)

2, A binomial probability experiment is conducted with the given parameters. Compute the probability of x successes in the n independent trials of the experiment.

p(38)=

​(Do not round until the final answer. Then round to four decimal places as​ needed.)

3, A binomial probability experiment is conducted with the given parameters. Compute the probability of x successes in the n independent trials of the experiment.

n=9, p=0.7, x≤3

The probability of x less than or equals x≤3 successes is nothing.

​(Round to four decimal places as​ needed.)

4, A binomial probability experiment is conducted with the given parameters. Use technology to find the probability of x successes in the n independent trials of the experiment.

n=8​, p=0.2​, x<4

p(x<4)=

​(Round to four decimal places as​ needed.)

5, A binomial probability experiment is conducted with the given parameters. Compute the probability of x successes in the n independent trials of the experiment.

n=10​, p=0.25​, x≤4

The probability of x≤4 successes is nothing.

​(Round to four decimal places as​ needed.)

I have attached the following script file

Q1) List the full name of members, their DETAIL_DAILYLATEFEE and the average of DETAIL_DAILYLATEFEE for all members whose DETAIL_DAILYLATEFEE is less than the average of all DETAIL_DAILYLATEFEE.
Your query MUST contain a subquery.
Your result should be as shown below. Note that each member is only listed once.
Required: AVG(DETAIL_DAILYLATEFEE)
CONCAT
DISTINCT
Restricted: GROUP BY

Q2) Management is also interested in finding out the age of their movies (i.e. how old the movies are) in number of years compared to the average age (in rounded number of years) of all movies in their stock. They want a report that lists information about the title, year, genre and how many 'Years Old' a movie is, for all movies that are newer than the average age (in rounded years) of all movies. (For example, if the average age of all movies is X, list all movies with age < X)  
Required:
ROUND(AVG(MOVIE_YEAR))
YEAR(NOW()) - MOVIE_YEAR

-- Comment the following two lines if creating database in Mimir or Bluenose
create schema if not exists DVD_vidrental;
use DVD_vidrental;

DROP TABLE IF EXISTS `detailrental`;
DROP TABLE IF EXISTS `rental`;
DROP TABLE IF EXISTS `video`;
DROP TABLE IF EXISTS `movie`;
DROP TABLE IF EXISTS `price`;
DROP TABLE IF EXISTS `membership`;

CREATE TABLE `membership` (
`MEM_NUM` decimal(8,0) NOT NULL,
`MEM_FNAME` varchar(30) NOT NULL,
`MEM_LNAME` varchar(30) NOT NULL,
`MEM_STREET` varchar(120) DEFAULT NULL,
`MEM_CITY` varchar(50) DEFAULT NULL,
`MEM_STATE` char(2) DEFAULT NULL,
`MEM_ZIP` char(5) DEFAULT NULL,
`MEM_BALANCE` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`MEM_NUM`)
);

CREATE TABLE `price` (
`PRICE_CODE` decimal(2,0) NOT NULL,
`PRICE_DESCRIPTION` varchar(20) NOT NULL,
`PRICE_RENTFEE` decimal(5,2) DEFAULT NULL,
`PRICE_DAILYLATEFEE` decimal(5,2) DEFAULT NULL,
PRIMARY KEY (`PRICE_CODE`)
);

CREATE TABLE `movie` (
`MOVIE_NUM` decimal(8,0) NOT NULL,
`MOVIE_TITLE` varchar(75) NOT NULL,
`MOVIE_YEAR` decimal(4,0) DEFAULT NULL,
`MOVIE_COST` decimal(5,2) DEFAULT NULL,
`MOVIE_GENRE` varchar(50) DEFAULT NULL,
`PRICE_CODE` decimal(2,0) DEFAULT NULL,
PRIMARY KEY (`MOVIE_NUM`),
KEY `PRICE_CODE` (`PRICE_CODE`),
CONSTRAINT `movie_ibfk_1` FOREIGN KEY (`PRICE_CODE`) REFERENCES `price` (`PRICE_CODE`)
);

CREATE TABLE `video` (
`VID_NUM` decimal(8,0) NOT NULL,
`VID_INDATE` date DEFAULT NULL,
`MOVIE_NUM` decimal(8,0) DEFAULT NULL,
PRIMARY KEY (`VID_NUM`),
KEY `MOVIE_NUM` (`MOVIE_NUM`),
CONSTRAINT `video_ibfk_1` FOREIGN KEY (`MOVIE_NUM`) REFERENCES `movie` (`MOVIE_NUM`)
);

CREATE TABLE `rental` (
`RENT_NUM` decimal(8,0) NOT NULL,
`RENT_DATE` date DEFAULT NULL,
`MEM_NUM` decimal(8,0) DEFAULT NULL,
PRIMARY KEY (`RENT_NUM`),
KEY `MEM_NUM` (`MEM_NUM`),
CONSTRAINT `rental_ibfk_1` FOREIGN KEY (`MEM_NUM`) REFERENCES `membership` (`MEM_NUM`)
);

CREATE TABLE `detailrental` (
`RENT_NUM` decimal(8,0) NOT NULL,
`VID_NUM` decimal(8,0) NOT NULL,
`DETAIL_FEE` decimal(5,2) DEFAULT NULL,
`DETAIL_DUEDATE` date DEFAULT NULL,
`DETAIL_RETURNDATE` date DEFAULT NULL,
`DETAIL_DAILYLATEFEE` decimal(5,2) DEFAULT NULL,
PRIMARY KEY (`RENT_NUM`,`VID_NUM`),
KEY `VID_NUM` (`VID_NUM`),
CONSTRAINT `detailrental_ibfk_1` FOREIGN KEY (`RENT_NUM`) REFERENCES `rental` (`RENT_NUM`),
CONSTRAINT `detailrental_ibfk_2` FOREIGN KEY (`VID_NUM`) REFERENCES `video` (`VID_NUM`)
);

START TRANSACTION;

INSERT INTO `membership` VALUES (102,'TAMI','DAWSON','2632 TAKLI CIRCLE','NORENE','TN','37136',11.00),
(103,'CURT','KNIGHT','4025 CORNELL COURT','FLATGAP','KY','41219',6.00),
(104,'JAMAL','MELENDEZ','788 EAST 145TH AVENUE','QUEBECK','TN','38579',0.00),
(105,'IVA','MCCLAIN','6045 MUSKET BALL CIRCLE','SUMMIT','KY','42783',15.00),
(106,'MIRANDA','PARKS','4469 MAXWELL PLACE','GERMANTOWN','TN','38183',0.00),
(107,'ROSARIO','ELLIOTT','7578 DANNER AVENUE','COLUMBIA','TN','38402',5.00),
(108,'MATTIE','GUY','4390 EVERGREEN STREET','LILY','KY','40740',0.00),
(109,'CLINT','OCHOA','1711 ELM STREET','GREENEVILLE','TN','37745',10.00),
(110,'LEWIS','ROSALES','4524 SOUTHWIND CIRCLE','COUNCE','TN','38326',0.00),
(111,'STACY','MANN','2789 EAST COOK AVENUE','MURFREESBORO','TN','37132',8.00),
(112,'LUIS','TRUJILLO','7267 MELVIN AVENUE','HEISKELL','TN','37754',3.00),
(113,'MINNIE','GONZALES','6430 VASILI DRIVE','WILLISTON','TN','38076',0.00);

INSERT INTO `price` VALUES (1,'Standard',3.00,1.00),
(2,'New Release',4.50,3.00),(3,'Discount',2.50,1.00),
(4,'Weekly Special',2.00,0.50);
INSERT INTO `movie` VALUES (1234,'The Cesar Family Christmas',2014,39.95,'FAMILY',2),
(1235,'Smokey Mountain Wildlife',2011,59.95,'ACTION',3),(1236,'Richard Goodhope',2015,59.95,'DRAMA',2),
(1237,'Beatnik Fever',2014,29.95,'COMEDY',2),(1238,'Constant Companion',2015,89.95,'DRAMA',NULL),
(1239,'Where Hope Dies',2005,25.49,'DRAMA',3),(1245,'Time to Burn',2015,45.49,'ACTION',3),
(1246,'What He Doesn\'t Know',2013,58.29,'COMEDY',1);
INSERT INTO `video` VALUES (34341,'2014-01-22',1235),(34342,'2014-01-22',1235),
(34366,'2016-03-02',1236),(34367,'2016-03-02',1236),(34368,'2016-03-02',1236),
(34369,'2016-03-02',1236),(44392,'2015-10-21',1237),(44397,'2015-10-21',1237),
(54321,'2015-06-18',1234),(54324,'2015-06-18',1234),(54325,'2015-06-18',1234),
(59237,'2016-02-14',1237),(61353,'2013-01-28',1245),(61354,'2013-01-28',1245),
(61367,'2015-07-30',1246),(61369,'2015-07-30',1246),(61388,'2014-01-25',1239);
INSERT INTO `rental` VALUES (1001,'2016-03-01',103),(1002,'2016-03-01',105),
(1003,'2016-03-02',102),(1004,'2016-03-02',110),(1005,'2016-03-02',111),
(1006,'2016-03-02',107),(1007,'2016-03-02',104),(1008,'2016-03-03',105),(1009,'2016-03-03',111);
INSERT INTO `detailrental` VALUES (1001,34342,2.00,'2016-03-04','2016-03-02',NULL),
(1001,34366,3.50,'2016-03-04','2016-03-02',3.00),(1001,61353,2.00,'2016-03-04','2016-03-03',1.00),
(1002,59237,3.50,'2016-03-04','2016-03-04',3.00),(1003,54325,3.50,'2016-03-04','2016-03-09',3.00),
(1003,61369,2.00,'2016-03-06','2016-03-09',1.00),(1003,61388,0.00,'2016-03-06','2016-03-09',1.00),
(1004,34341,2.00,'2016-03-07','2016-03-07',1.00),(1004,34367,3.50,'2016-03-05','2016-03-07',3.00),
(1004,44392,3.50,'2016-03-05','2016-03-07',3.00),(1005,34342,2.00,'2016-03-07','2016-03-05',1.00),
(1005,44397,3.50,'2016-03-05','2016-03-05',3.00),(1006,34366,3.50,'2016-03-05','2016-03-04',3.00),
(1006,61367,2.00,'2016-03-07',NULL,1.00),(1007,34368,3.50,'2016-03-05',NULL,3.00),
(1008,34369,3.50,'2016-03-05','2016-03-05',3.00),
(1009,54324,3.50,'2016-03-05',NULL,3.00);

COMMIT;

show that for any two vectors u and v in an inner product space

||u+v||^2+||u-v||^2=2(||u||^2+||v||^2)

give a geometric interpretation of this result fot he vector space R^2

Calculus dictates that
(∂U/∂V) T,Ni = T(∂S/∂V)T,Ni – p = T(∂p/∂T)V,Ni – p

(a) Calculate (∂U/∂V) T,N for an ideal gas [ for which p = nRT/V ]

(b) Calculate (∂U/∂V) T,N for a van der Waals gas
[ for which p = nRT/(V–nb) – a (n/V)2 ]

(c) Give a physical explanation for the difference between the two.

(Note: Since the mole number n is just the particle number N divided by Avogadro’s number, holding one constant is equivalent to holding the other constant.)

In the experiment: To determine the resistivity of a semiconductor using Four probe method.

What does the floating potential mean? Like what's the difference between potential and floating potential?

Also what does the correction factor in this experiment signify? Like why do we need the correction factor in this experiment?
The value of the correction factor in this experiment is G7 which is 2ln2.

The Cauchy-Schwarz Inequality Let u and v be vectors in R 2 .

We wish to prove that ->    (u · v)^ 2 ≤ |u|^ 2 |v|^2 .

This inequality is called the Cauchy-Schwarz inequality and is one of the most important inequalities in linear algebra.

One way to do this to use the angle relation of the dot product (do it!). Another way is a bit longer, but can be considered an application of optimization. First, assume that the two vectors are unit in size and consider the constrained optimization problem:

Maximize u · v

Subject to |u| = 1 |v| = 1.

Note that |u| = 1 is equivalent to |u| 2 = u · u = 1.

(a) Let u = a b and v = c d . Rewrite the above maximization problem in terms of a, b, c, d.

(b) Use Lagrange multipliers to show that u · v is maximized provided u = v.

(c) Explain why the maximum value of u · v must, therefore, be 1.

(d) Find the minimum value of u · v and explain why for any unit vectors u and v we must have |u · v| ≤ 1.

(e) Let u and v be any vectors in R 2 (not necessarily unit). Apply your conclusion above to the vectors: u |u| and v |v| to show that (u · v) ^2 ≤ |u|^ 2 |v|^ 2 .

A basis of a vector space V is a maximal linearly independent set of vectors in V . Similarly, one can view it as a minimal spanning set of vectors in V . Prove that any set S ⊆ V spanning a finite-dimensional vector space V contains a basis of V .

• Describe an experiment for electrostatic force and record your experiment with your phone.Describe your experiment and answer the following questions about each object:
• Is it a conductor or an insulator?
• Is it charged or neutral?
• If it is charged, describe how you charged it. Is it positively charged or negatively charged?
• If it is neutral, describe how it still attracted or repulsed by a charged object.
• You can answer these questions by either narrating your video, or by submitting a separate word file. There is no need to get fancy production wise unless you want to submit it to TikTok

You can choose either a repulsive interaction, or an attractive one.

Consider the following reduction potentials:

Mg2+ + 2e- → Mg

E° = -2.37 V

V2+ + 2e- → V

E° = -1.18 V

Cu2+ + e- → Cu+

E° = +0.15 V

Which one of the following reactions will proceed spontaneously?

• Mg2+ + V → V2+ + Mg

• Mg2+ + 2Cu+ → 2Cu2+ + Mg

• V2+ + 2Cu+ → V + 2Cu2+

• V + 2Cu2+ → V2+ + 2Cu+

Question 48

What is the minimum size of an Ethernet frame?

Group of answer choices

64 bytes

1,024 bytes

256 bytes

1,500 bytes

Question 49

Data is organized into frames for transmission at which OSI level?

Group of answer choices

Application

Network

Data Link

Transport

Question 50

Which of the following devices does not limit network broadcast traffic and does not increase performance?

Group of answer choices

Router

NIC

Hub

Switch

Question 51

Which of the OSI layers does IP operate?

Group of answer choices

Session

Transport

Physical

Data Link

Network

Presentation

Application

Question 52

You have an interface on a router with the IP address of 192.168.192.10/29. What is the broadcast address the hosts will use on this LAN?

Group of answer choices

192.168.192.15

192.168.192.127

192.168.192.31

192.168.192.255

192.168.192.63

Question 53

What is the distance limitation of 100BaseT?

Group of answer choices

100 meters

250 meters

185 meters

500 meters

Question 54

Which layer of the TCP/IP model is mapped to the bottom two layers of the OSI model?

Group of answer choices

Internet

Link

Application

Transport

Question 55

A MAC address is composed of which two parts?

Group of answer choices

the network address and the node address

the computer name and the node address

the organizationally unique identifier and the unique device ID of the NIC

the IP address and the NICs serial number

Question 56

Which layer of the TCP/IP model is mapped to the top three layers of the OSI model?

Group of answer choices

Internet

Link

Application

Transport

Question 57

Which of the following can operate at both layers 2 and 3 of the OSI model?

Group of answer choices

Bridge

Switch

Repeater

Hub

Question 58

Which of the following is not identified in a cabling specification such as 10BaseT?

Group of answer choices

the signal type

the maximum length

the speed

the maximum number of routers

Question 59

Which of the following OSI layers is responsible for establishing connections between two devices?

Group of answer choices

Session

Transport

Network

Application

Question 60

Which setting configures a network interface to both send and receive data, but not at the same time?

Group of answer choices

Simplex

Full duplex

Half duplex

Time-division duplexing

Question 61

A network device that is used to connect multiple devices without segmenting a network is a:

Group of answer choices

router

bridge

hub

switch

Question 62

If your network subnet mask is /16, what is the maximum number of host IDs available for this network?

Group of answer choices

62

254

65,534

16,277,214

Question 63

What is the binary equivalent of the decimal value 97?

Group of answer choices

00110001

01100001

01001110

01101010

Question 64

Which network card setting configures the interface to send and receive data at the same time?

Group of answer choices

Simplex

Full duplex

Half duplex

Time-division duplexing

Question 65

Which of the following network components would be used to create VLANs?

Group of answer choices

Routers

Gateways

Switches

Bridges

Question 66

A host is rebooted and you view the IP address that it was assigned. The address is 169.123.13.34. Which of the following happened?

Group of answer choices

The host received an APIPA address

The host received a public address

The host receive a multicast address

The host received a private address

Question 67

What is the maximum number of IP addresses that can be assigned to hosts on a local subnet that uses the 255.255.255.224 subnet mask?

Group of answer choices

14

30

15

31

16

62

Question 68

What information do bridges use to determine whether to forward traffic?

Group of answer choices

MAC addresses

IP addresses

traffic conditions at the time

nothing because bridges forward all traffic