Please evaluate the correlation matrix below, assuming stock price is the response variable in a series of multiple regression equations you plan to run. If you are using this as a diagnostic tool, what are you looking for? If this was your data, how would you proceed?

Consider the levels of GHB for control patients and patients under treatment:

control:

0.7, 0.5, 0.6, 0.8, 0.8, 1.1, 0.5, 0.4, 0.6, 0.7, 0.5, 1.0, 1.5, 1.4, 0.7, 0.9, 0.6, 0.8, 0.9, 1.0, 0.7, 0.7, 0.7, 0.8, 1.0, 0.6, 1.2, 0.7, 0.9, 0.9

treatment:

0.7, 0.8, 0.7, 0.6, 1.0, 0.9, 1.4, 1.4, 1.0, 0.8, 0.6, 1.3, 0.4, 0.5, 0.9, 1.0, 1.0, 0.5, 0.7, 1.0, 1.2, 1.3, 0.6, 1.0, 0.8, 1.4, 0.8, 1.0, 1.3, 1.4

a. Do a 95% hypothesis test to test if:

(H0) the mean CONTROL level is greater than 0.89 vs. (Ha) he mean CONTROL level is less than 0.89.

Report the p-value:

Reject Null hypothesis at the 95% level of confidence?

yes OR no    

b. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is equal to the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is not equal to the mean of the TREATMENT.

Report the p-value:

Reject Null hypothesis at the 95% level of confidence?

yes OR no    

c. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is less than the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is greater than the mean of the TREATMENT (Ha).

Report the p-value: .

Reject Null hypothesis at the 95% level of confidence?

yes OR no    

Consider the levels of GHB for control patients and patients under treatment:

control:
0.7, 0.5, 0.6, 0.8, 0.8, 1.1, 0.5, 0.4, 0.6, 0.7, 0.5, 1.0, 1.5, 1.4, 0.7, 0.9, 0.6, 0.8, 0.9, 1.0, 0.7, 0.7, 0.7, 0.8, 1.0, 0.6, 1.2, 0.7, 0.9, 0.9

treatment:
0.7, 0.8, 0.7, 0.6, 1.0, 0.9, 1.4, 1.4, 1.0, 0.8, 0.6, 1.3, 0.4, 0.5, 0.9, 1.0, 1.0, 0.5, 0.7, 1.0, 1.2, 1.3, 0.6, 1.0, 0.8, 1.4, 0.8, 1.0, 1.3, 1.4

a. Do a 95% hypothesis test to test if:

(H0) the mean CONTROL level is greater than 0.89 vs. (Ha) he mean CONTROL level is less than 0.89.

Report the p-value: ___
Reject Null hypothesis at the 95% level of confidence?

no

yes    


b. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is equal to the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is not equal to the mean of the TREATMENT.

Report the p-value: ___
Reject Null hypothesis at the 95% level of confidence?

yes

no    


c. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is less than the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is greater than the mean of the TREATMENT (Ha).

Report the p-value: ___
Reject Null hypothesis at the 95% level of confidence?

yes

no    

An accountant for a large department store has the business objective of developing a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion time (in hours) are shown below. (Hint: First determine which are the independent and dependent variables.) Use Excel:

• Assuming a linear relationship, create a regression model to compute the regression coefficients b₀ and b₁.
• Interpret the meaning of the Y intercept, b₀, and the slope, b₁. What does the slope tell you about the relationship between number of invoices processed and completion time?
• Use the prediction line developed to predict the mean amount of time it would take to process 150 invoices. Would you use the regression model to predict the amount of time it would take to process 350 invoices? Why?
• What is the coefficient of determination, r² ? Interpret its meaning.
• Plot the residuals against the number of invoices processed and also against time. Based on these plots, does the model seem appropriate?

The following are quality control data for a manufacturing process at Kensport Chemical Company. The data show the temperature in degrees centigrade at five points in time during a manufacturing cycle.

The company is interested in using control charts to monitor the temperature of its manufacturing process. Compute the upper and lower control limits for the R chart. (Round your answers to three decimal places.)

UCL=___

LCL=___

Construct the R chart.

12

3 4

Compute the upper and lower control limits for the x chart. (Round your answers to three decimal places.)

UCL=___

LCL=___

Construct the x chart.

12

3 4

What conclusions can be made about the quality of the process?

The R chart indicates that the process variability is  in control/out of control .  - No samples fall/One sample falls/Two samples fall/More than two samples fall...outside the R chart control limits. The x chart indicates that the process mean is  in control/out of control .  No samples fall/One sample falls/Two samples fall/More than two samples fall....outside the x chart control limits.

Beate Klingenberg manages a​ Poughkeepsie, New​ York, movie theater complex called Cinema 8. Each of the eight auditoriums plays a different​ film; the schedule staggers starting times to avoid the large crowds that would occur if all eight movies started at the same time. The theater has a single ticket booth and a cashier who can maintain an average service rate of

280 patrons per hour. Service times are assumed to follow a negative exponential distribution. Arrivals on a normally active day are Poisson distributed and average 200

per hour.

a) Find the average number of moviegoers waiting in line to purchase a ticket.
b) What percentage of the time is the cashier busy?
c) What is the average time that a customer spends in the system?
d) What is the average time spent waiting in line to get to the ticket window?
e) What is the probability that there are more than two people in the system? More than three people? More than four?

/*explain */ Select *

From Student join enrollment on student.ID = enrollment.Student_ID

            join section on section.ID = enrollment.section_ID

            join department on major = department.name

            join faculty on faculty.id = section.faculty_ID

            join address on address.id = student.address_ID

            join Course on section.course_Number = course.course_number and section.dept_id = course.dept_ID

Where

--we want to make sure we have name information for students if we want to reach out to them

Student.Name_Last Not Like ('')

-- the theater department has asked to be out of this study

and Student.Major <> 'Theater'

--no students who have failed as we're looking for passing grades

and Grade > '1.33'

--we want to make sure we only have instructors, and the theater department is not part of this study

and Faculty.job in

            (Select job

            From Faculty

            Where Job not in ('Administrative','General Services','Human Resources')

            and Dept <> 'THT')

and Section_ID >=1

--summer courses don't always reflect accurately given their tight schedule and rapid fire delivery of materials

and Semester <> 'Summer'

--we don't want bias of an adivosr giving better grades

and Student.Advisor_ID <> Section.Faculty_ID

-- we don't want bias if a student is possibly a faculty members child

and Student.Address_ID <> Faculty.Address_ID

Order by Student.Name_Last, Grade desc, Faculty.Name_Last, Major

1. Based on the output from the explain command, determine the steps you would take (building indexes on certain columns, modifying the query, both, etc.) to get the same output, but improve overall performance.
2. Execute three steps that you think would make for improvement in the performance of this query. Report their run time in the table below.

Evaluate the impact of the steps you took, what their potential benefits and setbacks may be, and what you would advise as the next steps to improve the performance of this query.

A solenoid has N=1000 turns, length l=20 cm, and radius r=1.0 cm. (a) What is its self-inductance? (b) You are ramping up the current from 0 to 1.0 A in 1.0 s. How much voltage do you have to apply? (c) Calculate the energy stored in the inductor when the current is 1.0 A.

10. A researcher claims that the mean rate of individuals below poverty in the City of Chicago is below 17 %. Based on the data represented for the years 2005 – 2011, perform a hypothesis test to test his claim using a significance level of α = 0.10.

11. Would your conclusion change for question 10 if you used a significance level of α = 0.05? Explain.

12. A survey conducted at Chicago Public Schools (CPS) involving high school students on whether they had participated in binged drinking during the past month. Binge drinking was defined as 5 or more drinks in a row on one or more of the past 30 days.

a. From the sample data is there evidence that the proportion of students who participate in binge drinking is greater than 10%? Write a null and alternative hypothesis and perform an appropriate significance test using α=0.05.

b. Construct a 90% Confidence Interval for the population proportion. Does it support the same conclusion as in 12a? Explain.