In what follows use any of the following tests/procedures: Regression, multiple regressions, confidence intervals, one-sided t-test or two-sided t-test. All the procedures should be done with 5% P-value or 95% confidence interval

Upload CARS data. SETUP: It is believed that Lincolns are heavier than Cadillac. Given the data your job is to confirm or disprove this belief. (CAREFULL: sort the data in order to extract the needed information).

9. What test/procedure did you perform?

• a. One-sided t-test
• b. Regression
• c. Two-sided t-test
• d. ​​Confidence interval

10. What is the P-value/margin of error?

• a. 339.06234
• b. 0.598587029
• c. 0.299293514
• d. 8.065421
• e. ​​None of these

11. Statistical Interpretation

• a. Due to small margin of error we are confident that the average mpg is above 3500.
• b. Since P-value is large we cannot claim that the averages are different.
• c. Since P-value is very small we are confident that the slope of regression line is not zero.
• d. None of these

12. Conclusion

• a. Yes, I am confident that the above assertion is correct.
• b. No, we cannot claim that the above assertion is correct.

Task 2

A. A researcher was interested in comparing the GPAs of students at two different colleges. Independent simple random samples of 8 students from college A and 13 students from college B yielded the following results. The mean GPA for college A was x1 = 3.11, with a standard deviation s1 = 0.44. The GPA for college B was 2 = 3.44, with a standard deviation s2 = 0.55. Determine a 95% confidence interval for the difference, µ1-µ2 between the mean GPA of college A students and the mean GPA of college B students. (Assume college a and B have the same population standard deviations)

B. A manufacturing process produces bags of cookies. The distribution of content weights of these bags is Normal with mean 15.0 oz and standard deviation 6.0 oz. We will randomly select a sample of 900 bags of cookies and weigh the contents of each bag selected, is the mean of such sample

a) The mean of is x

b) The standard deviation of x is

c) The distribution of x is

d) Does the distribution of depend on the assumption that the weight (in oz) of these bags is normally distributed and why?

C.Last year, the mean annual salary for adults in one town was $35,000. A researcher wants to perform a hypothesis test to determine whether the mean annual salary for adults in this town has changed this year. The mean annual salary for a random sample of 16 adults from the town was 33000. Assume population standard deviation σ =12000. Use a significance level of α=0.05

D. A special diet is intended to reduce the cholesterol of patients at risk of heart disease. After six months on the diet, an SRS of 64 patients at risk for heart disease had an average cholesterol of x= 192, with standard deviation s = 24. The 95% confidence interval for the average cholesterol of patients at risk for heart disease who have been on the diet for 6 months is

An analyst at a local bank wonders if the age distribution of customers coming for service at his branch in town is the same as at the branch located near the mall. He selects 100 transactions at random from each branch and researches the age information for the associated customer. Use the table below to answer the questions.

1. What are the null and alternative hypotheses?

a. Ho: The age distributions of customers at the two branches are not the same.

     Ha: The age distributions of customers at the two branches are the same.

b. Ho: Age is not independent of branch.

    Ha: Age is independent of branch.

c. Ho: The age distributions of customers at the two branches are the same.

    Ha: The age distributions of customers at the two branches are not the same.

d. Ho: Age is independent of branch.

    Ha: Age is not independent of branch.

2. What type of test is this?

a. Chi-square goodness-of-fit-test

b. Chi-square test of independence

c. Chi-square test of homogeneity

3. What are the expected numbers for each cell if the null hypothesis is true?

4. Find the X2 statistic.

X2 =               (round to two decimal places)

5. How many degrees of freedom does the X2 statistic have?

df =

6. Find the critical value at alpha = 0.05

X2 =               (round to three decimal places)

7. What do you conclude?

The test statistic is (greater than or less than) the critical value. There is (insufficient or sufficient) evidence to reject Ho.

Marty and Jean are married and have 4-year-old twins. Jean is going to school full-time for 8 months of the year, and Marty earns $45,400. The twins are in day care so Jean can go to school while Marty is at work. The cost of day care is $8,600. What is their child and dependent care credit?

In a given school, 3 out of 10 people tend to have IQ level of more than 150.

1. If a group of 100 people were to be picked from this school, what is the probability of getting 80 people that have IQ below 150.

b. What is the expected number of people with IQ over 150 in a group of 100.

It is estimated that 4.5% of the general population will live past their 90th birthday. Suppose a random sample of 753 high school seniors is selected.

a. Describe the sampling distribution of ?̂.

b. What is the probability that from this random sample taken, the sample proportion of these high school seniors who will live past their 90th birthday is between 0.043 and 0.056?

1.Which players have lost more matches than the average number of losses?   No duplicates should be listed.   Order by player number.   Insert your screen shot here.

2.How many players from each town served on the committee in any capacity? Display the town as ‘Town’ and the number served as ‘Committee Service’.   Insert your screenshot here.

3.How many members come from each town? Display the town as ‘Town’ and the number of members as ‘Number’. Insert your screenshot here.

4.Who has served on the committee more than once? Display the player number as ‘Number’, concatenate the player initial and name as ‘Name’, town as ‘Town’, and number served as ‘Terms’. Insert your screenshot here.

Below I will include the tennis database

* *******************************************************************

CREATE and OPEN the TENNIS Base

******************************************************************* */

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players

(

playerno              int                         not null                primary key,

name                    varchar(15)         not null,

initials   varchar(3),

birth_date           date,

gender                 char(1),

joined                   int          not null,

street                   varchar(15)         not null,

houseno                             varchar(4),

zip                         char(6),

town                     varchar(10)         not null,

phoneno                             char(10),

leagueno             char(4)

);

Insert into players values

(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),

(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),

(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),

(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),

(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),

(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),

(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),

(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),

(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),

(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),

(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),

(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),

(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),

(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members

(

playerno              int          not null,

begin_date          date       not null,

end_date             date,

position               varchar(20),

primary key(playerno, begin_date)

);

Insert into committee_members values

(2,'2010-01-01','2012-12-31','Chairman'),

(2,'2014-01-01',Null,'General Member'),

(6,'2010-01-01','2010-12-31','Secretary'),

(6,'2011-01-01','2012-12-31','General Member'),

(6,'2012-01-01','2013-12-31','Treasurer'),

(6,'2013-01-01',Null,'Chairman'),

(8,'2010-01-01','2010-12-31','Treasurer'),

(8,'2011-01-01','2011-12-31','Secretary'),

(8,'2013-01-01','2013-12-31','General Member'),

(8,'2014-01-01',Null,'General Member'),

(27,'2010-01-01','2010-12-31','General Member'),

(27,'2011-01-01','2011-12-31','Treasurer'),

(27,'2013-01-01','2013-12-31','Treasurer'),

(57,'2012-01-01','2012-12-31','Secretary'),

(94,'2014-01-01',Null,'Treasurer'),

(112,'2012-01-01','2012-12-31','General Member'),

(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches

(

matchno                             int          not null Primary Key,

teamno                int          not null references teams(teamno),

playerno              int          not null references players(playerno),

won                      int,

lost                       int

);

Insert into matches values

(1,1,6,3,1),

(2,1,6,2,3),

(3,1,6,3,0),

(4,1,44,3,2),

(5,1,83,0,3),

(6,1,2,1,3),

(7,1,57,3,0),

(8,1,8,0,3),

(9,2,27,3,2),

(10,2,104,3,2),

(11,2,112,2,3),

(12,2,112,1,3),

(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties

(

paymentno         int          not null Primary Key,

playerno              int          not null references players(playerno),

payment_Date   date       not null,

amount decimal(10,2)     not null

);

Insert into Penalties values

(1,6,'2010-12-08',100.00),

(2,44,'2011-05-05',75.00),

(3,27,'2013-09-10',100.00),

(4,104,'2014-07-08',50.00),

(5,44,'2010-12-08',25.00),

(6,8,'2010-12-08' ,25.00),

(7,44,'2012-12-30',30.00),

(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams

(

teamno int          Primary Key        Not Null,

playerno              int          Not Null               references players(playerno),

division varchar(6)

);

Insert into teams values

(1,6,'first'),

(2,27,'second');

/* ********************************************************************************************

End of loading the database

******************************************************************************************** */

Phase 1 – ERD

In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules showed here. In other words, do not add realismto your design by expanding or refining the business rules.  However, make sure you include all attributes needed that would permit the model to be successfully implemented, including all primary and foreign keys.

1.Trinity College (TC) is divided into several schools: a school of business, a school of arts and sciences, a school of education, and a school of applied sciences. Each school is administered by a dean who is a professor.  Each dean can administer only one school.  Each school must have a school name.

2.Each school is composed of several departments.  The smallest number of departments operated by a school is one, and the largest number of departments is indeterminate.  Each department belongs to only one school. A department may be classified as research only.  Each department must have a department name.

3.Each department may have many professors assigned to it.  One of those professors chairs the department.  Only one professor may chair the department to which he or she is assigned.  No professor is required to accept the chair position.  Each professor must have a first name, last name, rank, specialty, and an email.

4.Each department may offer courses.  Each course is offered by only one department.  If a department is research only, it will offer no courses. Each course must have a course title, description, and number of credits.

5.A class will be a section of a course.   A course may exist in Trinity College’s catalog even when it is not offered as a class in a current schedule.  Each class must have a class section and class time.

6.Each professor can teach up to four classes.  A professor may also be on a research contract and teach no classes at all.

7.A student may enroll in up to six classes, but takes each class only once during each enrollment period. Each class may have up to 35 students.  A class can exist even though no students are enrolled in it.

8.Each department has several students whose major is offered by that department, but a student can have only one major and is, therefore, associated with only one department. A student is not required to declare a major field of study when first enrolling.

9.Each student has an advisor in his or her department, each advisor counsels several students.  An advisor is a professor, but not all professors advise students.

10.Each class is taught in a room, and each room is located in a building.  A building can contain many rooms, but a room can only be contained in one building. Some buildings do not contain class rooms (e.g., maintenance building).  A room must have a room type, a building must have a building name and location.

Phase 2. After reviewing the various ERDs, Trinity College has decided on the following tables and attributes.

Write the SQL code to drop and then create the above tables.  Remember that when creating tables, the tables with foreign keys have to be created afterthe table that the foreign key points to.  When dropping tables, they have to be dropped in the reverse order, so that the tables with foreign keys are dropped beforethe tables that the foreign keys point to.  You can create all the drop SQL statements first followed by all the create tables.  The first time you run them the drop statements will work as no tables have been created and therefore no drops will occur.  You will need to run them twice to insure the drops will work.

Please be sure to review the Phase 1 requirements so you can determine the primary and foreign keys for each table and then determine the order of DROP and CREATE STATEMENTS. Please note that some fields are foreign keys but not identified as such by their names. Also know which fields are required fields and which are not.  Use appropriate data types for each field and meaningful field names.  

Completion is only granted for questions that require a graph if your answer includes:

A clear and completely labeled graph.

A clear statement of what curve(s) are changing.

Why those curve(s) are changing.

A clear statement of what is happening to the equilibrium values of the variables in the model.

1)     A survey indicated that chocolate is the most popular flavor of ice cream in America. For each of the following, indicate the possible effects on demand, supply, or both as well as equilibrium price and quantity of chocolate ice cream.

a.     A severe drought in the Midwest causes dairy farmers to reduce the number of milk-producing cattle in their herds by a third. These dairy farmers supply cream that is used to manufacture chocolate ice cream.

b.     A new report by the American Medical Association reveals that chocolate does, in fact, have significant health benefits.

c.     The discovery of cheaper synthetic vanilla flavoring lowers the price of vanilla ice cream.

d.     New technology for mixing and freezing ice cream lowers manufacturers’ costs of producing chocolate ice cream.

2.     In a supply and demand diagram, draw the shift of the demand curve for hamburgers in your hometown due to the following events. In each case, show the effect on equilibrium price and quantity.

a.     The price of tacos increases.

b.     All hamburger sellers raise the price of their French fries.

c.     Income falls in town.

d.     Hot dog stands cut the price of hot dogs.