Manic Corporation uses customers served as its measure of activity. During June, the company budgeted for 20,000 customers, but actually served 19,000 customers. The company has provided the following data concerning the formulas used in its budgeting and its actual results for June:

Data used in budgeting:

Actual results for June:

Required: Prepare the company's flexible budget performance report for June. Label each variance as favorable (F) or unfavorable (U).

An entrepreneur opened a small hardware store in a strip mall. During the first few weeks, business was slow, with the store averaging only one customer every 20 minutes in the morning. Assume that the random arrival of customers is Poisson distributed. (a) What is the probability that at least 1 hour would elapse between customers? (b) What is the probability that 10 to 30 minutes would elapse between customers? (c) What is the probability that less than 5 minutes would elapse between customers?

                                     SPOOL output.log

DROP TABLE Customers CASCADE CONSTRAINT;

DROP TABLE Orders CASCADE CONSTRAINT;

DROP TABLE Products CASCADE CONSTRAINT;

DROP TABLE Distributors CASCADE CONSTRAINT;

DROP TABLE Catalogs CASCADE CONSTRAINT;

DROP TABLE Rentals CASCADE CONSTRAINT;

CREATE TABLE Customers (
Customer_id NUMBER(10) NOT NULL,
CustomerFirst_name VARCHAR(20) NOT NULL,
CustomerLast_name VARCHAR(20) NOT NULL,
CustomerStreet_address VARCHAR(30) NOT NULL,
CostumerCity VARCHAR(20) NOT NULL,
CustomerState CHAR(2) NOT NULL,
CostumerZip VARCHAR(9) NOT NULL,
CustomerPhone_number VARCHAR(12) NOT NULL,
CONSTRAINT Customer_PK PRIMARY KEY (Customer_id));

--Customers
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState,
CostumerZip, CustomerPhone_number) VALUES ('100', 'Ben', 'Bill', '201 Ash Street', 'San Silva', 'MD', '20850', '443-123-4567');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState, CostumerZip,
CustomerPhone_number) VALUES ('101', 'James', 'Seth', '142 Athens Avenue', 'Silver Boro', 'MD', '20841', '443-230-4444');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState,
CostumerZip, CustomerPhone_number) VALUES ('200', 'Victor', 'Jones', '124 Flower Street', 'Rockville','MD', '20857', '301-547-2036');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState, CostumerZip,
CustomerPhone_number) VALUES ('300', 'Ashley', 'Maverick', '105 University Boulevard', 'Baltimore', 'MD', '21593', '228-567-8174');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState, CostumerZip,
CustomerPhone_number) VALUES ('450', 'Bill','Booker', '208 New Hampshire Avenue', 'Wheaton', 'MD', '20103', '250-413-7020');

CREATE TABLE Orders(
Order_id NUMBER(10) NOT NULL,
OrderDate DATE DEFAULT SYSDATE,
CONSTRAINT Order_PK PRIMARY KEY (Order_id));

-- Order
INSERT INTO Orders (Order_id, OrderDate) VALUES ('1', TO_DATE('02/05/2007','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate) VALUES ('2', TO_DATE('2/20/2011','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate) VALUES ('3', TO_DATE('02/05/2003','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate) VALUES ('4', TO_DATE('02/05/2005','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('5', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('6', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('7', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('8', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('9', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('10', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('11', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('12', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('13', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('14', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('15', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('15', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('16', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('17', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('18', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('19', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('20', TO_DATE('02/05/2006','MM/DD/YYYY'));

CREATE TABLE Products (
Product_id NUMBER(10) NOT NULL CONSTRAINT Product_PK PRIMARY KEY,
ProductDescription VARCHAR2(50),
ProductMovieType varchar(11),
Order_id NUMBER(10) NOT NULL
CONSTRAINT Product_FK REFERENCES Orders (Order_id));

-- Product
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('1', 'Beauty and the Beast', 'Romance','6');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('2', 'Mist', 'Thriller','7');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('3', 'Police Academy', 'Comedy','8');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('5', 'When Sally met Harry', 'Romance','9');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('6', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('7', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('8', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('9', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('10', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('11', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('12', 'Beauty and the Beast', 'Romance','6');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('13', 'Mist', 'Thriller','7');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('14', 'Police Academy', 'Comedy','8');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('15', 'When Sally met Harry', 'Romance','9');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('16', 'Rambo', 'Action','10');

CREATE TABLE Distributors (
DistributorDisc_id NUMBER(11,0) NOT NULL,
DistributorPrice NUMBER(11,0) NOT NULL,
DistributorOrderQuantity NUMBER(11),
Order_id NUMBER(10) NOT NULL,
CONSTRAINT Distributor_PK PRIMARY KEY (DistributorDisc_id) ,
CONSTRAINT Distributor_FK FOREIGN KEY (Order_id) REFERENCES Orders (Order_id));

-- Distributor
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('1', '5','10', '11');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('2', '5','10', '12');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('3', '15','10','13');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('4', '5','10', '14');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('5', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('6', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('7', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('8', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('9', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('10', '5','10', '15');

CREATE TABLE Catalogs (
Catalog_id NUMBER(5,0) NOT NULL,
CatalogRating VARCHAR(10) NOT NULL,
CatalogAcademyAwards VARCHAR(50) NOT NULL,
CatalogDateReleased DATE DEFAULT SYSDATE,
Product_id NUMBER(10) NOT NULL,
Order_id NUMBER(10) NOT NULL,
DistributorDisc_id NUMBER(11,0) NOT NULL,
CONSTRAINT Catalog_PK1 PRIMARY KEY (Catalog_id),
CONSTRAINT Catalog_FK1 FOREIGN KEY (Order_id) REFERENCES Orders (Order_id),
CONSTRAINT Catalog_FK2 FOREIGN KEY (Product_id) REFERENCES Products (Product_id),
CONSTRAINT Catalog_FK3 FOREIGN KEY (DistributorDisc_id) REFERENCES Distributors (DistributorDisc_id));

-- Catalog
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('1', 'Rated R','2',TO_DATE('02/05/2000','MM/DD/YYYY'),'7','16','6');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('2', 'Parental Guide', '12', TO_DATE('02/05/2001','MM/DD/YYYY'),'8','17','7');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('3', 'Youth','3',TO_DATE('02/05/2002','MM/DD/YYYY'), '9','18','8');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('4', 'Everyone','8', TO_DATE('02/05/2003','MM/DD/YYYY'),'10','19','9');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('5', 'Preschool','9',TO_DATE('02/05/2004','MM/DD/YYYY'),'11','20','10');

CREATE TABLE Rentals(
Rental_id NUMBER(9) NOT NULL,
RentalReturnDate DATE DEFAULT SYSDATE,
RentalRentedQuantity VARCHAR(2) NOT NULL,
RentalTotal_charge NUMBER(19,4) NOT NULL,
RentalTax NUMBER(19,4) NOT NULL,
Product_id NUMBER(10) NOT NULL,
CONSTRAINT Rental_PK PRIMARY KEY(Rental_id),
CONSTRAINT Rental_FK FOREIGN KEY(Product_id) REFERENCES Products(Product_id));
-- Rental
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('1', TO_DATE('04/05/2009','MM/DD/YYYY'), '35','17.99', '0.3','11');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('2', TO_DATE('03/04/2001','MM/DD/YYYY'), '34','17.99', '0.3','12');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('3', TO_DATE('04/03/2002','MM/DD/YYYY'), '33','17.99', '0.3','13');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('4', TO_DATE('04/01/2003','MM/DD/YYYY'), '32','17.99', '0.3','14');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('5', TO_DATE('04/03/2004','MM/DD/YYYY'), '31','17.99', '0.3','15');

SPOOL OFF;

Error message

             *
ERROR at line 1:
ORA-00955: name is already used by an existing object

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('1', 'Beauty and the Beast', 'Romance','6')
                                                                                                                        *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('2', 'Mist', 'Thriller','7')
                                                                                                        *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('3', 'Police Academy', 'Comedy','8')
                                                                                                                  *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('5', 'When Sally met Harry', 'Romance','9')
                                                                                                                        *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('6', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('7', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('8', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('9', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('10', 'Rambo', 'Action','10')
                                                                                                          *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('11', 'Rambo', 'Action','10')
                                                                                                          *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('12', 'Beauty and the Beast', 'Romance','6')
                                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('13', 'Mist', 'Thriller','7')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('14', 'Police Academy', 'Comedy','8')
                                                                                                                   *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('15', 'When Sally met Harry', 'Romance','9')
                                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number

INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('16', 'Rambo', 'Action','10')
                                                                                                          *
ERROR at line 1:
ORA-01722: invalid number

CREATE TABLE Distributors (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('1', '5','10', '11')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('2', '5','10', '12')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('3', '15','10','13')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('4', '5','10', '14')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('5', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('6', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('7', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('8', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('9', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('10', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated

CREATE TABLE Catalogs (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object

INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found

INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found

INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found

INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found

INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found

CREATE TABLE Rentals(
              *
ERROR at line 1:
ORA-00955: name is already used by an existing object

INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found

INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found

INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found

INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found

INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found

• Nine experts rated two brands of Colombian coffee in a taste-testing experiment. A rating on a 7-point scale ( 1=1= 1 equals extremely unpleasing, 7=7= 7 equals extremely pleasing) is given for each of four characteristics: taste, aroma, richness, and acidity. The following data stored in Coffee contain the ratings accumulated over all four characteristics:

  	BRAND
  EXPERT	A	B
  C.C.	24	26
  S.E.	27	27
  E.G.	19	22
  B.L.	24	27
  C.M.	22	25
  C.N.	26	27
  G.N.	27	26
  R.M.	25	27
  P.V.	22	23

  • a. At the 0.05 level of significance, is there evidence of a difference in the mean ratings between the two brands?

  • b. What assumption is necessary about the population distribution in order to perform this test?

  • c. Determine the p-value in (a) and interpret its meaning.

  • d. Construct and interpret a 95% confidence interval estimate of the difference in the mean ratings between the two brands.

The National Association of Realtors estimates that 23% of all homes purchased in 2004 were considered investment properties. If a sample of 800 homes sold in 2004 is obtained what is the probability that at most 175 homes are going to be used as investment property? Round to four decimal places, if necessary.

1- Describe, with the aid of diagrams, the relationship between pressure and volume during normal lung ventilation. 10) 2- Describe, with the aid of diagrams, the structural features of the respiratory tract. Include in your answer a description of how these features contribute to the function of the lung.

A popular toothpaste brand claims that four out of five (or eighty percent) of dentists recommend their brand.

1. You randomly select 35 dentists. Calculate the probability that the sample proportion is between 74 percent and 88 percent.

2. Comment on the appropriateness of the sample size.

A firm gives discounts to its customers who pay their bills on time. A customer receives a ten percent discount on the next invoice when a bill is paid in full before its due date. Thirty percent of all customers use the discount. If the company sends out eight bills, what is the expected number of customers that will take the discount (round answers to three decimal places, for example, 0.xxx)?

A firm gives discounts to its customers who pay their bills on time. A customer receives a ten percent discount on the next invoice when a bill is paid in full before its due date. Thirty percent of all customers use the discount. If the company sends out eight bills, what is the probability that at least three take the discount (round answers to three decimal places, for example, 0.xxx)?

A firm gives discounts to its customers who pay their bills on time. A customer receives a ten percent discount on the next invoice when a bill is paid in full before its due date. Thirty percent of all customers use the discount. If the company sends out eight bills, what is the probability that exactly three take the discount (round answers to three decimal places, for example, 0.xxx)?

A firm gives discounts to its customers who pay their bills on time. A customer receives a ten percent discount on the next invoice when a bill is paid in full before its due date. Thirty percent of all customers use the discount. If the company sends out eight bills, what is the probability that less than three take the discount (round answers to three decimal places, for example, 0.xxx)?

A researcher wants to determine the relationship between the typing speed of administrative assistants at a major university is related to the time that it takes for the admin assistant to learn to use a new software program and may be used to predict learning time. Data are gathered from 12 departments at the university.

Dept Typing speed (words per minute) Learning time (hours)

A 48 7

B 74 4

C 52 8

D 79 3.5

E 83 2

F 56 6

G 85 2.3

H 63 5

I 88 2.1

J 74 4.5

K 90 1.9

L 92 1.5

Run a regression analysis of the data on Excel. Use your output to answer the following:

d. What is the value of the correlation coefficient between typing speed and learning time? What does is say about the strength of the relationship?

Explain the relationship between Marketing efforts and actual Revenue dollars?  How does Marketing efforts drive Revenue?