In this experiment you will use an online circuit board to build three circuits: a series circuit with three resistors, a parallel circuit with three resistors, and a circuit with a combination of parallel and series resistors. You will use an ammeter and a volt meter to measure the current flow and voltage across the resistors in the circuits. After you record the results of your experiment, you will be able to compare the measurements you take with what Ohm’s Law predicts. You will record the data in the Experiment Worksheet and answer questions as indicated in the experiment worksheet. Your answers should be presented in a report format.

Series Circuit Set Up

Place a battery from slide 1 in the upper middle portion of the blue work space. Place and connect a switch to the right of the battery. Place and connect an ammeter to the right of the switch (placing it in-line where we want to measure the amperage). The ammeter can be found in the second box on the right side. Moving vertically, place three (3) resistors from slide 1 in series. These will be referred to as R1, R2, and R3, respectively, from left to right. On the left side, place a wire connected to the left end of the battery and running to left and then downward, stretched to about the same height as the resistors on the right side. Place and stretch a wire running horizontally to connect the left wire and right resistors. Click on the first resistor (R1) and adjust the resistance to 4 Ω. Repeat for the other resistors. Click on the battery to ensure it is set to 10.0 V. Place a voltmeter across the first resistor and measure the voltage.

Identification of a Communication Theory: Uncertainty Reduction Theory

What is axiology all about? How would the author of the theory answer the 3 specific axiological questions? How do you know the author would answer the questions in this way (i.e., provide evidence from the theory that led you to your conclusions) - (Based on Burgoon article and Olson article)

There are 4 big houses in my home town. They are made from these materials: red marbles, green marbles, white marbles and blue marbles. We know the following facts:

• Mrs Jennifer's house is somewhere to the left of the green marbles one.
• The third one along is white marbles
• Mrs Sharon owns a red marbles house.
• Mr Cruz does not live at either end, but somewhere to the right of the blue marbles house.
• Mr Danny lives in the fourth house
• The first house is not made from red marbles.

Who lives where, and what is their house made from?

QS 16-13 Computing cash from asset sales LO P3

Furniture costing $71,500 is sold at its book value in 2019. Acquisitions of furniture total $61,900 cash, on which no depreciation is necessary because it is acquired at year-end. Complete the general ledger accounts to calculate cash received from the sale of furniture.

Complete the general ledger accounts to calculate cash received from the sale of furniture.

All the question should be solved using IF statement
Q1) List the Full Name, the city, and the state of all members, and order them by their first name in descending order (Z-A) if they are from 'KY' or by their last name in ascending order (A-Z) when they are from 'TN' state.

Q2) List the total number of movies for each genre (FAMILY, ACTION, DRAMA, COMEDY).

- 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;

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding.

Santa Fe black-on-white is a type of pottery commonly found at archaeological excavations at a certain monument. At one excavation site a sample of 586 potsherds was found, of which 358 were identified as Santa Fe black-on-white.

(a) Let p represent the proportion of Santa Fe black-on-white potsherds at the excavation site. Find a point estimate for p. (Round your answer to four decimal places.)


(b) Find a 95% confidence interval for p. (Round your answers to three decimal places.)

Give a brief statement of the meaning of the confidence interval.

95% of the confidence intervals created using this method would include the true proportion of potsherds. 5% of the confidence intervals created using this method would include the true proportion of potsherds.     95% of all confidence intervals would include the true proportion of potsherds. 5% of all confidence intervals would include the true proportion of potsherds.

(c) Do you think that np > 5 and nq > 5 are satisfied for this problem? Explain why this would be an important consideration.

Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately normal. No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately normal.     No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately binomial. Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately binomial.

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding. Santa Fe black-on-white is a type of pottery commonly found at archaeological excavations at a certain monument. At one excavation site a sample of 572 potsherds was found, of which 353 were identified as Santa Fe black-on-white. (a) Let p represent the proportion of Santa Fe black-on-white potsherds at the excavation site. Find a point estimate for p. (Round answer to four decimal places.)

(b) Find a 95% confidence interval for p. (Round answers to three decimal places.)

lower limit

upper limit

Give a brief statement of the meaning of the confidence interval.

5% of the confidence intervals created using this method would include the true proportion of potsherds.

95% of the confidence intervals created using this method would include the true proportion of potsherds.

5% of all confidence intervals would include the true proportion of potsherds.

95% of all confidence intervals would include the true proportion of potsherds.

(c) Do you think that np > 5 and nq > 5 are satisfied for this problem? Explain why this would be an important consideration.

No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately normal.

No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately binomial.

Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately binomial.

Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately normal.

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding.

Santa Fe black-on-white is a type of pottery commonly found at archaeological excavations at a certain monument. At one excavation site a sample of 600 potsherds was found, of which 360 were identified as Santa Fe black-on-white.

(a) Let p represent the proportion of Santa Fe black-on-white potsherds at the excavation site. Find a point estimate for p. (Round your answer to four decimal places.)


(b) Find a 95% confidence interval for p. (Round your answers to three decimal places.)

Give a brief statement of the meaning of the confidence interval.

5% of the confidence intervals created using this method would include the true proportion of potsherds.

5% of all confidence intervals would include the true proportion of potsherds.

95% of the confidence intervals created using this method would include the true proportion of potsherds.

95% of all confidence intervals would include the true proportion of potsherds.

(c) Do you think that np > 5 and nq > 5 are satisfied for this problem? Explain why this would be an important consideration.

Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately normal.

No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately normal.

No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately binomial.

Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately binomial.

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding. Santa Fe black-on-white is a type of pottery commonly found at archaeological excavations at a certain monument. At one excavation site a sample of 584 potsherds was found, of which 354 were identified as Santa Fe black-on-white. (a) Let p represent the proportion of Santa Fe black-on-white potsherds at the excavation site. Find a point estimate for p. (Round your answer to four decimal places.) (b) Find a 95% confidence interval for p. (Round your answers to three decimal places.) lower limit upper limit Give a brief statement of the meaning of the confidence interval. 95% of the confidence intervals created using this method would include the true proportion of potsherds. 5% of the confidence intervals created using this method would include the true proportion of potsherds. 5% of all confidence intervals would include the true proportion of potsherds. 95% of all confidence intervals would include the true proportion of potsherds. (c) Do you think that np > 5 and nq > 5 are satisfied for this problem? Explain why this would be an important consideration. Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately normal. Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately binomial. No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately normal. No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately binomial.

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding.

Santa Fe black-on-white is a type of pottery commonly found at archaeological excavations at a certain monument. At one excavation site a sample of 594 potsherds was found, of which 359 were identified as Santa Fe black-on-white.

(a) Let p represent the proportion of Santa Fe black-on-white potsherds at the excavation site. Find a point estimate for p. (Round your answer to four decimal places.)


(b) Find a 95% confidence interval for p. (Round your answers to three decimal places.)

Give a brief statement of the meaning of the confidence interval.

5% of the confidence intervals created using this method would include the true proportion of potsherds.5% of all confidence intervals would include the true proportion of potsherds.     95% of the confidence intervals created using this method would include the true proportion of potsherds.95% of all confidence intervals would include the true proportion of potsherds.

(c) Do you think that np > 5 and nq > 5 are satisfied for this problem? Explain why this would be an important consideration.

Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately normal.Yes, the conditions are satisfied. This is important because it allows us to say that p̂ is approximately binomial.     No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately normal.No, the conditions are not satisfied. This is important because it allows us to say that p̂ is approximately binomial.