Linda is a 35-year-old divorced mother. She has 2 boys aged 7 and 10, in her care. She has started a new job which requires her to move out of the city frequently. She feels very guilty about having to leave her children with a babysitter while she travels. Her work is very stressful, and includes many meetings that include lunches, dinners and cocktails. She noticed that she has nausea frequently, and moreover, 3 weeks ago, she had an incident of vomiting with blood. Therefore, she decided to see a doctor who admitted her to the hospital. Her medical history revealed that she had suffered from pain in the upper abdomen for several months. These pains became more and more acute over time, accompanied by headaches, for which she used aspirin. Linda was pale, nervous and weak upon admission. She had lost 4kg in the past year and weighs 50kg now, for a height of 165 cm.

The initial treatment was: • Blood transfusions • Intravenous infusion of fluids. • Electrolytes and vitamin C • Drugs including: cimetidine, aluminum hydroxide and magnesium. • Triple antibiotic therapy. After leaving the hospital, after 2 weeks, the dietician discussed general nutritional needs with her. She advised her to consume her meals at fixed and regular times each day, in a relaxed atmosphere as much as possible, to eliminate coffee and snacks between meals and to take a daily multivitamin supplement with a meal. She also advised her to quit smoking and stay home to rest for 2 weeks before returning to work. She also received a general guide with a list of some foods and eating habits to avoid. After that, she was to return for a follow-up in a week.

1. After your assessment, what can you diagnose in Linda’s case? 2. What do you think would be the normal weight range? 3. Knowing that the list given for foods to avoid was a small list, in your opinion, what would be the foods mentioned? and why are they to be avoided? 4. What role does vitamin C have in her case? 5. What other vitamins and minerals are significant in this case? what role does each have? 6. Why are antibiotics given in the treatment of ulcers? 7. Will Linda have a problem when she eliminates coffee, cigarettes and alcohol? what are they and what is your rational concerning them? 8. Write a day menu as an example to illustrate.

The country has an initiative for students in underperforming schools. To get funding, schools provide each student with eight 2-hour-long group teachering sessions each month. Also, parents must agree to pay $10 per month for each child they register for the program. The county will pay each school $200 per enrolled child, per month.

Schools must provide one teacher for every five students enrolled in the program, at a cost of

$50 per hour at a teacher’s home school, or $60 per hour if the teacher has to commute from another school in the system.

Schools that participate also need to acquire a site license for a self-study computer program, at a cost of $2,400 per year regardless of the number of students. The school also incurs a cost of $1.50 per child, per teachering session, for workbooks that are tied to the self-study program.

Generally, the county takes one month to pay bills submitted by schools. Parents pay all tuition bills at the beginning of each month. Participating teachers are paid for all after-school programs at the end of each month. The full cost of the software must be paid by the end of the first month of the program. Workbooks are paid for in the month they are used.

You are the budget manager for Typical County School (TCS). Five teachers in your school have agreed to be teachers. Since you expect to need 15 teachers by the end of the year, you will also use 10 teachers from other schools, as needed. Your calculations indicate an expected 25 students in the program during the first month it is offered. 41 in the second month and 52 in the third month. As budget manager:

1. Prepare operating budgets for each of the first three months of the program.
2. Summarize the three monthly budgets into a quarterly operating budget
3. Starting from a zero cash-balance, prepare a cash budget for the first quarter (three months) of the program. You do not have to prepare monthly cash budgets.

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?

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.

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.